Standard Jet DBnb` Ugr@?~1y0̝cßFNn7ќ(T#`{6߱0aC:3sy[ |*|hGf_Љ$g'DeFx -bT4.00BF YS  Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeniYYIdParentIdName        OYi444SY Y Y  Y 2ACMFInheritableObjectIdSID444 4YObjectId YkSjY  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$szReferencedObjectszRelationshipZF w 2 c  ; l M  r-^ xx@@(@@B@@ T@ c@ ` =<@@9 @@+kh+MSi`f^JbmQOYmd^O+kh+MMWY^OBF+kh+Oifmf^JbmSo^^+kh+OMdbmJMmhoQivkoLiQfdimf^JbmkLvOJmQdSkmJimof+ MFDLH>SJ>HBB@O8J@:L+ +;K[ d^OSi`f^Jbm^YkmSi`f^JbmfdkmmiQJmkoLSdi`Si`fdkmmiQJm`QbmkoLSdi`Si`fidUiQkkSi`iQJOQiSi`kQJiMWSi`kQJiMWiQko^mkSi`kQJiMWmQkm Si`koLSdi`MdbMQbmiJmQ/!Si`koLSdi`MdbmJMm/"Si`koLSdi``kM/#Si`koLSdi`dffidL^Q`/$Si`koLSdi`fQi`Ym/%Si`koLSdi`f^JbmiQJkdb/&Si`koLSdi`fdkmmiQJm/'Si`koLSdi`fiQmiQJm/(Si`koLSdi`kdoiMQ/)Si`sdi\kWQQmk*LJkkQJiMWkoffdim+M^JkkkQJiMWfJiJ`QmQiU^dLJ^JLLiQqYJmYdbmJL^Qifmf^JbmSo^^ifmkoLiQfdimMdbMQbmiJmQ7ifmkoLiQfdimMdbmJMm7ifmkoLiQfdimdffidL^Q`k7ifmkoLiQfdimfQi`Ym7ifmkoLiQfdimf^JbmiQJkdb7ifmkoLiQfdimfdkmmiQJm`Qbm7 ifmkoLiQfdimfiQmiQJm`Qbm7 ifmkoLiQfdimkdoiMQ7 iQkQmfJUQ JO`Yb OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MMdbMQbmiJmQkoLSdi`+kh+MMdbmiQJmmvfQMd`Ld+kh+MSi`fOSsdi\kWQQmk+kh+MM`LmYm^Q+kh+MSi`f^JbmQOYmd^O+kh+MMWY^O866+kh+MSi`f^JbmQOYmd^O+kh+MMWY^O<:+kh+MSi`f^JbmQOYmd^O+kh+MMWY^O>8+kh+MSi`f^JbmQOYmd^O+kh+MMWY^OB:+kh+MSi`f^JbmQOYmd^O+kh+MMWY^OBF+kh+MSi`f^JbmQOYmd^O+kh+MMWY^OH@+kh+MSi`f^JbmQOYmd^O+kh+MM`Lf^JbmmvfQ+kh+MSi`f^JbmQOYmd^O+kh+MMd`Ld:<+kh+MSi`f^JbmQOYmd^O+kh+MkS`fiQmiQJm+kh+MSi`f^JbmQOYmd^O+kh+MmQum88@+kh+MSi`f^JbmQOYm+kh+MMWY^O866+kh+MSi`f^JbmQOYm+kh+MMWY^O8:+kh+MSi`f^JbmQOYm+kh+MMWY^O<:+kh+MSi`f^JbmQOYm+kh+MMWY^O>8+kh+MSi`f^JbmQOYm+kh+MMWY^OB:+kh+MSi`f^JbmQOYm+kh+MMWY^OBF+kh+MSi`f^JbmQOYm+kh+MMWY^OH@ +kh+MSi`f^JbmQOYm+kh+MM`Lf^JbmmvfQ!+kh+MSi`f^JbmQOYm+kh+MMd`Ld86D+kh+MSi`f^JbmQOYm+kh+MMd`Ld88@+kh+MSi`f^JbmQOYm+kh+MMd`Ld8D>+kh+MSi`f^JbmQOYm+kh+MMd`Ld:<+kh+MSi`f^JbmQOYm+kh+MkS`fiQmiQJm+kh+MSi`f^JbmQOYm+kh+MmQum88@+kh+MSi`f^JbmfdkmmiQJmkoLSdi`+kh+MMWY^O8+kh+MSi`fdkmmiQJm`QbmkoLSdi`+kh+MMWY^O<+kh+MSi`koLSdi`MdbMQbmiJmQ+kh+MMLdfiQmiQJmmvfQC+kh+MSi`koLSdi`OYkMWJiUQmvfQ+kh+MMd`Ld:8C +kh+MSi`koLSdi`dffidL^Q`+kh+MMLddffidL^Q`mvfQC +kh+MSi`koLSdi`fQi`Ym+kh+MMLdfiQmiQJmmvfQC +kh+MSi`koLSdi`f^JbmiQJkdb+kh+MMd`Ld:8C +kh+MSi`koLSdi`fdkmmiQJm+kh+MMLdfdkmmiQJmmvfQC +kh+MSi`koLSdi`kdoiMQ+kh+MMLdfiQmiQJmmvfQC+kh+MfQi`YmkoLSdi`+kh+MfQi`YmmvfQ+YO+kh+Mf^JbmiQJkdbkoLSdi`+kh+Mf^JbmiQJkdbMd`Ld+kh+MfdkmmiQJm`QbmkoLSdi`+kh+MfdkmmiQJmmvfQMd`Ld`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @           !"#$%&' (!)"*#+$%&'()*+,- . / 0 1 23456789:;<=>?@ABCD E!FGHIJKLMNO P Q R S TUVWXYZ[\]^_`abcdefghijk l mnopqrstuv!w%x)y*z{|}~      !"#$%      !"#$%&'                        !   ' 5:?DKU_&  *"/#3$9'(" ) 7 ; @ E J O p v  E    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP        !!!" "!""###$#%$&$'$(%)%*%+&2&3&4'5'6'7(8(9(:);)<)=*>*?*@+A+B+C,D,E,F-G-H-I.J..///00011 1 2 2 2 2333344445555666677 7!7"8#8$8%8&9'9(9)9*:+:,:-:.;/;0;1;2<3<4<5<6=7=8=9=:>;>>>????@@@ @ A A A ABBBBCCCCDDDDEEEEFF F!F"G#G$G%G&H'H(H)H*I+I,I-I.J/J0J1J2K3K4K5K6L7LLLMMMMNNN N O O O OPPPPQQQQRRRRSSSSTT T!T"U#U$U%U&V'V(V)V*W+W,W-W.X/X0X1X2Y3Y4Y5Y6Z7ZZZ[[[[\\\ \ ] ] ] ]^^^^____````aaaabb b!b"c#c$c%c&d'd(d)d*e+e,e-e.f/,-./0123456789:;<=>?@ABCDEFGHIJ      !"#$%&'()*+,-./01  !"# 6 @D['m>4v^ )} 3 #F !6 5555556666667777 7!78"8$8%8&8'8#9(9*9+9,9-9):.:0:1:/;2;4;5;3<6<8<9<:<;<7=<=>=?==>@>B>C>D>E>A?F?H?I?J?K?G@L@N@O@P@@MAAAAAABB B B B BC CCCCCDDDDDDEEEEFFF FG!G#G$G"H%H'H(H&I)I+I,I*J-J/J0J1J2J.K3K5K6K4L7L9L:L;LNCNENFNDOGOIOJOHPKPMPNPLQOQQQRQPRSRURVRTSWSYSZSXT[TTTUUUUUUV V V V V WWWWWXXXXXXYYYYYYZZ!Z"Z#Z$Z [%[&X@@@@@@@+ 6@LDJ<8M:Q>@>S:LFDSDSFQBL>J>DO+ +;K[z+ 8D:@:@O>QFMB>>6>F6FSQQ8SHFM8SQ@S+ +;K[z+ :6J@H@FSH@LJ6MBJHDFOOJ8+ +;K[z+ :8@>MH::Q>DJ>DD>LJ>QLQSQHQSQS6J>+ +;K[z+ :LOD666DHLD>>QB8F>>6DLMFDLH>SJ>HBB@O8J@:L+ +;K[z+ >D6DOFHMD6B@>8HFJQJSQ8<:F:L8@SMO+ +;K[z+ @DH>>F8JLHDJF>HF:6L::FF8+ +;K[z + @L@@8:F@L>B@JF>L>FBODFD>>OQDD+ +;K[z + D>L@MQ@>6S>QSJ:HD<:6QM8BH:8J@+ +;K[z + DD8OF>MHLSOF:H66MMJ68>FSQ@L>J+ +;K[z + DJF>SBSLOFLH>8BJF>DOS8@LJ:DSB<@F+ +;K[z + F>8<>JL>JOFFL>>S6<6QFMDH6SOOHO<6BJFQ+ +;K[z+ H@HF@LMS:S868JFOH6FLQHM@:BJQO+ +;K[z+ H@Q8B8OJL>@JJDFL66B>:6DO@>MB+ +;K[z+ JQ@66FOQD>8>>JDLQQQS@O<>MQM>M+ +;K[z+ L8:O6J<>HD<>B>MHJFBM@Q>M+ +;K[z+ LDMB6F6FLBHQ6JJSH>S8ODQSHQ>6>6F+ +;K[+ MQMFMDHFSOSS>6HSF6J:FLQD8H:@::M:+ +;K[+ O>JHS:BHMJM6>@FBLS86SSHLOMLM6O>FJOBDJDHDJSF8B68MH8BF88H:>HOBFJ8SBM6BJ:O@<8:Q+ +;K[F @ @@ MdbMQbmiJmQMdbmJMmzdffidL^Q`kz fQi`YmOQmJY^zf^Jbmzf^Jbmz f^Jbmz f^Jbmzf^Jbmf^Jbmf^JbmfQi`Ymzf^JbmfQi`Ymzf^JbmfdkmmiQJmzf^JbmfdkmmiQJmzf^JbmfiQmiQJmzf^JbmfiQmiQJmzf^JbmuMdbMQbmiJmQzf^JbmuMdbMQbmiJmQz f^JbmudffidL^Q`kzf^JbmudffidL^Q`kf^JbmuiQJkdbz f^JbmuiQJkdbfdkmmiQJm`QbmzfiQmiQJm`QbmzkdoiMQzkdoiMQkdoiMQOQmJY^zk  @  MdbMQbmiJmQz MdbmiQJmmvfQOYkMWJiUQmvfQz QbUOkbSYi`z `Q`LiJbQz`kMdffidL^Q`kdffidL^Q`mvfQz fQi`YmOQmJY^zfQi`YmmvfQzf^Jbmzf^Jbmzf^Jbmzf^Jbmzf^Jbmzf^Jbmzf^Jbmzf^Jbmf^JbmMJmQUdivf^JbmiQJkdbz f^JbmmvfQzfdkmmiQJm`QbmzfdkmmiQJmmvfQzfiQmiQJm`QbmzfiQmiQJmmvfQkzkdoiMQOQmJY^kdoiMQmvfQz;,d _ Z g  ~K y  ( |%m<;wRY#-@-@basSearchSupport#BBBBBBBBBB@ "Tb@Tb@frmWorksheets#<<<<<<<<<<: !X_@X_@frmSubform-Source#DDDDDDDDDDB  V_@V_@frmSubform-Pretreat#HHHHHHHHHHF ~;y_@~;y_@frmSubform-Posttreat#JJJJJJJJJJH $/ ^@$/ ^@frmSubform-PlantReason#NNNNNNNNNNL ZX_@ZX_@frmSubform-Permit#DDDDDDDDDDB eX_@eX_@frmSubform-OpProblem#JJJJJJJJJJH Of^_@Of^_@frmSubform-MSC#>>>>>>>>>>< a}^@a}^@frmSubform-Contact#FFFFFFFFFFD tX_@tX_@frmSubform-Concentrate#NNNNNNNNNNL l@l@frmSearchTest#<<<<<<<<<<: L @L @frmSearchResults#BBBBBBBBBB@ @N@@N@frmSearch#44444444442 I@I@frmReader#44444444442 uV@uV@frmProgress#88888888886 _@_@frmPostTreatmentSubform#PPPPPPPPPPN _@_@frmPlantPosttreatSubform#RRRRRRRRRRP  @ @frmPlantList#::::::::::8 Pi^@Pi^@frmPlantEdit(old)#DDDDDDDDDDB \S[]_@\S[]_@frmPlantEdit#::::::::::8  ;@ ;@frmPDFWorksheets#BBBBBBBBBB@  @@frmMain#0000000000.  fZ1_@fZ1_@frmEdit-PlantTypes#FFFFFFFFFFD   U_@ U_@frmEditor-PretreatTypes(old)#ZZZZZZZZZZX  |*_@|*_@frmEditor-PostTreatType(old)#ZZZZZZZZZZX  f9@f9@frmAbout#22222222220  9[ @9[ @UserDefined#88888888886  [ @[ @SummaryInfo#@DDD88888886 @ p#[ @p#[ @SysRel#.........., p#[ @p#[ @Scripts#0000000000. p#[ @p#[ @Reports#0000000000. p#[ @p#[ @Modules#0000000000. M[ @M[ @Forms#,,,,,,,,,,* wab@wab@DataAccessPages#@@@@@@@@@@>  [ @ [ @MSysRelationships"DDDDDDDDDDB  [ @ [ @MSysQueries"88888888886  [ @ [ @MSysACEs"22222222220  [ @ [ @MSysObjects"88888888886  [ @`_@MSysDb#@8:::......., @ [ @ [ @Relationships"<<<<<<<<<<:  [ @ [ @Databases"44444444442  [ @ [ @Tables".........., 7"N% Q } 4 IH%b^GE<8DB PLAEE[@[@~sq_cfrmPE+D$Ѽc@z%Ѽc@~sq_cfrmPlantEdit~sq_ccmbPlantType#4MR2KeepLocal Tfffffffd @Cмc@Wмc@~sq_cfrmPlantEdit~sq_cChild68#4MR2KeepLocal T\\\\\\\Z @BzѼc@+Ѽc@~sq_cfrmPlantEdit~sq_cChild62#4MR2KeepLocal T\\\\\\\Z @@F Ѽc@^Ѽc@~sq_cfrmPlantEdit~sq_cChild32#4MR2KeepLocal T\\\\\\\Z @?Ѽc@FѼc@~sq_cfrmPlantEdit~sq_cChild12#4MR2KeepLocal T\\\\\\\Z @=b_@xb_@~sq_cfrmPlantEdit(old)~sq_cText115#4MR2KeepLocal Tfffffffd @<b_@Lb_@~sq_cfrmPlantEdit(old)~sq_csfmPretreat#4MR2KeepLocal Tnnnnnnnl @:b_@b_@~sq_cfrmPlantEdit(old)~sq_ccmbPlantType#4MR2KeepLocal Tpppppppn @9(ڗb_@ۗb_@~sq_cfrmPlantEdit(old)~sq_cChild95#4MR2KeepLocal Tfffffffd @ 7^Jb_@2b_@~sq_cfrmPlantEdit(old)~sq_cChild62#4MR2KeepLocal Tfffffffd @6eb_@b_@~sq_cfrmPlantEdit(old)~sq_cChild41#4MR2KeepLocal Tfffffffd @ 4ӗb_@ ՗b_@~sq_cfrmPlantEdit(old)~sq_cChild100#4MR2KeepLocal Thhhhhhhf @ 2ehOM@RM@~sq_cConcentrateSubform~sq_cConTreatTypeCombo#4MR2KeepLocal T|||||||z @1 r^ @ "ҍ@Admin#p Tx8,,,,,,,,,* 0,+[ @Zb@ResetPage#44444444442 / q![ @Zb@rptSubreport-Source#HHHHHHHHHHF .u[ @b@rptSubreport-PreTreatment#TTTTTTTTTTR -Ĩ[ @b@rptSubreport-Posttreatment#VVVVVVVVVVT ,H[ @b@rptSubreport-PlantReason#RRRRRRRRRRP +Hם[ @b@rptSubreport-Permit#HHHHHHHHHHF *W֝[ @b@rptSubreport-OpProblems#PPPPPPPPPPN )HV͝[ @b@rptSubreport-Contact#JJJJJJJJJJH (ʝ[ @b@rptSubreport-Concentrate#RRRRRRRRRRP 'Ç@Ç@rptPlantFull#::::::::::8 &~@b@Abbreviation table#FFFFFFFFFFD % 9.@ 9.@Global#.........., $]--@]--@ClassSearchParameter#JJJJJJJJJJH  Qd:n# / | ^ q ? ! t V 8  A #  IxwG) yG)~`B$~`O1l:@qrySubform-PlantReasonfrmPlantEditUU= @  G@__Plant_ID%%% O@ @ G?([__Plant_ID] = Plant_ID)8 '?ContactfrmPlantEdit77 ?  G?__Plant_ID%%% O? ? G>([__Plant_ID] = Plant_ID)8 '>qrySubform-OpProblemfrmPlantEditQQ9 >  G>__Plant_ID%%% O> > G=DischargeType+++ =  G= = G<([__Plant_ID] = Plant_ID)8 '<qrySubform-PretreatfrmPlantEdit(old)YY7 <  G<__Plant_ID%%% O< < G;PlantCategory+++ ;  G; ; G:PlantType### :  G: : G9([__Plant_ID] = Plant_ID)8 '9qrySubform-PermitfrmPlantEdit(old)UU3 9  G9__Plant_ID%%% O9 9 G8([__Plant_ID] = Plant_ID)8 '8qrySubform-ConcentratefrmPlantEdit(old)__= 8  G8__Plant_ID%%% O8 8 G7([__Plant_ID] = Plant_ID)8 '7qrySubform-SourcefrmPlantEdit(old)UU3 7  G7__Plant_ID%%% O7 7 G6([__Plant_ID] = Plant_ID)8 '6qrySubform-PostTreatfrmPlantEdit(old)[[9 6  G6__Plant_ID%%% O6 6 G5([__Plant_ID] = Plant_ID)8 '5qrySubform-PlantReasonfrmPlantEdit(old)__= 5  G5__Plant_ID%%% O5 5 G4([__Plant_ID] = Plant_ID)8 '4qrySubform-OpProblemfrmPlantEdit(old)[[9 4  G4__Plant_ID%%% O4 4 G3![tblPDFWorksheetTitles].[Title]> g3[tblPDFWorksheetTitles].[ID]; g3tblPDFWorksheetTitles;;; 3 3 G2B@ g2H@ g2ConTreatType))) 2 2 GLVAL+v4Z V > ~ , < L  N@|&vhz.hPretreatTypes.PretreatType_ID = Pretreatment.PretreatType_IDPlantType.PlantType_ID = Plant.PlantType_IDPlantReason.PlantReason_ID = PlantXReason.PlantReason_IDPlant.Plant_ID = PlantXReason.Plant_IDConTreatType.ConcentrateTreatTypePlantType.PlantType_ID = Plant.PlantType_IDPlant.Plant_ID = PlantXConcentrate.Plant_IDConTreatType.ConcentrateTreatment_ID = Concentrate.ConcentrateTreatment_IDConcentrate.Concentrate_ID = PlantXConcentrate.Concentrate_IDDischargeType.DischargeType_ID = Plant.DischargeType_IDConTreatType.ConcentrateTreatTypePlantType.PlantType_ID = Plant.PlantType_IDDischargeType.DischargeType_ID = Plant.DischargeType_IDPlantType.PlantType_ID = Plant.PlantType_IDPlantType.PlantType_ID = Plant.PlantType_IDMembrane.Membrane_ID = Plant.Membrane_IDPlantCategory.PlantCatagory_ID = Plant.PlantCategoryPermitDetail.Permit_ID = PlantPermit.Permit_IDPermitType.PermitType_ID = PermitDetail.PermitType_IDOpProblemType.OpProblemsType_ID = OpProblems.OpProblemsType_IDOpProblems.OpProblems_ID = PlantXOpProblems.OpProblems_IDMSC.MemSysCon_ID = Plant.MemSysCon_IDMSC.MemSysCon_ID = Plant.MemSysCon_IDPlantType.PlantType_ID = Plant.PlantType_IDMembrane.Membrane_ID = Plant.Membrane_IDMembrane.Membrane_ID = PlantXMem.Membrane_IDPlant.Plant_ID = PlantXMem.Plant_IDEngDsnFirm.EngDsn_ID = Plant.EngDsnFrm_IDEngDsnFirm.EngDsn_ID = Plant.EngDsnFrm_ID[DischargeType].[DischargeType_ID] =[Plant].[DischargeType_ID][DischargeType].[DischargeType_ID]Plant.Plant_ID = Contact.Plant_IDPlant.Plant_ID = Contact.Plant_IDConTreatType.ConcentrateTreatment_ID = Concentrate.ConcentrateTreatment_IDConcentrate.Concentrate_ID = PlantXConcentrate.Concentrate_IDConTreatType.ConcentrateTreatTypeConTreatType.ConcentrateTreatment_IDConcentrate.ConcentrateTreatment_ID[PretreatTypes].[PretreatType_ID]([__PosttreatType_ID] = PostTreatType_ID)([__PostTreat_ID] = PostTreat_ID)ConTreatType.ConcentrateTreatTypeConTreatType.ConcentrateTreatment_ID\M/nP c E ' u 0  L  } _ A # w Y ;  Y;q,|^$tV8rH* |^&vX:z\> T GSPostTreatType+++ S  GS S GRPlantReason''' R  GR R GQPermitType%%% Q  GQ Q GPOpProblemType+++ P  GP P GODischargeType+++ O  GO O GNConTreatType))) N  GN N GMR@ 'MPostTreatTypefrmPostTreatmentSubformYY+ M  GM__PosttreatType_ID555 OM M GLB@ 'LPostTreatmentfrmPlantPosttreatSubform[[+ L  GL__PostTreat_ID--- OL L GKDischargeType+++ K  GK K GJ([__Plant_ID] = Plant_ID)8 'JqrySubform-PretreatfrmPlantEditOO7 J  GJ__Plant_ID%%% OJ J GIPlantCategory+++ I  GI I GHEngDsnFirm%%% H  GH H GGMembrane!!! G  GG G GFMSC F  GF F GEPlantType### E  GE E GD([__Plant_ID] = Plant_ID)8 'DqrySubform-PermitfrmPlantEditKK3 D  GD__Plant_ID%%% OD D GC([__Plant_ID] = Plant_ID)8 'CqrySubform-ConcentratefrmPlantEditUU= C  GC__Plant_ID%%% OC C GB([__Plant_ID] = Plant_ID)8 'BqrySubform-SourcefrmPlantEditKK3 B  GB__Plant_ID%%% OB B GA([__Plant_ID] = Plant_ID)8 'AqrySubform-PostTreatfrmPlantEditQQ9 A  GA__Plant_ID%%% OA A G@([__Plant_ID] = Plant_ID)8 'OAN M ! LL q mJ G84FU~zDB Kaa @ @~sq_ffrmEditor-PostTreatType(old)#4MR2KeepLocal Tdddddddb @` r:h@s:h@~sq_drptPlantFull~sq_drptSubreport-SourceQuery#4MR2KeepLocal T~~~~~~~| @_Yk:h@-qm:h@~sq_drptPlantFull~sq_dPreTreatQuery subreport#4MR2KeepLocal T|||||||z @]N{:h@Y>}:h@~sq_drptPlantFull~sq_dPlantReasonQuery subreport#4MR2KeepLocal T @\+Y:h@"Z:h@~sq_drptPlantFull~sq_dPermitQuery subreport1#4MR2KeepLocal Tzzzzzzzx @Z=x:h@Uy:h@~sq_drptPlantFull~sq_dContactQuery subreport#4MR2KeepLocal Tzzzzzzzx @YV_:h@`:h@~sq_drptPlantFull~sq_dConcentrateQuery subreport#4MR2KeepLocal T @WL@AsL@~sq_cPostTreatmentSubform~sq_cPostTreatTypeCombo#4MR2KeepLocal T @VM@M@~sq_cPlantReasonSubform~sq_cPlantReasonCombo#4MR2KeepLocal Tzzzzzzzx @TZl_@l_@~sq_cfrmSubform-Source~sq_ccboPretreatType#4MR2KeepLocal Tvvvvvvvt @S!@@~sq_cfrmSubform-Posttreat~sq_ccboPostTreatType#4MR2KeepLocal T~~~~~~~| @RY^_@Y^_@~sq_cfrmSubform-PlantReason~sq_cCombo21#4MR2KeepLocal Tpppppppn @POY_@CY_@~sq_cfrmSubform-OpProblem~sq_ccboOpProblemType#4MR2KeepLocal T~~~~~~~| @O^[_@[_@~sq_cfrmSubform-DischargeType~sq_cCombo21#4MR2KeepLocal Ttttttttr @MCe_@Re_@~sq_cfrmPostTreatmentSubform~sq_cChild3#4MR2KeepLocal Tpppppppn @L}_@:8_@~sq_cfrmPlantPosttreatSubform~sq_cChild1#4MR2KeepLocal Trrrrrrrp @JCѼc@Ѽc@~sq_cfrmPlantEdit~sq_csfmPretreat#4MR2KeepLocal Tdddddddb @Hq+Ѽc@|E-Ѽc@~sq_cfrmPlantEdit~sq_cCombo174#4MR2KeepLocal T^^^^^^^\ @GEѼc@,:Ѽc@~sq_cfrmPlantEdit~sq_cCombo115#4MR2KeepLocal T^^^^^^^\ @ StV8y[=  b D { ] ? ! u W 9  B $  r -  CrgIf4sU7F( bmO1c c GbPretreatTypes+++ b  Gb b GaPostTreatType+++ a  Ga a G`([__Plant_ID] = Plant_ID)8 '`qrySubform-SourcerptPlantFullKK3 `  G`__Plant_ID%%% O` ` G_([__Plant_ID] = Plant_ID)8 '_qrySubform-PretreatrptPlantFullOO7 _  G___Plant_ID%%% O_ _ G^([__Plant_ID] = Plant_ID)8 '^qrySubform-PostTreatrptPlantFullQQ9 ^  G^__Plant_ID%%% O^ ^ G]([__Plant_ID] = Plant_ID)8 ']qrySubform-PlantReasonrptPlantFullUU= ]  G]__Plant_ID%%% O] ] G\([__Plant_ID] = Plant_ID)8 '\qrySubform-PermitrptPlantFullKK3 \  G\__Plant_ID%%% O\ \ G[([__Plant_ID] = Plant_ID)8 '[qrySubform-OpProblemrptPlantFullQQ9 [  G[__Plant_ID%%% O[ [ GZ([__Plant_ID] = Plant_ID)8 'ZContactrptPlantFull77 Z  GZ__Plant_ID%%% OZ Z GY([__Plant_ID] = Plant_ID)8 'YqrySubform-ConcentraterptPlantFullUU= Y  GY__Plant_ID%%% OY Y GX [PretreatTypes].[PretreatType]= gXB@ gXPretreatTypes+++ X GX X GWPostTreatType.PostTreatType: gW PostTreatType.PostTreatType_ID= gWPostTreatType+++ W W GVPlantReason.PlantReason6 gVPlantReason.PlantReason_ID9 gVPlantReason''' V V GUermitType].[PermitType]8 gU[PermitType].[PermitType_ID]; gUPermitType%%% U GU U GTSourceType%%% T  GT @@  @@ @ @     @Si`JLdomSi`QOYmdifdkmmiQJmmvfQd^O+Si`QOYmdifiQmiQJmmvfQkd^O+Si`QOYmf^JbmmvfQk#Si``JYbSi`fOSsdi\kWQQmkSi`f^JbmQOYmSi`f^JbmQOYmd^OSi`f^Jbm^YkmSi`f^JbmfdkmmiQJmkoLSdi`Si`fdkmmiQJm`QbmkoLSdi`Si`fidUiQkkSi`iQJOQiSi`kQJiMWSi`kQJiMWiQko^mkSi`kQJiMWmQkm Si`koLSdi`MdbMQbmiJmQ/!Si`koLSdi`MdbmJMm/"Si`koLSdi``kM/#Si`koLSdi`dffidL^Q`/$Si`koLSdi`fQi`Ym/%Si`koLSdi`f^JbmiQJkdb/&Si`koLSdi`fdkmmiQJm/'Si`koLSdi`fiQmiQJm/(Si`koLSdi`kdoiMQ/)Si`sdi\kWQQmk*LJkkQJiMWkoffdim+M^JkkkQJiMWfJiJ`QmQiU^dLJ^JLLiQqYJmYdbmJL^Qifmf^JbmSo^^ifmkoLiQfdimMdbMQbmiJmQ7ifmkoLiQfdimMdbmJMm7ifmkoLiQfdimdffidL^Q`k7ifmkoLiQfdimfQi`Ym7ifmkoLiQfdimf^JbmiQJkdb7ifmkoLiQfdimfdkmmiQJm`Qbm7 ifmkoLiQfdimfiQmiQJm`Qbm7 ifmkoLiQfdimkdoiMQ7 iQkQmfJUQ JO`Yb OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MMdbMQbmiJmQkoLSdi`+kh+MMdbmiQJmmvfQMd`Ld+kh+MSi`fOSsdi\kWQQmk+kh+MM`LmYm^Q+kh+MSi`f^JbmQOYmd^O+kh+MMWY^O866+kh+MSi`f^JbmQOYmd^O+kh+MMWY^O<:+kh+MSi`f^JbmQOYmd^O+kh+MMWY^O>8+kh+MSi`f^JbmQOYmd^O+kh+MMWY^OB:+kh+MSi`f^JbmQOYmd^O+kh+MMWY^OBF+kh+MSi`f^JbmQOYmd^O+kh+MMWY^OH@+kh+MSi`f^JbmQOYmd^O+kh+MM`Lf^JbmmvfQ+kh+MSi`f^JbmQOYmd^O+kh+MMd`Ld:<+kh+MSi`f^JbmQOYmd^O+kh+MkS`fiQmiQJm+kh+MSi`f^JbmQOYmd^O+kh+MmQum88@+kh+MSi`f^JbmQOYm+kh+MMWY^O866+kh+MSi`f^JbmQOYm+kh+MMWY^O8:+kh+MSi`f^JbmQOYm+kh+MMWY^O<:+kh+MSi`f^JbmQOYm+kh+MMWY^O>8+kh+MSi`f^JbmQOYm+kh+MMWY^OB:+kh+MSi`f^JbmQOYm+kh+MMWY^OBF+kh+MSi`f^JbmQOYm+kh+MMWY^OH@ +kh+MSi`f^JbmQOYm+kh+MM`Lf^JbmmvfQ!+kh+MSi`f^JbmQOYm+kh+MMd`Ld86D+kh+MSi`f^JbmQOYm+kh+MMd`Ld88@+kh+MSi`f^JbmQOYm+kh+MMd`Ld8D>+kh+MSi`f^JbmQOYm+kh+MMd`Ld:<+kh+MSi`f^JbmQOYm+kh+MkS`fiQmiQJm+kh+MSi`f^JbmQOYm+kh+MmQum88@+kh+MSi`f^JbmfdkmmiQJmkoLSdi`+kh+MMWY^O8+kh+MSi`fdkmmiQJm`QbmkoLSdi`+kh+MMWY^O<+kh+MSi`koLSdi`MdbMQbmiJmQ+kh+MMLdfiQmiQJmmvfQC+kh+MSi`koLSdi`OYkMWJiUQmvfQ+kh+MMd`Ld:8C +kh+MSi`koLSdi`dffidL^Q`+kh+MMLddffidL^Q`mvfQC +kh+MSi`koLSdi`fQi`Ym+kh+MMLdfiQmiQJmmvfQC +kh+MSi`koLSdi`f^JbmiQJkdb+kh+MMd`Ld:8C +kh+MSi`koLSdi`fdkmmiQJm+kh+MMLdfdkmmiQJmmvfQC +kh+MSi`koLSdi`kdoiMQ+kh+MMLdfiQmiQJmmvfQC+kh+MfQi`YmkoLSdi`+kh+MfQi`YmmvfQ+YO+kh+Mf^JbmiQJkdbkoLSdi`+kh+Mf^JbmiQJkdbMd`Ld+kh+MfdkmmiQJm`QbmkoLSdi`+kh+MfdkmmiQJmmvfQMd`Ld`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO@  @ +kh+MSi`f^JbmQOYmd^O+kh+MMWY^OH@+kh+MSi`f^JbmQOYmd^O+kh+MM`Lf^JbmmvfQ+kh+MSi`f^JbmQOYmd^O+kh+MMd`Ld:<+kh+MSi`f^JbmQOYmd^O+kh+MkS`fiQmiQJm+kh+MSi`f^JbmQOYmd^O+kh+MmQum88@+kh+MSi`f^JbmQOYm+kh+MMWY^O866+kh+MSi`f^JbmQOYm+kh+MMWY^O8:+kh+MSi`f^JbmQOYm+kh+MMWY^O<:+kh+MSi`f^JbmQOYm+kh+MMWY^O>8+kh+MSi`f^JbmQOYm+kh+MMWY^OB:+kh+MSi`f^JbmQOYm+kh+MMWY^OBF+kh+MSi`f^JbmQOYm+kh+MMWY^OH@ +kh+MSi`f^JbmQOYm+kh+MM`Lf^JbmmvfQ!+kh+MSi`f^JbmQOYm+kh+MMd`Ld86D+kh+MSi`f^JbmQOYm+kh+MMd`Ld88@+kh+MSi`f^JbmQOYm+kh+MMd`Ld8D>+kh+MSi`f^JbmQOYm+kh+MMd`Ld:<+kh+MSi`f^JbmQOYm+kh+MkS`fiQmiQJm+kh+MSi`f^JbmQOYm+kh+MmQum88@+kh+MSi`f^JbmfdkmmiQJmkoLSdi`+kh+MMWY^O8+kh+MSi`fdkmmiQJm`QbmkoLSdi`+kh+MMWY^O<+kh+MSi`koLSdi`MdbMQbmiJmQ+kh+MMLdfiQmiQJmmvfQC+kh+MSi`koLSdi`OYkMWJiUQmvfQ+kh+MMd`Ld:8C +kh+MSi`koLSdi`dffidL^Q`+kh+MMLddffidL^Q`mvfQC +kh+MSi`koLSdi`fQi`Ym+kh+MMLdfiQmiQJmmvfQC +kh+MSi`koLSdi`f^JbmiQJkdb+kh+MMd`Ld:8C +kh+MSi`koLSdi`fdkmmiQJm+kh+MMLdfdkmmiQJmmvfQC +kh+MSi`koLSdi`kdoiMQ+kh+MMLdfiQmiQJmmvfQC+kh+MfQi`YmkoLSdi`+kh+MfQi`YmmvfQ+YO+kh+Mf^JbmiQJkdbkoLSdi`+kh+Mf^JbmiQJkdbMd`Ld+kh+MfdkmmiQJm`QbmkoLSdi`+kh+MfdkmmiQJmmvfQMd`Ld+kh+MfiQmiQJm`QbmkoLSdi`+kh+MfiQmiQJmmvfQYOMd`Ld'+kh+Oifmf^JbmSo^^+kh+OMdbMQbmiJmQhoQivkoLiQfdim+kh+Oifmf^JbmSo^^+kh+OMdbmJMmhoQivkoLiQfdim+kh+Oifmf^JbmSo^^+kh+OdffidL^Q`khoQivkoLiQfdim+kh+Oifmf^JbmSo^^+kh+OfQi`YmhoQivkoLiQfdim8+kh+Oifmf^JbmSo^^+kh+Of^JbmiQJkdbhoQivkoLiQfdim+kh+Oifmf^JbmSo^^+kh+OfdkmmiQJm`QbmhoQivkoLiQfdim+kh+Oifmf^JbmSo^^+kh+OfiQmiQJmhoQivkoLiQfdim+kh+Oifmf^JbmSo^^+kh+OifmkoLiQfdimkdoiMQhoQiv+kh+SSi`QOYmdifdkmmiQJmmvfQd^O?+kh+SSi`QOYmdifiQmiQJmmvfQkd^O?+kh+SSi`f^JbmQOYm+kh+SSi`f^JbmQOYmd^O+kh+SSi`f^JbmfdkmmiQJmkoLSdi`+kh+SSi`fdkmmiQJm`QbmkoLSdi`+kh+SSi`kQJiMW+kh+SSi`koLSdi`MdbmJMmC+kh+iJLLiQqYJmYdbmJL^Q+kh+iifmkoLiQfdimMdbmJMmKJLLiQqYJmYdbmJL^Q MdbMQbmiJmQ MdbMQbmiJmQhoQiv MdbmJMm MdbmJMm^YkmLvkmJmQf^Jbm MdbmJMmhoQivMdbmiQJmmvfQMdkm`dOQ^MdbkmJbmkOYkMWJiUQiQfdimhoQivOYkMWJiUQmvfQQOSiQfdimhoQivQbUOkbSYi`QbUOkbSYi`hoQiv`Q`LiJbQ`Q`LiJbQhoQiv`Q``dOQ^hoQiv`S^YkmhoQiv[m`kM`kMhoQiv`kMiQfdimhoQiv`kvkJMMQkkdL[QMmk`kvkJMQk`kvkY`QuMd^o`bk`kvkY`QukfQMk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkdffidL^Q`k dffidL^Q`khoQiv!dffidL^Q`mvfQ"dmWQifJiJ`QmQi#fQi`YmOQmJY^$fQi`YmhoQiv%fQi`YmmvfQ&f^Jbm'f^JbmMJmQUdiv(f^JbmMJmQUdiviQfdim)f^Jbm`Q`LiJbQiQfdim*f^JbmfQi`YmJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO @ @ @ @ @ @ @ @ @ @ @ @ @ @222223333 34 4 4 444 5555556666667777 7!78"8$8%8&8'8#9(9*9+9,9-9):.:0:1:/;2;4;5;3<6<8<9<:<;<7=<=>=?==>@>B>C>D>E>A?F?H?I?J?K?G@L@N@O@P@@MAAAAAABB B B B BC CCCCCDDDDDDEEEEFFF FG!G#G$G"H%H'H(H&I)I+I,I*J-J/J0J1J2J.K3K5K6K4L7L9L:L;LNCNENFNDOGOIOJOHPKPMPNPLQOQQQRQPRSRURVRTSWSYSZSXT[TTTUUUUUUV V V V V WWWWWXXXXXXYYYYYYZZ!Z"Z#Z$Z [%[&X4 @ @ @ @ @ @ @ @ @ @ @ @ @ @EEEEFFF FG!G#G$G"H%H'H(H&I)I+I,I*J-J/J0J1J2J.K3K5K6K4L7L9L:L;LNCNENFNDOGOIOJOHPKPMPNPLQOQQQRQPRSRURVRTSWSYSZSXT[TTTUUUUUUV V V V V WWWWWXXXXXXYYYYYYZZ!Z"Z#Z$Z [%['[([)[*[&\+\-\.\/\0\,]1]3]4]5]6]2^7^9^:^;^<^8_=_?_@_A_B_>`C`E`F`G`H`DaIaKaLaJbMbObPbNcQcccRddddeee ef f f f gggghhhhiiiijjjjkk k!k"k#k$k%k&k'k(k)k*k+k,kl-l/l0l1l2l3l4l5l6l7l 8l 9l.m:m>>>>>>< @ v͡[ @8 [ @OpProblemsQuery#@LLL@@@@@@@> @ c@@OpProblems#@BBB66666664 @A5V@C5V@MSysIMEXSpecs#<<<<<<<<<<: lF5V@ceH5V@MSysIMEXColumns#@@@@@@@@@@> _x'P@UV@MSysAccessObjects#DDDDDDDDDDB uP[ @򎡘[ @MSCReportQuery#@JJJ>>>>>>>< @tԠ[ @[ @MSCQuery#@>>>22222220 @ sAX[ @e[ @MF List Query (JT)#}@RRRFFFFFFFD @r[ @[ @MemModelQuery#@HHH<<<<<<<: @q_[ @ם[ @MembraneQuery#@HHH<<<<<<<: @K@|j@Membrane#5@>>>22222220 @p![ @![ @EngDsnFirmQuery#@LLL@@@@@@@> @DW@pF~@EngDsnFirm#?@BBB66666664 @?`|@/|@DischargeType#@HHH<<<<<<<: @n)[ @'g[ @DischargeReportQuery#@VVVJJJJJJJH @: t@z@CostModelConstants#@RRRFFFFFFFD @5Rl@"{@ConTreatType#@FFF:::::::8 @m[ @Ꝙ[ @ContactQuery#K@FFF:::::::8 @lw0[ @n[ @Contact List by State/Plant#W@dddXXXXXXXV @'Zc@@Contact#F@<<<0000000. @k v[ @0[ @ConcentrateQuery#@NNNBBBBBBB@ @sd[@!{@Concentrate#^@DDD88888886 @AO@Y@Abbreviation table#@RRRFFFFFFFD @ipys@s@~sq_rAbbreviation table#4MR2KeepLocal TPPPPPPPN @g6@6@~sq_ffrmSearch#2kz:4MR2KeepLocal TJ>>>>>>< `faq5_@aq5_@~sq_ffrmPostTreatmentSubform#4MR2KeepLocal TZZZZZZZX @d b_@ b_@~sq_ffrmPlantEdit(old)#4MR2KeepLocal TNNNNNNNL @c#/0Ѽc@1Ѽc@~sq_ffrmPlantEdit#4MR2KeepLocal TDDDDDDDB @1S~`8hJ r T 6 n P 2  v B  p * t J fH*c%f$uM!v4z<3c%oEngDsnFirm.EngDsn_ID3 goPlant.EngDsnFrm_ID1 goPlant.Plant_ID- goPlant oEngDsnFirm%%% o o GnDischargeTypePlant|@ A5+ n![DischargeType].[DischargeType]> gnD@  gn[Plant].[DischargeType_ID]9 gn[Plant].[Plant_ID]1 gnPlant nDischargeType+++ n Gn n GmPlantContactB@ 5) m Contact.*( gmPlant.Plant_Name/ gmPlant.Plant_ID- gm Contact m Plant m  m Gl Plant.Plant_Name/ 'l  Plant.State* 'lPlantContactB@ 5) lContact.ContactPhone3 glContact.ContactTitle3 glContact.ContactName2 glPlant.PlantType_ID1 glPlant.Plant_Name/ gl Plant.State* gl Contact l Plant l  l GkYConTreatTypeConcentrate@ K?) kYConcentratePlantXConcentratez@UI' kYB@ gkYH@ gkYConcentrate.TreatReason6 gkYConcentrate.ConcentrateDetail< gkYF@ gkYConcentrate.Concentrate_ID9 gkY"PlantXConcentrate.Concentrate_ID? gkYPlantXConcentrate.Plant_ID9 gkYPlantXConcentrate333 kYConcentrate''' kYConTreatType))) kY kY GjContact j  Gj j GiAbbreviation table555 i  Gi i GhContact h  Gh h GgPlant g  Gg g GfPostTreatment+++ f  Gf f GePlantPosttreat--- e  Ge e GdPlant d  Gd d GcPlant c  G6YEENEEY  Y V Y IDAbbreviationExplanation!!!YPrimaryKeyv1@ ES-wQ' m I g C  i C  h 9 z \ * z_AhDpDJ aAxGEWWTPwastewater treatment plant( DWWwastewater CWTPwater treatment plant" BWETwhole effluent toxicity$ AWDwater district @VOCvolatile organic chemical& ?UVultraviolet >UICUnderground Injection Control* =TSStotal suspended solids# <TREtoxicity reduction evaluation* ;TRCtotal residual chlorine$ :TOCtotal organic carbon! 9TNRCCTexas Natural Resources Conservation Commission> 8TMPtransmembrane pressure# 7THMFPtrihalomethane formation potential1 6THMtrihalomethane 5TFCthin film composite 4TDStotal dissolved solids# 3SWspiral wound (referring to membranes)1 2SROseawater reverse osmosis% 1SHMPsodium hexametaphosphate& 0SAWPASanta Ana Watershed Project Authority4 /ROreverse osmosis .PSIpounds per square inch (pressure). -PPMparts per million ,POTWpublicly owned treatment works (wastewater treatment)C +PACpowdered activated carbon& *PApolyamide )O2oxygen (NPDESNational Pollution Discharge Elimination System> 'NORMnormally occurring radioactive material5 &NDMAnitrosodimethylamine" %MTBEmethyl tertiary butyl ether) $Mnmanganese #Mg/Lmilligrams per liter" "MGDmillion gallons per day$ !MFmicrofiltration  MDEQMichegan Department of Environmental Quality: MCLmaximum contaminant level& LSILangelier Saturation Index' KDHEKansas Department of Health and Environment9 IXion exchange HFhollow fiber HCLhydrochloric acid H2Shydrogen sulfide GACgranular activated carbon& Feiron FDEPFlorida Department of Environmental Protection< EXCHexchange EDRelectrodialysis reversal% EDelectrodialysis DPdifferential pressure! DOdissolved oxygen DNRPDepartment of Natural Resources Protection8 DHECSouth Carolina Department of Health & Environmental ControlI DESALdesalination  DEMOdemonstration  DEMINdemineralization  DBCPdibromochloropropane (a pesticide)0  CWCBCalifornia Water Control Board,  CTACellulose triacetate! CONVENTconventionalCL2chlorine CIPclean in place Causticsodium hydroxide (also known as caustic soda)>CAPCentral Arizona Project$ CACellulose acetate BRObrackish reverse osmosis% Alum BRO brackish reverse osmosis CA Cellulose acetateusually aluminum potassium sulfate  a flocculantv@  @ @ @ @ @ @ @ @            ! "!#"$#%$&%'&(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?>@?A@BACBDCED) YR| = 251N  Y Y  Y  Y Concentrate_ID.ConcentrateTreatment_ID"ConcentrateDetailTreatReasoneeyh %V] &YY5YY.rCL{F76A81A4-1192-49D6-8A1F-6C06A2D5312E}.ConcentrateTreatment_IDPrimaryKey     v1b @ b1 S' | i V C 0 s ` M : '   u b O < )   ~ k X E 2  X E 2 s`M:'taN;{hUB/<l:'mZ/X-V+R| " R| " R| " R| " R| " R|'7B@#" R| " R| " R| " R| " R| " R|.7;@#T@"" R| " R| c?s caustic O?vs|2chlorination H2S removal=$ Yxq l Ki$7 ~g uf Mdhydrochloric acid)) Qd lb 8*_ b^ } FW V MHQ ^O|2BF Goodrich AF600 AntiscalantB) QN$7air injectionincrease D.O.@% *L$7 add oxygenwhen use Gulf dischargeG" JK$7 4ppm H2S   dHK|2oxygenation (O2)(( qJ ->B A l? M=|2blending of concentratereuse of concentrateQ/ ){9 'z9 M8 (8|2chlorination$$ ج6 *K6 $?6 5chlorination$$ a3|2hydrogen peroxideincrease D.O.D) x2 W/ hC. ❍- '[) % JO% $ e^$ A" " 7 'I Scarbon dioxide feed to lower pHD+ \'   R causticto approximate river pHD E"! B {  i> M $S $7air injection%% Hv   K 7 B -T M oy  Bt gt ѻP t G x u$7 *T ^o >DS Cchlorination$$ < 8Y  4 $7 \| >  S  m a|2chlorination$$ $7oxygenation (O2)((  |2blending with POTW water00 0H¿  -ڽ + $7 ,'air stripping%% sodium hydroxide(( U  gNե  Oe H2S removal#  Ϗ|2antiscalent - Flocon,, EDR concentrate low pH.  W)   ~ M Ӫ 5Nsodium bisulfite(( isulfuric acidfacilitate H2S removalI% R\ jp i =% wLVALV0removal of H2S aremoval of H2S and addition of DOwhen some concentrate goes to reuse systemwhen concentrate goes to deep wellprevent foaming of concentrte in sewerodor complaints from local residentsTreated or disposed of in cogulation processNo sewage treatment plant is availableMaximize recovery of wastewater and minimize discharge of waste to sanitary sewer. LVAL: Membrane backwash is dUse the acid and base cleaning Use the acid and base cleaning materials to nutralize each othersand/gravel filter; sludge is deposited; water goes back to lake sourceUse the acid and base cleaning materials to nutralize each otherMembrane backwash is delivered to a secondary recovery system where it can be returned to the head of the plant and removed in the floc/sed process, or it can be blended with raw water and pumped to one of the eight membrane racks for filtering. The wastewater from this rack is discharged to the sanitary sewer.8rGU* u 1  >  ^ 3  k @ p E   sHJvK R| " R| " R| chlorine, R|#@"" R|:7" R|$7" R|57" R|and scrubber0$ R|$7when go to perc pondDO<, R|when go to perc pondH2S=, R| remove H2S. R|*7" R|*7" R|" R|37" R|27" R|17" R|%7" R|%7 R|(7 R|B@#" R| " R|.7suspended solids removal< R| " R| " R| chlorine,@", R| $@"" R|$7" R|.7allow some separation9 R|-7Dow(@"' R| " R| " R| caustic+ R| " R| " R| " R| " R|phosphoric acid or caustic>2 R| " R| " R| " R| " R|/7remove hydrogen sulfide; R| " R| " R| " R|+7 bioxide&@"+ R| " R| " R| " R| " R| Recycled to head of plant.@"=1 R|*7" R|)7I@#(@"" R| " R|Receiving pond is chlorinatedTo control algae growthZ5  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @q !q !q !q !q !q !q !q ! q ! q !q !q !q !q !q !q !q !q !q !q !q ! q !!q !"q !$q !%q !&q !(q !)q !*q !,q !-q !.q !/q !0q !1q !2q !3q !4q !5q !6q !8q !9q !:q !<q !=q !?q !@q !Bq !Cq !Fq !Gq !Hq !Iq !Jq !Kq !Lq !Mq !Nq !Oq !Qq !Tq !Uq !Vq !Xq !Yq !Zq !\q !]q !^q !_q !eq !fq !gq !hq !iq !jq !kq !mq !pq !qq !tq !uq !wq !xq !yq !zq !{q !}q !~q !q !q !q $q $q $q $q $q $q $ q $ q $ q $q $q $q $q $q $q $q $q $q $q $q $q $ q $"q $6q $7! !!!7!>!E!P!n$*$-$.$0$4!! !!A!D!l!s$$$#!'!S$$$5!|! |!|!|!R|!W|![|!`|!d|!r$!$!$!#$!+$!;$!a$!b$!c$!o$$$$/$$2%$%%$&'!|($$)$*$*$+*$,+$ -$.!v.$.$!/$ 1$'2$(3$)5$1:$3 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @%=!i!pj! \R! i!N5!!M!~!! ! )W! ! ! eO!!%Ng!)!-U!0!2',!9 +!=-!=!?H0!A!B!Dȹ!Ga!Km!L!MS!P! P>!!T|\!"[ 4!#]!$cY8!%f<!&hC!'kSD>!(lo^!)rT*!*ru!+ux!,uG!-vt!.xP!/ztg!0ztB!1|!2}yo!3M!4T-!5B 7!6K!7!8!9vH!:S$!;M!<>i!={!>B!?!"E!@R!A!B '\!CS!DI'!E7!F!GA!H^e!I!JOJ!Kښ!L['!M!NCh!OW!Pȱx!Qa!R!S?$!TK*!U!V(!WŶM!Xz'!Y{)!ZM![l!\ݧ!]>-!^q!_Hd !`˄J!a*!bQ!c^!dHM!e֗!fF }!gb!h*8!il!jQ!kM!lu!m~!nK!o!pxY!qv?O!r?c!sR!tR!uR!vR!wR!xR!yR!zR!{R!|R!}R!~R!R!R!R$R$R$R$R$R$R$R$R$R$ R$ R$ R$ R$ R$R$R$R$R$R$R$R$R$R$R$R$R$R$R$R$R$R$R$ R$!R$"R$#R$$R$%R$&R$'R$(R$)R$*R$+R$,R$-R$.R$/R$0R$1R$2R$3R$4R$5R$6R$7 ?Y = 251N((Y Y  Y   Y   Y   Y   Y  Y Contact_IDPlant_IDContactNameContactTitleContactPhoneContactFaxContact DateUseContact  (2 (3Y 9YYL{2154C922-E47A-4774-BA4E-BEFE9EFEF0A4}Plant_IDPrimaryKey((((((( ( ( ( v1b N  : :'o9  ~ [ #  yvQ}=~&Մ=LRichard MarshallProject Manager 3039692569 3039692238 7-21-00u]E( iT Roger OlsonPlant Operator 9062280488 90622804874/99oW?# %04>8Steve NewmanWater Supervisor 3193852121 3193853010 8-24-99rZB$ ꥡ->Jim PassanisiWater & Refuse Superintend 8059866566 80598665655-6-99}eM% _Vh Karen HarrWater Resource Administrator 7574210601 7574214483 3-17-99|dL" JHK8Dennis RaymonSystem Engineer 9564306110 956430611112/99rZB% O8ӜFh7 Rudy HardManager (SC Edison) 3105100932 5624912450rrZB! |?z Dave BittnerEngineer, US Filter 3032873367 12-7-99r]]E$ 7{ Ron LongPublic Works Director 6023862487 60238678513-2-99s[C /F%zWilliam Dunivin!Superintendent Water Production 7143783253 7143783374 9-15-99lT' )$William O. GreenSuperintendent 9414862624 94148032207/99t\D( h *William KneePlant Manager 9544381231 95443053181/00oW?$ 39Fh7Kelly SullivanVillage Marine 8004214503ZZZB& z Andy GereSr. Water Qual. Supervisor 4082797815 40829258123/99yaI! TjBud ChristianseyPlant Supervisor 9098990060 90989903403/99v^F( /YHXSherri Anderson)@* 8438849626 843849223011-99vcK3' ,}9Stephen Hambric Engineer 9158521007 91585216205-00mU=' %4FManuel GonzalezWater-Wastewater Foreman 9153368525 9153366273 9-28-99}eM' 3ԍ:e+Brad O'keefePlant Superintendent 5617705068 56177053307/99v^F$ Š7 Cliff GibbsDirector of Public Works 7852633510 7852633594 1-22-99yaI# 2lTerry RaymondPlant Superintendent 7606634911 7606633715ww_G% zڈ8E7 Bryan RabonSystems Operator 8438865955 8438866894 8-24-99qYA# ЇVz8Charlie TouchstonePlant & District Mgr. 5805924421 5805924550 1-10-00}eM* Oy{ Guss Pennell,@* 7609664865 7607570347 11-19-99v`H0$ bJI8Adolfo BarrazaPlant Operator 9159642344 9159642394 10-1-99rZB& ԖI8Rodney A. EvansWater Utility Supervisor 3036552100 30365521069-9-99}eM' OF! 8 John BrownPlant Supervisor 7079372953 70793729533/99pX@" LVAL]6Water & Sewer TrWater & Sewer Treatment SupervisorSuperintendent of Water/WastewaterProcess&Improvement Educ. CoordinatorPresident, Aqua-Envirotech Mfg., Inc.President, Aqua-Envirotech Mfg., Inc.Process & Improvement Educ. CoordinatorEnvironmental Regulator Compliance Officer'qS  z T (  g1J:]}\A Paul PerryChief Operator 5404738316 54047383605/99nV>" SɝCarl BehrensWater Treatment Operator 6098849577 60988495763-3-99zbJ$ S[Paul SchoenbergerChief of Eng. and Operations 3106606218 31021724144/99kS) (eU#fM Tom ClarkWater Treatment Div. Mgr. 2547761441 2547725780 8-30-99x`H! f) David JundtWater Commissioner 4023583557 4023583715 8-24-99s[C# .ZNa Dan WhitlowCity Engineer 31965365843-3-99jVV># David CarrickWater & Sewer Supervisor 6098849576 60988473413-2-99{cK% z8E')Bob OreskovichWater Director252-441-7788 2524412239 4-27-99t\B& 08 Gary VeehWater Services Mgr. 7145733381 1-21-99oZZB! w  Carmen QuanDesign Manager 7144292020 71442920502-25-99, 12-2-99oW?# Ǽ{8 Jack DefoeMaintenance Foreman 9153712483 9153712555 1-11-00s[C" -B-jRich YoungbloodConservation Coordinator 8313846131 8315822675 9-10-99}eM' `qCTim CostelloExecutive Director 8042635341 80426385894/99t\D$ fDarrel V. LeemasterDistrict Manager 4353815333 43538153455/99yaI+ pXFCarl RuschmeyerUtility Engineering Manager 7757826227 7757829007 2-22-99hP' K(XQ Mel Falcon'@* 7015728527 7015729182 11-16-99t^F." E¯; Tom MayUtilities Operation Manager 9048226417 90482264668/99x`H etl0 Pat DyerWater System Manager 3605334100 36053329594/99rZB K` Ʉ8 Glen Lewis Operator 5123261311 5123265390 1-18-00}hP8" T7NVaile FeemsterSystems Supervisor 3348612363 3348615242 1-25-99v^F& Q'8Andrew FenskeChief Water Operator 9415740877 94157408826/99w_G% Fy{ Casey JaworskiTreatment Plant Supervisor 7609664865 76075703479-9-99~fN& U$G Karen HarrWater Resource Administrator 7574210601 7574214483 3-17-99|dL" 9& Roy FallonChief Operator 5615756235 56157562459/99nV>" #Y< Robin PeckChief Operator 5306224513 53062225284/99nV>" T¥^X John MortonLead Operator 9419552325 94136548406/99nV># 'l:  ` $   jE mK5[f36x9Steve SpearmanUtilities Superintendent 7022938984 70229689675-00|dL& =& 笀8Jim PassanisiWater & Refuse Superinten 8059866566 80598665655-6-99|dL% !8Duane WallaceSupervisor Water Operation 9544522544 95445225468/99}eM% On Bob ThomasWater Production Manager 2529262363 2529355337 3-29-99x`H" M}-j Joe CorreaPlant Operator 8313846131 12-8-99kVV>" gF8 Paul SietzOperation Manager 8086674349 80827078334/99qYA" G Bill PierceChief Operator 4158681224 41586895013/99oW?# ^jd<Nilaksh KothariWater Utilities Manager 9206834600 92068347484/99|dL' 6/)-g James JoersPrincipal Operator 6309647207 6309647467 9-22-99s[C# 8s%)Carl Hoffman Water Treatment Superintendent 4174482757 4174482758 1-10-99hP$ vis8 Dan DiazTreasurer of Board 9155924513 91559115221-5-00pX@ (k #s+ Dennis RuppPlant Supervisor 5803364165 58033658415/99qYA# _VJim PassanisiWater & Refuse Superinten 8059866566 80598665655-6-99|dL% U$v{9Ken KoistinenPublic Works Director 7014773610 7014773834xx`H% M{y$8Robert Boyce Manager 9549674230 95496742327/99{iQ9$ g]zRandy HoustonTreatment Plant Supervisor 4082797885eeeM% "wؗ5 Randy HinesSuperintendent 5617468343 5617438733 7/99, 5/00oW?# 8YHX Greg Hill Water Treatment Plant Operator 8438849626 8438492230 5-27-99}eM! Mt&Joseph NicolettiPlant Superintendent 9144221212 91442214695/99zbJ( KҲPaul Brayton Manager 9416252288 94162595846/99{iQ9$ gH7 JT MorrisManager, Oak Trail Shores 8175733931 817573012211/99x`H!  탊\Steve PotterChief Operator 9253735230 92537352953/99pX@$ nDwRobert DeHaasDistrict Manager 3034435394 30341506213/99s[C% qOC0# Larry ArnoldChief Operator 9142545676 91425468375/99pX@$ x>^D8O. Fred NelsonWater Utility Gen. Manager 2626534308 26265343036/99~fN& {P8Lewie BlessingSuperintendent 5402455227 54024556844/99rZB& oޒ!8Barry EricksonChief Operator 9413527002 941352702010/99rZB& 2'hn V P /   a.gZ1x"*8 Gary TreeseSuperintendent 8107943281 81079491865/99oW?# | 3"8Bret EisenhourSuperintendent 9078523176 90785263723/99rZB&   } 8 Rose BoydMaintanence Supervisor 7603553205 76035526853/99u]E! [ K} Randy BrownUnit Superintendent 9066442603 90664426665/99t\D# -؝ \Harry YoakumSuperintendent 3097422351 3097428224 10-1-99pX@$  ^}uMark Bissell 2522613266 25226117601-6-00hT<$$ } 0William E. JonesGeneral Manager 5405867679 54058658054/99u]E( wT  Ray DuboisWater/Sewer Supervisor 6239367141 6239070902 1-24-00v^F" \DlAlex MorelliSupervisor Operator 5185895020 51858970196/99u]E$ һ$G Glen PalenProject Manager, CH2MHill 70347114414-99saaI" 5wZlRobert BoycePlant Manager 9549674230 95496742322/00oW?$ cimSherri Anderson'@* 8438849626 843849223011-99vcK3' 9Steve Saltau"Water Production Superintendent 9413161530 94136164172/00jR$ 2 Dave MeckesChief Operator 9145861725 91458617274/99oW?# ;d Joe PaineCity Services Superintendent 4064852524 5-25-99xccK! Kz9Wayne GriffinMaintenence Manager 9416971758 94169706968/99v^F%  Jim StoneSuperintendent 8175739592 8175735591 8-25-99mU=! QY+J8George MaseehEngineer, Malcolm Pirnie 52062999822/99uccK% A%ηBruce ZimmermanWater Utility Manager 9068476130 90684760335/99zbJ' mN i Don LongOperation Supervisor 9544345519 95468031598/99rZB KAd8 Jim FoxPlant Supervisor 4156691414 41566910103/99mU= K Fh7 Dean MonroeManager (SC Edison) 0000000000\\\D# Jeg Floyd NakamuraHead of Plant Division 8085276140 80852761874/99zbJ& U)bK Mel Falcon'@* 7015728527 7015729182 4-21-99s^F." TRichard MarshallProject Manager 3039692569 30396922387-00u]E( ^b韭Bob Hendricks Director 8057726261SSS;% jiOqJohn TenEyckEnvironmental Manager 5619785220 56197852152/00w_G$ O">uBob OreskovichWater Director252-441-7788 2524412239 1-14-00t\B& i'c\ 2  z C + nK rDFPg; ' Fred DavisAssistant Superintendent 4072554622 40725546369/99x`H" Df8-j Pete Cohen 8313846131 12-9-99O::"" 77Ronald DeiberSuperintendent Operations 7122841122 7122841122 8-24-99|dL% q:00]Brian StewartLead Plant Operator 9547972169 954797276312/99v^F% j/6x9Richard MarshallProject Manager 3039692569 30396922387-00u]E( .4>8Lori GlanzmanGeneral Manager 3193852121 3193853010 11-15-99rZB% |.GK 4 Tim LewisWater System Superintendent 9038927257 90389271778-24-99, 11-30-99zbJ! .K+a John HaysSuperintendent of Water 3196532764 3196535273 9-28-99v^F! ;'ABrent GolladayWater Dept. Superintendendent 5407409576 54074092044/99iQ& 0o%James BennuttoChief Operator 9416252288 9416259584rrZB& {$SH Jim FixenSuperintendent 70182834611-5-00iUU=! v*$pDick DerowitschEngineering Manager 9414721502 94147215059/99x`H' $$?5 Sal PalazolloChief Operator 6075887388 60758881565/99qYA% Ҿ#2Dan SpauldingSuperintendent 4029946705 4029946705 8-24-99qYA% 6L)bK Mike MadsonDirector of Public Works 4067662202 4-21-99vaaI# 38 Jude PereraProcess Control Eng. 3104140183 3103225572uu]E# O)F Dave RequaEngineering Manager 9258280515 92582911805/99s[C" <)Art ValenzuelaWater Qual.&Prodn Supervisor 7145733382 7148380039 1-21-99hP& Х'k8David HamiltonPlant Operator 3362463558 33624644094/99rZB& *$m Greg Hill Water Treatment Plant Operator 8438849626 8438492230 5-27-99}eM! <ND Mitch McCaw$@* 8158534585 8158530006 9-22-99t_G/# ƞ}Byron WeightmanSuperintendent 9413326876 94133266238/99s[C' fyMark ChristiansonCity Superintendent 7124693043 7124693986 1-24-00zbJ) 붵>< Ron WeisLead Operator 9416425405 94164265308/99}kS; 1~NJeff Caldwell Manager 3348612363 1-25-99gRR:% j)- Jimm BakosProject Engineer 5177544717 51775444407/99pX@" { TSteve SpearmanUtilities Superintendent 7022938984 70229389875-99|dL& 'i% , P , ]6iI_G_ iGeorge HaughneyUtilities Director 9544345519 95468031598/99w_G' ]uv Roy DavisPlant Operator 9407792251 9407794210 1-12-00mU=! R]5c Mehul PatelPlant Research Eng. 7143783200 71437833744/99t\D# d]ĤkBill PrestonFacilities Manager 9097855411 9097857076 3-23-99t\D$ \%8Bernie MiloskyPlant Superintendent 9417435588 94174372928/99x`H& <9[fb Joe ZawackiAssistant Manager 9412831071 94128377927/99rZB# .[ggRaymond MatneyTown Manager 5406864221 54068649225/99pX@& LqZW{8 Jay BellPlant Operator 8159453811 81594535111-5-00lT< ݿZ$J Ron HarrisChief of Water Resources 7572478465 7579267178 3-23-99x`H" %XR_ Greg Hill Water Treatment Plant Operator 8438849626 8438492230 5-27-99}eM! WG$Albert Quednau Operator II 9416390331 94163946658/99oW?& :jUG9 Michael RoyPlant Superintendent 9414743217 94147504971/00u]E# $`Ro#8 Darrel PolkGeneral Manager 9419642423 94196406258/99pX@# HRogMCharles McGuirePublic Works Director 3094322644 3094323547 9-21-99zbJ' YN=LSteve SpearmanPark Superintendent 7022938984 70229389675/99w_G& UMэ8Dennis HoweyWater Superintendent 7016782548 70167827501-5-00v^F$ L) Gary VeehWater Services Mgr. 7145733381 1-19-99oZZB! ,͜J/8Dave Dollinger Superintendent of Public Works 8154522406 8154522811 1-24-00jR& qBJ0 Tom MayUtilities Operation Manager 9048226417 90482264668/99x`H H8Lynn StevensWater Plant Foreman 7277381840 727736620512/99u]E$ ,Fx} Lee Slate 9097855411999!! jP|E^X John MortonLead Operator Ext. 6259U>>># 1C- Vicki FloodClerk 5176975532NNN6# pB,wi Carmen QuanDesign Manager 7144292020 71442920502-25-99, 12-2-99oW?# )AȄ7 Bob ThomasWater Production Manager 2529355327 2529355337 3-26-99x`H" *yAmuY8Brian VanMeeterenWater Superintendent 7128454526 71284546118-24-99,12-16-99{cK) ip<9ml James JoersPrincipal Operator 6309647207 6309647467 9-24-99s[C# 2'b0  o z F 3  xV-~ 2U|WFSam Frazzini Operator614-882-0313TTT:$ WF Steve SmithSuperintendent of Operations614-882-6586gggM# QFSteve Scotton operator978-630-8791UUU;% ^F Rick Garcia supervisor940-889-0040 5-10-02jUU;# ]F Greg HobbsDirector of Water254-662-5429[[[A" aF Tom TraxelWater and Sewer Director307-532-2012bbbH" RFGlenn DishongSuperintendent W & WW512-930-3555bbbH% _F hFRandy Mullins303-790-4830 9/13/02T??%% Wߣ7 Kevin RudeProject Manager (PEC) 3162622691 3162623003 1-22-99u]E" }dDouglas WhitneyEngineer, MSE-HKM 4066566399 4066566398 6-17-99v^F' |H7 Phil IvesPlant Operator 8175733931 81757301225/00mU=! x ׵Patrick IrwinPlant Supervisor252-987-1111252-987-1110 4-27-99w]C% )x`8 Wyatt WonAss't Mgr. of Operations 3106606203 3104140183 9-10-99w_G! XvErik CaldwellRegional Mgr., Koch Membr 60396418843-3-99xddL% `eo+J8 Don GageProject Manager 6029303904 6029152667 2/99, 12/99mU= )o;Paul HendricksOperations Manager 6025828560 6235810929 1-14-00v^F& n8Art ValenzuelaWater Qual.&Prodn Supervisor 7145733382 1-21-99}hhP& fnx} Mike WrightProgram Manager 9095970827 90978570765/00pX@# tWmVh Glen PalenProject Manager, CH2MHill 70347114414-99saaI" 1SlI8 James JoersPrincipal Operator 6309647207 6309647467 9-22-99s[C# =:j+2Steve SpearmanUtilities Superintendent 7022938984 70229389875-99|dL& ~iI:4Bob Hendricks Director 8057726261SSS;% xhis8 Mark BrodyPlant Supervisor 6194759047 61947962719-9-99pX@" ff+2Richard MarshallProject Manager 3039692569 30396922387-00u]E( Hf3I[Lonnie BurrusPlant/Systems Mgr. 2529286651 25292866517-1-99u]E% 8ds!Lonnie SpadyLead Operator 7194566067 7194561210 5-27-99oW?$ ,d?z Mike ComparoniPlant Operator 7194561260 7193843167 11-12-99rZB& cV+ Tom WernerWater Production Manager 7572552247 75725503042-4-99x`H" cF49Slavica Dedovic-HammondProject Engineer 3105248349 31052483105/00}eM/ P '$\ C * O s d ~ uF Conrad EyeWater operator540-476-2554XXX>" >uTerry GoldmanChief Operator252-995-5061 6-06-02p[[A% _>uJohn ContestablePlant Superintendent252-995-5061 6-06-02yddJ( _ ׵Robert OreskovichUtilities Director252-441-7788 6-07-02xccI) _8E')Nancy LoomisPlant Superintendent252-441-7788 6/07/02u``F$ _SF Don CumbeeExecutive Director, GCPSAIIII" CF Brad MacekAsst. Operations Manager772-873-6400bbbH" CF Gary BashamUtility Director772-873-6400[[[A# LF [F Carl ScheelManager, Water DistrictHHHH# dF Carl ScheelManager, Water DistrictHHHH# NFDave WhittakerSuperintendent810-765-4647\\\B& \FDerek ClevengerDirector of Water620-421-7091```F' YFBary Collins$@*660-562-3713JJJ0$ ZF Rich MorseSenior Operator860-396-7517YYY?" ZFPatrick BernardoDirector of Utilities860-396-6780eeeK( ' @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ _R/ wD, Mgo/  V_,[+;+  7H, 7H0]0.gg/X^+X^/,."T-"T.&Cq+ )G$+)G$-*2+0*2+0+ #0,1DN.3-5}.5c5/5 05 1 6F. 7Θ%- ;)B0-D<+Flm9/F0/N\-N). N)/ Sl2)S$G/U&,XA+Zu>-Zu>1 Zu>1\{7)`A.bz) bz, f$)hȩ -mj) nq-q)f+q+V0s5, si -si /sm-sm.z2. {}x/{}x0 »+++0- --.-/{y){y+ - z?)z?05?.y.Gڗ,)%s,!s0d- d09ۉ+ .'E8+'E81  )e:)s#,lt+ڜ- KG.:I0hF)hF)hF-/.E8)։)։0, !F) }-*-3. "3-`0+0 k.d-P,վ,D^,!,!,#o/$y{, %/'Q+>4)>4.IJ)I)IѤ0 J+- J+0K)Yum/sҳ0si,zV){+{W//ɲ+/ // 4F0x6,x6.{v$, }) -G/0 dj,>.-)Xp+ S.$/b)-b). =)=/ f#+Π+Π.X(+ HY) HY, I30܊,+.f/ݑ+ -),V)V0 w,/-+-,-./Z-D-O,Ƣ.}^-u/%F)K-F4) FC1FC1 FL1FN1FQ0FR0FS1 FW0FW0FY1FZ1FZ1F[1F\1F]0F^0F_0Fa0Fd1Fh0Fu1' @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @O))b)O)Ј)z) ) ) ԣ3)%) ,) /) T) ) 93)hȻ)))/))|)8O)HJ) _)")#0%)#Ti)$&)%T+'Y#+(+*U++F+,˨+-7T+/ `K+/e+/E+ 3K+ 3̱+ 4+ 4`+ 5B-+5+6 w+60+:z+<̚+?NZ.+?+FUe(+HS+IS+I\}+Jo,O{,P>x,PCOq,Pn,Q ,Qg,RK,TtM,V8, Xw", Z]g, [Mܠ, [U, ],^ k(,`v,`8,a/6,a^,d,dFg,d}M,f,f,g &=,g3f,i"O-iOij-ib^-jӅ-kU-ugeJ-w K-yAK-{Nm-|A- }YQ- }- 9zK- ;- --ic-w5--\-Tw-}----[- -|-"- {.)j.~1..f.Ƹ.<.$*.'.<. )O. . L6. . $.*v.{.o0.;.K..|..j.:q..fD.gP.pi/y*/)/p/1/|Pj/,/Ⱥ/Bq/ʜ,/ / ̈́U/ Y/ H/ `$/j://%//qL/./9</ܯ/݈d/ݧR/ݩ/G/00,080H0f0hx0~0:=0S10 Wt0 f0 쌥0 )0 e`0٬X0)000000000000001111111111 1 1 1 1 11) @ @ @ @ @ @ @ @ @ @ @ @ @ @[([)[*[&\+\-\.\/\0\,]1]3]4]5]6]2^7^9^:^;^<^8_=_?_@_A_B_>`C`E`F`G`H`DaIaKaLaJbMbObPbNcQcccRddddeee ef f f f gggghhhhiiiijjjjkk k!k"k#k$k%k&k'k(k)k*k+k,kl-l/l0l1l2l3l4l5l6l7l 8l 9l.m:mm?m@mAm;nBnDnEnFnGnHnInJnKnCoLoNoOoPoQoRoCoCoCoCoCo CoCoMpCpC pC pC pC pC pCpCpCpCqCqCqCqCqCqCqCqCqCqCqCqCq CqCqC qCrC!rC#rC$rC%rC&rC"sC'sC)sC*sC+sC,sC-sC.sC/sC0sC1sC2sC(tC3tC5tC6tC7tC8tC9tC:tC;tCv^v^v^v^v^v^v^ v^ v^ v^mY:7N66Y  Y ].ConcentrateTreatment_ID(ConcentrateTreatTypeY69YY.rBPrimaryKey66v1 5i@ }V) ` 9 q P :7Na2CO357degas for H2S!47degas37 chlorine27 soda ash17aerate07$@8/7air stripper .7 settling-7defoaming agent#,7air stripper/chlorination-+7odor control agent&*7 )7sand/gravel filter&(7chlorination '7neutralization"&7secondary recovery&%7#$7 aeration|2otherdechlorination"disinfection pH adjustment!degasification" NoneLVALdegas-scrubber, degas-scrubber, caustic blend, Cl2? 5 @ @ @q 77777|7$7%7&7'7 (7 )7 *7 +7 ,7-7.7/7071727374757:7 wY N;;Y Y Y  Y Y Y lConstantsID4curCapitolCostInitialValuelLandTypelDikeHeightdLinerMaterialslNumberLiners;=lna;>YYlConstantsIDPrimaryKeyv1@ ^:t ףp= ????V@?pLQ?? :<<<< :<<<<QYN@@Y  Y ] DischargeType_IDDischargeType@B.Y9Y.rBPrimaryKey@@v1, ?sI'N _ ,  f evaporation ponds%evaporation shed$land application$DWI septic tanksurface (after settling),recycle (after settling),multiple types"land - percolation pond+land - leach field&land - irrigation (reuse)-injection - shallow well,injection - deep well)injection - aquifer (reuse)/  reuse system  recycle#otherevaporation pond$sewer surfaceZ ? @ @ @AAAAAA A AAA A A A A AAAAAAAAI{:u- Y  R x H  R  B  oQ3W9|@ `tL_$lD WuMSC.MemSysState. guMSC.MemSysCity- guMSC.MemSysName- guMSC.MemSysCon, guMSC.MemSysCon_ID/ guPlant.MemSysCon_ID1 guPlant.Plant_ID- guPlant uMSC u Gu u GtMSCPlantJ@-! tMSC.MemSysPhone. gtMSC.MemSysName- gtMSC.MemSysCon, gtMSC.MemSysCon_ID/ gtPlant.MemSysCon_ID1 gtPlant tMSC t t Gs(((Plant.PlantType_ID)=1))9 'sPlantTypePlantV@9-# sPlant.DesignCap. gsPlant.County+ gs Plant.State* gs Plant.City) gsPlant.Plant_Name/ gsPlantType.PlantTypeInitials: gsPlant sPlantType### s s GrMembranePlantP@7+! rMembrane.MembraneModel5 grPlant rMembrane!!! r r GqMembranePlantXMemX@?3! qPlantPlantXMemF@9- q Membrane.MembraneType4 gqMembrane.MembraneMaterial8 gqMembrane.MembraneModel5 gqMembrane.MembraneManufacturer< gqMembrane.Membrane_ID3 gqPlantXMem.Membrane_ID4 gqPlantXMem.StepNum0 gqPlantXMem.Plant_ID1 gqPlant.Plant_ID- gqPlantXMem### qPlant qMembrane!!! q q GpEngDsnFirmPlantR@;/% pEngDsnFirm.EngDsnPhone5 gpEngDsnFirm.EngDsnContact7 gpEngDsnFirm.EngDsnFirm4 gpEngDsnFirm.EngDsn_ID3 gpPlant.EngDsnFrm_ID1 gpPlant pEngDsnFirm%%% p p GoEngDsnFirmPlantR@;/% o EngDsnFirm.EngDsnPhone5 goEngDsnFirm.EngDsnState5 goEngDsnFirm.EngDsnCity4 goEngDsnFirm.EngDsnCity4 goEngDsnFirm.EngDsnContact7 goEngDsnFirm.EngDsnFirm4 g !YlF = 251NEEllY  Y  Y  Y  Y   Y  EngDsn_IDEngDsnFirmEngDsnContactEngDsnCityEngDsnStateEngDsnPhone Y EJ Y 9Y.rBPrimaryKeyEEEEEEE E v1b N D$%8 L Y q e  4n..d]3YhVUlteig Engineers, Inc.Bruce LangnessFargoND]]YF*Boyle Engineering Corp.Don Shroeder OntarioCA 7149866811v^ZE+?GsCamp Dressor & McKee Bill Suratt AnnandaleVA 7578738850t\XA(?m7McClure Engineering ServicesPeoriaILHHD00bMetcalf & Eddy, Inc. David BlairAAAA(~Poe & AssociatesOklahoma CityOKCC?$$Kennedy/Jenks ConsultantsLynn Takaichi VenturaCA 8056580607ya]H-?u~ McLaughlin Water Engineers LTDTerry KanyonDenverCO 3034585550|d`L2?0;A&H ConsultingJim AlexanderLovellWI 3075489965mUQ="?9Ees Consulting Inc.Rick PiersonWA 4254528100]EAA'7o JEO, Inc.Dennis JepsonWahooNEOOK8][Maurer-Stutz, Inc. Joe StutzPeoriaIL 3096937615mUQ=&?4sIonics, Inc.Curt GalreithMA??;; IFluid Systems & CDM'''''^CH2M Hill, Inc.Brian FuerstDallasTX 9729802170mUQ=#?0OOsmonics, Inc. MinnetonkaMN>>:""3 SPICER Group Jim Bakos SaginawMI 5177521294hPL7 ?-WMontgomery Watson EngineersAbdul RashidiCANNJJ/G&7Gilmore EngineeringRoger Gilmore 9169877124ZBBB'';ZCamp Dressor & McKeeRhonoVA??;((& Thomas & Hutton Engineering Co Mark Yodice Mt PleasantSC 8438847878hdK2?8 Anderson & Associates BlacksburgVAEEA))DProf. Engineering Consultants Kevin Rude WitchitaKS 3162622691{c_I1?~!G.V. Jones & Assocs. Greg Jones AnchorageAK 9073464123s[W@(?eCH2M Hill, Inc. Glen Palen HerndonVA 7034711441lTP;#?!Metcalf & Eddy, Inc.Robert OrtizFL 9544505114^FBB(7l Montgomery Watson & City of LASlavica Dedovic-Hammond El SegundoCA 3105248349soW2?0 Reese, Macon & Associates Inc. Bill Reese Lake WorthFL 5614333226~fbJ2?|߅Malcolm Pirnie, Inc.VictorA. Hurburt, P.E. MaitlandFL 4076601113~fbL(?Waterlink Technologies, Inc.00000"Gee & Jensen Engineering Inc.JacksonvilleFLOOK119R.Stuart Royer & Assocs., IncMatt Eastbrook RichmondVA 8042810901gcM1?u!̃McAmee,Porter,& Seley Eng.Ken Kingsley Ann ArborMIcc_H.Source, Inc. Jim Elliot Cape CoralFL 9415492345lTP8 ?g*Rivers & Associates, Inc. Randy Gould GreenvilleNC 2527524135zb^F-?{ݍCamp Dressor & McKee AnnandaleVACC?((JD!' L P }  &9JPUGE~;Matter & Craig Tom AustinRhonoVAQQM:"T!Kadrmas Lee Jackson PC Don Loomer WillistonND 7015726352u]YB*? HDR Engineering Roger NoackAustinTX 5129125100lTP<#?bS FTCSH, Inc.Grand RapidsMI==9 ~ Brelge and Race Inc. Tom Yokoy Santa RosaCA 7075761322s[W?(?&AEPI/Rostek, Inc. Ian Watson Santa RosaCA 7075277908qYU=%?Camp Dressor & McKee Bill Surrat Vero BeachFL 5612314301u]YA(?JMontgomery Watson Engineers Lyle Muner PlantationFL 9548460401{c_G/?g JEO, Inc. Ron Benson NorfolkNE 4023716416fNJ5?Hutcheon Engineers John PottsWest Palm BeachFL 5618450666w_[>&?XInterstate Engineering Randy Pope JamestownND 7012520234u]YB*?' MSE-HKMDoug Whitney BillingsMT 4066566398gOK5?cm0Coster EngineeringMike Pasbrig MankatoMN 8004335620qYU@&?5[Montgomery Watson Engineers Jeff Mohr PasadenaCA``\F/uAEPI/Rostek, Inc. Ian Watson Santa RosaCA 7075277908qYU=%?tBoyle Engineering Corp. Doug Eckman SarasotaFL^^ZD+dpHazen and Sawyer PCSussan Milmud New YorkNY 2125397071t\XB'?American Tech Steve Ike WillistonNDSSO8!,Faught & AssociatesRoman Bustillos El PasoTX 9155424900u]YD'?+dSeparation Processes Inc. Dick Sudak San DiegoCA 7607363200x`\E-?_8Black & Veatch Corp Jeff DavisNC 9106723600[C??'7V<CH2M Hill, Inc.Randy Dentin Santa AnaCA 7144292020pXT=#?0Harn RO Systems, Inc. Jim HarnVeniceFL 9414889671oWS?)?Ionics, Inc.Not Supplied 0000000000R::: 'oJohanson Tuttle Eng.Craig JohansenCastle ValleyUTcc_D(qxPickett & Associates, Inc.Vince PickettBartowFL 9415339095ya]I.?r In House Brad JordanDarienIL 6309647207eMI5?bJCamp Dresser & MckeeRhonoVA??;((<:Engineering Concepts Inc.William Johnson FintcastleVA 5404731253~fbJ-?W URS GranierVictor Frazita New YorkNYUUQ;FMontgomery Watson EngineersDennis SmithSan FranciscoCAhhdI/= Finkbeiner,Pettis&Strout,Inc.William RussellGreensboroughNC 3362922271miN1?mVeenstra & Kimm, Inc.Tim O'Conner 5152258000[CCC)'LD$}tG Z $ f C : j .Vm e\o1} Parkhill, Smith & Cooper, Inc.Louie Rodriguez El PasoTX 9155433320hdO2?=t{DRMPTampaFL//+yzMontgomery Watson Engineers Dan Spiegel SacramentoCA 9169248844|d`H/?yMatter & Craig Tom Austin RhonockVASSO:",vHoward R. Green Company Dan Lovett Des MoinesIA 5152782913w_[C+?>yetMalcolm Pirnie, Inc.George Maseeh PhoenixAZ 5206299982t\XC(?^oBoyle Engineering Corp.Steve DuranceauFL 4074251100dLHH+7{UmHDR Engineering#####/lNot SpecifiedNot Specified 0000000000T<<<!'kFarnsworth & Wylie, Inc. Doug Melton BloomingtonIL 3096638435zb^E,?Li Ionics, Inc Paul Wright PhoenixAZQQM8iCamp Dressor & McKeeDon G. BrownWalnut CreekCA``\B(5hCH2M Hill, Inc.James HeydornFL 8138740777ZB>>#7;MfIonics, Inc.Edward Geishecker WatertownMA 6179362500rZV? ?bHDR EngineeringAllan Kitchenn Las VegasNVZZV?#BXFishbeck,Thompson,Carr,&HuberTim McNamaraAdaMI 6166762666x`\K1?0GRQ Associates, Inc. Bob Quinn TeaneckNJ 2016921640oWS>'?EBlack & Veatch Corp. Dan Lopez Los AngelesLA\\X?(~eDBoyle Engineering Corp. Bob MahoneyDDDD+dBBoyle Engineering Corp.Christopher Martin BakersfieldCA 8053257253hdK+?ESBCamp Dressor & McKeeJohn N. CevaalDenverCO\\XD(ڝAPatrick Engineering Jeff SchuhLisleILVVR?'h@Boyle Engineering Corp.N/A OrlandoFL 4074251100mUQ<+?ɑ> Interstate Rock Products, Inc. Trace Allan HurricaneUT 4356352628~fbK2?;Duberry and DavisMarionVA==9%%9Black & Veatch Corp. Dan Lopez Los AngelesCA\\X?(Q9Ees Consulting Inc.Rick PiersonWA 4254528100]EAA'71z9Camp Dressor & McKee(((((4w9NPS-Denver Service Center Dan Overzet LakewoodCO 3039692295x`\F-?Q9Graham & Associates'''''6CH2M Hill, Inc.Chuck Crandall AtlantaGAXXT?#i$5Fluid Process SystemsStephen Hambric El PasoTX 9158521007w_[F)?* NBS Lowery*g-&CH2M Hill, Inc. Troy LynDeerfield BeachFL 9544266112rZV9#?k" Conklin, Porter & Holmes Engin Al Baker DaytonaFL 9047364142ya]H2?q'Camp Dressor & McKeeBruce ChalmersIrvineCA 9497525452t\XD(?D2F#####FMalcolm Pirnie, Inc. Bob Volgo New YorkNY 5185895131qYU?(?Kiwi PacificSan FranciscoCA??; T D @ @ @ @ @ @ @ @ @ @ @ @ @{F*gFF!uF9F"FF|F0FlF !F  eF  !~F  DF  8F&FZ;F7&GFW-F$ 3F%O0F&^F(IF-s4F3[]F5oF69F7;0F9~uF?FB~FCbFE7mF FsGF!IF"JVF#KmGL =GLFGMWGN:<GRJbGU rGWxqGYoG[G \0G _H,HH yH!t=H"H#IFIFI Y5I{ = 251NLLY  Y  Y  Y  Y  Membrane_ID(MembraneManufacturerMembraneModel MembraneMaterialMembraneTypei  LT YY 9Y.rBPrimaryKeyLLLLLLL L v1b N `3K+K7 J {  X  W \z(!#W [5i$8Hydranautics8040LSV-CPA2PASWZJ: `|8Fluid Systems8231 SD MagnumCTASW^N=!7Memcor60M10CPolypropyleneHFYI.a7Memcor72M10CPolypropyleneHFYI.T7Not SpecifiedNot SpecifiedN/AN/A^M<!r@2HydranauticsESPAPASWRB2 Dupont 0880 B9PAHFO?/^ FilmTecFT30SW=--$Hydranautics L348040CPAZPASWYI9 96 Aqua SourceUFHF?//{Fluid Systems TFC 8822HRPASWYI9!| Memcor72M10CPolypropyleneHFYI.}Memcor24M10CPolypropyleneHFYI.0 OsmonicsSW,2ϬHydranauticsCPA2PASWRB2 <\ Dow FilmtecBW-400PASWSC39Fluid Systems 8821 HRSWF66!t"ZenonZeenogen ZeeweedHFG77ͱMemcorPolypropyleneHFE5o Filmtec NFD-8040PASWQA1tIonics, Inc. Aquamite 50999 #Fluid SystemsSW1!!!$ FilmtecPASW;+Ionics, Inc.Aquamite 50, & 20??? y[Fluid Systems 8831ULP-600PASWZJ:!HydranauticsPVD1PASWRB2 ժFluid Systems8921SPASWTD4!US Filter/Memcor42M10CPolypropyleneHFcS8$HydranauticsCPA2-LSY 8040PASW[K; `o US Filter48M10CPolypropyleneHF\L1aiY Dow-FilmtecNF-70CTASWSC26 Filmtec BW30-8040PASWRB2SMemcor40M1PolypropyleneHFWG,Hydranautics8040MSY-CAB2CTASW[K: S}QHydranautics8040LHY-CPA3PASWZJ: =]Dow Chemical BW30-8040PASWWG7 Ionics, Inc. EDR2020555 Ionics, Inc.Aquamite 100::: H4 US Filter200M10PolypropyleneHF\L1 Ionics, Inc.Aquamite 130::: UHydranautics ESPA2-365PASWWG7 ŠʏMemcor30M10CPolypropyleneHFYI.pp1Not SpecifiedCTASWB2!!VK)D% 5 e  E ? e  J] Jx 3N:I{Fluid Systems TFCL 8822HRhigh reject polyamidespiral-woundw]:!I{+@PT@O Polyamidespiral woundO5I{ polyamidespiral woundO5I{ polyamidespiral woundO5I{MEMCOR - US Filter M10C CMFPolypropeleneHollow FiberqW<&I{ US Filter610MCPolyprolieneHFZJ0I{Koch Membrane SystemsHF-40 polysulfonehollow fiberoU<)I{ polyamidespiral woundO5I{MemcorM10Cpolyproplenehollow fiber`F,I{PALLMicroza USV-6203PVDFHollow fiberbH6I{ONDEOLB-35CAhollow fiberV<,I{ Dow FilmtecC7+I{Hydranautics ESPA 2-4040TFCspiral wounddJ9 I{Koch Membrane Systems 8822HR-365TFCSpiral WoundlRA)I{Asahi Chemical USV-6203PVDFHollow FiberdJ8"I{Pall USV - 6203PVDF hollow tube[B0I{''''I{Hydranautics8040-LSY-CPA2PASW[K; yKoch8821/ 8831 ULPSWD44{r Osmonics54A-230K-BLX-HRPASWYI99n Filmtec BW30LE-440PASWSC3:mFluid Systems TFC2822SSSWH88!ވefOsmonics, Inc.811CTASWTD3"EbIonics, Inc. ` Dow-FilmtecPASW?/6^Memcor90M10CPolypropyleneHFYI.K[HydranauticsPASW@0 ZYU.S. Filter (Dow)B-9HFF66%XFluid Systems 8" MagnumCASWXH8!+NHydranautics8040-UHY-ESPAPASW[K; 1MFluid Systems 8822 HRSWF66!{KMemcor60M10CPolypropyleneHFYI. KFluid Systems8821ULP MagnumPASW]M=!FJ Dow-Filmtec30W400PASWSC3GG FilmtecCTASW<,oEIonics, Inc.Aquamite 120::: >HydranauticsCPA3PASWRB2 [7;Fluid Systems8821LPPASWUE5!#f9 Filmtec NF90-400PASWQA1f@9Koch/Fluid Systemssee commentsPASW`P@&8Fluid SystemsULPSWB22!LVALPhase one / Espa's Phase two / TFC 8822 Phase one / Espa's Phase two / TFC 8822 HR (1st stage) TFC 8821 ULP400 (2nd stage)LVALPhase one / HydranauPhase one / Hydranautics Phase two / KochK2*R F  }  K  ? ? `9XWK?v3j'v̼I{HydranauticsCPA2CASpiralVB2 ˼I{ CFM90M10CA5)ʼI{6*ɼI{6*ȼI{6*ǼI{6*ƼI{6*żI{6*ļI{6*üI{6*¼I{6*I{6*I{6*I{6*I{ Zeno Gem@4(I{HydranauticsHydrocore 50sulfonate PESspiral woundoU: I{6*I{6*I{6*I{HydranauticsESPA3composite polyamidespiral woundnT3 I{6*I{ Osmonicsspiral woundN4(I{6*I{KOCH<0$I{Dow ChemicalFilmtec BW30LE-440TFCspiral woundkQ@ I{KOCH ROGA 8231CAspiral woundY?/I{6*I{6*I{M10CMFspiral woundL2&I{6*I{HydranauticsD8, I{HydranauticsESPA 3TFCspiral wound_E4 I{ HyranauticsESPA3spiral woundX>2I{HydranauticsTFCspiral woundW=, I{6*I{6*I{6*I{6*I{PALL Microze MFPVDFhollow fiber\B0I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{ FilmTec NF-70/NF-55TFCspiral wound_E4I{Zenon ZeeWeed 500PVDFhollow fiber_E3I{Koch PolysufoneH<$I{KOCH Membrane Systems 5" HF PMPW PolysulfoneHollow FibertZA)&K:P D { 8 o , c W  K  ?v3j'^RF}:q.I{6*I{6* I{6* I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*߼I{6*޼I{6*ݼI{6*ܼI{6*ۼI{6*ڼI{6*ټI{6*ؼI{6*׼I{6*ԼI{6*ӼI{6*ҼI{6*ѼI{6*мI{6*ϼI{6*μI{6*ͼI{MemcorM10Cpolyproplenehollow fiber`F,fKz7n+ b  V  J  > u 2 5I{6*4I{6*3I{6*2I{6*1I{6*0I{6*/I{6*.I{6*-I{6*,I{6*+I{6**I{6*(I{6*'I{6*&I{6*%I{6*$I{6*#I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*I{6*dK @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ 1ppMʠMUM M!4HM&M'M(]=M)Q}SM2M 5SM >6M >YiaM >o`M BMCMHMIMS[yM[M_$M_#MatMcoMgMh"tMr9Mw\<Mw2M}0M}M|M{M 69M!$M"^M#M$@rM%TM&aM'M(|`M)$M*N@fNf#N7[NNoNGNʻFN˭ N{N 1N ή+N N ZN KN޵6NN⋈ENeN:N9N{NNININININININININININ IN!IN"IN#IN$IN%IN&IN'IN(IQIQIQIQIQIQIQIQIQIQ IQ IQ IQ IQ IQIQIQIQIQIQIQIQIQIQIQIQIQIQIQIQIQIQIQ IQ!IQ"IQ#IQ$IQ%IQ&IQ'IQ(IQ)IQ*IQ+IQ,IQ-IQ.IQ/IQ0IQ1IRIRIRIRIRIRIRIRIRIR IR IR IR IR IRIRIRIRIRIRIRIRIRIRIRIRIRIRIRIRIRIRIR IR!IR"IR#IR$IR%IR&IR'IR(IR)IR*IR+IR,IR-IR.IR/IR0IR1IR2IR3IR4IR5I R6I R7IR8IR9ISISISISISISISISISIS I#S I$S I%S I&S I'SI(SI*SI+SI,SI-SI.SI/SI0SI1SI2SI3SI4SI5S YP} = 251NVVY  Y  Y . Y  Y  Y MemSysCon_IDMemSysConMemSysNameMemSysCityMemSysStateMemSysPhone  V] Y9Y.rBPrimaryKeyVVVVVVV V v1b N U#t  ~ 5 d `N HEXx' LA WaterWalnutCA440dy#Koch Membrane/Fluid Systems/////"Dupont Permasep ProductsRichard Myers Jr.NewarkDE 3024510938{c_K,?Z Hydranautics John Wammes OceansideCATTP9 h,Coster EngineeringMike Pasbrig MankatoMN 8004335620qYU@&?Ionics, Inc.Eugene ReahlHuntington BeachCA 7148992310t\X: ?S U.S. FilterAndy Mitchell 5624904649R:::'Not SpecifiedNot Specified 0000000000T<<<!'wIonics, Inc. Bill Harvey WatertownMA 6179262500lTP9 ?c*Waterlink Technologies, Inc. Jeff DunnWest Palm BeachFL 5616846300hdG0?%Osmonics, Inc. Woody Caine MinneapolisMN 6126534300pXT;"?PƿU.S. Filter Memcor&&&&&C8Ionics, Inc.Curt GalreithMA??;; `Ionics, Inc.Edward Geishecker WatertownMA 6179262500rZV? ?EIonics, Inc.Mark Feinberg;;;; 4FilmTec CorporationStuart McCellan 6516266616\DDD''J[Coster Engineering MankatoMN 8004335620W?;&&; ]Hydropro, Inc. Lake ParkFL==9""E Ionics Inc.Joe Aldridge 6023822431Q999'hKoch Membrane/Fluid SystemsCarrie Haider St. PaulMN 6124701253|d`J/?5uHydranautics Mark Wilf San DiegoCA 7609012578jRN7 ? Gaco SystemsBrantford, Ont, CanadaDDD  ,7Coster Engineering Jim Eidget MankatoMN 5076256621oWS>&?d*Koch Membrane/Fluid SystemsGerry Foreman San DiegoCA 6196953840}eaJ/?}Hydranautics @Membrane Systems CorporationMike Humpries Cape CoralFL 9412839462gcK0?!3Waterlink Technologies, Inc. Jeff DunnWest Palm BeachFL 5616846300hdG0?mtWaterlink Technologies, Inc.John RiflemanW. Palm BeachFLjjfK0'ΠZenon Environmental Inc.Adam KaminskiBurlington, Ontario, Canada 9056396320ppG,/oMembrane Systems Corporation Larry Clure San DiegoCAdd`I0Koch Membrane/Fluid SystemsGerald Foreman 6196953840cKKK/'vFluid Process SystemsStephen Hambric El PasoTX 9158521007w_[F)?FIonics, Inc. Paul Wright PhoenixAZRRN9 qAqua-Envirotech Mfg., Inc.Mel D. Falcon WillistonND 7015728527|d`I.?fMembrane Systems CorporationPaul Laverty San DiegoCA 6196792206}eaJ0?0U'z {   N  5 : r7O[.9}X@TP}KOCHEvelyn Scibelli978-657-4250O555'SP}Fluid Systems619-695-3840G---!'RP}(@YBen Molenhoff772-546-6292G---'QP}+@YSeparation Processes Inc760-736-3205R888'PP}W@YSeparation Processes Inc760-736-3200R888'OP}Energenecs (MEMCOR) Harlan Mueller262-377-6360^DDD''NP}MEMCOR US Filter719-550-2109K111'MP}KOCHBrian Kilcullen800-343-0499O555'LP}2@YSeparation Processes Inc.760-736-3205S999'KP}MEMCOR US Filter800-636-2674K111'JP}PALLColleen Wing607-753-6041L222'IP} AQUASOURCE6***'HP}&@YMr. Hany Said 626 4326632F---'GP}Membrane Systems Inc.Ashwin Desai805-564-8939]CCC)'FP}Harn R/O Systems Inc. Jim Harn941 488-9671Y???)'EP}PALL Karl Britt607-753-6041J000'DP}PALL Rick Moro516-801-9842I///'CP}'''''BP}Dow ChemicalCliff GilbertNJ 6092318392W?;; 75zOsmonics, Inc.John Schuster MinnetonkaMNYYU="*zHydropro, Inc.Ben Mohlenhoff Lake ParkFL 5618486788qYU>"?!uFarnsworth & Wylie, Inc.,,,,,5=pHydranautics San MarcosCA<<8 iCoster Engineering Rob Jones MankatoMN 8004335620nVR=&?UFhCharleston ConstructorsCambridge Trott CharlestonSCdd`H+weTexas Western Water Services Don Pruitt El PasoTX 9157784855ya]H0?|bU.S. Filter MemcorJonathan Hado 4102520800YAAA&'")THydranauticsDaniel J. Muff BastropTXUUQ< q MOsmonics, Inc. MinnetonkaMN>>:""ʣ3LSeparation Processes, Inc......Z3KKoch Membrane/Fluid SystemsMadelyn Epple St. PaulMN 6124701253|d`J/?pEU.S. Filter Memcor Joe West TimoniumMD 4103082971nVR<&?DHarn R/O Systems, Inc. Jim HarnVeniceFL 9414889671pXT@*?ZKDU.S. Filter Memcor Rick Farnan BroadviewILZZV?&48>Koch Membrane/Fluid SystemsJohn Buonassisi San DiegoCA 9414925408gcL/?u= Water&Power Technologies, Inc.Mark StevensAllenTX 9727277844{c_L2?D:AquaSource North America Barry Nixon 8047567711]EEE,'Γ@8Hydranautics John Zorbas OceansideCA 7609012584lTP9 ?b0U.S. Filter MemcorDave BittnerCommerce CityCO 3032873367w_[@&?LVALQ&Fluid Systems (KOCHFluid Systems (KOCH)/Avista TechnologiesPhase one / Hydropro Phase two / AMSTrain #1 - 4 Fluid Systems (KOCH) TFC-HRTrain # 1 & 2 Hydraunatics ESPA'2s (low press) Train #3 Fluid systems (KOCH) TFC-HRTrain #4 - 8 Hydranautics ESPA2's (low pressure)Advanced Environmental Systems, Inc.2U=HN F  H  W  P  Q  UL PY u<-Ie,P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}MEMCOR US Filter800-636-2674K111'P} Ferguson Service Systems, Inc. Woods Davis800 539 0045eKKK2'P}MEMCOR2&&&'P}*'P}*'P}*'P}*'P}*'~P} AQUASOURCE6***'}P}ZENON1%%%'|P}*'{P}*'zP}*'yP}MEMCOR2&&&'xP}ZENON1%%%'wP} ; ZENON3''''vP}Ionics2&&&'uP}*'tP}Koch Membrane SystemsA555)'sP}KOCH0$$$'rP}*'qP}PALL0$$$'pP} Osmonics4((('oP}MEMCOR2&&&'nP}*'mP}MECO 1%%%'lP}Medco System8,,, 'kP}KOCH0$$$'jP}KOCH0$$$'iP}MEMCOR2&&&'hP}ZENON1%%%'gP}Hydranautics8,,, 'fP}*@Y*'eP} AES Florida7+++'dP}*'cP}*'bP}MEMCOR2&&&'aP} AQUASOURCE6***'`P}*'_P}PALL0$$$'^P}MEMCOR2&&&']P}ZENON1%%%'\P}ZENON1%%%'[P}Hydranautics8,,, 'ZP}KOCH0$$$'YP}MEMCOR2&&&'XP}MEMCOR2&&&'WP}*'VP}ZENONTeresa Voisin905-465-3030N444'UP}KOCHSandy Berman800-343-0499L222' UEUq8 T  p 7 S  o 6 R  n5Qm4Pl3Ok2NP}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'ߙP}*'ޙP}*'ݙP}*'ܙP}*'ؙP}*'יP}*'ԙP}*'љP}*'ЙP}*'͙P}*'̙P}*'˙P}*'ʙP}*'əP}*'șP}*'ǙP}*'ƙP}*'™P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'P}*'UUP}*'P}*'P}*'P}*'P}*'U @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @fWqW FWvWW oįW 'W"tmW$3!W%@W 1}W ;*dW ?7,W A W Mu5WShΤWUEWZ] W][JW]4WeEWh`Wn8CWwPWy%Wy*cW{wWߣWSWʳW,hWZWW ydW!xW"bX@XDXuX84XKZXXŬpX3ZX3X  qX )"X Մ|X wX FUXX=5Xܽ!X*X5XPBXPCXPDXPEXPFXPGXPHXPIXPJXPKXPLXPMXPNX POX!PPX"PQX#PRX$PSX%PTX&PUZPVZPWZPXZPYZPZZP[ZP\ZP]ZP^Z P_Z P`Z PaZ PbZ PcZPdZPeZPfZPgZPhZPiZPjZPkZPlZPmZPnZPoZPpZPqZPrZPsZPtZPuZ PvZ!PwZ"PxZ#PyZ$PzZ%P{Z&P|Z'P}Z(P~Z)PZ*PZ+PZ,PZ-PZ.PZ/PZ0PZ1PZ2PZ3PZ4PZ5PZ6PZ7PZ8PZ9PZ:PZ;PZ<P[P[P[P[P[P[P[P[P[P[ P[ P[ P[ P[ P[P[P[P[P[P[P[P[P[P[P[P[P[P[P[P[P[P[P[ P[!P["P[#P[$P[%P[&P['P[(P[)P[*P[+P[,P[-P[.P[/P[0P[1P[2P[3P[4P[5P[6P[7P[8P[9P[:P[;P[<P[=P[>P[?P[@P[AP[BP[CP[DP\P\P\P\P\CmOb @ O k 5  : o . bD&n/P2G|7vFX!2z Plant.StartDate. 'zPlantTypePlantV@9-# zTypePlantType.PlantTypeInitialsB ozCapacityPlant.DesignCap>!! ozStart Up DatePlant.StartDateH++ oz Plant.State* gz Plant.City) gzName of PlantPlant.Plant_NameI++ ozPlant.Plant_ID- gzPlant zPlantType### z z GyMembranePlantP@7+! yMembrane.MembraneType4 gyMembrane.MembraneMaterial8 gyMembrane.MembraneModel5 gyMembrane.MembraneManufacturer< gyMembrane.Membrane_ID3 gyPlant.Membrane_ID0 gyPlant.Plant_ID- gyPlant yMembrane!!! y y GxPlantCategoryPlanth@A5+ xPlantCategory.PlantCatagory: gx PlantCategory.PlantCatagory_ID= gxPlant.PlantCategory2 gxPlant.Plant_ID- gxPlant xPlantCategory+++ x Gx Gx x GwctPermitDetailPlantPermit\@K?) wctPermitTypePermitDetailj@I=% wctPermitType.PermitType4 gwctPermitType.PermitType_ID7 gwctPermitDetail.Conditions6 gwctPermitDetail.Description7 gwctPermitDetail.PermitType_ID9 gwctPlantPermit.Plant_ID3 gwctPlantPermit.Permit_ID4 gwuctPlantPermit''' wuctPermitDetail))) wuctPermitType%%% wct Gwuct wct GvReOpProblemTypeOpProblems|@K?+ vReOpProblemsPlantXOpProblemsr@QE% vReOpProblemType.OpProblemsType; gvRe!OpProblemType.OpProblemsType_ID> gvRe"OpProblems.OpProblemsDescription? gvReOpProblems.OpProblemsType_ID; gvReOpProblems.OpProblems_ID7 gvRe PlantXOpProblems.OpProblems_ID= gvRePlantXOpProblems.Plant_ID8 gvtRePlantXOpProblems111 vtReOpProblems%%% vtReOpProblemType+++ vtRe vRe GuMSCPlantJ@-! uMSC.MemSysPhone. g YT.1N``Y Y DataID_sa`peYAOIndexN K_[ 8J. 0cctLLS@LL0c0fpe cd\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ph`ifgPMSysAccounts x xK_[ࡱ> :1,-Root EntrypaUVBA=8paUVBAProject "=8paUVBA=8paUvEF )!t#&(PropDataSUTypeInfou23FwZ L8Blob       45 !"#$%&'()*+,-./01236789HGRSJKLMNOPQglUVWXYZ[\]^_`abcdefhijkmonprqsvuwyxz|{}~AcessVBAData PROJECTwm_PROJECT! NFRZUICGSXECODHMVIFGGJIFVIBF:tPropDataWYTypeInfo BlobDeltaX24K_[]җ8җ8hargeTyped Label10mtxtOpProblemsd Label11mtxtStartDated Label12mtxtFeedTDSd Label13mtxtCityd Label15mtxtPlantIDd  Label17dmmdmdmdmdmdmdmdmdmdmdmdmdmdmdmdmd worksheet from the list, then click View:܆UEy{ t9hͬ$3>OWm>Detailh btnClosed Label8h btnViewocmbTitle038=Babce ghXijIk3H/@ qrySearchResults Arial8 h4C od,,LetterDINU"4'Z@)LPT1:s IILPT1:d2 Tahomam45 Tahoma` DetailKUMK=Fm7U`aektxtPlantNamePlant_Name"[Event Procedure]6^E.Htd5U`,abc Label0Plant Name:#4N{K~m7U`atektxtState State pzPGBY@?d5U`,atb c Label1 State: 0;@ߵ&R3m7U`aP e ktxtPlantTypePlantType%E,I[=d5U`,aP bc Label2Plant Type:rAMm7U`ae)k txtPlantCategoryPlantCategory6/t8@Kۊ_j&d5U`,ab*c Label3Category:RaDzNm07U`aektxtDesignCapDesignCap Fixed͘ GBdmd5U`,abc Label4Dsgn Capacity:eSgMUm7U`aeuktxtWaterSourceWaterSourceãAKJA d5U`,abvc Label5Source:9}?IKm7U`ae ktxtPretreatPretreatbE{Qd5U`,abc Label6Pre-treat:"Hs5fORm7U`a$ ektxtPosttreatPosttreate0EQ=d5U`,a$ bfc Label7Post-treat:C_Oc_dm7U`a| eak txtPlantReasonPlantReasonA3`E9m[[?d5U`,a| bc Label8Reason::(C1FAQ]j^m7U`a e$ k txtConcentrateConcentrateN|9N$w=iwd5U`,a bc Label9Conc-treat:>?@ABDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklnoqrstuvwxyz{|}~ _ Forms V8kۉ      !"#$%&'(6+,-./012357=9O:;<>B?@ACIDEFGHJMKLPNQRabcdefg_xz{AcessVBAData PROJECTwm_PROJECT! NFRZUICGSXECODHMVIFGGJIFVIBF:tt ID:m8e6Io P N` P@X  @xID="{68000A37-4D80-485E-B7EF-37D2AE0C48E8}" DocClass=Form_frmMain/&H000K_[00000 DocClass=Form_frmAbout/&H00000000 DocClass=Form_frmPlantList/&H00000000 DocClass=Form_frmSearch/&H00000000 DocClass=Form_frmReader/&H00000000 DocClass=Report_rptPlantFull/&H00000000 DocClass=Form_frmWorksheets/&H00000000 DocClass=Form_frmPDFWorksheets/&H00000000 Module=Global DocClass=Form_frmSea      !"#$%&'()*+,-./012     !$'(+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQSTUVWXYZ[\]`abcdfghijklmnqstuvwxyz{|}~      !"#$%&'()*+,-./012rchResults/&H00000000 DocClass=Form_frmProgress/&H00000000 DocClass=Form_frmPlantEdit(old)/&H00000000 DocClass=Form_frmSubform-Contact/&H00000000 DocClass=Form_frmSubform-PlantReason/&H00000000 DocClass=Form_frmSubform-Posttreat/&H00000000 DocClass=Form_frmSubform-Pretreat/&H00000000 DocClass=Form_frmEditor-PretreatTypes(old)/&H00000000 DocClass=Form_frmSubform-Concentrate/&H00000000 DocClass=Form_frmSubform-Permit/&H00000000 DocClass=Form_frmSubform-Source/&H00000000 DocClass=Form_frmSubform-OpProblem/&H00000000 DocClass=Form_frmSubform-MSC/&H00000000 DocClass=Form_frmEdit-PlantTypes/&H00000000 DocClass=Form_frmSearchTest/&H00000000 Class=ClassSearchParameter Module=basSearchSupport Name="TreatmentPlants" HelpContextID="0" VersionCompatible32="393222000" CMG="C8CA29AF2DAF2DAF2DAF2D" DPB="9092717272727272" GC="585AB93ABA3ABAC5" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_frmMain=22, 22, 734, 536, Z Form_frmAbout=110, 110, 866, 531, Form_frmPlantList=88, 88, 844, 594, Form_frmSearch=198, 40, 962, 627, Form_frmReader=0, 0, 764, 417, Report_rptPlantFull=220, 220, 834, 668, Form_frmWorksheets=242, 242, 954, 756, Form_frmPDFWorksheets=88, 88, 852, 517, Global=110, 110, 874, 539, Form_frmSearchResults=176, 176, 940, 605, Form_frmProgress=176, 176, 939, 605, Form_frmPlantEdit(old)=22, 22, 807, 386, Form_frmSubform-Contact=176, 176, 912, 540, Form_frmSubform-PlantReason=132, 132, 868, 496, Form_frmSubform-Posttreat=44, 44, 780, 408, Form_frmSubform-Pretreat=22, 22, 758, 386, Form_frmEditor-PretrK_[eatTypes(old)=0, 0, 714, 441, Form_frmSubform-Concentrate=110, 110, 846, 474, Form_frmSubform-Permit=88, 88, 824, 452, Form_frmSubform-Source=66, 66, 802, 430, Form_frmSubform-OpProblem=154, 154, 890, 518, Form_frmSubform-MSC=0, 0, 736, 364, Form_frmEdit-PlantTypes=176, 176, 696, 532, Form_frmSearchTest=22, 22, 736, 463, ClassSearchParameter=44, 44, 758, 485, basSearchSupport=198, 198, 912, 639, Bky]Form_frmMainForm_frmMainForm_frmAboutForm_frmAboutForm_frmPlantListForm_frmPlantListForm_frmSearchForm_frmSearchForm_frmReaderForm_frmReaderReport_rptPlantFullReport_rptPlantFullForm_frmWorksheetsForm_frmWorksheetsForm_frmPDFWorksheetsForm_frmPDFWorksheetsGlobalGlobalForm_frmSearchResultsForm_frmSearchResultsForm_frmProgressForm_frmProgressForm_frmPlantEdit(old)Form_frmPlantEdit(old)Form_frmSubform-ContactForm_frmSubform-ContactForm_frmSubform-PlantReasonForm_frmSubform-PlantReasonForm_frmSubform-PosttreatForm_frmSubform-PosttreatForm_frmSubform-PretreatForm_frmSubform-PretreatForm_frmEditor-PretreatTypes(old)FrchResults/&H00000000 DocClass=Form_frmProgress/&H00000000 DocClass=Form_frmPlantEdit(old)/&H00000000 DocClass=Form_frmSubform-Contact/&H00000000 DocClass=Form_frmSubform-PlantReason/&H00000000 DocClass=Form_frmSubform-Posttreat/&H00000000 DocClass=Form_frmSubform-Pretreat/&H00000000 DocClass=Form_frmEditor-PretreatTypes(old)/&H00000000 DocClass=Form_frmSubform-Concentrate/&H00000000 DocClass=Form_frmSubform-Permit/&H00000000 DocClass=Form_frmSubform-Source/&H00000000 DocClass=Form_frmSubform-OpPorm_frmEditor-PretreatTypes(old)Form_frmSubform-ConcentrateForm_frmSubform-ConcentrateForm_frmSubform-PermitForm_frmSubform-PermitForm_frmSubform-SourceForm_frmSubform-SourceForm_frmSubform-OpProblemForm_frmSubform-OpProblemForm_frmSubform-MSCForm_frmSubform-MSCForm_frmEdit-PlantTypesForm_frmEdit-PlantTypesForm_frmSearchroblem/&H00000000 DocClass=Form_frmSubform-MSC/&H00000000 DocClass=Form_frmEdit-PlantTypes/&H00000000 DocClass=Form_frmSearchTest/&H00000000 Class=ClassSearchParameter Module=basSearchSupport Name="TreatmentPlants" HelpContextID="0" VersionCompatible32="393222000" CMG="7F7D9E2162DFE5E3E5E3E5E3E5E3" DPB="FEFC1FA2E15E615F615F61" GC="7D7F9C1F649F659F6560" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_frmMain=22, 22, 734, 536, Z Form_fTestForm_frmSearchTestClassSearchParameterClassSearchParameterbasSearchSupportbasSearchSupport  Bas0{741B7CEF-3C5D-4D5F-8738-A8799D0BFB3C} |GlobalSpacAIFalse dCreatablTru PredeclaId"Expose_Templat@eDerivCustomizD$Option Comp@ DT  EnFd)M-cmd7_ C;k.Dim intRespon@=Integ er= PWTEAGIWJFNYNDYPPDQAKRIRPMNJ:pl0FFAMCOEYMFHWRDKCTKFJLRCKCYAK:+_VBA_PROJECTCSdir:K_[rmAbout=110, 110, 866, 531, Form_frmPlantList=88, 88, 844, 594, Form_frmSearch=198, 40, 962, 627, Form_frmReader=0, 0, 764, 417, Report_rptPlantFull=220, 220, 834, 668, Form_frmWorksheets=242, 242, 954, 756, Form_frmPDFWorksheets=88, 88, 852, 517, Global=110, 110, 874, 539, Form_frmSearchResults=176, 176, 940, 605, Form_frmProgress=176, 176, 939, 605, Form_frmPlantEdit(old)=22, 22, 807, 386, Form_frmSubform-Contact=176, 176, 912, 540, Form_frmSubform-PlantReason=132, 132, 868, 496, artDateStartDateHxF?},d5U`,aXbucLabel12Start Date:5btOsٸm7U`a,etk txtFeedTDSFeedTDS2ۡVG(*dd5U`,a,b9cLabel13Feed TDS:힦¹O\m7U`aHeaktxtCityCityHB"Sd5U`,aHb cLabel15 City:Ѣ2Eu^m7U`aetxtPlantIDPlant_IDemMKw0Yd5U`,abcLabel17Plan Form_frmSubform-Posttreat=44, 44, 780, 408, Form_frmSubform-Pretreat=22, 22, 758, 386, Form_frmEditor-PretreatTypes(old)=0, 0, 714, 441, Form_frmSubform-Concentrate=110, 110, 846, 474, Form_frmSubform-Permit=88, 88, 824, 452, Form_frmSubform-Source=66, 66, 802, 430, Form_frmSubform-OpProblem=154, 154, 890, 518, Form_frmSubform-MSC=0, 0, 736, 364, Form_frmEdit-PlantTypes=176, 176, 696, 532, Form_frmSearchTest=22, 22, 736, 463, ClassSearchParameter=44, 44, 758, 485, basSearchSupport=198ͬ!?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}WCAUKSFAWINASDNSVKLTBLSQUHCJ:le&KOSJERKGQUYUIEWHMZFFNBOPJRBB: -GOKWVNDECNOKHEPVZQEYHVNFUTMK:YAJRDDEFJIGNHEMIVDCPLJBOFZBD: ^@AYSHOGCUISXPFEXQJCZEDSNZKAON:1>VSYIVBEKWJNPODWJOILR_TRRMQXD:+ANACKYJJUHKOVDQSANHSCNZTDDSN:?SWPWSXCUFXIHHEBYHFNZ_FYBDVMJ:l      !"#%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]_`abcdefghijklmnopqrstuvwxyz{|}~MLTPKWFNWJATBEWITLTV_FVWOIXH:6SFMNICCPJGJHRDUWPQKMIQBQZQXF: VHPQVKIGMXRCFEDGTJIWK_[DXYXFXDF:]SZRSBN_TQKFTRDZFTGNLJPUZVPB_:      !"#$%&'()*+,-./012345789:;<=>?@ABCDEFGHIJKLMNOPQRSTUWXYZ[\]^_`abcdefhijklmnopqrstuvwxyz{|}~XBESUJLEQNRZODKSRFPGMVFHCDQK:pTWMFDSLMZEJYAEIJCCNXIVWKCGBE: KJWHPBIOKGTCVDEJBRTFGVEEBIAI:glDGBLIAFRWKCXZDVZEVVINPRDFEDK:V.0* pHdTreatmentPlantsQH@  = | jdB J"< DAO>BDAO *\G{00025E01-0C  0046}#5.0#0#C:\Program Files\Common Microsoft Shared\w\dao350.dll# 3.51 Object LibraryHUstdole>fstdole^f\^043[W-^2^WINNT\System32\12.tlb#OLE Automation/Word>*WArD A905cA8.2PDO@ffice\10\MSWORD0.OLBN" 10.0TNA)MS@e@Dlg>@(MSC-mDOgO@x.F9@OC88-F6F2-101A-A3C9-08@B2F49FB}#1.Ocomdlg32.ocx)Dialog Control 6-(SP3) @*ctl>+c}lLib-~t-831FDD16-0C5C-11D2-A9FC_F8754DA1 }#}OMCT L.OCXIVinpdows+BD-sG- @Scriptin@WBcr(p+inWrh*420B2B8SE718@C@F-893D@A0C`F4228+kScrrunlg& Runtime@ @)RichPText)RchT@gx)@w`3B7@@63-D78FA@B-B9BY4h021i9@RICHTX@)! Aboxu@Ÿy]a*Form_fr mSearst(G$@Fom(_f`.mEea  WCAUKSFA)ASDNSVKLTBLSQUH`CJ28!`bAPUKFWPINSdNU`V L&BPSTQ H J DH 1","""(+[e"Edit(old)G,+`Pua`JtE`i7( l`)KOSJERKGQUYUIEWHMZFFNBOPJRBBKOJ R G"YI W MZF NB PJR BE`Class 8PaeterG!Css7P"9amT t`r$GOKWVNDECNOKHEPVZQEYHVNFUTMK#GKWVU7DCO`H`PZ`EY`!F`TMD+9-ER=9SubfV-Source39SuU@Lf+-orCetYAJRDDEFJIGNHEMIVDCPLJBOFZBDsVY)D*EJ+GqMVpCP*JF&B0^ +g_+uPermi9+9{Pm HttNTANHBMTHCHCTDYVKPJE_CELYPJ9NP7Ar BpTpC2jT YK0,_58EY9"~_7ZGG0G+8OHRCTYQTJGEQRMGSBGRJUEAH O R0E C Y(Tp6G)Q6MG BPjRPUPA לF8! AFor-PretK_[ATypesDGBaD)EUFoU-Zr tt y4psZJfApI0RCNVKmG}oK-OpblemrPuhjO`na whDGBLIAFRXZDVZEVVINPRDFEZD$-D@ IIFZW*Cq:V;E@V Np=R`. FD,-1E,"0B"`(E+GlobalG ,lob"a"MLTPKWFNWJATBEWITLTV_FVWOI XH28BLTPKWFNJABE I (V_VOIXH]5B] pl*!  Form_frmSearchResultsG*_Hrm6fSefrchDRsumtsoSFMNICCPJGJHRDUWPQKMIQBQZQXFoS[MkICAPJGH&DUgPQE}MjQBZX o5 6rEdit-PlantT(ypes.sEdit-a lIHQD`L YQF`:I`R@:53QD1AbasSupportGAsgaopa5telYSHOGCUISXPFEXQJCZEDSNZKAOA/SOCOZI` X`lXJUTZ"SZlA"o.u K߆ 0kAboujP3AP5oDe VSYIVBEKWJNPODWJOILR_TRRMQXDV` Y@V0RE@ W&P D &JpI &RS5M X-o Eo  mLis FBP{a2PL@ns4S'ANACKYJJUHKOVDQSANHSCNZTD@ APA0jKpJ@ UOV Q@HpCTP1)N?P+ OB0P ReaderG] шa`{eA SWPWSXCUFXIHHEB 4NZ_FYBDVMJ uAMP Sw&xI0 Q4B0HlNP6աYD4Mp"z` O$qWNPWTEAGIWJFNYNDYPPDQAKRIRPMN q ZT2A4AJ YUD PP5D`'A)R*RQJLf͇ jReqA_rptb(Fuljp jt/rAt@ՕF 6l)FFAMCOEYMFHWRDKCTKFJLRCKCYAKUF AYC4EU MHR@'KU *T FLOC=C0߽ G O The config *file should be named =ED^3$/+.}ISNhK1G *036AJUV_C"(YH9W9כuԞVBftB_0*E>Label0Label2 Pq > $Aobeam   *\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{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll#Microsoft DAO 3.51 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automation*\G{00020905- K_[0000-0000-C000-000000000046}#8.2#0#C:\Program Files\Microsoft Office\Office10\MSWORD.OLB#Microsoft Word 10.0 Object Library*\G{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0#C:\WINNT\System32\comdlg32.ocx#Microsoft Common Dialog Control 6.0 (SP3)*\G{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0#C:\WINNT\System32\MSCOMCTL.OCX#Microsoft Windows Common Controls 6.0*\G{420B2830-E718-11CF-893D-00A0C9054228}#1.0#0#C:\WINNT\System32\scrrun.dll#Microsoft Scripting Runtime*\G{3B7C8863-D78F-101B-B9B5-04021C009402}#1.2#0#C:\WINNT\System32\RICHTX32.OCX#Microsoft Rich Textbox Control 6.0 (SP3) jdB  y]8WCAUKSFAWINASDNSVKLTBLSQUHCJ0145c71373$Form_frmSearchTest8KOSJERKGQUYUIEWHMZFFNBOPJRBB0245c71373,Form_frmPlantEdit(old)E8GOKWVNDECNOKHEPVZQEYHVNFUTMK0345c71373(ClassSearchParameterER0 8YAJRDDEFJIGNHEMIVDCPLJBOFZBD0445c71373,Form_frmSubform-Sourceg_H^ 8NTANHBMTHCHCTDYVKPJE_CELYPJJ0545c71373,Form_frmSubform-Permit_`~ 8OHRHEMCTYQTJGEQRMGSBGRJUEAHJ0645c71373 Form_frmSearchxל8MWIZWCHZUGEZZDEMPAEFCILQSZCD0745c71373 BForm_frmEditor-PretreatTypes(old)E8GWSZUCDNPEHPTDUJNJRZHFXIGSZD0845c713730Form_frmSubform-PretreatF 8XBESUJLEQNRZODKSRFPGMVFHCDQK0945c713732Form_frmSubform-PosttreatX\~ 8TWMFDSLMZEJYAEIJCCNXIVWKCGBE0:45c713736Form_frmSubform-PlantReason 8KJWHPBIOKGTCVDEJBRTFGVEEBIAI0;45c713732Form_frmSubform-OpProblem=v 8DGBLIAFRWKCXZDVZEVVINPRDFEDK0<45c71373.Form_frmSubform-ContactBE8MLTPKWFNWJATBEWITLTV_FVWOIXH0=45c71373 Globalpl ]8SFMNICCPJGJHRDUWPQKMIQBQZQXF0>45c71373-*Form_frmSearchResults685 8VHPQVKIGMXRCFEDGTJIWDXYXFXDF0?45c71373S.Form_frmEdit-PlantTypes?P8SZRSBN_TQKFTRDZFTGNLJPUZVPB_0@45c71373_ Form_frmProgressh8AEHYELKRMCQPCEKONRHXLUKHCKLM0A45c71373s6Form_frmSubform-Concentrater 8DCURXTIRAAH K_[UBEMSSWLLNDAZQUYE0B45c71373w&Form_frmSubform-MSC98INXMDJNVUZJBEEAMWIYGLSGYVQMM0C45c71373y*Form_frmPDFWorksheets3Z 8PAQZGIBTBGDSHEDILNYHFVIERRFN0D45c71373Form_frmMainD38AYSHOGCUISXPFEXQJCZEDSNZKAON0E45c71373 basSearchSupport .u8VSYIVBEKWJNPODWJOILR_TRRMQXD0F45c71373kForm_frmAboutE8ANACKYJJUHKOVDQSANHSCNZTDDSN0G45c71373m"Form_frmPlantList8SWPWSXCUFXIHHEBYHFNZ_FYBDVMJ0H45c71373Form_frmReader`(8PWTEAGIWJFNYNDYPPDQAKRIRPMNJ0I45c71373$Form_frmWorksheets@L&8FFAMCOEYMFHWRDKCTKFJLRCKCYAK0J45c71373+&Report_rptPlantFullGXEx8 (@hHPxX=]D;1㗲Hh CP3\I6@pwC O1UUDm_Ѿ]JN_c}]HVqI~LU>m&VÓI{z-c\jJϭ$:}JKr6NÔW]KHBX2Bα]F%Gk=jC8գ0[lHv^`H JAg&@8p9nyoI%E>c+m4qEQpGBP#L):|MₜGH Hb0G)(,FHj{fb,WE?fI`,+"GCГ, cHk+opN|TbZuA~kyd zZ M/|LAccessQf[ GlobalNameVBAWin16~Win32MacVBA6#TreatmentPlantsDAOstdole`WordkMSComDlgW MSComctlLibm Scripting RichTextLibForm_frmSearchTestl _Evaluate m_intTestNumm_db1 m_rstTestData< Recordsetm_oSearchParameterDictionaryS Dictionarym_intFailCount=QbtnStartTest_ClickxErr_btnStartTest_Click8 CreateNewLog.Forms frmSearchTestr txtResultsSetFocus vbNewLineuaSelStartZInitSearchParameterDictionary> CurrentDbStblSearchTestData OpenRecordset|EOF MoveFirstNDoTestYExit_btnStartTest_Click&MsgBoxErrorHandler­btnStopTest_Click/ TimerInterval?c Err_DoTestp- strTestResultstrSQLF bTestPassed( strTestNotes0 LogMessageErr_DoTest_SetUserParametersyIsNullstrNotes5SetUserParameters3strCity?bCity`strState`bState^strPlantCategorySbPlantCategory:<strWaterSource`x bWaterSource strPretreat bPretreat7u strPosttreatO bPosttreat6S strPlantType bPlantTypevOstrPlantReasonݗ bPlantReasonE strConcentrateZG bConcentratestrDischargeTypebDischargeTypé strOpProblemsK bOpProblemsnstrFeedTDSQualifier strFeedTDS1 strFeedTDS2bFeedTDSstrStartDateQualifier6 strStartDate1Q strStartDate2R bStartDate]ystrDesignCapQualifierZ strDesignCap1 strDesignCap2 bDesignCa K_[p}Err_DoTest_BuildQueryO BuildQuery-Err_DoTest_TestQueryOpen TestQueryOpeng_strResultsQueryNameiY LogRecordsetMoveNextL! Exit_DoTestLogErrorHandler5~ErroRaise vbObjectError  Form_TimerErr_Form_TimerExit_Form_TimerForm_frmPlantEdit(old)]ClassSearchParameter2 m_strName- m_strValue / m_strValue2m_strQualifier:C m_bSelected}strNameZValueKstrValueKValue2 strValue2@w Qualifieri strQualifier#4SelectedY bSelectedForm_frmSubform-SourceϴForm_BeforeInsertCancelrs_rs2 lngPlant_IDx lngSource_ID& frmPlantEditSFields7AddNewaUpdateRequeryMoveLastForm_frmSubform-PermitR lngPermit_IDhForm_frmSearch' m_bFormLoaded Form_Load{ Form_Open- Err_Form_Open+chkCity chkStatechkPlantCategoryjMchkWaterSourcef chkPreTreatz chkPostTreatܜ chkPlantTypechkPlantReasonv chkConTreatchkDischargeType chkOpProblems chkFeedTDS chkStartDate chkDesignCaplcmbFeedTDSQualifier_AfterUpdatecIcmbStartQualifier_AfterUpdate!cmbDesignCapQualifier_AfterUpdateIExit_Form_Openw ListStates?Pfld܎Controlid]rowcolHcodestrListdEntries ReturnVal[dbsǂqdfQueryDefrstacLBInitialize QueryDefs&RefreshacLBOpen TimerXacLBGetRowCountacLBGetColumnCount7acLBGetColumnWidtho acLBGetValueacLBEndListPlantCategories`LListWaterSources`ListPreTreatTypesݾListPostTreatTypesBListPlantTypes^ListPlantReasons_JListConTreatTypes ListDischargeTypesBListOpProblemTypesbtnSearchNow_ClickOErr_btnSearchNow_ClickۓPullAndValidateFormqDisplayResultsgExit_btnSearchNow_ClickS4MsgBoxR Description oSearchParameterDictionaryErr_PullAndValidateFormw!strStartQualifier=strDate1;strDate2< frmSearch~cmbFeedTDSQualifierB tbxFeedTDS1 IsNumeric$* tbxFeedTDS2ValcmbStartQualifiertbxDate1tbxDate2cmbDesignCapQualifier tbxDesignCap1 tbxDesignCap2tbxCityS cmbStates~cmbPlantCategorycmbWaterSource#P cmbPreTreatC cmbPostTreat)\ cmbPlantTypeiXcmbPlantReasono cmbConTreatcmbDischargeType cmbOpProblemse=Exit_PullAndValidateForm=#Err_cmbFeedTDSQualifier_AfterUpdateJ?ComboBox\Enabled۪DoCmdƧ GoToControl P$Exit_cmbFeedTDSQualifier_AfterUpdateJ!Err_cmbStartQualifier_AfterUpdatej"Exit_cmbStartQualifier_AfterUpdateu%Err_cmbDesignCapQualifier_AfterUpdate&Exit_cmbDesignCapQualifier_AfterUpdate$Err_DisplayResultsJctli`OpenFormacFormDSfrmSearchResults T txtPlantID[ ColumnHidden? txtPlantNametxtCityItemztxtStatetxtPlantCategory7ZtxtWaterSource$ txtPretreat* txtPosttreaty txtPlantType:txtPlantReasontxtConcentratetxtDischargeTypeɟ txtOpProblemsN txtFeedTDS  txtStartDatea txtDesignCap Exit_DisplayResultsu.btnClose_ClickErr_btnClose_Click Exit_btnClose_Clickv!Form_frmEditor-PretreatTypes(old)Form_frmSubform-Pretreat .lngPreTreat_IDForm_frmSubform-PosttreatyJlngPostTreat_ID[Form_frmSubform-PlantReason/7Form_frmSubform-OpProblem}lngOpProblems_IDForm_frmSubform-Contactf6str_G_AdobeFilename_Hstr_G_AdobePath!g_strAppPathname>g_strLogPathname.g_strConfigPathname g_strAdobeConfigPathTg_strRequestLogForm_frmSearchResultsZtxtPlantName_DblClickdb\Field3 intRecNumber strPlantName9 lngPlantIDB rstPlantFull Err_btnPlant_Name_DblClickaPlant_ID^ Plant_Name=[SQL" FindFirstM=NoMatch/3FindNext K_[u OpenReport acViewPreview2MaximizeFyExit_btnPlant_Name_DblClick0Form_frmEdit-PlantTypes Form_AfterInsertw Form_ErrorDataErr6ResponseClearForm_frmProgressQm_bCancelImportgQpgrImportProgress5MinMaxȲcmdCancel_Click\ intResponsevbYesNo vbQuestionvbYesa?Form_frmSubform-ConcentratelngConcentrate_IDnForm_frmSubform-MSCDForm_frmPDFWorksheets btnView_ClickiErr_btnView_Click9fsF]file%strTaskcmbTitleEstrTitle strPathname=strCommandLinefrmPDFWorksheetse CreateObjectGetFile:ShellVExit_btnView_ClickNX Form_frmMain;m_intPlantCountR SetGlobals_Err_Form_Open_FindAdobeh FindAdobet lblFullPlantdCaptionx CancelEventURErr_SetGlobalsKfsostrTempM Application*CurrentProject$Path2 FileExists OpenTextFile AtEndOfStreamReadLineRight Exit_SetGlobals Err_FindAdobeystrTrialFolderja bFoundAdobefileSys> FileSearchD FolderExists  NewSearchfFileNamejSearchSubFoldersLookInPExecuteY FoundFilesExit_FindAdobebtnAbout_ClickErr_btnAbout_Click'LExit_btnAbout_ClickbtnCalculator_ClickIErr_btnCalculator_ClickExit_btnCalculator_ClickbtnExcel_Click0Err_btnExcel_Click|Exit_btnExcel_ClicklbtnFullReport_Click2Err_btnFullReport_Click vbOKCancelx?vbCancel'Exit_btnFullReport_Click֊btnGlossary_ClickErr_btnGlossary_ClickExit_btnGlossary_ClickzbtnPlantList_ClickmErr_btnPlantList_ClickP{Exit_btnPlantList_ClickbtnQueries_ClickErr_btnQueries_ClickExit_btnQueries_Click5btnReport_ClickA strCurrentDirErr_btnReport_Click8Exit_btnReport_ClickbasSearchSupportg_strMasterTableName!Err_InitSearchParameterDictionaryf1sp$_Addr"Exit_InitSearchParameterDictionary"Err_SetUserParametersoExit_SetUserParametersosjErr_BuildQueryXstrCurrentTempQueryabIgnore?C strSelect%strWherebExiststBuildLikeClausesfBuildEqualClauses/BuildInequalityClausesKCreateQueryDefzNExit_BuildQuerystrParameterNameϚ strQueryNameErr_TestQueryOpen% strRecordRintRecordCountE<strDescriptiondExit_TestQueryOpen* RowsToString^ strResultErr_CreateNewLogCreateTextFile WriteLineeTimeExit_CreateNewLog}LErr_LogRecordsetUCase5 Count0vExit_LogRecordset strErrNum4Number-SourceG strMessageޝstrMsgG&Err_LogMessage@Exit_LogMessageNA Form_frmAboutG_Form_frmPlantListS m_objWord4m_wsp" Workspace3m_bDocumentErrorrm_bDocumentsError,m_intIndentLevelN m_bLogStartedLogMessage2InitSpace  LogMessage2[LogMessage2IncrIndent[wLogMessage2DecrIndent IncrProgress' frmProgressaControlsK Form_CurrentErr_Form_Current lngRecNumSysCmdGacSysCmdGetObjectState?acForm CurrentRecord@ GoToRecordM6 acDataFormacGoToiExit_Form_CurrentK Form_Unload cmdAdd_ClickFvErr_cmdAdd_ClickzExit_cmdAdd_Click-vbCrLfcmdImport_ClickastrCDLChoicessstrAbsolutePathname, astrFilenamesz intNumFilescdlFileChoosert CommonDialogo colFields CollectionWafieldat FormField intFieldCountstrDocumentsErrorLists strSummaryMsg\[FileSystemObjectNUDBEngineQ WorkspacesUdVisible CancelErrorF ErrHandler } DefaultExty DialogTitle߄Filter; FilterIndex˟FlagsocdlOFNAllowMultiselect$cdlOFNExplorercdlOFNFileMustExisttcdlOFNHideReadOnly MaxFileSizeTShowOpen~Split)ChrK~vbBinaryCompare̝GetParentFolderN K_[ameo GetFileNamelblCurrentTaskWordFileToCollection PlantExistsdCollectionToDatabaseaRemoveϱExit_cmdImport_ClickQuit9strPathlErr_WordFileToFieldCollectionstrData@intMembrane_IDintNewMembrane_ID8intNewDischargeType_idR8intExistingPlantCategory_IDtstrNormalizedPlantCategory˜ DocumentsActiveDocument\ FormFields-|ResulturKeyExit_WordFileToFieldCollection% ProcessField{ strFieldNameV vFieldValue:Err_ProcessFieldzExit_ProcessField<strPlantNameOfficial8gErr_PlantExistsstrFindiXExit_PlantExists ProcessRecord strTableName strKeyNamefstrSearchFielddctRecordFieldsw|bCheckForMatchkVstrMatchActionEstrNoMatchAction~zintRelativeErrorNum2Err_ProcessRecord  lngRecordIDvarFieldintOldErrorNumw strActionExit_ProcessRecordErr_CollectionToDatabasestrNormalizedPlantTypeInitialsskblngOpProblemsType_IDxlngPlantReason_IDlngSourceType_ID4 lngPostTreatType_IDlngPreTreatType_ID$lngPermitType_IDlngConcentrateTreatment_IDXKlngDummy]lngPlantType_ID lngMemSysCon_IDlngPlantCategory_IDlngMembrane_ID#lngDischargeType_ID BeginTransNormalizePlantTypeoNormalizePlantCategoryX RemoveAllRollback CommitTransu Exit_CollectionToDatabaseFHstrTextPlant_Name_DblClickoCommand12_ClickErr_Command12_ClickiScreenIPreviousControlExit_Command12_Click cmdEdit_ClickErr_cmdEdit_Clickq'Exit_cmdEdit_ClickvUCommand15_ClicklErr_Command15_Clickz0 intDelete`vbDefaultButton2Exit_Command15_ClickcmdModifySchema_ClickErr_cmdModifySchematdftableDefmprp@ TableDefs%i Properties+AllowZeroLength dbMemoExit_cmdModifySchemaTPlant_Name_EnterJCForm_frmReaderForm_frmWorksheetsϊbtnCalculateDeepWell_ClickErr_btnCalculateDeepWell_Click)tbcGpgePageN}tbxTubeDiameterTextBoxQ tbxWellDepth tbxTotalCosty dblTotalCostQTabCtl08PagesExit_btnCalculateDeepWell_ClickdbtnCalculateEvapPond_ClickjErr_btnCalculateEvapPond_Click tbxEvapArea@ tbxDikeHeight2tbxLinerl tbxLandCosti tbxClearCosttbxUnitAreaCostO tbxAreaCont"dblUnitAreaCost dblAreaCont)CSqr(Exit_btnCalculateEvapPond_Click0btnCalculateSpray_ClickqErr_btnCalculateSpray_Click tbxFlowRateGtbxSoilLoadingtbxStorageDays4Exit_btnCalculateSpray_ClickbtnCalculateZeroDisch_ClickIErr_btnCalculateZeroDisch_ClickHN tbxBrineConc tbxRejectDtbxElectricCost&qtbxZDBrineConc> tbxZDReject6tbxZDElectricCost_ Exit_btnCalculateZeroDisch_Click=btnDWClose_ClickErr_btnDWClose_ClickExit_btnDWClose_ClickeCommand128_ClickErr_Command128_Click Exit_Command128_ClickCommand161_ClickErr_Command161_Click6Exit_Command161_ClickNCommand25_Click]Err_Command25_Click"1Exit_Command25_Click8Command62_ClickبErr_Command62_ClicklExit_Command62_ClickfCommand95_ClickBbErr_Command95_Click9&Exit_Command95_ClickСReport_rptPlantFull1B        -   S5k6m7_8+9DsF@wAyCEE:HK_[*#*'2a\lMl@H $ \A<0fL]1, lM@H $  A/: ]>'6\< ?y]GxME (S<S<S<<N0{6CC8B496-EEB0-4DC6-AF06-69B82A82231C}8(%H xpAttribute VB_Name = "Report_rptPlantFull" Bas0{6CC8B496-EEB0-4DC6-AF06-69B82A82231C} |@GlobalSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT lifier strDesi y]`xME (S<S<S<<N0{D4A47 ( F&y]xME PS<S<S<<:<<<<N0{20A593DD-B35A-48C7-951D-0ACB88E30466} # X % x% @% teNe% ile.%` 5 P % p% % % % % % 0% P% p %`@```x +   % 8H % XJ% x %  % Z%  %  %`0 0$ p % % % % %  %` p   K_[ 0 p $% p "  (08 @  (Hp 4  &&" "H  Np    R@  H "PX `hpx   ( 48  &P"x$""&8"`" (n F  h  x    R   "(0 8@HPX`hp x  ( 4  &"0$X$""" 0   0&     N ` h "p x         (  4 (  &@ "h  & "  N  P ` h p Rx   "      H ` h "p x     H   "    ( 0H8  "    F  " (  0 @H PFX  "    F0 8Hxh]@]`]]]]! Return reference to tab control. ".- Return reference to currently selected page. ! %. set refs to text boxes on pagetbxDWTubeDiameter %. tbxDWWellDepth %. tbxDWTotalCost %.  K_[ nt rol pgbe Pag tbxTubeDiterTexptBoxA&DepthTotalCostdbl DouoC' Return referDento @y coB3. Set9= Me!Ta bCtl0Ycur@tly selectspAHG=.Gs(Q.ValuebJEs@'s %J boxes {OC C'U= @."CC1s("TDWI^"\R ?WEi , f= (-288 _i+ 145.x9 *%J%0.754D,* 100:C`)= i@ Exith:?sajpMs"ge ("u9001:x{: SysteuG: " & vbNew0Line`.D`escriBResu<a# ndEvapPond ہ ! A@DikeHeig6h/ x%La ndґClearUnityn6qʪ5aTM D)   ߪccߪPoU oUToUc*Qz'`Yt1_oU x#NxEP|Q$o`C&?0e'L(_Plj#%Lg&_Pes.= 5406?_ 1+ 465b"$]hi.07?60.931C_]217. '#c F(1.2** (1 + 0.15_ / Sqrv0)tb*qSt9#T ty5{y@ yeiy ryy2y\yyyy!!EySprayy_y0i^yFlowR kqhSoilLo`ading{xStorDays/#y9-} STsjoqoqR|abƑ+oqo oqoqQoqoqƍxYxSP ]xSPSoilLoading")  Set tbxStorageDays = pge.Controls("xP tLandCostn: hClear5 6Total66dbl 889961 _ + 116@2842 *FlowRate. Value- p2708+ 33133357.6270.27U @C'old formulaDM-43660A'ON228000YN - 4093 N KB p75.1'NO 87E N@OƜ9%= T  Exit_btnCalc@cteSpray_Click:  SuHb rr\ MsgBox ("Error 9003:  System text: " & vbNewLine` .Descr@iptionResume "ndPrivk*ZeroDi(sch( On GoToA'  *Di bc As $'P6Br`;T& Re0jectaElricq  nDoub le' Return reference to tab c.c Me!TabCtl09cur tly seed p$K A'= c.'sp(tbc[A sʀs ) boxes on Dϧ.ZDLd1rc 3)62#*9= -27@32+35717CHU37716cA<28591ZZD S_L$Y ?l9oK 0=@ i@` i `X`,`d`D  $%`F `H``J  ) % 8 (%`  % 8 $%`P```R``d`T``V`X``Z``\``^````t`b``d`f`h`j`l,p0i|i ,rpi|i ~.i 0(,% PH$% 8h0%`4`6`8 :$% L4% 8 ` 2 08% P$% 8(0%`6`8 :x$% L4%`d` % 0(8% H<% h@% 8D% %  (  (08 " @H X `*h     B(p x "   * @ P` hp xB  " "  (0 "8@ X hK_[p x J V VH 6"    & H PX `Dh "  " J@8Jx "  28 @ "H Phpx       @ P` h 0x :H<0 0p . :  4 JH J F J0 (    b Z V Z  88 Vp V  @&Px   8X`&h    F 88pJx8JPX J`0J 0H D`2D(`0 :T N("x X   (@ >X N &     , 0  8 HX p D :0 <8 x (D   (0 P4X J( xJ      F@X  P N LH N " P" `h px ( B8P(hJ \ Xp \( 0  (8 `  *h   &   0 ! "!0!8!@!H!0X! !!! ! (! N! . " :P" " " <" # *# @# PP#2## # " ### $$  $($0$ 8$@$nH$ $ $$$ B $ $ %%%%  % K_[@@%%0% %% %% %%% 6% 0&8&@& H&P&VX& &&& f& 8' P' XX' ' @' L( RX( N( \) V`) Z) X* fp*B$* * *++++ +(+0+8+  .@+ p+ :+++,   T, Fh,, T, &- 48- p- -- -- -- P- ..   Z ... . . N.  / 0/ @/ JH/ L/ P/ H80 H0 @0 11 (1  01&@1 h1Fp1 1 *1 12L2 X2*h2222:2 3&3 @3P3X3`3&h3 3 3 3 3 N3 4 4 @4 H4 :h4 4 4 4 4 55 5  5 5(505 85@5BH5(55 R5 "6 @6P6p6 " x6 6 6666666666666667777 7(70787@7  H7P7X7`7h7p7  x7(77  N7 H8H8 h8  Tx8 8 T8&H9 \p9 <9:$0: hX:  T: "; T@;&; ^; < <"`< < h<  =  T = x= T=&=,>,H> x> >0> *>H?  `?   Tp? ? T?&@@@h@4@8@0A LHA  A TA $B T(B&B4B fB , HC TXC C TC&(D6PD@D(D(D E$8E(`E$E,E8E0F4HF0F4F6F4 G ZXG4G ZG lPH jH0I,PII,I(I0I ^J<pJ0J0J0K l@K jK L(@LhL0pL lL jMM,MMM4M40N lhN jNHO,hOOK_[(O8O,P@0P PpP0P4P"(Q@PQ<Q0Q8R<8R4xR,R(R(S \0S , S TS JS 6HT TTT 0T& U HUhU TpU $U TU 2HV :V  lV 0 0W  T@W W TW .X $@X BhX  jX 0 Y T0Y &Y TY 4Z @Z `Z  HZ 0 ZZ Z  TZ N@[ [ T[\ ( \6H\ \\ T\ "] T(] .] 6]  f]  P^ < T`^ "^ T^ 08_ h_ _  D_ 0 _``  T` Rh` ` T`8a (Pa4xa aa Ta 0b TPb .b 2b  Xc 0 hc  Txc "c Tc 0Pd d Td Dd .@e 6pe 6e  Ne 0 0f T@f f Tf *g @g `g  >g 0 ggg   Tg V8h *h Thi 00i&`i ii Ti $j T0j 0j :j  jj 0 hk  Txk $k Tk 0Pl "l 8l 4l  Rm 0 pm Tm $m Tn 2Xn n n  Fn 0 o(o0o   T8o To (o Tphp .p$p pp Tq $Xq Tq 0q 6r  h@r 0 r  Tr "s T8s 0s "s .s 2t  PPt 0 t Tt $u T0u 0u u u  Fu 0 @vPvXv   T`v Lv "w T0ww (w"w wx Tx px Tx .x 2y  `Py 0 y  Ty "z T@z 0z z <z 8({  N`{ 0 { T{ "| T@| .| | |  D} 0 P}`}h}   Tp} V} , ~ TP~~ 2~&~  @ TH " T 0  @P  v 0   T "p T . *  BP <  R؂ 0 0 T@ ( T 4 P p  J 0 K_[   V XP`B8L8 4 І؆ <B8D ȇ2 ( B 08@ `p & Ȉ&؈ & 8H hx ȉ Љ B  0 HXhx  R"   (08 @  *Hx    B  D h  Lx ZȌ ( H Xx  ( ȍ ؍ N@ H "PX ` p    R "(0 8 (@ h&x  D  "( 0 8@H &Px  *ؐ  t0 F 8@ JH 8 JВ  (  0"@<h  .ȓ     "(0 8@HP  X h 4 (T@ & Е     J Vh V 6"PX hxp]@]@ ]@@]@X]@p]@] f 'xScripting.FileSystemObject$.~ *1 $ ~%. x$~ d 'd d B@N B@B!kh|f&Error 4001: LogMessage2: System text: : !A@ho0]f`m_intIndentLevel = 0Scripting.FileSystemObject$.~ *1 $ ~%. x$~ d 'd d B@N B@Bkh|f&Error 4001: LogMessage2: System text: : !A@h0o( x 'xo x 'x x 'xko@ 2"!"b55f5d9d5 9kpqho`D Moving to a plant name in the list displays that same record in theP frmPlantEdiK_[t form if the frmPlantEdit form is open, otherwise it has no effect.O This covers movement by specifically left-clicking a plant name, or navigating0 to a different record using the navigation bar.]   frmPlantEdit$ !'  frmPlantEdit   B@k|'Error 4001: Form_Current: System text: : !A@Ho@'zo( z@****************************************************************A@Plant List form closed at !P,  !ZA@@****************************************************************A@k0o(x|Error in cmdAdd_Click:  !A@oopen file dialog]]0]H]]]]]]] ]@]X]p] %.p'v' .n n(e  Set CancelError is Truerg.% (  Set flags)cdlFileChooser.Flags = cdlOFNHideReadOnly.doc (,$appended in absence of user doing soImport Into Database (:!displayed title of overall dialog0All Files (*.*)|*.*|Word Documents (*.doc)|*.doc (tDat (&default to second filter entry       (Ca} ()'buffer size for all file names selectedsignCa- Display the Open dialog box in modal fashion D This will remain open until the user chooses files and clicks OK orUserPaD Cancel. If OK, control passes to the next statement following this======? one. If Cancel, error handling takes over and no more regularutC processing takes place, due to how we specified to treat Cancel asucture" an error earlier in this routine. B@ SELEC[Apparently the return format from the CDL varies depending on the number of files selected. ORDERTIf only one is selected, the first (and only) element of the returned array containsrametePthe full pathname to the file. If more than one is selected, the returned array WScontains the folder path in element 0 and filenames only in the remaining elements.then u1split CDL string into a string array of filenamesO NOTE: For some reason, running the Split function on Mike's machine requiredulO all parameters to be specified, even though the optional ones can be left on== my development system. .x !$ $' '$ %'nt_ID,$ %+(d '$'(      $ + *A@k[ You chose  files. frmProgress B@sttrea 2"!"b 9d29f5d9q@The user has chosen to add to the database so we need to log it.2If a log file has not yet been started, create one z@****************************************************************A@| Plant List form opened at P,  ZA@@****************************************************************A@ng by 'zk@****************************************************************A@K CStarted import at P,  ZA@@****************************************************************A@lts fo for each file ope   :==========================================================A@L \ $, begin importA@ L:==========================================================A@d in't<File   of  : ' $' 2"!"(4FormK_[s!frmProgress.Controls!lblPlantName.Caption = "".0A@Gneeded to allow repaint event for progress form first time through loopQuerGparse Word file into collection of strings representing form field data== \ $ A@======RForms!frmProgress.Controls!lblPlantName.Caption = colFields("Plant_Name_Official")DoEvents p !X'he W[Document field count =   ter7 No way to find string key value once item is added? a[Extracted Field : Name:  , Value:   %  Plant_Name_Official$$s,'t A plant by the name of 'Plant_Name_Official$' already exists. 0Please delete existing record then import again.'d- dA@n: add MsgBox strMsg clad & populate database with extracted datat's A@ilter k clean up !X' Act   to WH B@x !XEA@:==========================================================A@ tSuccessfully imported \ $A@ants, dERRORS - did not import \ $A@rchR'v   \ $'kP:==========================================================A@routA@ a dicA@ searcA@rs key  frmProgress B@B b v,All selected documents successfully imported'oicedh 7The following documents were not imported due to errors  (see C:\maalog.txt for details):  '====k@****************************************************************A@ objec A@iction@****************************************************************A@rch pa A@.g. Ci nB@tc.)|@User pressed the Cancel button, so bypass regular handling above wError in cmdImport_Click: !^:  !A@`oXI*************************************************************************G extract Word document fields to array. This restricts the exposure ofatF the Word document automation object. The more contained we can limit forH access to it, the fewer problems there will be trying to clean it up in case of unnrelated errors. I*************************************************************************]p]]]]]]] ]8]PA@Entering WordFileToCollectionA@;TODO: code goes here to open doc read-only in case of crash!  n!B@. n!!!X' Document field count = A@   (  n!%.Field :  !, Text (Result):  !A@VThe Word form contains some misnamed fields: four fields were either missing names orRincorrectly named. This code corrects for this situation by inserting the correctUfield name for the erroneous ones and transfers the existing field name for the rest.( 6KT ! MemSysName B@7KT ! MemSysPhone B@ <KT !Recovery B@pKT !PermitDescription1 B@S ! ! B@ (nA@ n!B@B.%Exiting WordFileToCollection normallyA@pA@|`X"**********************************HTODO: code goes here to see if doc is still open and if so, to close it.' For Each doc In m_objWord.Documents4 If doc.Name = "Report.doc" Then Found = True Next docIf Found <> True Then!6 Documents.Open FileName:="C:\Documents\Report.doc" Else $ Documents("Report.doc").K_[Activate!End If$Error in WordFileToFieldCollection:  !^:  !A@( Exiting WordFileToCollection - ERRORA@====== op$]A@ "  ,====&A@|$'t Error in ProcessField: !^:  !, Field=  , Value= "'der MsgBox StrMsgdy b dA@ to&o0*]]]]Entering PlantExistsA@==+SELECT Plant.Plant_Name_Official FROM Plant @%D. [Plant_Name_Official] = ' ('', ,C@Dty 5F',d ',kq%Exiting PlantExists normally, result= ,A@. ,'z*'t Error in PlantExists: !^:  !, Plant= ('d dA@terSou.8i0_*********************************************************************************************** ProcessRecord%RThis function processes records in tables under several parameterized constraints.Input parameters:: strTableName - name of Access table containing recordsE strKeyName - name of key field into table (single key field only)L strSearchField - name of field containing data to match to table records H dctRecordFields - mapping of all record fields and values EXCEPT keyU bCheckForMatch - see if record exists in table matching the search field contents%O strMatchAction - what to do if match is found in table (ADD, LOOKUP, ERROR)atS strMatchAction - what to do if match is not found in table (ADD, LOOKUP, ERROR)signCaQ intRelativeErrorNum - error offset identifying this attempted database update_***********************************************************************************************== ! ==B] ] ] ] ] ] ] ]0 ]H 'Retrieve recordset from specified tableLogMessage2IncrIndentthe 4LogMessage2 "Processing " & strTableName & " record"clauseSELECT * FROM 2'Xm cl X @%D.HERE NFirst determine if we need to check for a match. Sometimes the caller may notopul@wish to, for example in the case of an unconditional record add.an : NLook for a match to an existing record. The text to search on originates from The one of the Word document fields. i[ 6] = ' 6 8%'', Thi ,C@D tied 5F >'Jdh <'JkXdP JNo need to check for record match. Just default to positive match action. <'JkbCheckForMatch==TNext perform the indicated action based on the results of the record matching above.@A@ JLOOKUPKT 47'DLEMatched existing record: ID: D,  6 8%A@ADDKT ( )add new record, remember its ID for laterC@ DThe following conditional is sort of a kludge to be able to use this Ffunction with compound key tables (e.g. "Source"). In this particular( Japp, compound key records are only added, so passing in a blank single key Band pre-populating the record with multi-key values allows this to Bwork. Probably not the most elegant solution, but quick. We only 9remember the record ID if it is from a single key record. 4**** 47'D**k 6 comAdded new record: ID: DA@dAdded new record: ID: D,  6 8%A@ Ck@[dctRecordFields.Count= 8!Xt. Th F 8un F'Populating field: '  ' with: ' F 8%'A@in t[ ' r(treat field errors as non-fatal @. F 8% ; !^A@K_[ERROR IN FIELD DATA: !^:  !'dB@4 B@\, UB:resume fatal error handlingue dA@('tA@k B6resume fatal error handlingXh C@ERRORKTL 47'DBRecord key already exists: ID: D,  6 8%'d dA@earchS  @ ^ d B@S should never get here====+Internal logic error: unrecognized action: J'd====== dA@R T  ^ d B@n LogMessage2DecrIndentrameq .A@L A@ D'0z B 'tError in ProcessRecord:  !^:  !'dr possExiting ProcessRecord: dA@A@Lnow that error has been trapped and logged, raise same error again without aer in trap so caller can catch itd on i !^'H H^ d B@O i ` Nx ] ] ] ] ]@ ]X ]p ] ] ] ] ] ] ] ]0 ]H ]` ]x ] ] ] ] ] ]] ]8]P]h]]A@Entering CollectionToDatabaseA@A@GAll updates must succeed as a group or none do. This ensures that onlySEAerror-free Word documents will result in changes to the database.Transaction begunA@s-by pB@nN******************************************************************************====lookup PlantType recordN******************************************************************************!Processing record PlantTypeA@.U Plant type choices offered to user on the Word form are slightly different in format6 from the verbage in the table, so we need to convert. PlantType$$p'PPlantTypeInitials P 8B@$ $ PlantType PlantType_IDPlantTypeInitials 8LOOKUPERROR$0'dN******************************************************************************lookup PlantCategory record======N******************************************************************************addsProcessing record PlantTypeA@seX PlantCategory choices offered to user on the Word form are slightly different in formato 6 from the verbage in the table, so we need to convert.K T PlantCategory$$r'ser ca PlantCatagory  8B@ ( PlantCategoryPlantCatagory_ID PlantCatagory 8LOOKUPERROR$0'h 8B@td on iN******************************************************************************lts,populate MSC record its vN******************************************************************************(donProcessing record PlantTypeA@r MemSysCon MemSysCon$ 8B@ add MemSysName MemSysName$ 8B@ VieCity - missing from formState - missing from form MemSysPhone MemSysPhone$ 8B@[dctRecordFields.Count= 8!X SELEC $MSC MemSysCon_ID 8ADDADD$0'f 8B@tN******************************************************************************====populate Membrane record iN******************************************************************************Processing record PlantTypeA@MembraneManufacturerMembraneManufacturer$ 8B@ MembraneModel MembraneModel$ 8B@MembraneMaterialMembraneMaterial$ 8B@ MembraneType MembraneType$ 8B@ #Membrane Membrane_ID 8ADDADD$0'j 8B@tN******************************************************************************populate DischargeType recordN****************************************************K_[**************************Processing record PlantTypeA@ DischargeType DischargeType$ 8B@ ( DischargeTypeDischargeType_ID DischargeType 8LOOKUPADD$0'l 8B@tN******************************************************************************populate Plant recordN******************************************************************************Processing record PlantTypeA@ Plant_NamePlant_Name_Official$ 8B@Plant_Name_OfficialPlant_Name_Official$ 8B@AddressAddress$ 8B@Address2Address2$ 8B@CityCity$ 8B@StateState$ 8B@ZipCodeZipCode$ 8B@CountyCounty$ 8B@ PlantOwner PlantOwner$ 8B@PlantOwnAddressPlantOwnAddress$ 8B@ PlantOwnCity PlantOwnCity$ 8B@ PlantOwnState PlantOwnState$ 8B@ PlantOwnZip PlantOwnZip$ 8B@ PlantOwnPhone PlantOwnPhone$ 8B@ PlantCategory h 8B@@computed earlier PlantType_ID d 8B@@computed earlierSPlantEngDsnFrm_ID ' missing from Word form MemSysCon_ID f 8B@@computed earlierSPlantStatus ' missing from Word formfStartDate is a numeric field with no required value. However, if it is to be blank, don't populate itdwith a blank string as this will cause an error during update. Just leave field alone in that case. StartDate$ StartDate StartDate$ 8B@kx6 DesignCap DesignCap$ 8B@ActPermActPerm$ 8B@ BlendedFlag BlendedFlag$ 8B@WBlendCapBas ' missing from Word formBlendBypassAmountBlendBypassAmount$ 8B@ BlendPercent BlendPercent$ 8B@ BlendSource BlendSource$ 8B@ PlantProdVol PlantProdVol$ 8B@eRecovery is a numeric field with no required value. However, if it is to be blank, don't populate itdwith a blank string as this will cause an error during update. Just leave field alone in that case.Recovery$RecoveryRecovery$ 8B@k3 BuildOutCap BuildOutCap$ 8B@fNumStages is a numeric field with no required value. However, if it is to be blank, don't populate itdwith a blank string as this will cause an error during update. Just leave field alone in that case. NumStages$ NumStages NumStages$ 8B@k(2 Membrane_ID j 8B@MembraneConfigMembraneConfig$ 8B@ EnergyRecover EnergyRecover$ 8B@fNumTrains is a numeric field with no required value. However, if it is to be blank, don't populate itdwith a blank string as this will cause an error during update. Just leave field alone in that case. NumTrains$ NumTrains NumTrains$ 8B@k`0TrainCapTrainCap$ 8B@MembraneReplaceMembraneReplace$ 8B@ ProductUse ProductUse$ 8B@PlantDetailsCommentsPlantDetailsComments$ 8B@IConcentrate 'unused MemCleanSol MemCleanSol$ 8B@ MemCleanSched MemCleanSched$ 8B@DischargeType_ID l 8B@DischargeConcentrateDischargeConcentrate$ 8B@DisposalDifficultDisposalDifficult$ 8B@ OtherOptions OtherOptions$ 8K_[B@MembraneDisposeMembraneDispose$ 8B@PermitChange3YearPermitChange3Year$ 8B@ProcEquip3YearProcEquip3Year$ 8B@ AcquireNet AcquireNet$ 8B@ShareNetShareNet$ 8B@CommentsComments$ 8B@ PlantPlant_IDPlant_Name_Official 8ERRORADD$0' 8B@tN******************************************************************************Cprocess operational problems - the user can specify up to three, an0operational problem spans three types of recordsN****************************************************************************** RProcessing operational problem RA@OpProblemsType R$no data specifiedA@d* N****************************************************************************** populate OpProblemType record N******************************************************************************!Processing record OpProblemsType RA@OpProblemsTypeOpProblemsType R$ 8B@1 1 OpProblemTypeOpProblemsType_IDOpProblemsType 8LOOKUPADD$0'T 8B@t N****************************************************************************** populate OpProblems record N******************************************************************************Processing record OpProblems RA@OpProblemsType_ID T 8B@OpProblemsDescriptionOpProblemsDesc R$ 8B@- - OpProblems OpProblems_IDOpProblemsDescription 8ADDADD$0' 8B@t N****************************************************************************** populate PlantXOpProblems record N******************************************************************************#Processing record PlantXOpProblems RA@Plant_ID  8B@ OpProblems_ID  8B@ -PlantXOpProblems 8ADDADD $0'b 8B@tk %%N******************************************************************************Hprocess plant reasons - the user can specify up to three, a plant reasonspans two types of recordsN****************************************************************************** RProcessing plant reason RA@ PlantReason R$no data specifiedA@dX# N****************************************************************************** populate PlantReason record N******************************************************************************Processing record PlantReason RA@ PlantReason PlantReason R$ 8B@. . PlantReasonPlantReason_ID PlantReason 8LOOKUPERROR $0'V 8B@t N****************************************************************************** populate PlantXReason record N******************************************************************************Processing record PlantXReason RA@Plant_ID  8B@PlantReason_ID V 8B@ % PlantXReason 8ADDADD $0'b 8B@tkN******************************************************************************Lprocess source types - the user can specify up to three, a source type spansthree types of recordsN****************************************************************************** RProcessing source type RA@ SourceType R$K_[no data specifiedA@d( N****************************************************************************** populate SourceType record N******************************************************************************Processing record SourceType RA@ SourceType SourceType R$ 8B@ - SourceTypeType_ID SourceType 8LOOKUPERROR $0'X 8B@t N****************************************************************************** populate SourceDetail record N******************************************************************************Processing record SourceDetail RA@Type_ID X 8B@ MWaterSource ' missing from Word form =dctRecordFields.Add "FeedTDS", CInt(colFields("FeedTDS" & k))FeedTDSFeedTDS R$ 8B@ FeedPressure FeedPressure R$ 8B@ WaterConcern WaterConcern R$ 8B@ ) SourceDetail Source_ID 8ADDADD $0' 8B@t N****************************************************************************** populate Source record N******************************************************************************Processing record Source RA@Plant_ID  8B@ Source_ID  8B@ %Source 8ADDADD$0'b 8B@tk( N******************************************************************************Pprocess postreatment methods - the user can specify up to three, a posttreatment#method spans three types of recordsN****************************************************************************** RProcessing postreatment method RA@ PostTreatType R$no data specifiedA@dP N****************************************************************************** populate PostTreatType record N****************************************************************************** Processing record PostTreatType RA@ PostTreatType PostTreatType R$ 8B@0 0 PostTreatTypePostTreatType_ID PostTreatType 8LOOKUPADD$0'Z 8B@t N****************************************************************************** populate PostTreatment record N****************************************************************************** Processing record PostTreatment RA@PosttreatType_ID Z 8B@ChemUsedPosttreatChemUsed R$ 8B@ReasonPosttreatReason R$ 8B@ , PostTreatment PostTreat_ID 8ADDADD$0' 8B@t N****************************************************************************** populate PlantPosttreat record N******************************************************************************!Processing record PlantPosttreat RA@ PostTreat_ID  8B@Plant_ID  8B@ %PlantPosttreat 8ADDADD$0'b 8B@tkN******************************************************************************Mprocess pretreatment types - the user can specify up to three, a pretreatment!type spans three types of recordsN****************************************************************************** RProcessing pretreatment type RA@ PretreatType R$no data specifiedA@d N************************************K_[****************************************** populate PretreatTypes record N****************************************************************************** Processing record PretreatTypes RA@ PretreatType PretreatType R$ 8B@/ / PretreatTypesPretreatType_ID PretreatType 8LOOKUPADD$0'\ 8B@t N****************************************************************************** populate Pretreatment record N******************************************************************************Processing record Pretreatment RA@PretreatType_ID \ 8B@ChemUsedChemUsed R$ 8B@ReasonPretreatReason R$ 8B@ + Pretreatment PreTreat_ID 8ADDADD$0' 8B@t N****************************************************************************** populate PlantPretreat record N****************************************************************************** Processing record PlantPretreat RA@ PreTreat_ID  8B@Plant_ID  8B@ % PlantPretreat 8ADDADD$0'b 8B@tk N******************************************************************************Fprocess permit types - the user can specify up to three, a permit typespans three types of recordsN****************************************************************************** RProcessing permit type RA@ PermitType R$no data specifiedA@d N****************************************************************************** populate PermitType record N******************************************************************************Processing record PermitType RA@ PermitType PermitType R$ 8B@- - PermitType PermitType_ID PermitType 8LOOKUPADD$0'^ 8B@t N****************************************************************************** populate PermitDetail record N******************************************************************************Processing record PermitDetail RA@ PermitType_ID ^ 8B@ DescriptionPermitDescription R$ 8B@ ConditionsPermitConditions R$ 8B@ ) PermitDetail Permit_ID 8ADDADD$0' 8B@t N****************************************************************************** populate PlantPermit record N******************************************************************************Processing record PlantPermit RA@ Permit_ID  8B@Plant_ID  8B@ % PlantPermit 8ADDADD$0'b 8B@tkN******************************************************************************Pprocess concentrate treatments - the user can specify up to three, a concentrate&treatment spans three types of recordsN****************************************************************************** R!Processing concentrate treatment RA@ ConcTreatType R$no data specifiedA@d N****************************************************************************** populate ConTreatType record N******************************************************************************Processing record ConTreatType RA@ConcentrateTreatType ConcTreatType R$ 8B@- - ConTreatTypeConcentrateTreatme K_[nt_IDConcentrateTreatType 8LOOKUPADD$0'` 8B@t N****************************************************************************** populate Concentrate record N******************************************************************************Processing record Concentrate RA@ConcentrateTreatment_ID ` 8B@ConcentrateDetailConcentrateDetail R$ 8B@ TreatReasonConcentrateReason R$ 8B@ ) ConcentrateConcentrate_ID 8ADDADD$0't 8B@t N****************************************************************************** !populate PlantXConcentrate record N******************************************************************************$Processing record PlantXConcentrate RA@Plant_ID  8B@Concentrate_ID t 8B@ %PlantXConcentrate 8ADDADD$0'b 8B@tk{{P******************************************************************************** tFTransaction rolled back: document had non-fatal errors (field errors)A@ pB@v#2undo all database changes related to Word documentdz-Transaction committed: no errors in documentA@ pB@x#<make permanent all database changes related to Word documentkpyA@) Exiting CollectionToDatabase normallyA@z(yA@|yNy't2Transaction rolled back: document had fatal errorA@ pB@v2undo all database changes related to Word documentError in CollectionToDatabase: !^:  !'d MsgBox StrMsg" Exiting CollectionToDatabase: dA@A@zwow |microfiltration (MF)KTMF'pnanofiltration (NF)KTNF'pbrackish reverse osmosis (BRO)KTBRO'pseawater reverse osmosis (SRO)KTSRO'pelectrodialysis reversal (EDR)KTEDR'pelectrodialysis (ED)KTED'pultrafiltration (UF)KTUF'potherKTOther'pS0v--'pnviv0 |drinking water (DW)KTDW'rwastewater (WW)KTWW'rotherKTOther'rSu--'rnhui`uL Double-clicking on a plant name in the list opens the report for that plant]]0]P]p]]]]<t# find which plant the user selected !$.P P">'8 P"@'6; Select record matching Plant_ID (should be only one match) @.0 qryPlantFull 0%T.L1SELECT Plant.* FROM Plant WHERE Plant.Plant_ID = 8 L(B L!D.:F Activate that record as the current record within the Access databaseT (Strictly speaking, loop is not needed since recordset should have only one record) Plant_ID = 8 :B@D :!Fb Plant_ID = 8 :B@Hr" Open report on the current record rptPlantFull L B@J B@NP r|r<r1Error 4001: btnPlant_Name_DblClick: System text: : !A@Pqoqq !B@8 B@Hxq|pqhq !A@PqoHqL Clicking the Edit button opens form frmPlantEdit and displays the currently selected plant.8p]x frmPlantEdit B@#acFormDS !'  frmPlantEdit   B@Xp|PpHp(Error 4001: cmdEdit_Click: System text: : !A@ooo Delete planto]]] !K_[Dim intRecNumber As Integer]0]H]`]]]# find which plant the user selected !$.P P">'8 P"@'6 ,Are you sure you want to delete the plant: ' 6'? This action cannot be undone.'d d l n  Delete Plant?$'  p      !"#$%&'()*+,-/023456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~@The user has chosen to add to the database so we need to log it.2If a log file has not yet been started, create one z@****************************************************************A@|Plant List form opened at P,  ZA@@****************************************************************A@'zkl @.0 qryTempDelete 0%T.L)DELETE FROM Plant WHERE Plant.Plant_ID = 8 L(B LB@A@Deleted plant: 8:  6A@klk|kkkokk]]0]P]p @.0 Concentrate 0%.[ ! properties:  ![Name: ! , Value:  ! [ ! fields: 8 ![Field: 8!, Type:  8!l, Allow 0 Len:  8! 8ConcentrateDetail %.8  8(lj|jj !A@ioiD Moving to a plant name in the list displays that same record in theP frmPlantEdit form if the frmPlantEdit form is open, otherwise it has no effect.O This covers movement by specifically left-clicking a plant name, or navigating0 to a different record using the navigation bar.ohhAttribute VB_Name = "Form_frmPlantList" " Bas0{2210F4AD-5A4F-4C25-9264-574576CB 2A08} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Option Comp@ D3T  hASZ4Box ("1400$1:9: #( t: " & vPbNewB&a6.HDesC.onResT L#  DH_H"J_H*'H HH HH$?HHc}HG rr7GGG GGIntcrc(D0@N+ 1S2De {@- :n< 0N%$!  Progr With As!a.Controls!pgrImportW( .Valux.Maxl  iSEr}5e 1 ' Moving to a |nt X in the l dis ysat saZ recwS ' Edi0d1 ifisD o_, or wiЏ0has @no eff0g. !Thcove0rs m`Az by specifically left-ckQ ) r vig0LngBdi r3PzE usnabar@Y rCurU OvY#SzlngRecNumq|Lo1 P!paCmd(acGetR@te, ac,d ")")#G= Me. p1Do.A3at", s% %r_r r/ rrzrrrr/Loadm_b= F3#1BRUnl!Canc$S kۑ5 "*_Pq1zR a fQ:cd p=@VBA.Tip& p!2o  d $qcmdAdd_Ca>o7)Q)_)R)/U)$PN:4CrLf- wRqLcwe!'R fpXa\loLaDaCDLChoices()aESC1 Absol@յom n] wKAsi_j_PP ǀ? cdl"K_[!0 HoseMSDlgummonDiKcoeldB ``ll dWxafi :F Cou p 0 SB4' 3 Dim strSummaryMsg As String #fsoXFileSystemObject Set m_wsp = DBEngine.Workspaces(0)Nm_bDocuments Error^Fa8lse Lidst"""fobjZdNew  .Appli@cation)m_%.Visible-h"' N@CancelEi`s TruEcdlxChooseU8MSComDlg.mon`Dialo.E-=-On 8GoToHandlerKflagvs +F g OFNHideReadOnly DefaultEx.doc" 'appended in abse@C of$ u;do sFo=TitV"Import Into Database'display@t overall, dN]tB\"A as (*.*)||F@46R+I@:x@NR2?'dE @,second filA@rR Q#^&owMUisel@ + _CWN@@lExplor@7 ?Muso 2MaxSiz!c32000'buffusfs4"e names led'; `the O`I: boxaJmoda@l fashfs'H Th@mwi ;r(ema OounXtilOcns'2@ d c`|ks` OK ofecl. If, 8trol pasNs`;ne _stateA follow[t %o`c , e"fhsbak W !no m8 r egulapro s_ce, due!Mhow we specifibo treat  a~ $earli2% routLTS 0e|I ar[ly",r eturn!rm!@fromCD@L varidJe`2donbnxumbw!BA.W 0o` ( ;eE,fir (&) fB1 4!arrayO8BE!!fuEpathAQ!)c?B1t`5 $aE #old! V0b=!C`B1e ?wWA$sd! ci:`*ia?C)  qNO TE: F@psom! ason, runnAaS@t func Mike's 0machCquDoEvs'needed to allow repaint e for p1m first time through loop Oparse W8ord'o collecpings7_F0eld data(%ToC"!AbsolutePath\,?Fi,sS/1C("BY_NY_Official")EYGDCouZ='q@ Deb ug.Pr "DocumJUH>c; 8 jA@1 To 'No wayA find Cg key value once item is ad@?G *ExtpractB9Bj)f: K:", VCV.I@(jHRNextGIf `Exists(f) ThenA-m_bUErr= True!MsgA pAk b %he "N`YB~'`lready eb.A7vbCrLf MeaideleteCe(rec!lt import ag `w.H}LogM@age2;`"' BoxnEls,!' popu,lasbwi|th`>v'vToDz%GEN If'' clean u! aY`3 -h_`C Remove 1+PC]Asse . 0'Incre)3"=4=`bNot ZO_jSucc@Dful|lydIwS_aOG ERRORS - did nWa8݈syE~L6& 9e1=f{nd Y-z(b?"z.DoCm d.CloGac3m, " &d&pSummarypF"AlXl sLbd4ms s?(edt $qQ'werPZ% -dle^s&W@Y"(see C:\maalog.txt details):O ?&O*9//$ge 0{@t_cmdIrk_@Click:m_obj.Qui SubS rrHandler'UYЪGL`q Ca`l button, so{pasQbg`lr h1#a.b _d "#Din. m ҋ.berA@31DescriRes@ ck5 PB =!'o* 'yӸ1sRrray. trict@exposu 4o`y'4Vautoma#bjre mo@con1nwe c{xlim@fidt,bfe:blemwiBrb`ry!`;cintЬ c! unnred =.pM(4 As Sng, ByRef'7pOn "GoP=_T"Di~mᓗ%Membrane_IDInteg$er'rsaDAO.Rbse5xNew/+PPDischargeType_{/stp"C gory PN alize~dQ A?#K_[nt1_ m afEmQL(ogMessage2IncrIndent L "Entering WordFileToCollection" 'TODO: code goes here to open doc read-only in case of crashAnm_obj]. Docums.O<mName:=strPat/intFieldCount = %?AveE.Form)s.+9 f(b)" &V3( i801 ToSet a&"M(i)o.] EG"6:-. , Text (Result) .'The funtains some misnZdBs: $urD wtei6tvA s s orincorrzB. This@s tsitua bsertA@ Te erroneou!n@and transfers@xisArest.Se Ci54icolĕAdd Item :=f], Key:="MemS|ysk@A5Ph>60Recovery1 112? PermitDesc(rip!<1m El|se d*E`?C8gProgu =sNe#CloeKxiH1 n`ialla'# E_BEgf:( De Sub ` rrZ '*xsee8 ift@ellGAiso,Acy# ie aX!EachBInh%m .'!aIB = "ReportZ.`"F dTru`B'4 ` <> d& "C:\\ N"F()d).at!JIf0MsgBox{@r`;v bCrLf@Err.NumberahcB &@N- ERRORj!EId#K Privp& p2c (SAs DAO.Ardset, 0xKq7 Sta, vRValueaVariant@mOn or lGor_ICDim'SX2]rs.s( )`$ 2888it8/b$S=*c  ! .*""!"! #_Ga42", b=ǁ% , j'0 A,ss% I)$Fun Pl@'st"Official)BooleanS"84#Fiv($ngb Q//İi' 81= CuaPntDb"J4("SELECTS*.b__FRTOM"W rl0P&[/tl]0'D"& "'4 4nнrstQ  0X.NoMat^ D1E= Fa*}~^%UVS -"pxm_O@2l1`6P"G@8?@"a0?@ 0@r`s= =GxE1 bfeEproair0rdswtab"lund@usecEpar˱z4ednts0'Input &s"0T - AcA rq1'4P PkeyCӀ @#(le p=ESearchgr]hCcordatam8k Xdctsmapp 02d $fields and values EXCEPT key ' bCheckForMatch - see if record exists in table mJing th2eTarf contentsstActionWwhat t0o do^G i`s fou_(ADD, LOOKUP, ERROR),Qnot(UintRelativeError(NumVe offset id1kify{Yattempted daase u*peT*[ FunProcPessR(TName As StrW, HKeyPSeoFcA _ d.c@J s cript.Di%ary,  )Boolean)BċK0NouIger)A/0LongC;COn GoToF_X DimAVSelegЀ solua, but quic1W re7R@ i}at"CS5<> l""_T .4me4FK bPd; 9,9ne/O9dIDXq_5_Pj>3 Z>>, cDebug.P0t "%-C4t=us.ǒ Ea`f_5!T1=oӫ?JP3:uR' 3t- B ! 0Yo =fRpil'tlre Bsn-f`lc) v /.].PZ`60Y6y LogMessage2IncrIndent  8strMsg = "ERROR IN FIELD DATA: " & Err.Number"&Description8 ClearOnZor GoToA _ProcR ecord'resume fatal err0handlingW~ om_bDoc-ntT+@= True*DeEnd If#!uNex .U0pdatH/!Casew"&lng [ID.Fields(MKeyName) CShkey$K_[ already exists: ID& ",’_ x dct .Item!S@î:=vbObjec{+ inlative , :=;G,GTElsL'should nev@get h erQIntern@logicAö: unrgnized acTA!O?Bp1000?d5!\Sel('hc'C#aWithS #rsINothycgs# Exit=:k= Sc FunD, rr ;bJL *C9vbCrLfg(@y&1 !'now that&s been trappORged, rhsagain w 9out a 'A so call_can@tch iDnOldem?@$CkvKTJ 7 Sub CoQ9ToDb(ByRef col As$c/ Dimma New S ng.Diary5Str` af!W.Formg!DAO.SseN alDPlantTypeInitialZsmrCegorym iA!Lge~Qk_` Count? q m:OpA04blems! _jpLoqZRReason/#Sourc~eo Dd$ostTqOLreOP4?4ermioP PConc`r m/#Dummr$w3,MemSys@ -OVbraneDischarg"q19SH[}\]/Fse$'All uBs must@ succe\s a group Pnone do. This` ensuPv`onlI'-free Gsp_c ultmnges to0EV.. "Ts##fgun m_wsp.Begin"!#'*Dlookv% Qrd/oC*DA D' tP[ choi offdus@v*o{hf^ are slightly di W zaa' frlombt)tapV,a|weG`#pcon`t$eRe= Fd& (w("w)wͿAdd gğSSD<=Y& `O=z/ ,,LOOKUPp=1V 0&E"*6 'lookup PlantCategory recon((LKName'City - mi2.*  -  p  -"M!! /"Q5 $~ $s'$B_$_$rd_$Ğ_" r_OfficJ(Ml"Pr-E22?¸3эk;#OGZipCbkEy{4ogOwnMpx/Ḛ_3ʐԐ e__?VZ/38r?pyYPM'c omputea rlierUNִtRecordFields.Add "PlantType_ID", lng D 'computed earlie(r 4'XEngDsnFrm`' missing from W form YdcMemSysCon rStatusO V'*rtDate is a numeric f with no requirvalue. However, if itto be bk, don't popul,t'a stras th=will cause an er@ror duu pd#Just@ leave(a(lon@.nat@se.If Hcol("9") <> "" ThenC AKl ,End IfDesigpnCap@%)ActPermBlendedFlag  '@(B@cb0BBypassAmount)s~$ce%^Source0ProdVol+*D' hynnnxnnnnenfn' Ce~nBuildOutn# e1Num}ge~s1111 閆111h 1brangCRfi|LoEner߬ ߬G ߬1׬ Ko/kKs~ oKZ= O@KI"I_I?)nMAERROR10K }%?#y4$#q_--antXReason " & k dctRecordFields.Add "Pl_ID", lng%p | D kDummy = Process("_ ? r, False,0 "ADq11)'.Rem@oveAllE nd IfNe0xt '* J*pCS source types - the user can specify@ up toreHa ansthDof >r0ICFor k@1 To 3aGLogMage2<ing0LIf col("SGT@G )@"" ThenG Jno dat@NTied" E?| [ populate GD5 ) 2cFI3A+-j5,8=; "BcD, g , TruALOOKUPAERROR12k '쑋_Q@( LQDetailQ_=Q QGCJl W@qrJ7' missfrom W` forml M=eFeedTDS$CInt(N)|&0_OAPr@Zure@ B ? 0 Concern f@dea3!P?@?@l 13yK@5@? ?s5hO ''Ot0!@#'p@)q)4(N ((4( M( OcS!ODpostreatment me0thod, a d󲣴R_  00o*SPpT!pS`A? :??_'fI IOOI m6PtTreatType", colFields("Pos & k0)  4lng b_ID = ProcessR ecord , 2_ W q , 0CdctR@, TruePL OOKUPK"ADD15 !P i 5.RemoveAll '*J .populate nment rk?". LogMage2ing"L'"эTAddtP ChemUsed Ȃ&ReasonTK*27ہtGB",ʬ, FalsdccEd6_df0Ld_e_i(Ì Gelante?e=+}ee.e"CK+ZP ` DummyPWF,aWdUCCUb7UEMkM!UEnd IfNext#W'H(C 'pè p,re"U"ts - the user can specify up tore0=a4ansc ofd0st? CFor k"1 To< 33Q1ssQd \1If2rXP"" Then no dataibE`R?J sJ@ O Ġy} J 5JXpA)yt 1Nre毰KpsAHPN?I!?"I@|ߪx8N[-N$"?^-"MϪ ?{O-cF0V?-?-n%)[}1o  515ϩ' ߟ 91ѓ۵K)&1^ "*: LogMessage2 "Procing record PlantPretreat@ " & k ~dctR*Fiel@ds.AddGeT0_ID", lngA!>t; 81Dumm0y = aJ(" `F"_ o, False`, "ADm2<0)'. RemoveAll@End IfNextCI'M 'p permit types - the user can specify@ up toreIa spaLnsDofDs?1IFor k1 To 3?bGUH= Ifp colCGT @G)@"" T8hen no dataOied" E@wj+ populate P&$3 ) #GF`5a@`; "'(ߍ!CgTruaLOOKUP Ŗ1ߖ+  #ܖW?G( WDetailX_=X_XMXI(=2yDescription n0Q~!/`~Condiesit  54#1|1N+ |b}221?O|K2'2!S1` o/k1ssT (!$ԥp%`a*4)N ))3) }) cS/"Dconcentvrm??, a d&`ߧ$0ߧ ߧ_1S1yWc֯߯  'J J?{_J |J@-W,j ô lngConcentrateTreatm0_ID = ProcessRecord("Type", p4_ J#b-GdctFields, TrueLOOKU"PADD24)P[ 5.RemoveAll '*J .popul r!hCLogMage2 "Ding"&" & k&qSAddD etail@colÌ+ +BReasonK.K8* Ail, FXalsgf"dg5g|2lghl( fhPlantX?i ?& 9C! Next Lg#' -a]K)DoCmd.R"rpt"BD, acViewPreviMaximiz$xitp:>E wMsgBox ("#}@4001: |: System "t%: "`RvbNewLine`.DescripA9ResuanujCommand12_c a#!Screen.*ousControl.vFocusC3@ t+*," "#S!' "KEdit buttM#m frmP& di sy{ly ,' .cmdA-e/.A?!k0Form " " 'acqDSRbWMjS4y=A,A6pJng_pw  _? 33_3_3__3W3C."Dute %&5+s0p4PUo A! 'sq/mB1!V !Psn` $Z t Q X@"?p Are you suwP to dC$QF: '1^ & "'?_CrtLf`__2"Tha can`undone.0h( , vbYesNo + sdAaultBO2=?UIf t= The% ' bh choseo 8addaŎ s0o welopg it Sa`gPybg started, h! m_bLog^S qMa ge2In_"*45 4 Lqre!fPATi|  @T2 o / l k= TruAIW5 ?yTempS$/%!5D0TE뿻(.R_@I ºExecutx zs d^r"3;YbooaTόd1tjԲrivate Sub cmdModifySchema_Click () On Error GoTo(_ L Dim db As DAO.Da@tabase6t df84leDe"fprpPr@opertyfldField#Setu= CurrentDbq=.Tabos("Con*c&r"rDebug.Print .Name@ & " pDiPes:"*FEach p InW )"':'&., Vpalue !NxextRfPPs#NC! 'TypD'AE, Allow 0 LenC Zero@gth1CCk9 =NC&JeDetailf .!qMemo Exitͤ:IA rrT M sgBox.DescriptionCResu@nd' Moving to@ a pla@nAihe lis@is@ys @that sr@ecord C ' frmPAEdit forPm if es n, otherwise has no e@ffect.This covePrs mm@ by specifically left-cAI r navixgat`! @fen usA`on bar@k_Ab_En(terAE')49ALabel2519 Product_Use_rptSubreport_SourceQuery{Combo0OpPro(S<S<S<<N0{45E6631F-2EBF-4DA4-9217-00C22C5317F6} @  %H@'K_[ "  08 @FH  " xp` B@BMEL H|@8)Error 2001: btnClose_Click: System text: : !A@== ho`@oPHAttribute VB_Name = "Form_frmAbo ut" Bas0{45E6631F-2EBF-4DA4-9217-00C22C5317F6} |Global!SpacFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  p)% % fxM#ihij 8v ilXin xipir `itiv ixiz 8i|Xi~ xii ii ii 8iXi xii iiii 8iXixii iiii 8)X%`  W)% P% L % 08%`X`$`& `(`*`, `  0($)HP%i8pi(i* .x$)8 %i88ble i(XrchMi*rchR 2@ )====%i8 buili( ramei*. ` 2i:B A P en s% L (K_[amet % 0 ====%`>====`====`@`BL A F IX is t 0 h pa%  son,%`Harch 0 "@~ r.@ City  3i: P o be% L cont % 0@ o be%`>cont`*`@m se`B N `\  p `\Plan`b ^ id.@~ rce@  0p o .@` Z V R8 H Z" 8@ H  RP N P H h(x<<< :`         8H h x        (  @P h x        (  @P h x        (  @P h x         0  H X  p            0  H X  p            0  H P X F`   ^ ^ ^x & ^ "|B`      $0$X ""    0  P p "" "" $0$X       @ `         @H PX `>p Z B  :h "   $ 8 T@ T Z VP < Z" H)K_[PX`hpx @ $8"`  ""$8 `    F 2( F`  R R .X     2H@      88@ ZH X V X h Rp  Z @ V` 4 R 2H L >  R p Z "   >!$P! x!>!V! (">H"$"V"# # Z# Xx# V# ($ H$ RP$ $ Z$  % V@% 4% R% 2(& L`& >& & R& P' Zh'"'  '>'$0( X(>p(\( )>0)$p)\)) * Z* Xh* X* 2+ P+ RX+ + Z+ (, VH, 4, R, 20- Lh- >- - R. X. Zp.".  .>.$8/ `/>x/// V/@0 VX00 0h1 p1>1$112 V(22 V22 333 3 " 33 3333334  4404 @4 P4`4h4p4 x44 48444 f4 V@5 b5 b6 `h6 6 6 6 7  7 @7 `7 7 7 7 7 7 48 .@8 fp8B 8888  89 9 >09 p9^9 99 9 : (: H:X: `:p:x::: ":: :*:::^;\h;H;<X <Xx<X<(=8=TH=D==:=^8> >> >> >^>(? 0? " 8?@? H?P?X?`?h?p?x?  ??? 8? @ @ @ @@ @ @@@ 8A HXAA AA AA AX*K_[B  XB hBxBB BB B8BBB :B"(C0C D8CC6CCBCDF DhD pD"DD DDD6D0EB8EEEBE EE (E" F F (F *8FhFxFF FF FF F4FGG (Gxp( global contants, visible to all modules"]$tblSearchMaster]$qrySearchResultsT====================================================================================O This routine builds a dictionary of search parameters keyed by parameter name.L It will be used to build SQL search strings from the user's search choices.B A dictionary was chosen so we can easily index by parameter name.T====================================================================================0]L Add the SQL clauses object to the dictionary. A dictionary entry has a keyH that is the name of the search parameter (e.g. City, PlantReason, etc.)J and a ClassSearchParameter object that contains the properties associated with the key parameter..City ( name of parameter (* to be populated from search form controls (* to be populated from search form controls (* to be populated from search form controls (* to be populated from search form controls !  B@.State ( ( ( ( ( !  B@. PlantCategory ( ( ( ( ( !  B@. WaterSource ( ( ( ( ( !  B@.Pretreat ( ( ( ( ( !  B@. Posttreat ( ( ( ( ( !  B@. PlantType ( ( ( ( ( !  B@. PlantReason ( ( ( ( ( !  B@. Concentrate ( ( ( ( ( !  B@. DischargeType ( ( ( ( ( !  B@. OpProblems ( ( ( ( ( !  B@.FeedTDS ( ( ( ( ( !  B@. StartDate ( ( ( ( ( !  B@. DesignCap ( ( ( ( ( !  B@|'  .basSearchSupport.InitSearchParameterDictionary B@PoHX========================================================================================W This populates the search parameter dictionary with all user-dependent values from theW passed in+K_[ values. It assumes InitSearchParameterDictionary has already been called to build the proper keyed entries.X========================================================================================8 #+3;CKS[k{P hCity %( jCity %( lState %( nState %( p PlantCategory %( r PlantCategory %( t WaterSource %( v WaterSource %( xPretreat %( zPretreat %( | Posttreat %( ~ Posttreat %(  PlantType %(  PlantType %(  PlantReason %(  PlantReason %(  Concentrate %(  Concentrate %(  DischargeType %(  DischargeType %(  OpProblems %(  OpProblems %( FeedTDS %( FeedTDS %( FeedTDS %( FeedTDS %(  StartDate %(  StartDate %(  StartDate %(  StartDate %(  DesignCap %(  DesignCap %(  DesignCap %(  DesignCap %( |  ]` !' '  "basSearchSupport.SetUserParameters  B@H o@ T====================================================================================< This routine builds the SQL search string. Recall that the4 overall structure of the SQL string being built is: SELECT  FROM  WHERE  ORDER BY Plant.Plant_NameN The routine takes a populated dictionary mapping parameter names to parameterM values and uses it to append the appropriate SELECT and WHERE clauses to theT SQL command. The pre-existing query "qrySearchResults" is then updated to use thisO SQL command. This query is tied to the frmSearchResults form and is the means6 by which the search results are conveyed to the user.T=========================={K_[==========================================================x" ]]] ]@]X]p]]]SELECT  .Plant_ID,   .Plant_Name'( WHERE True'* City ( *A@. State ( *A@0  PlantCategory ( *A@0  WaterSource ( *A@. Pretreat ( *A@.  Posttreat ( *A@.  PlantType ( *A@0  PlantReason ( *A@.  Concentrate ( *A@.  DischargeType ( *A@0  OpProblems ( *A@. FeedTDS ( *A@2  StartDate ( *A@2  DesignCap ( *A@2?***************************************************************, build complete query, sorting by plant name?***************************************************************K Create the results query if it doesn't already exist. This query is boundL at design time to the frmSearchResults form, which in turn is opened in the' routine Form_frmSearch.DisplayResults. @.0', L 0!T L! ',k( L ,  0B@4k, Update the SQL command in the results query ( FROM   * ORDER BY   .Plant_Name'X  0%T.L X L(B LB@B.L.06(| "] !' '  basSearchSupport.BuildQuery  B@6oT====================================================================================R This routine adds the appropriate SELECT and WHERE clauses for the parameter nameO passed in. The WHERE clause added will have an equality test on the parameter value.K The are four possibilities that a user can choose with respect to a search parameter:T 1. Ignore (don't display parameter in results, don't filter results based on it) Action: noneO 2. View (display parameter in results, but don't filter based on its value)- Action: add parameter to SELECT clauseL 3. Filter (don't display but use it's value to filter resulting records), Action: add parameter to WHERE clauseE 4. View and Filter (both display in results and filter recordset)8 Action: add parameter to SELECT and WHERE clausesL The updated SELECT and WHERE clauses are returned through pass-by-reference arguments.T====================================================================================  if View only 8 %! 8 %! (,  . 8'( if Filter only 8 %! 8 %!e * AND ( . 8 = ' 8 %!')'* if View and Filter 8 %! 8 %!e (,  . 8'( * AND ( . 8 = ' 8 %!')'*koT====================================================================================R This routine adds the appropriate SELECT and WHERE clauses for the parameter nameO passed in. The WHERE clause added will use the LIKE operator to pattern match the parameter value.K The are four possibilities that a user can choose with respect to a search parameter:T 1. Ignore (don't display parameter in results, don't filter results based on it) Action: noneO 2. View (display parameter in results, but don't filter based on its value)- |K_[ Action: add parameter to SELECT clauseL 3. Filter (don't display but use it's value to filter resulting records), Action: add parameter to WHERE clauseE 4. View and Filter (both display in results and filter recordset)8 Action: add parameter to SELECT and WHERE clausesL The updated SELECT and WHERE clauses are returned through pass-by-reference arguments.T====================================================================================  if View only 8 %! 8 %! (,  . 8'( if Filter only 8 %! 8 %!e * AND ( . 8 LIKE '* 8 %!*')'* if View and Filter 8 %! 8 %!e (,  . 8'( * AND ( . 8 LIKE '* 8 %!*')'*koT====================================================================================R This routine adds the appropriate SELECT and WHERE clauses for the parameter nameQ passed in. The WHERE clause added will have an inequality test on the parameter+ value(s) based on the parameter qualifier.K The are four possibilities that a user can choose with respect to a search parameter:T 1. Ignore (don't display parameter in results, don't filter results based on it) Action: noneO 2. View (display parameter in results, but don't filter based on its value)- Action: add parameter to SELECT clauseL 3. Filter (don't display but use it's value to filter resulting records), Action: add parameter to WHERE clauseE 4. View and Filter (both display in results and filter recordset)8 Action: add parameter to SELECT and WHERE clausesL The updated SELECT and WHERE clauses are returned through pass-by-reference arguments.T==================================================================================== x if View only 8 %! 8 %! (,  . 8'( if Filter only 8 %! 8 %!e 8 %! Less ThanKT * AND ( . 8 <  8 %!)'* Greater ThanKT * AND ( . 8 >  8 %!)'*BetweenKT # * AND (( . 8 >  8 %!)  AND ( . 8 <  8 %!))'*n if View and Filter 8 %! 8 %!e (,  . 8'( 8 %! Less ThanKT * AND ( . 8 <  8 %!)'* Greater ThanKT * AND ( . 8 >  8 %!)'*BetweenKT # * AND (( . 8 >  8 %!)  AND ( . 8 <  8 %!))'*nP kH o@ @ <0 ] ] ] ] ] ]0 ]H @.0 : 0%T.L L!D.P PB@B LB@B.P.L.0D |x <p '  Form_frmSearchTest.TestQueryOpen B@D0 o( `==========================================================================================}K_[======P Converts rows in a table field to a single comma-separated-values (CSV) string.[ This function is called by the various search queries ("qrySearch*") to build intermediate[ search tables. It is slow, but unfortunately this is one of the only techniques availableY to easily "flatten" multiple records into one. It is used in situations similar to this example: Plant_Name Pretreat ========== ======== PlantA aeration PlantA fluoridation PlantA clarifier PlantB fluoridation PlantB fluoridation Plant_Name Pretreat ========== ========. PlantA aeration, fluoridation, clarifier' PlantB fluoridation, fluoridation`================================================================================================` ] ] ] @.0 X 0%D. B@H8 handle first string separately to avoid putting a comma !F %'H'? append a blank string to convert possible null field to string B@k handle remaining strings !Fb H,  %'H B@ B@B..0 H'Fip J`]X p Scripting.FileSystemObject$.~ *1 $ ~%L.N============================================================================== B@NLThis log file was automatically generated by the Membrane Utilities Database B@N7produced by Mickley & Associates, www.mickleyassoc.com. B@N B@NHThis log is generated whenever the application sees the text 'log=1' in  B@NHthe config file . To suppress or request generation of the log, add or  B@NGremove such text in the config file. The config file should be named:  B@N & B@N B@NCThis log file can be safely deleted any time the application is not B@N4running. Deleting it will not harm the application. B@N B@N Log created !Z at  !P B@NN============================================================================== B@N B@BkPRH|@J8BError 1015: CreateNewLog: Unable to create log file. System text: : !A@Ro T] ] ]( ]H ]` ]x ] @.0 : 0%T.L L!D.P" :Test passed on  Z at  P : :vvv SQL query below vvv : L!B :^^^ SQL query above ^^^ : :'B BA@^'@ P!F PB@Hk8? P!Fb convert record to string[ P%!$V]  P%!'>  P!!X >, [  P%!$V]   P%!'>X> >A@^ @ '@ PB@ >Record count = @A@^N==============================================================================A@^ PB@B LB@B.L.0Zp=|h=T`='  Form_frmSearchTest.LogRecordset B@Z =o=4 Formats and displays error to user via message box. ] > test if error was generated by VB runtime or this application !^ Sys !^'\8 tag error as system ("S")d0<App !^  '\8 tag error as application ("A")k;Error # \ in  !`:  : !A@o; Logs error in log file ]@ > test if error was generated by VB runtime~K_[ or this application !^ Sys !^'\8 tag error as system ("S")d:App !^  '\8 tag error as application ("A")kx:]X Error # \ in  !`: : !'b bA@^o:! writes single string to log filep f9]  Scripting.FileSystemObject$.~ *1 $ ~%. d B@N B@Bk@9h89|09f(9'  basSearchSupport.LogMessage B@h8o88Attribute VB_Name = "basSearchSupport" Option Compare D(atae`Explicit ' global contants, visible to all modules Pub6Vnst g_strMasterTa-As Sngtbl%@ResultsQueryAqryA&BX=PThis routine builds a dicary of s }s keyed by n .(It wibe us+0 SQL%ings from Dthr'sc@hoices'A! Fwas sen so we can easily index$NO Sub InitCkPaJrCGDN(o cring. )n Error GoTob_ CD im spCle4 NP os e  0&4Typ& "9@ 3sA tt `3 er@?/&uQ9 Conc@A xgj'M   DischargeO'ri?4?4?4/ / / S/ / + OpProms///9?' O4O4O4  FeedTDS 44441?rtNN;B333?^t&gg "DeIsignCap" sp.Value = " 2 LQualifier ,Sel ected*FalseoSearchParameterDictionary.Add uN,/Exit_Ihnit?:*( Sub Err#3rr.Raise 10001 + vbObj_ or, "bascrip* Raise 10005 + `vbObjVor, "basSupport.!P", s&Re`sume 1-ndE0 '=?N This routine builds the SQL sBF. Recallat0overucture ofcT bet ih'q5: 88Blob PropData9;TypeInfob     K_[ !"#$%&'()*+,-./0123456789:;<=>?BCDEFGIJKNOPQRTUWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{~d5]`haxb,c Label0@Error 1002. Adobe Acrobat not found. Report viewing requires the free utility "Adobe Acrobat Reader" to be installed. A free version can be downloaded from:  G"T8d5`habcKNIL Label2hhttp://www.adobe.com/products/acrobat/readstep2.htmlhhttp://www.adobe.com/products/acrobat/readstep2.html ZGzLEh1U`adbHcbtnClose Close"[Event Procedure]7Dw3ͬuԞVBftBDetaild Label0d Label2h btnClose 023879=BabcW!e g"hij2kj168A>@8`>Blob ;PropData=?@TypeInfo@A@(Mickley & Associates"[Event Procedure] Ariald2 Tahomahgh Tahomam45 Tahoma{ Tahoma`@ Detailp OhL)kh1U`Xa(bcbtnPlantListPlant List"[Event Procedure]h#?@EDx h1U`XabcibtnFullReport"Full Plant Report"[Event Procedure]T j~KUMxdh1U`Xa bcibtnQueries Search"[Event Procedure]Search the database by criteriaFKF1Md5U` abch Label7>View glossary and abbreviations0@˶'Id5]7`iab cde Label8pMembrane Concentrate Disposal: Practices and Regulation ArialռtM9΃?d5U78`a$b!c,Label10ݾCopyright (C) 2001-2004, Bureau of Reclamation and Mickley && Associates. All rights reserved.Times New RomanxAjhvh1U` abibtnAbout About"[Event Procedure]?Hq&c%h1U`abibtnClose Close"[Event Procedure]/S/M㩟'h1U`abcibtnK_[ExcelHConcentrate Disposal Cost Worksheets"[Event Procedure]C^Ed5U` abcLabel15View and download worksheets to develop preliminary level cost estimates for concentrate disposal optionsuQ%@6|"h1U`abcibtnCalculatorPSimplified Calculation of Disposal Costs"[Event Procedure](s@J .(-d5U` abcLabel17ݢCalculate rough preliminary level cost estimates for concentrate disposal options`BҙnSGgbm*ph1U`Xa0 bcibtnReport Full Text Report"[Event Procedure]NN{qH pd5U`P al bEc,Label19,View full text report:e@O<ʭd5U`al bcLabel20pMembrane Concentrate Disposal: Practices and Regulation7.Wq|Evjd5_7`abLc,d eLabel21ݘMembrane Utilities Database and Concentrate Disposal Preliminary Cost Models Arial:|cJ)Dpd5W7` abc,d eLabel33Second Edition ArialBL)KPͬizPHLɺP0FDetailh btnPlantListh btnFullReporth btnQueriesh btnGlossaryd Label4d Label6d Label7d  Label8d  Label10h  btnAbouth  btnClosed Label15h btnExceld Label17h btnCalculatord Label19h btnReportd Label20d Label21d lblFullPlantd Label33BlobDeltaH17C@8osBlob 0PropDataBDLdhm{hhhhddddddhhhdhdhddddͬ"OZ%LdWEv*DetailmPlant_NamePlant NamemCategoryPlantCatagoryDesignCapmStatemTypemDesign_Cap___mgd_ 87=Babc e ghij!k "[Event Procedure]k@qryPlantListPlant List"[Event Procedure] Arial8 h\\BELFORD\HP PSC 500@l od,,Y8HP PSC 500K_[,, ` B K dY8<&winspool\\BELFORD\HP PSC 500LPT1:"[Event Procedure]d2 Tahomahgh Tahomam45 Tahomap5w2`FormHeaderV~|A{;u.h1Uaxbc,cmdImportImport..."[Event Procedure]5ncqGrȁw026U`bcdecdFileChooseࡱ> Root EntryRoot Entry<+/ImOleObjectData\AccessObjSiteData&\K_[\$828C4C820-401A-101B-A3C9-08002B2F49FB<+/I!C4OO< ACommonDialog.MSComDlg.CommonDialog.1|!Z**E|mF&7h1U`axbc,iCommand15 Delete"[Event Procedure] G7dCr'#gh1U`8axb8c,icmdEditEdit"[Event Procedure]Q @kK֨h` DetailȜ8rCkWHm7U`b e[Plant NamePlant_Name"[Event Procedure]"[Event Procedure]Plant_Namev9CINXlBm7U``bekCategoryPlantCatagoryF5;fDV(sEm07U`lb ebk"Design Cap. (mgd)DesignCap Fixed"Design_Cap___mgd_ވ:F]m7U`bXek State StateKb!JAgm7U`be kTypePlantTypeT˶'O|`FormFooteruy!I0)TypeInfoEMlBlobDeltaS18<NH>8>8Blob VE Design Cap. (mgd)FormHeader FormFooterh cmdImportwcdFileChoose<+/I<+/Ih Command15h cmdEditdhmpwhwhhmmmmm 02389=Babc !e gh itjh.kf9@About Report Arial"[Event Procedure]d2 Tahomahgh Tahomak1m45 Tahomazij Tahoma` Detail!5G5xX d5]78`ta bc,d KNIL Label5.info@mickleyassoc.com Times New Roman8mailto:info@mickleyassoc.com{dJkeJ?%2d5W78`ta bc,d KNIL Label6,www.mickleyassoc.com Times New Roman6http://www.mickleyassoc.com%L|O+8OSd5]7` abc,d e Label9pMembrane Concentrate Disposal: Practices and Regulation ArialLHW=L֐-Fwd5U7` ab cLabel108Second Edition, January 2004S_kM}}d5U7`` ab cXLabel12ݲDeveloped by Mickley && Associates under Bureau of Reclamation Agreement No. 98FC810054-D6I}0!2btd5U7`a$ b cXeLabel13݀Mickley && Associates 752 Gapter Road BouldeK_[r, Colorado 80303 L#L?ҍo\h1U`La<bbtnClose Close"[Event Procedure]sKi(~d5W7`abLchd eLabel21ݘMembrane Utilities Database and Concentrate Disposal Preliminary Cost Models Arial`AIpqkkd5U7`a$ b cXLabel18ݲDatabase Implementation by Thought Vector Technologies 3740 Everett, Lincoln, NE 68506&&hEEEfCW d5]78`a bc,d KNILLabel190info@thoughtvector.com Times New Roman:mailto:info@thoughtvector.com]M%N@ d5W78`a bc,d KNILLabel20.www.thoughtvector.com Times New Roman8http://www.thoughtvector.comJxphCGwLͬ cE.M,SDetaild Label5d Label6d Label9d Label10d Label12d Label13h btnClosed Label21d LaPropDataGI|TypeInfo}19L>8>8Blob  SELECT FROM <fromMWHERE C 9ti@mfrm form 'mean" by whichErZ a3`onvey' r. X?- } BWQ$(wB}zng.g) On x GoT:oA_' vrsta@aordsebt'qdf!"D$efdbDatae`f="trCurrentTemp" AibIgno`- Bool@3 k- Wgpbstb C abel18d Label19d Label20ͬo@H2GKEL6Detaild Reason_For_Plant_LabelReason For Plant_Labeld Plant_Type_LabelPlant Type_Labeld Plant_Category_LabelPlant Category_Labeld Label19 Plant_ID Plant_Name Plant_Name_Official Address Address2CityStateZipCodeCountyP 023879=Babc!e gdhijU2k `@ Plant Search"[Event Procedure] Arial"[Event Procedure]d2 Tahomahgh Tahomai1ghj1ghm45 Tahoman2 Tahomao2 Tahoma`p DetailȜ8rCkWH+o05UbcpdDnp{KʟAcmbPlantReason ListPlantReasons1815d5U`aDb(c,Reason For Plant_Label Reason For Plant,Reason_For_Plant_LaK_[bel sW@;i:"o05Ubcpdn#(DMK`cmbPlantTypeListPlantTypes2190d5U`ab*c Plant Type_LabelPlant Type Plant_Type_Labelـ\E/xo05UbcDdpn?PG%f-D cmbPlantCategory&ListPlantCategories795d5U`apbdc(Plant Category_LabelPlant Category(Plant_Category_Label%NO~a~0d5U7`axb|cLabel19To search: 1) Enter as many or as few search criteria as desired (blank categories will match all records) 2) Check/uncheck fields to be displayed in results as desired 3) Click "Search Now". 1m6^^ByQ2fh1U`ab ibtnSearchNowSearch Now"[Event Procedure]6j(Z`HB>@dnm7U` abXktbxDate1">=1000 And <10000JPlease enter a four-digit year (YYYY)xfx,(O!uOjo05UcDdn9pG Ub"cmbStartQualifierValue ListN"";"Less Than";"Greater Than";"Between""[Event Procedure]d5U`ab(cLabel36"Start Date (year)XBwdd5U`abc lblAndAND5-d2C{m7U`abXktbxDate2">=1000 And <10000JPlease enter a four-digit year (YYYY)6"Ip"LUSm07U` a bXktbxDesignCap1 FixedG5nA5ARdo05UbcDd ng2@|(ScmbWaterSource ListWaterSources1815d5U`a b(cLabel46Water SourceD[jvo05UbcDd n줹-L>cmbPreTreat"ListPreTreatTypes1815d5U`a b(cLabel52Pre-Treat TypekA*_S嚱o05UbcDd nJ:a(NlcmbPostTreat$ListPostTreatTypes1815d5U`a b(cLabel54Post-Treat Type(U͒@Tj!wDo05UbcpdpnY {BةcmbConTreat"ListConTreatTypes1815d5U`apbcLabel56$Concentrate Treat.8&K88{o05UbcDdDn NJ2ScmbStatesListStates795d5U`aDbcLabel62 State!FMjAwEo05Ubcpd n p꺫5B05˝ cmbDischargeType$ListDischargeTypes1815d5U`a bcLabel64Discharge Type~:Y5IIn o05Ubcpd n im8MV ͂cmbOpProblems$ListOpProblemTypes1815d5U`a bcLabel66"Operating Problem@, Bocmh1U`4abibtnClose Close"[Event Procedure]F,0 `GPm07U`a bXktbxDesignCap2 Fixedk.~ E5bfd5U`a*bcLabel70ANDrU J֜yo05cDd nGlOnA& Q4*cmbDesignCapQualifierValue ListN"";"Less Than";"Greater Than";"Between""[Event Procedure]d5]`a bcLabel72*Design Capacity (mgd)r;'Da*:m7U` a<bXk tbxFeedTDS1yTYGYf m7U`a<bXk tbxFeedTDS2rZ5;Ed5U`aZbcLabel75ANDGZ$qnNhGu&s;o05UcDd<n ~0E$|U&cmbFeedTDSQualifierValueK_[ ListN"";"Less Than";"Greater Than";"Between""[Event Procedure]d5U`a<bcLabel77Feed TDSH[4&0j2U`apichkConTreatmkcJFO*(j2U`a i chkDischargeType-R5BH(G9j2U`a i chkOpProblemsݥ|ݽNvOPj2U`Da<i!chkFeedTDSLOSΟYj2U`Dai"chkStartDate4@c+&gM&%Dj2U`Da i#chkDesignCap+2ԅ@ /td5U` ab cLabel97&Display in results E̟D2id5U`ab cLabel98&Display in resultsyO {V'd5U`Da b cLabel99&Display in resultsAv-Ii PropDataKMTypeInfo 21JRPŔ8Ŕ8Blob =lantOwnerPlantOwnAddressPlantOwnCityPlantOwnStatePlantOwnZipPlantOwnPhonePlantCategoryPlantType_IDEngDsnFrm_IDMemSysCon_IDPlantStatusStartDateDesignCapActPerm BlendedFlag!BlendCapBas"BlendBypassAmount#BlendPercent$BlendSource%PlantProdVol&Recovery'BuildOutCap(NumStages)Membrane_ID*MembraneConfig+EnergyRecover,NumTrains-TrainCap.MembraneReplace/ProductUse0PlantDetailsComments1Concentrate2MemCleanSol3MemCleanSched4DischargeType_ID5DischargeConcentrate6DisposalDifficult7OtherOptions8MembraneDispose9PermitChange3Year:ProcEquip3Year;AcquireNet<ShareNet=Commentsh btnSearchNowocmbPlantReasonocmbPlantTypeocmbPlantCategoryd @Label36o?cmbStartQualifierm>tbxDate1mBtbxDate2d AlblAndd HLabel46oGcmbWaterSourced LLabel52d NLabel54oMcmbPostTreatd PLabel56d RLabel62oQcmbStatesd TLabel64d VLabel66oUcmbOpProblemsoKcmbPreTreatoOcmbConTreatoScmbDischargeTypeh WbtnClosemCtbxDesignCap1mXtbxDesignCap2d YLabel70d [Label72oZcmbDesignCapQualifierd ^Label75d `Label77o_cmbFeedTDSQualifierm\tbxFeedTDS1m]tbxFeedTDS2d bLabel81matbxCityd qLabel97d rLabel98d sLabel99jcchkCityjdchkStatejechkPlantCategoryjfchkWaterSourcejgchkPreTreatjhchkPostTreatjichkPlantTypejjchkPlantReasonjkchkConK_[TreatjlchkDischargeTypejmchkOpProblemsjnchkFeedTDSjochkStartDatejpchkDesignCapͬjݓ ZH ˈfDetail{ TabCtl0|!Page1|!Page2|!Page4|!Page6d Label7d Label0d Label1d Label3d Label4d Label5d Label6d Label9d Label11d Label18d Label19d %Label31d (Label34d *Label8d +Label10d ,Label 023879=Babce ghrij%kjTb@$Calculation Sheets Ariald2 Tahomahgh Tahomam45 Tahoma{ Tahoma` Detail/ jKaIo_{1UabcTabCtl0u IAJ|1`Zab-c Page1Deep Well0SH_N;P-d57`Zab-cd e Label0ݦRegression Model for Deep Well Injection Disposal (5 to 24 inch injection tubing) Arial%%%_RM'd57`abcHe Label18***THIS MODEL IS FOR PRELIMINARY CAPITAL COSTS ESTIMATES ONLY*** The model assumptions used may not apply to your situation. A more accurate cost estimate will require consideration of site-specific parameters. SEE REPORT TEXT FOR INFORMATION ON DESIGN APPROACHES AND COST FACTORS. Arial&G:Cd5`XaP btcX Label3HIncluded in the model are costs of:F~SEZ )Ld5`DaP bdc8 Label4ݜDeep injection well Monitoring well Mobilization/ Demobilization>Hy( 2d5` aP bcX Label5PNOT included in the model are costs of:iDQfCjd5`aP bc Label6\Pretreatment Pump Pipeline to equipment siteҀqBHM4h1`abcbtnDWClose Close"[Event Procedure]>S@( m7`:abtk"tbxDWTubeDiameterGeneral Number>=5 And <=24LPlease enter a number between 5 and 24165,.N"j .d5`1abc Label9`ENTER Diameter of injection tubing (5 to 24 in)΃ԯUC brm7`:abtktbxDWWellDepthGeneral Number">=500 And <=10000XPlease enter a number between 500 and 10,0003400Ae1Jkƛ^d5`,abcLabel11nENTER Total depth of injection well (500 to 10,000 ft)3L_K0㪳d5`abcLabel18in .y2F聍d5`abcLabel19ft.B (@]K(m 07`` abtktbxDWTotalCost FixedԗB9d5`abcLabel31$`[aBJI·d5`,ab4ceLabel34$TOTAL CAPITAL COST:c=O h1`ambci (btnCalculateDeepWellCalculate Cost"[Event Procedure]'n8L+d5`apbcLabel187revision 1.0m3 D/<|1`abc Page2Evap. Pondu(`Cm౶Yd57`aK_[bchd e Label8nRegression Model for Evaporation Pond (10 to 100 acres) Arialc{V͏M%ƒd57`aibcHeLabel108***THIS MODEL IS FOR PRELIMINARY CAPITAL COSTS ESTIMATES ONLY*** The model assumptions used may not apply to your situation. A more accurate cost estimate will require consideration of site-specific parameters. SEE REPORT TEXT FOR INFORMATION ON DESIGN APPROACHES AND COST FACTORS. Arialy2F3 d5`7aubcLabel12revision 1.0i@hEէNd5`?a) btcXLabel14HIncluded in the model are costs of:KrDL"d5`+a) bdcLabel16tLand Land Clearing Dike Liner Perimeter Fence Roadway&odE6dd5` a) bcXLabel23PNOT included in the model are costs of:A\A $7Xd5`a) bcHLabel24Disposal of sludge Seepage monitoring Cleanup of contaminated soil Pipeline to evaporation pond<Jp'Xh1`abcCommand25 Close"[Event Procedure]t5)G_#-[m7`Oa}btktbxEPEvapAreaGeneral Number>=10 And <=100PPlease enter a number between 10 and 10010 %EVH:d5`a}bcLabel27\ENTER Number of evaporation acres (10 to 100)YD%*Fm7`OambtktbxEPDikeHeightGeneral Number*(=4) Or (=8) Or (=12)DPlease enter the value 4, 8, or 128[٘ @5QƷd5`ambcLabel29FENTER Dike height (4, 8 or 12 ft.)bHyzMD`nm7`Oa]btktbxEPLinerGeneral Number>=20 And <=120PPlease enter a number between 20 and 12060 L&Z%KX Wd5`a]bcLabel35PENTER Liner thickness (20 to 120 mils)^'yHopm7`OaMbtktbxEPLandCostGeneral Number>=0 And <=10000TPlease enter a number between 0 and 10,0005000c~vKA띩td5`aMbcLabel37FENTER Acre land cost (0 to 10,000)B1BBB /m7`Oa=btktbxEPClearCostGeneral Number">=1000 And <=7000ZPlease enter a number between 1,000 and 7,0004000UXB q{߈d5`a=bcLabel39^ENTER Acre land clearing cost (1,000 to 7,000)tH'MA+j#d5`a}bcLabel40 acresAmF tN@d5`ambcLabel41ft.jA@0LLd5`a]bJcLabel42mils`X LJd5`aMbcLabel43 $/acre}jE2g%d5`a=bcLabel44 $/acreHzQMeߖgm 07`7 aYbtk"tbxEPUnitAreaCost Fixed1q|Ig_Sd5`aYbcLabel46 $/acrexYmuLَAJ͉m 07`7 aIbtktbxEPAreaCont FixedVJInd5`aIb9cLaK_[bel481.2 * areacɷOi@ţ m 07`7 a9btktbxEPTotalCost FixedJKd5`a9bcLabel50$mqK2Sd5`aYbcLabel51(Total unit area cost{B(y4d5`aIbrcLabel52(Area and contingencyoZTH3\)NDd5`a9b4ceLabel53$TOTAL CAPITAL COSTxk@GEjtm7Ah1`ambci (btnCalculateEvapPondCalculate Cost"[Event Procedure]QEPuBT؆G3|1`abc Page4 SprayڵJQd57`ab]chd eLabel88lRegression Model for Spray Irrigation (0.3 to 2.0 mgd) ArialD7E6d*٫d57`aibcHeLabel898***THIS MODEL IS FOR PRELIMINARY CAPITAL COSTS ESTIMATES ONLY*** The model assumptions used may not apply to your situation. A more accurate cost estimate will require consideration of site-specific parameters. SEE REPORT TEXT FOR INFORMATION ON DESIGN APPROACHES AND COST FACTORS. Arial uڤLNIGd5`7aubcLabel90revision 1.1\aKmEFd5`?a) btcXLabel91HIncluded in the model are costs of:ͫYFR/Gd5`&a$ b6cLabel92Land Land clearing Distribution piping Sprinklers Valves && control system Pump Storage Underdrain systemd QBasWMd5` a) bcXLabel93PNOT included in the model are costs of:M+LY\ d5`a) bcLabel94ݰPretreatment of concentrate Cost of monitoring wells Pipeline to spray irrigation sitef|JvKh1`abcCommand95 Close"[Event Procedure]E}$l0m7`habtktbxSPFlowRateGeneral Number>=0.3 And <=2RPlease enter a number between 0.3 and 2.01qUJ\]@Y+<-d5`abcLabel97BENTER Flow rate (0.3 to 2.0 mgd)_֋qNxQbm7`ha btk tbxSPSoilLoadingGeneral Number>=5 And <=20JPlease enter a value between 5 and 2010aKȠ d5`a bcLabel99FENTER Soil loading (5 to 20 ft/yr) ҦӝI"m7`habtk tbxSPStorageDaysGeneral Number=1 Or =20Please enter 1 or 2 days1xյKK RId5`abcLabel101JENTER Required storage days (1 or 2)VcM.I?`m7`habtktbxSPLandCostGeneral Number>=0 And <=10000TPlease enter a number between 0 and 10,0005000)f`JIdAcd5`abcLabel103FENTER Acre land cost (0 to 10,000))a+Jڱvm7`habtktbxSPClearCostGeneral Number">=1000 And <=7000ZPlease enter a number between 1,000 and 7,0002000woG9@dK_[5`abcLabel105^ENTER Acre land clearing cost (1,000 to 7,000)_sNοd5`abcLabel106mgd,`ɸM-1<0d5`a bcLabel107 ft/yrF3*K6Dh%Gd5`abcLabel108 day(s)zWA_L{]d5`abcLabel109 $/acreEAM0~]?d5`abcLabel110 $/acre8=ǔ#G#^m 07`7 a9btktbxSPTotalCost Fixed;⏲|rDN#]Pd5`a9bcLabel116$UH~U̠zd5`a9b4ceLabel119$TOTAL CAPITAL COST%AL0h1`ambci"btnCalculateSprayCalculate Cost"[Event Procedure]{1wM 7e|1`abc Page6Zero Disch.|:o@p|7-=d57`ab?chd eLabel154vRegression Model for Zero Liquid Discharge (0.4 to 2.0 mgd) Arial2REd%d57`aibcHeLabel155>***THIS MODEL IS FOR PRELIMINARY ANNUALIZED COSTS ESTIMATES ONLY*** The model assumptions used may not apply to your situation. A more accurate cost estimate will require consideration of site-specific parameters. SEE REPORT TEXT FOR INFORMATION ON DESIGN APPROACHES AND COST FACTORS. Ariala|Ʉ)KUc4d5`7aubcLabel156revision 1.12:bK0٫=d5`?a) btcXLabel157HIncluded in the model are costs of:YeIX[gȤd5`+a) bdcLabel158`Brine concentrator Crystallizer Energy Usage wPrL=% Ϝd5` a) bcXLabel159PNOT included in the model are costs of:JNF>Rd5`a) bcHLabel160Disposal of solid waste Disposal of any minor blowdown brine stream Pipeline to equipment site_BBSEVh1`abcCommand161 Close"[Event Procedure]XE (Fjm7`axbtktbxZDBrineConcGeneral Number>=0.4 And <=2RPlease enter a number between 0.4 and 2.01znA Sd5`axbcLabel163dENTER Flow to brine concentrator (0.4 to 2.0 mgd)3IMȪMm7`ahbtktbxZDRejectGeneral Number>=2 And <=10JPlease enter a value between 2 and 105.u#+G,vId5`ahbZcLabel165fENTER Percent rejection of concentrator (2 to 10%)0eFpzLmnm7`aXbtk"tbxZDElectricCostGeneral Number >=0.05 And <=0.2VPlease enter a number between 0.05 and 0.200.1\,0HBB}QHd5`a]bcLabel167^ENTER Cost of electricity (0.05 to 0.20 $/kWh)+ߡ9Ke "d5`axbcLabel172mgdmC݂Td5`ahbcLabel173%6@%s0d5`aSbcLabel174 $/kWhjeB4MKGXam 07` abtktbxZDTotalCost Fixed3e0AgťOJd5`<aK_[bcLabel182$/LLdH[7d5`abceLabel185*TOTAL ANNUALIZED COSTY6HO,h1`ambci*btnCalculateZeroDischCalculate Cost"[Event Procedure]At[C?A;HMÇd5U`habce Label7RChoose a cost model by clicking on a tab:͠qGaSq PropDataOQTypeInfo22TŔ8 L8Blob 12d -Label14d .Label16d /Label23d 0Label24h 1Command25d 3Label27d 5Label29d 7Label35d 9Label37d ;Label39d <Label40d =Label41d >Label42d ?Label43d @Label44d BLabel46d DLabel48d FLabel50d GLabel51d HLabel52d ILabel53h )btnCalculateDeepWellh JbtnCalculateEvapPondd lLabel88d mLabel89d nLabel90d oLabel91d pLabel92d qLabel93d rLabel94h sCommand95d uLabel97d wLabel99d yLabel101d {Label103d }Label105d ~Label106d Label107d Label108d Label109d Label110d Label116d Label119d Label154d Label155d Label156d Label157d Label158d Label159d Label160h Command161d Label163d Label165d Label167d Label172d Label173d Label174d Label182d Label185h btnCalculateSprayh btnCalculateZeroDischm4tbxEPDikeHeightm2tbxEPEvapAream6tbxEPLinerm$tbxDWTotalCostm8tbxEPLandCostmztbxSPLandCostmtbxEPClearCostm|tbxSPClearCostmCtbxEPAreaContmAtbxEPUnitAreaCostmEtbxEPTotalCostmtbxSPTotalCostmtbxZDTotalCosth btnDWClosemttbxSPFlowRatemvtbxSPSoilLoadingmxtbxSPStorageDaysmtbxZDBrineConcmtbxZDRejectmtbxZDElectricCostmtbxDWTubeDiametermtbxDWWellDepthd Label187 023879=Babce g hij+k9z ;@(View Worksheet Files Ariald2 Tahomahgh Tahomao2 Tahoma``  Detail}`F o ?Kh1U`abbtnClose Close"[Event Procedure]ȓyGC4:h1U`a(bibtnViewView"[Event Procedure]03Nb@ ,ino5U`bJchdHef,n,"";"";"";"";"10";"200"GjZCkeIcmbTitleTable/QuerySELECT [tblPDFWorksheetTitles].[ID], [tblPDFWorksheetTitles].[Title] FROM [tblPDFWorksheetTitles] 0;4170d5U`a,b c Label8dSelect a;     45 !"#$%&'()*+,-./01236789<=>?@ABCDHGRSJKLMNOPQglUVWXYZ[\]^_`abK_[cdefhijkmonprqsvuwyxz|{}~ = "$x" & g_ MasTablean"DpID`" C epTruec3LikeCbs >!Citytr3trb Eq Stm ~JC0gorO } _ry`WrSource 1 :2 retreatost/gϓTyp??$a aeReason@ "Conc>rOL) Discharge?:`OpPro>ms Ine/`75aFeedTDSooo/"`p:rtW_ = DϦ  5'*/T |plӀ`Lpy p)St C1?e~Tfdoesn't alpdy RRboundd tiY_suQ,i@n turnoXpenhtu'F_~s^yA y=: vDq5p= 0Fals Ea~In.~Ga1If .}o=cq4r`n_UAnEIᤄNextp0Not +db. (zPY' U8  #@Ev FqH.ԀaA=:/!$1 QL3 QCloCh6g#Vo !W dUuery: Dim s As Strings = Err.Descrip0tion`PRaise 10006 + vbObject2or, "basSearchSupport.BuildBQ", sResume Exit_ End Sub '=P ' This routine adds thppropriate SELECT aGWHERE clauses forparame`ter n*passed in. 0e 2 will hav5n equality test on +(valXue.TPre@ur posPsibiiIt@hat a Or can choowith resp to^sˁ&_'A1@. Igno(don't displayG @6A@ults, filA@A @~91@2it) AcA: noneD2. View (bu!#s BGs-=rCpD 3. F/;R it'N :BcordsɁD4?!bo@kCinZeQWU=N A!Iupd`]n]aAreturnI:th fgh`+ss-by-ref erenc:argyntsUv?- BEgRCq(ocPqDbiMaryBnLg.`trN#w, _stprSelgW>h`?\c' ifZonlycIf X.Item(` ).C`.= True) >A$ _ ,).Va"") G= g& @" & g_Mas}Table&.@J!ZaG!Else!!F>a!=U,!<>> " "") The0n Wh@ere = (& " AND (@" & g_.MasTable,".84 0 LIKE '* _hooSearch2Dictionary.Iptem( N*')"L' if View an`d FilElseIf (/3SelectedTrue) A-^0)8r,|jrEYIfC0 A Sub A'=#?N '@is routine adds thppropriate SELECTWHERE clausesP for p n@passin. will havn quality test on v(s) ba fier.@  afour possib i@ i that a r can choose with reDsp`_ to s7s :K1. Igno (don't dis play !in ults, cfsGit)  A: nonRe2.#|( bu f%its "( >$><$3.D a)p it'D A' ing@cordsmoE4' (bo5!G-Ue+A \@Iupd bdWbM@return@\thjgh`+ss-@by-refnc:argumexntsU{?-  BuildhInekCCwط As Scripg.,k!tr;, D@hf@\ onlycqC/= v~=?ker_{P?|0V~ # FaO| CY >Q_["Less0danԎ@V%,r<҆X eAGE Gre0Dr}? 1%@ _%&9( `? /? Betwee/r ?- ?1me 0 &%Lq___m $$$$e2)D`ODOOAHD?Ud$$נ @=dDOU׳ D$7I ~& _ o@Search1Dictionary.Item( M@).Valum)WS3void puttIf T.EOF The^ns "i =F!aCs(0)x" ' aptdZb/k4cG possi nullwGT 8Next|remain 7Q Do Whiw / tPYlt ?0]`V Loopkk?/ji&a(Qy @PublicQk CCeNewLo|g(t)OY}(fs5 Sp~fs#m("Sng.F0SyШmN""Re1Utp@"1""hfs.T1(`Pathname, Truef.WriteLi\(";?U llo&g`)#wabut omVAmy genXmMembra0 Utilitme_ producCMickleyp'Assocaowww.maa.9. @q w =epr;%2d ByQ{t '=1'a=fiDPrPsuppress `rC"]y, addQ0>M such~ r w\Ayshoube %d: ( ?((Blob QPropData\^"TypeInfo#27[caҗ8җ808=Babe ghXiJjkl }l@ Arial"[Event Procedure]d2 Tahomahgh Tahomai1ghj1ghm45 Tahoma`@  DetailF;K&yh1U`abtnStartTestStart Test"[Event Procedure]`:,FF h1U` aibtnStopTestStop Test"[Event Procedure][vFO2Qhm 27U`abcktxtResultsT F99 xmd5Uab+c Label6 Text5:4@^L`]7ͬ",F̣bDetailh btnStartTesth btnStopTestd Label6mtxtResultsͬ|t]<_M8y <Detailh cmdCancelwpgrImportProgress":5j(6(\ uMBlob IPropData`b%TypeInfo&28eҗ8p8 023879=Babce g hN ihj4kTuV@Importing Files Arial"[Event Procedure]d2 Tahomahgh Tahomam45 Tahomaw2` Detail*xIq,Q! h1U` ab8cmdCancel Cancel"[Event Procedure]W{tiD$Q}[w026U`ab cde"pgrImportProgressࡱ> K_[Root EntryRoot Entry":5j(6( 7x<}OleObjectData`AccessObjSiteData&\\$89368265E-85FE-11d1-8BE3-0000F8754DA1":5j(6(!C4rBͫKVProgCtrl,MSComctlLib.ProgCtrl.25O@0ًzd5U`axbXclblCurrentTask*importing Plant tablesL&.)Mxbd lblCurrentTaskK_[ͬʍ) EĬJDetail Plant_ID Plant_Name_Official State ZipCode CountyPlantOwnerPlantOwnAddressPlantOwnCityPlantOwnStatePlantOwnZipPlantOwnPhonePlantCategoryPlantType_IDEngDsnFrm_IDMemSysCon_IDPlantStatuBlob T$PropDatadf)TypeInfo* 29_oip8p8087=Babc5e guhfiIjN9k) Plant.Plant_Namek^@ Plant Arial8 h\\OTHER-KITTY\HP LaserJet 5P0C odXXLetterDINU"0ה&#D.winspool\\OTHER-KITTY\HP LaserJet 5PLPT1:d2 Tahomahgh Tahomam45 Tahoman2 Tahomao2 Tahomap5`{ DetailepJJIlh='>m7U`ab,txtPlant_Name_OfficialPlant_Namef;JIj^!Ud5U7`habc Label7Plant Name:oJҤd5U`a<b#chde Label8\Bureau of Reclamation Membrane System DatabaseڈFI',xCd45]`a bHchd e Label9 Plant3~FW{pm7U`abk Text10&Plant_Name_Official,ck Jnd5U7`habcLabel11(Official Plant Name:hdhByK-`Xp3U4`hab%c8dChild12,Form.frmContactSubformPlant_IDPlant_ID,e8WlEdFd45]`a<bchd eLabel14Plant Contacts:)a/x bL;I/m7U`aDbktxtAddressAddress>xÇNm%?<2d5U7`haDbcLabel16Street 1:{$E YZm7U`apbktxtAddress2Address2@IgD d5U7`hapbcLabel18Street 2:1MMM6d45]`a4bchd eLabel19Plant OwnerL`S2WDgݦ_d45]`a bchd eLabel20"Plant InformationDIJnjX-m7U;` a%bk Text36StartDate \NF!"}0d5U7`Da%bcLabel37"Year of Start Up:QCUN]̦m7U`a bk Text38Cityy6+D>6GS10d5U7`ha bcLabel39 City:*ܚ'${L̊Vӓd5]`a>b chd eLabel404Post-Treatment Information /|Kp:d5U`alWbhchd eLabel72@Concentrate Disposal InformationlkGR Kd5U7`aLYb cLabel87LDischarge Type (surface, sewer, etc.):]]/G.фm 57U` axZbckCombo75(DischargeConcentrateG}HF_8 d5U7`axZb cLabel768Where Discharge Concentrate:oOX X:m 57U` a\bck Text88"DisposalDifficultBM lzd5U7`a\b cLabel89NDifficulties with Concentrate Disposal:V 'zI4݅(Hm 57U` a^bck Text90OtherOptionsiy/5 K=<^d5U7`a^b cLabel91݀Other Disposal Options Considered (What got ruled out and why?):x%g6LƬ8[m 5K_[7U` a`bck Text92"PermitChange3Year6@.xd5U7`a`b cLabel93NChanges in Permits in the Last 3 Years:0怟Dxʲd5]`adbHchd eLabel94HConcentrate Discharge Permit DetailsH#+}p3U5`agb%cdChild95,Form.frmSubform-PermitPlant_IDPlant_ID^Mjxd5W` aebcLabel96Permit Typei?Pf LgJfd5W` aebcLabel97Description7w(Nw=%ɡ d5U`aeb9cLabel98ConditionsHIҎ>A ) =K:d5]`apqbHchd eLabel990Major Operating Problems sF*Yp3U5`atb%cdChild1002Form.frmSubform-OpProblemPlant_IDPlant_ID5N!SrIj[d5W` arbcLabel1010Operational Problem Type}TvYpKɽT2d5W` arbcLabel102Description$_~IN_߄0m7U`a bkText104 State4 @@bG d5U7`ha bcLabel105 State:ݭҘz@R9m7U`a bkText106ZipCodeEK |Ed5U7`ha bcLabel107Zip:Z{>K=: ym7U`a bkText108 County(C܄Pyd5U7`ha bcLabel109"County (FL only):|.O$q~4f23W`a<b&Line110lL1ZD -uf23W`a b&Line111i_*N_Ԙ"1f23W`a4b&Line112A\ULI Lf23W`a b&Line113"%.E0?q&f23W`a&b&Line1144PIYHIqko35U`c dLYen("";"";"";"";"12";"0"zRCwS9Text115 DischargeType_IDTable/QueryDischargeType 0;1440"DischargeType";"DischargeType";"";"DischargeType_ID";"DischargeType";"PrimaryKey"sStartDateDesignCapActPermBlendedFlagBlendCapBasBlendBypassAmountBlendPercent BlendSource!PlantProdVol"Recovery#BuildOutCap$NumStages%Membrane_ID&MembraneConfig'EnergyRecover(NumTrains)TrainCap*MembraneReplace+ProductUse,PlantDetailsComments-Concentrate.MemCleanSol/MemCleanSched0DischargeType_ID1DischargeConcentrate2DisposalDifficult3OtherOptions4MembraneDispose5PermitChange3Year6ProcEquip3Year7AcquireNet8ShareNet9Comments:Plant_Name;Address<Address2=Cityd ?Label7d @Label8d ALabel9m>txtPlant_Name_OfficialmBText10d CLabel11pDChild12d ELabel14d GLabel16mFtxtAddressd ILabel18mHtxtAddress2d JLabel19d KLabel20oLCombo23d MLabel24d OLabel27oNcmbPlantTypepPChild32d QLabel33mRText36d SLabel37mTText38d ULabel39d VLabel40pWChild41d XLabel43d YLabel44d ZK_[Label45d \Label51d ]Label52d ^Label53d _Label54paChild56d bLabel58d cLabel59d dLabel60d eLabel61pfChild62d gLabel65d hLabel66d iLabel67pjChild68d kLabel69d lLabel70d mLabel71d nLabel72d rLabel76d xLabel87myCombo75mzText88d {Label89m|Text90d }Label91m~Text92d Label93d Label94pChild95d Label96d Label97d Label98d Label99pChild100d Label101d Label102mText104d Label105mText106d Label107mText108d Label109fLine110fLine111fLine112fLine113fLine114oText1152387=Babcx#e ghRi j,k 7^@Contact Ariald2 Tahomaj1ghm45 Tahoma`, Detail{.>D19<m7U`4bktxtContactTitleContactTitler[&EO6&~m7U`b(ktxtContactPhoneContactPhone8 ڄeCŒm%m7U`<bBlob RPropDatahj^TypeInfo_e30mp8p8txtContactNameContactName54~2CsIDm7U`b(ktxtContactFaxContactFax;48CAdDm7U`b8ktxtContactDateContact Datef[_|N O_j2U`t"cichkUseContactUseContactB[JPtZ4ͬ ?@D19NCombo21PlantReason_IDTable/QueryPlantReason 0;1440"PlantReason";"PlantReason";"";"PlantReason_ID";"PlantReason";"PrimaryKey"ͬ'ɼOXxRuDetailoCombo21Plant_IDPlantReason_IDPlantReason2387=Babcx#e ghrij+kK_[&X_@(qrySubform-PostTreat"[Event Procedure] Ariald2 Tahomaj1ghm45 Tahomao2 Tahoma`, Detail{.>D19<m7U` bktxtContactTitleChemUsedr[&EO6&~m7U`bktxtContBlob r*PropDataprTypeInfo32up8p8actPhone Reason8 ڄeCŒm%o35U`c<e` ("";"";"";"";"12";"0":XI]nIBԲVw cboPostTreatType PosttreatType_IDTable/QueryPostTreatType 0;1440"PostTreatType";"PostTreatType";"";"PostTreatType_ID";"PostTreatType";"PrimaryKey"ˁͬ 6H/4BkU"DetailmtxtContactTitlemtxtContactPhoneocboPostTreatTypePlant_IDPostTreat_IDPosttreatType_IDPostTreatTypeChemUsed Reason087=Babc)e ghi j8k".PlantPosttreat.Plant_IDs@_@PlantPosttreat Ariald2 Tahomam45 Tahomap5` Detail6~prr_o MsgBox ("15::V: Unѝ +2BQ):vbApKl & Err.Descripti@on) Resume Exit_CreateNewLogt End SuXb  6Recordset(strQueryNaAs S tringOnor GoTo_ 7\Dim rst =W1qdfdDefdbDatabaseFi Integer ntCounD* -cSet I= Curren\tD b=.=cs ā = K_[.OpenJU E= ""DvbinBlob  PropDataTypeInfo37882387=Babcx#e ghri j+kĚl_@&qrySubform-Pretreat"[Event Procedure] Ariald2 Tahomaj1ghm45 Tahomao2 Tahoma`, Detail{.>D19<m7U` bktxtContactTitleChemUsedr[&EO6&~m7U`bktxtContactPhone Reason8 ڄeCŒm%o35U`c<e` ("";"";"";"";"12";"0":XI]nIBԲVwcboPretreatTypePretreatType_IDTable/QueryPretreatTypes 0;1440"PretreatTypes";"PretreatTypes";"";"PretreatType_ID";"PretreatType";"PrimaryKey"ͬ biMLx]cDetailmtxtContactTitlemtxtContactPhoneocboPretreatTypePlant_IDPreTreat_IDPretreatType_IDPretreatTypeChemUsed Reason2387=Babcx#e ghci j +koX_@,qrySubform-Concentrate"[Event Procedure] Ariald2 Tahomaj1ghm45 Tahomao2 Tahoma`, Detail{.>D19<m7U` bktxtContactTitle"ConcentrateDetailr[&EO6&~m7U`Blob kPropDataTypeInfo3888bktxtContactPhoneTreatReason8 ڄeCŒm%o35U`c<e` ("";"";"";"";"12";"0":XI]nIBԲVwcboPretreatType.ConcentrateTreatment_IDTable/QueryConTreatType 0;1440"ConTreatType";"ConTreatType";"";"ConcentrateTreatment_ID";"ConcentrateTreatType";"PrimaryKey"ͬ oq)8HH cDetailmtxtContactTitlemtxtContactPhoneocboPretreatTypePlant_IDConcentrate_IDConcentrateTreatment_IDConcentrateTreatTypeConcentrateDetail TreatReason2387=Babcx#e ghi# j-k8O|3Y_@"qrySubform-Permit"[Event ProcedBlob PropDataTypeInfoK_[3988ure] Ariald2 Tahomaj1ghm45 Tahomao2 Tahoma`  Detail{.>D19<m 27U` b| cktxtContactTitleDescriptionr[&EO6&~m 7U`b\ cktxtContactPhoneConditions8 ڄeCŒm%o35U`c<e` ("";"";"";"";"12";"0":XI]nIBԲVwcboPretreatTypePermitType_IDTable/QueryPermitType 0;1440"PermitType";"PermitType";"";"PermitType_ID";"PermitType";"PrimaryKey"ͬ z- EmWDetailmtxtContactTitlemtxtContactPhoneocboPretreatTypePlant_IDPermit_IDPermitType_IDPermitTypeDescription ConditionsBlob PropDataTypeInfo740882387=Babcx#e ghrij+kpVY_@"qrySubform-Source"[Event Procedure] Ariald2 Tahomaj1ghm45 Tahomao2 Tahoma`X Detail{.>D19<m7U` bTktxtContactTitleWaterSourcer[&EO6&~m 7U`$b cktxtContactPhoneWaterConcern8 ڄeCŒm%o35U`c<e` ("";"";"";"";"12";"0":XI]nIBԲVwcboPretreatTypeType_IDTable/QuerySourceType 0;1440"SourceType";"SourceType";"";"Type_ID";"SourceType";"PrimaryKey"m7U`hbk Text19FeedTDS?(kM ;;k"am7U`dbk Text20FeedPressure?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnpqrstuvy{|}~ͬd7!tHzDetailmtxtContactTitlemtxtContactPhoneocboPretreatTypePlant_IDSource_IDType_IDSourceTypeWaterSource FeedTDS FeedPressure WaterConcernm Text19m Text202387=Babcx#e ghrj+kc,] Y_@(qrySubform-OpProblem"[Event Procedure] Ariald2 Tahomaj1ghm45Blob PropDataTypeInfoK_[4188 Tahomao2 Tahoma` Detail{.>D19<m 7U` bcXktxtContactPhone*OpProblemsDescription8 ڄeCŒm%o35U`c<e` ("";"";"";"";"12";"0":XI]nIBԲVw cboOpProblemType"OpProblemsType_IDTable/QueryOpProblemType 0;1440"OpProblemType";"OpProblemType";"";"OpProblemsType_ID";"OpProblemsType";"PrimaryKey"ͬ it GNu pDetailmtxtContactPhonePlant_IDOpProblems_IDOpProblemType.OpProblemsType_IDOpProblemsTypeOpProblems.OpProblemsType_ID OpProblemsDescriptionocboOpProblemType02387=Babce gh ij`'kXK_Blob PropData'TypeInfo(O428P8_@qrySubform-MSC Ariald2 Tahomahgh Tahomaj1ghm45 Tahomao2 Tahomaw2`@  Detail{.>D19< m7UC`$ abkContactMemSysNamer[&EO6&~m7UC`ak PhoneMemSysPhone8 ڄeCŒm%m7UC`$ akCityMemSysCityf[_|N O_d5U7`xab4cLabel19Contact:M|w@Ni5d5U7`xab4cLabel20 City:>L>I"w,Dd5U7`xab4cLabel21 State:2գx@ItAEڂm7UC`$ ak StateMemSysStatejI[PxKHU66d5U7`HabHcLabel23 Phone:VbAֲO3m7UC`$ axbSupplierMemSysConhz-].NM{d5U7`axbcLabel272Membrane System Supplier:6wFD16zÄͬFkpF6=`(IDetaild Label19d Label20d Label21d Label23 MemSysCon_ID MemSysCon MemSysNameMemSysCityMemSysStateMemSysPhoned Label27mContactmCitym StatemPhonemSupplierͬl㫊ARFp`1טDetail{ TabCtl0Blob %DPropData.TypeInfo/43P8P80387=Babc,e ghij9k" Plant.Plant_Nameb_@ Plant Ariald2 Tahomaj1ghm45 TK_[ahomao2 Tahomap5{ Tahoma` Detail^ˇ#M*4{1U`ab*cTabCtl0ac)Kܜ7;|1`wab)capgPlant Plant PlantJC_O m7`ab,txtPlant_Name_OfficialPlant_Name}b Iz1d57`Rabc Label7Plant Name:v!SfKLg=d45`6a'bHchd e Label9 Plant3T~̧N!dҟxm7`a# b Text10&Plant_Name_Officialx5hIF`d57`Ra# bcLabel11(Official Plant Name:lIaC]m7`aO btxtAddressAddress[B)<6NÞsd57`RaO bcLabel16Street 1:ȦFi Km7`a{ btxtAddress2Address20dO5zdTd57`Ra{ bcLabel18Street 2:OSMJ` ^m7`a b Text38City*쮼L~*d57`Ra bcLabel39 City:'t,0G帍m7`abText104 State5UNH=.fd57`RabcLabel105 State:E&MJsm7`abText106ZipCode}Bd57`RabcLabel107Zip:*lK )7um7`a+bText108 County.l4Ai=d57`Ra+bcLabel109"County (FL only):HpxЎZJ2k|1`wab)capgPlantContactsContactsFXuޘp34`fa b%c` Child12.Form.frmSubform-ContactPlant_IDPlant_ID qEB3i dd45`fa'bchd eLabel14Plant Contacts1!`Kxd5`ao bGcLabel141Contact Namew@k>Pd5` ao bGcLabel142Contact TitleN\IMId5`ao bGcLabel143 Phone #?AσәiQ d5`Nao bGcLabel144 Fax #TSNw}H8M#~d5` ao bGcLabel145Contact Date}*eMbيFd5`b%ao bcLabel146*May we use your name?LACb€u>|1`wab)capgPlantOwner OwnerۘYJ m7`a3 b Text12PlantOwner0I/6d57`a3 bcLabel13Plant Owner:tᘩJt'd45`vacbchd eLabel15Plant Ownerm DA{m7`a_ b Text18PlantOwnAddress˥GJp`d57`a_ bcLabel19Street:C-F^)Ėm7`a b Text22PlantOwnCitysf!'Om,!d57`a bcLabel23 City:OXr̈N| .m7`a b Text24PlantOwnState%MJt3ݑxd57`a bcLabel25 State:rX]CЃm7`a b Text26PlantOwnZipL; Ai,Yd57`a bcLabel27Zip:aVp.A75m7`ab Text28PlantOwnPhone+=I]ld57`abcLabel29Phone #:8 AS|1`wab)capgDesignerDesigner*ryz|GNodo]o5`cd e!X"";"";"";"";"";"";"";"";"";"";"";"";"12";"0"]GdkFT*DCombo174EngDsnFrm_IDTable/QueryEngDsnFirm20;2880;2160;1440;720;1440"EngDsnFirm";"EngDsnFirm";"";"EngDsn_ID";"EngDsnFirm";"PrimaryKey"d57`a bTcXLabel175^Engineering Design Firm (missing on Word form):P׵Jp 5d45`acb chd eLabel176.Engineering DeK_[sign FirmVh aOH"|1`wab)ca$pgPlantInformationPlant Info`?LNDT|S8d45`fabchd eLabel20"Plant Information!BC#7o5`cZdce("";"";"";"";"12";"0"R%B7mmCombo23PlantCategoryTable/QueryPlantCategory 0;1440"PlantCategory";"PlantCategory";"";"PlantCatagory_ID";"PlantCatagory";"PrimaryKey"d57`6acbcLabel24Plant Category:hJz-OhZo5`cZden4"";"";"";"";"";"";"12";"0"Lb{J YCcmbPlantTypePlantType_IDTable/QueryPlantType0;0;1440"PlantType";"PlantType";"";"PlantType_ID";"PlantType";"PrimaryKey"d57`6abcLabel30Plant Type:$nqjLTbp34`ZabcdChild326Form.frmSubform-PlantReasonPlant_IDPlant_IDFLB;hХd57`6abcLabel336Reasons for Building Plant:NJ=cm7;`Zab8k Text36StartDate<`;AFyd57` abcLabel37"Year of Start Up:~)fiNF: Amm7;`xabk Text31DesignCapa&31C,@d57`abcLabel32,Design Capacity (mgd):ATZkG\|)m7;`xabk Text33PlantProdVol{+)I d57`abcLabel34TTotal Plant Volume including Bypass (mgd):߁@X7#ss;m7;`,abk Text35ActPerm?4yH+S~zd57`abcLabel366Actual Permeate Flow (mgd):WER_@ ~m7;`,abk Text37BuildOutCap`JB d57`abcLabel382Build Out Capacity (mgd):}Ѡ&D)6ܩ'j2`Za iCheck39EnergyRecoverF?C7KxHHd57` a bscLabel40 Energy Recovery?SQ E?#+5j2`;a i Check41BlendedFlagj`}uO-PWd57`na bscLabel42Blended?9oKA/RrЇm7;`xa7bk Text43NumTrainslAk3wNM*Hd57`a7bcLabel44Number Trains:\)YH 0; m7;`ha7bk Text45"BlendBypassAmount$AQ9؞ed57`a7bcLabel46LDescribe as Blend Bypass Amount (mgd):b9udNA"{8m7;`ZaSbk Text47TrainCap+o]Lqd57`aSbcLabel48*Train Capacity (mgd):C!MXm7;`haSbk Text49BlendPercentB'.T=G d57`aSbcLabel504Describe as Blend Percent:~͒+-Fn|<m 7;`ZabTck Text51ProductUse< AS|umd57`abcLabel52Product Use:x.@ssDAYAm7;`habck Text53BlendSource^e 9Gr /d57`abcLabel54&Blend Water Source:L\m$EGnm 7;`iabck Text55(PlantDetailsCommentsHcЯfd57`abcLabel56,Plant Detail Comments:`yIbYLm7;`ab8Text171BlendCapBasЈ+Lꦣ~d57`ab cLabel172FBlendCapBas (missing on Word form):>%K_[p^DxG|1`wab)capgMembraneMembrane_ݚK"@T d45`vabO chd eLabel95(Membrane Information~(f H،%To5`c d3 eX"";"";"";"";"";"";"";"";"";"";"";"";"12";"0" u~A XwCombo107MemSysCon_IDTable/QueryMSC20;2880;2160;1440;720;1440l"MSC";"MSC";"";"MemSysCon_ID";"MemSysCon";"PrimaryKey"d57`a3 b4cLabel110xMembrane System Supplier (City, State missing on Word form):CQdAߴzo5`cd e!nL"";"";"";"";"";"";"";"";"";"";"12";"0"v܀^HюQJCombo115Membrane_IDTable/QueryMembrane*0;2880;2160;1440;1440"Membrane";"Membrane";"";"Membrane_ID";"MembraneManufacturer";"PrimaryKey"d57`a bTcLabel116Manufacturer: [9!+MB&P΅m7;`ap bkText147RecoveryXWjAI"dd57`au bTcLabel148,Membrane Recovery (%):TY^~-NIr;m7;`aW bkText149NumStages >G4Pd57`aW bcLabel1504Number of Membrane Stages:}ݕc5O[|%{m7;`ab(kText161MembraneConfig4֖tX tBRؕSid57`abcLabel162lMembrane Configuration (ratio of membranes per stage):ulz$O9dFm7;`ab(kText163MembraneReplaceL3agjd57`abcLabel164PYear of Last Major Membrane Replacement:󵪋I1cm7;`ab(kText165MemCleanSolzAK 9d57`a bcLabel166LMembrane Cleaning Solutions/Chemicals:\^"D$;m7;`a3b(kText167MemCleanSched3+O8ܙd57`a8bcLabel1686Membrane Cleaning Schedule:zFGHm 7;`a_b(ckText169MembraneDispose'R-άOJ WMm 57`a bc Text88"DisposalDifficultH378E>[8Td57`a b cLabel89\Difficulties with Concentrate/Reject Disposal:x4A ؝m 57`abc Text90OtherOptionsw=ʜP?IQ1Ͼ d57`ab cLabel91݀Other Disposal Options Considered (What got ruled out and why?):5iC^Gm 57`abc Text92"PermitChange3Year7iMױt{Cd57`ab cLabel93NChanges in Permits in the Last 3 Years:^sƟIĂhfo35`cdo e("";"";"";"";"12";"0"2x,K ٞLText115 DischargeType_IDTable/QueryDischargeType 0;1440"DischargeType";"DischargeType";"";"DischargeType_ID";"DischargeType";"PrimaryKey"|1`wab)capgPermitsPermits5+gD@8d5` abchd eLabel94VConcentrate/Reject Discharge Permit Detailsg={I$j40**p35`Va b%c0 Child95,Form.frmSubform-PermitPlant_IDPlant_ID &,D Vd5`a3 bcLabel96Permit Type J(F&wR#d5`a3 bcLabel97DescriptionɆ+MOP(d5`Na3 bcLabel98Conditions4~B{QS |1`wab)capgProblemsProblems ?jO/څQd5`acb chd eLabel990Major Operating Problems ?9KQp35`Va b%c0 Child1002Form.frmSubform-OpProblemPlant_IDPlant_IDj +O:[c0pd5`a# bcLabel1010Operational Problem TypevK_[DEKuWj}d5`a# bcLabel102Description̈́9_H; A|1`wab)capgOther Other_aOH>mm 57`ao bcText132ProcEquip3YearU6yM1S@,5d57`ao b cLabel133zMajor changes in procedures or equipment in the last 3 years:joG۱m 57`a bcText134AcquireNet剐FQld57`a b cLabel135jInformation you would like to acquire via a network?:z_EJJK]im 57`a bcText136ShareNetv JdD~d57`a b cLabel137fInformation you would like to share via a network?:Ţ6 o>M^,i zm 57`abcText138Comments;7)H OfbSd57`ab cLabel139 General CommentsxNDBk^^d5`a'b` chd eLabel140"Other Informationb;_ԙIj?m7UC`` abkText177Plant_Name$$Hi \d5U7`,axbchd eLabel178Plant Editor:{-K( ]I|!pgPlantmtxtPlant_Name_Officiald Label7d Label9mText10d Label11mtxtAddressd Label16m txtAddress2d Label18m Text38d Label39mText104d Label105mText106d Label107mText108d Label109|!pgPlantContactspChild12d Label14d Label141d Label142d Label143d Label144d Label145d Label146|!pgPlantOwnermText12d Label13d Label15m!Text18d "Label19m#Text22d $Label23m%Text24d &Label25m'Text26d (Label27m)Text28d *Label29|!+pgDesignero,Combo174d -Label175d .Label176|!/pgPlantInformationd 0Label20o1Combo23d 2Label24o3cmbPlantTyped 4Label30p5Child32d 6Label33m7Text36d 8Label37m9Text31d :Label32m;Text33d <Label34m=Text35d >Label36m?Text37d @Label38jACheck39d BLabel40jCCheck41d DLabel42mEText43d FLabel44mGText45d HLabel46mIText47d JLabel48mKText49d LLabel50mMText51d NLabel52mOText53d PLabel54mQText55d RLabel56mSText171d TLabel172|!UpgMembraned VLabel95oWCombo107d XLabel110oYCombo115d ZLabel116m[Text147d \Label148m]Text149d ^Label150m_Text161d `Label162maText163d bLabel164mcText165d dLabel166meText167d fLabel168mgText169d hLabel170|!ipgSourced jLabel120d kLabel59d lLabel121d mLabel61pnChild62d oLabel65d pLabel122|!qpgPretreatd rLabel51d sLabel123d tLabel53d uLabel124pvsfmPretreat|!wpgPosttreatd xLabel125pyChild41d zLabel43d {Label126d |Label45|!}pgConcentrated ~Label67K_[pChild68d Label69d Label127d Label71|!pgDisposald Label128d Label87mCombo75d Label129mText88d Label89mText90d Label91mText92d Label93oText115|!pgPermitsd Label94pChild95d Label96d Label97d Label98|!pgProblemsd Label99pChild100d Label101d Label102|!pgOthermText132d Label133mText134d Label135mText136d Label137mText138d Label139d Label140mText177d Label178Plant_IDPlant_NamePlant_Name_OfficialAddressAddress2CityStateZipCodeCountyPlantOwnerPlantOwnAddressPlantOwnCityPlantOwnStatePlantOwnZipPlantOwnPhonePlantCategoryPlantType_IDEngDsnFrm_IDMemSysCon_IDPlantStatusStartDateDesignCapActPermBlendedFlagBlendCapBasBlendBypassAmountBlendPercentBlendSourcePlantProdVolRecoveryBuildOutCapNumStagesMembrane_IDMembraneConfigEnergyRecoverNumTrainsTrainCapMembraneReplaceProductUsePlantDetailsCommentsMemCleanSolMemCleanSchedDischargeType_IDDischargeConcentrateDisposalDifficultOtherOptionsMembraneDisposePermitChange3YearProcEquip3YearAcquireNetShareNetComments8=Babce ghXiJjk:"[Event Blob oPropDatawTypeInfoxtDirDatazProcedure]lq_@$qryEdit-PlantTypes"Plant Type Editor Arial"[Event Procedure]d2 Tahomam45 Tahoma`h Detail{n!Hm\0Gm7U`<a<b ce2 PlantTypePlantType]'M mm7U` a<ck"PlantTypeInitials"PlantTypeInitialsWBᡦDE7qͬ;.N^͘DetailmPlantTypemPlantTypeInitialsPlantType_ID$frmSearchResultsfrmSearchTestfrmPlantEdit*&frmPlantEdit(old)2frmPostTreatmentSubform!4frmPlantPosttreatSubform frmWorksheetsfrmReaderfrmAboutfrmPlantListfrmMainfrmSearch$frmPDFWorksheetsK_[frmProgress*frmSubform-Pretreat$,frmSubform-Posttreat0frmSubform-PlantReason0frmSubform-Concentrate%&frmSubform-Permit&&frmSubform-Source',frmSubform-OpProblem((frmSubform-Contact frmSubform-MSC)