ࡱ> r  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqstuvwxyz{|}~Root Entry F- ,>;kWorkbook$DM_VBA_PROJECT_CUR"![%33Ctls & ɀ\p Howard Sykes Ba= ThisWorkbook=x[,!8X@"1Arial1Arial1Arial1Arial1$ Barbedor T1Arial1.Times New Roman1$ Barbedor T1$ Barbedor T1$ Barbedor T1$ Barbedor T1Arial1$ Barbedor T1Arial1Arial1Arial1QTahoma1QTahoma1QTahoma1Arial1Arial1$ Barbedor T1QTahoma"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) 0.0000000 0.00000[$-409]h:mm:ss\ AM/PM h:mm;@$[$-409]dddd\,\ mmmm\ dd\,\ yyyy mm/dd/yy;@0.0 #\ ??/16 #\ ?/8 m/d/yy;@ 00000                + ) , *   @@  @  "@   @   @     " # "@ @  @ @ "@ @  "  " !    @      *      #   * #          # *@ @   @*     @ @  @ @  @ @  @ @  @ @   @*     @ @       *      @*      @ @   *  *   * ( ( !   "    !  "@   @ @  @ @  @ @  @ @  @             "@@  "@  " @  @     @       @  *  *   @@   @           " "  @ @  @  @  " *@ @    "     *@ @ *@ @  *@ @ (@ @ "@      @ @  @ @ *@ @  @ @              @ @  @ @ !  "    @@  @   @   @ @  @ @   @ @   @@    @   `5j Test ResultsSummary0LSheet3!  ; 4@ AnnualReset Cratio150: Cratio200: Cratio250:   ;  ;  " FlowData;%46gpm150: Gratio150: Gratio200: Gratio250:   ;1   ;W  Printtestpsi150<psi200<.psi250<;" pumpdata; 4@" PumpMake;%8; pumpsortRatios: Reset_AllT ?  +*'}?"A.vu4I @={A.vu4I (P;IxڕSkQ} I#)kJxj~a @=9PѓP%ыEEmuf VXÐfs\ (rxA$-!ލ:TWA `J1/Ws>9'C԰pwJe)mMd$,T,txwzZ u)|uWv*'A:[H/{xȢVlm:+|_qF1ӹz&TI4?i+n-02Sȼ#Pvc=z1lؾLAnFh'L}cM4FpJLǷ1y}?Nj{jw}:=P4϶ֽ:s8s<-]ב GǢZB *Y/.6zW$7wnb\v].L-[1vңXR757u:elkܱ֩/t>mi苙0[<SCFblCldo hW|MpL 6":{\;ϮpP3D@=:{\;ϮpP3D2C;UxڕSMhAfg5i$ VtKA<5X5b=X+<D uD((z)xPHĂ^/=(Jl qy?` 5IFgck+7m#ErH -!U`W^H kM{>GHUN 8(tXf#(<6FP 3aYIZK0Md]p:ޞ@1\-fh;Nz6  ( /B[e I: ʥɂ/0!|_: qeʁ}5?iܘɕ:n8\!3T|X>OhvFFh52[kf$G_-G.x9^΢{RYXKOz-XOU~{gtݸZVB6d> dBNߟU>Mq֑0YvD4kb. mGqO Uiuk{}hSGwy3ў靍̌, h*;v̘C foDfc!mf No"r=`EB7+@=r=`EB7+ o ;|xڕSMhAfwc6u4Q[Z%T<5؈B z 5@b@ ^U<֟P~uo@ S쑒s\C#-w\.|P& ߈{:*(m{B"Es [Evx;mƣ6Ѷ)j'm[>W{eg?ByX,SOZ BwcyzD;EoyU%2[w@?v}HA,ND0kb.QؕZH7 ?b6R=5xq4H@/?Uſ`O}]B@Oj(&䱄2k*汌 fH*}N#`<N~td|Ks{7"rW!SP@=rW!SPM;dxڕSMhQnl~kҔ-h^ГxJHJ+H %P@SBK|ErKG/ǠB#A؛z(xE(muf ٝ}3o|ofVX@ֈlt2 - Ӿ>}@R}f6ߎ Q;WJW47JqJ9 ,, WiYJh3ZXJ:/|!XO0G5h%2ًSƫҎ|'Gv+ {]yqWۿƓm{ӈiۖ F[BM)wugNQӆOò*Qۘ Q仵>weD-^ׅ{8=1Q0-'lZQcS {^oޅkZzFQG ѹڏ0޼>6ak|?6OR$"s$`ؐ7@=ys$`ؐ7!;GxڕSkQ{$%M)(l`+H(BPWaA^Q""z"^z%`[eyY8~o͏ЗB<Wޥk)` !=n^ S{4e "•ًggPFzLZf1zAvNDV)ٰK<M=0Y[n6S܏|ڻ x4P1aʛY29< aFڜE(WLplUı=Gquoer{aTys->NDX?Ohwd=r>cM4uK,#Ҫ[WUi*!`]~O_x|+OyV2aEЖ%l msyArNaZt[IQo仵yhFDE8 ǙH+C2!k i^a?]㊱˱Lv?g٤] ij;r0*2 N)r+&~5Ϝ՛{{v"|:`p2_$@=|:`p2_$o ;]xڕSMhQ۔&!nlAKԖzRT<5X % BPB=1PAQE,muf $vg<`X%D~@+H.$Gg`ՙ%Ź/Pߡ8u6iJA4#Gj}MV && |rbP̣-kߵ&an wא/@\k%@\MށMg\X?.|յwO>^I_v&'wk ݏ؝[ љzv$Yš|w9iC';PEk?M*KgWO~/g vڅ|'mŞ˯ȧo[*q޳庶.,2Bo)OyoNX"?ZEg~\[!32}zN"a_x=' "AX</ %`[:m qy3o~<`zNHΟ{dϕ?-0VT 3&N>K0q,}yG/ !?ܑcF}*,s1u6ẮN _kfeI}*޶zeO18_̡)8_~ߔ+G U9(ʿbԑtX 6eR;0,\Ta 16re О>uj?ׯcri)y,`yQ^Rrk1Yc|P вof._쩯u,t^O] 4J(ȡQeչ1BX~3+ɝNN^g~{'s}"2TװI4C@=y2TװI4C2C;GxڕSkQ䓸mIQKuPO /@>Qz(x1AErPM/= ^μ}lBAe̛' ӄjp%Pp" FH.$rԧj9UTͥ+`OmOpydn`ITV7cj2CV &3~:.ao_|3TBWk,WںEXj}Ԁg*a4%ҤsLC"{d : ܑ>mlٍ؜ܥf4ww>d?LC?oRzo7\,_ w`3r~c5T{`W\,3G-1_c{mOv4=hsӷm9yBnR b-հ[|"TJFxjZ!}g-\"1:<#/< _Od-_ S{];d$1WX͗gdCZF:AvG*ffx :H,}諱]w4=gwֆ鿻Dž"Bu*T@-{]}@=uBu*T@-{](P;CxڕSMhAf'i6&ji.JZ! BPAأE%<PTϺΣ:do=W'a?H׵e@гJ؜3r)dV=|UKsw"fSn SF%U`}Mq3#IK1%k)kfjN^a?Ɲ9cm8fVٿLC0K!KfGnꨌgvޛz5O]f k͛88"?Hն+gHRued@=Hն+gHRued,84-;xڕTOHQE7w7Vk,\4 B.˰6{#t-C #out"埘w hH $4rcȶdtPFȵcgFs/]-\!s'tp-xy&E-,ŵ%HKBs]W ߫ ۉۼy') m}s C,֝aR;^~k 'w8 15)khÀjT 3%le2 Vh+V5ysn[Ʌ9Td͉7 j(s qa({Dr/2hcrG}uu1QTu&!M:GZ^%ʨH}#>at_x`ͿtM~iFo;Ix\?SʗPoYr"xNY@=wxNY(P;ExڕSkQ6fA6PJKs+H x !C(+Ǡ czA؛^<^z%b:m] ,v>vfVX&1}< T޺#} ";Pvե$ c"s}zsx\!CyilXH;<gʲ#r0O$dFW sl.*FL BF蘅l+ҳ.o~қĕOD?cL~,SaLgji['E(#g0P;rLZ={&w錕̝Zo>a?LCw?7<҈z!Q-/EEcqh_WKtP)A"v;} BӞ9һiB;\5QBW(oP!Οojfzxc Dl|yv?7is 3:fHs "d'8O|3)[#^;{"$Ont4@=z$Ont4(P;HxڕSkQ޾lB\FR\,!PZ /D 쓂२ {ЃRiozXҋP*۷m(gcgۙyb#.$ xPy %}@^;.%](?G|{ z`{<+Z'R,aT9S=, +-k u7DIúޱu1 n-`KM:w?|6+ iD?<߂Km]!LHmc".qQ;qBwѠsw#&w袑]=e7t36>Lyf`/Zl%0&h# ^c mNѡй+Y[[>u)`Hu=Eu^=őBDs魥%:)Et-5+o6Ҝ!Οj}[}jmK{;禅A9%E8~_oƂi d_gftbdYb41Rb&'&ߚI#"=4SCA% ه7fo^O}m_ ic,w: \$雵iv (3Ə0-wIVG1%LgꂗQ=?o8fc]3Cb.Vl&6?Q[EO[6 "as1*RVR7'b+Uy3"4h?+quoLrrwN 4*Zxq`'\_"TIc:q&Ѿ9Cp">#x3o=C%k=+/zl]SyxҞ*t[R]ΟҰ-:7{OP仳=4ʒ I8+Ii%|V6?'3u;0#K'ihS2,;rP%.a^ҷ'#/v3)1Zs3;5"q L8"}@=uq L8"2C;CxڕSkAζԸ6 ~zQxjjJ) B#@񤷀"=()/(臲7;۬KA|}>潷"ztOFݺ-@N)S{NI@~ɛWb/KM!CqN T:-sV;cP s PsElYBEE/ P0үF Xf q&~#kвg߂Gu1WLpMUıRgS&ο ܝg4Un/}$g<ډ8 nsNg4QG}?U'\(Y;ȅ<^N_yl=S]E%k<+OlX~z}Hwe@Ѷ؜eRUȌjEMw;)7ʝHV-Yg8̼#.k +ofby?}KV <3+_rM%ّY8!R%}kU6QD930wzb"FHg۴2ʬ@=zFHg۴2ʬ(P;HxڕSkQ}|J(Kr)Z1 !"X"PKQҋP(֙oP(2oogf4CX@'na d=S?% J)߹9zk>B:K(zG֞7|j#M_MeO B|1]juFx4= m9##zϛ<ݛ45K̔32wj ڸ[#:n" ?vFh#~cG@U\,aoԛyPmCuPqݭ2^~(EدqlY"~"[E촄왭d(dR:{I/5[XQ}fAKmE-Y6F+!эK{M 3S 9PLGX̗gl2&fbfv1K穡NK {o:s|ۑ]!;,"XY0lIX@=XY0lIX4 ;xڕTkAf7k6?cH R5%  ZP+FaY BNRx xPHJ^D// Jl q7{~{/_ \Hj@4 pFHa`:=¯r2鋄+hs.'8Bx߱0Aaŵaj u]_ 1d{I 8F箶z5O1d*:StMD_zu:\d?"ƥ QV#)̭kv5WZT7b$rd!i?!\WL=rQuנFTLQy.pm#Yϥw31;0C~,,nqZ/QCev/ehL N/γil>qbϡ\YzVϑOў:c(> ɤg "ƼЛjz]zDO·o;?O*D;coa&Dq\`^]MIXHXM}O"c6_k5\j=u)ջ[9 GjԳ*2FKt<SFGa(y< o3[aW>OPs "ҥSځCoB筪|@=tҥSځCoB筪ؤ(P;BxڕSkQwA\ Hbi.JiD/ VX OR +GK^Lx~d'\l_$0&h' >c C}VBgQ gϏtPS ۺφ֋Hv _*oQ覕K)* 6^]*~SmӢJ̥(w;3'lmZ8k͵`Q.i\fLUlN07L(&s&3m_ivv)ݑDOĹ)+%ab?7` o&"97^l@=97^llo ;xڕSMhAfwk6iۦğ-RACUV5 6K!E/O%J`tOnJ 3ަ<`Sw90r"fp[#0zy 3j:N|Jt:zڝZVdҩD8jVa/!{%bm1mz`$=`q'QqREOP_|pٟ 4t,_ڒJIYҡ!_ $BxCn7#_`;vP} __^/Ǒ ,g|~"_d=ޛܟw@=o_d=ޛܟ(P;=xڕSkQ-٤%v[I(EIKU+J ^=C)QCzzP"z ŋP(U֙6ۥ Nٙy4OY%Pu6 iKdpd\ 2(;Ν7I1ΐ8[ZFiYs=, DZ+ĵ|IIDƾgufkm]U'uXxcWW?++"LF:G ,9[E;G#lu T#g/87msr.XiܩUsC7ko3b q[!'M^~c-#U:\yґj_+*!f[{+F7bCWu{0vwz{H"n%U >w xoXֳ)4)WjafqR:Oٷ3:sXKͱ/t33M|k p԰Ho Gr/ w+N {47#ZDԮIECwX "~e sbG~@=v~e sbG(P;DxڕSkQ6fa\F\O VXAK)z}RXCЃRыGK.Bl3ov 2ocg3$4I\Nu$иz 'Fv";POI~U(/_q^8'BlXл`ʲThr0zX2 C#]W  S]'Mzr7cWgI](߼}75E?g<_"OS1L>aۤCeJfĮE< DnViw5[;tLcV.-;[wi0q-/wEESqC#;t+tV0x{eӯ~3CMBu C͑BxGs\g?%Z*zuIN6-OǼCuQ`ļ(gEfqvV_ ٳ3u~P> Dj|y~Hs{K4);;Mi<Ӵ>)>Uc {0`|+"fjO36d'Q,C"kCF@=xkCFƤ2C;FxڕSkANj6Ikh %֏Z/J"ZB,=Dt QR D=}a67(;$-d){Jp14ZA u1mrt/4'5gѠ{&O礑FZ=zݯ{Ւ;DT Ğcwh֣ 3VB/<i:%:Ki/l_]@{SWG7+x/qlY&^% Y// x?M="{ /a.EuPֱ9a\{ɮEù'%!iwrϊ1;vP8qDb~y )N#evBJ\4ax d'~I'~70wXtN"#0VھT5_@=#0VھT5_$;TxڕSMhQnlMbSJ(ixjj*Z(x !IE>} ??I} @@-} A$  Pump MakeXAA@A A A A A A A;A@ A A A A AAA@A@A@A@AAAAAAAAAAA@A@A@M4V@$ 7%$B%,.B%27B%?DB m ,O TP - /~ ~? ,~ UH@ /U U 4u* 5v+ 6vY 7v[ 8j, 9v- :vX ;vZ <j. =v/ >vW ?vV @k0 ,_ U^ .. ,`~ S$@ h U 4@@m?mM@m@7 8mn 9m?mM@mu@; <mn =m?mR@m`o@? @nn ,f UQ 2i UR /%~ Vy@ #&~ V0@ ~ V4@ ' 1 4p@m?mQ@mp@7 8mo 9m?mO@mh@; <mr =m?mP@mpw@? @nr ,g US 2i TT - /~ ~@ 2j~ V@ ~ VP@  4@@m@mR@m@7 8mp 9m?mN@m@; <mo =m?mM@m@? @nr 4@m@mQ@m@7 8wv 9m?mR@m@; <ww =m?m@P@m@? @xt3     4p@m@m@T@m@7 8wu9m@mP@m@; <ws=m?mQ@mp@? @xt  Rg$@<D #BfAD #BfB hRg$@2<D #BfAD #BfB hR g$@D <D #BfAD #BfB  h4X@m@mK@m@7 8mq9m?mO@mH@; <mq=m?mO@m@? @nq  ~ Wl@ X~ Wl@ X~  Wl@  X4@@m@mR@m@7 8mq9m?mN@m@; <mq=m?mM@m@? @nq   d e   ~ 4@5yyyyyyyyyyyz@  ~ p@%h@xDffffff?% p@D? ~ 4@5yyyyyyyyyyyz@~ 4|@5yyyyyyyyyyyz@    U.....  ~  Y~@~ 4p@5yyyyyyyyyyyz@ ~ V@T@ ~ V@  /~  VS@~ 4d@5yyyyyyyyyyyz@ ( )00000 ~ 4X@5yyy{yyyyyyyz@ ~ U@  /~ Z0@  / ~  Ut@  ~  e@  %~ 4L@5yyyyyyyyyyyz@ !~ U @ " 00  /#~  V@@  $~ 4'@@5&&&&&&&&&&&|@`? JDADAB%Tank flow test:Tank flow test 1:BTank flow test: e %fBD<D C[@4-D   B# Bf   %4mD#BfAK Tip Size: D#Bf Pitot: D#BfBPBTip Size: 1.5 Pitot: 58  `JDADAB%Tank flow test:Tank flow test 2:BTank flow test:~ e@ }~ ?  #~  ~M@  8; 4\)5% C #Bfw:Two lines of 2-50 sections + two 1-50 sections 2.5 hose /]) 6@FC #Bf  #) 7@T@ C #Bf+tV D My Fire Department8~@D 8;9   C  B            : H I 4i 5j 6k 8r 9s :s ;t< @ 9 9@ 9A  : ;J ;K ;L ;M cc ;J ;K ;N cc4l`o@4D ?5m?5"56 L6nR@"55 8l9m?m?n?; @:<>>?\~ ]@`@!>'@  DC (?P@ DDC]@]b@] b@^@! ?b@ DDR ?@T@- <C #BfAC #BfBR ?@- <C #BfAC #BfB \ A>>? $ L^g@^K@^e@^@ bb^ g@^K@^@ bb4lpw@ 4D ?5m?556nP@65 8lS9m$@m$@n$@; @DlQ0((0bt| A!A"A#A$A%A&A'A(A)A*A@+A@,A-A.A/A0@123456789:;<=@>?( <[[?!DAB \~ ]``@! >U@! D C ( ?x@!D D C ]Ĕ@]b@] b@^@! ?b@! D D  ?@T@ D @ ?@ D @ \ A[[?   ^g@^K@^e@^@ bb ^@g@^K@^,@ bb 4l@ 5D ? 5m? 65 6nM@ 5 8l 9m@m@n@; @(!<wwwwww?"D AB!\~ !]`@!!>33333@" D!C (!?@"D!D!C!]@]b@] b@^@!! ?b@" D!D!! ?@T@ ! !# L@! ?@! ! ! \! Awwwwww?  !^g@^K@^f@^@ !bb!^@g@^K@^,@ !bb!4l@!6D ?!5m?55!6n@P@65!8lmmn;("<>>?. D!AB"\~ "]`@!">33333@# D"C ("?@#D"D"C"]@]b@] b@^@!" ?b@# D"D"" ?@T@! ! " ?@" ! " `" A>>?!  "^g@^K@^ f@^@ "bb"^g@^K@^,@ "bb"4lp@"6D?"5m?!55"6nQ@!45"8lmmn;(#<[[?# D"AB#\~ #]`@!#>fffffާ@& D#C (#?@$D#D#C#]Ԕ@]c@] b@^@!# ?b@& D#D## ?@T@" ! # ?@# ! # \# A[[?"  #^ g@^K@^ f@^@ #bb#^g@^K@^,@ #bb#4l@#6D 7#5m@"4#5#%56L#6nR@#5#5#8lmmn;Q$<̜ D ;$$%$$B D#ABB $\^=$>̠ 'D$AD$C BC$? &-D$AD$D$CB$^^^^J$ ?  4$$%$$B D$D$BD$ ? # .$$%$$B  $ @BD$ ? $ .$$%$$B  $ @B$ \$ A̴  $bbbbbbbbbbb$4l@$6D 7$5m@#4#5$6nQ@$5#5$8lmmn; %C%=#%>@ %$%>X@%%%% -%>@%%%>@%%%>`@%%%>@%%%>;@%%% >@%%% >Py@% %% >j@% %% \% :  D%Total#%>@T %$#%>0q@% %$#%>@% %$#%>^@% %$ %DD#%>@% %$#%>0q@% %$#%>fffffQ@% %$ %DD%4o@%6D7%5p@$4#5%6q@T@%5#5%8oppq; &&F&>y`@F 0%$BA%$BB&>Gzz@&&:&& 0-BA-BB&>@R&&>@$&&>33333b@&&&> b@&&&>@&&& >b@&&& >@T@$ && >@& && \& : % D& Average&>g@& &:&& 0-BA-BB&>K@&&&>f@&&&>@&&&> &&&> &&&>@g@&&&>K@&&&> ףp= ,@&&&> &&&> && 'a'~ 'a @ 'ED 'FFF 'a'~ ' a$@ ' EE"' FFGHHHHHHHHHHH8(IIFFFFFFFFFFFGHHHHHHHHHHH )42) GHHHHHHHHHHH*9 * * *C * *B * * * *  *  *  * * : *H* *I* +9 +9@ +9A+ + J +KJ +KK +KL +KM +dd +KJ +KK +KN +dd,<?,\~ ,]@a@!,>̔@, D,C (,?@,D,D,C,]x@]@e@]@d@^@!, ?d@< D,D,, ?@T@. D @, ?@, D @, \, A?#D,,^f@^K@^e@^@ ,bb,^f@^K@^,@ ,bb(-<` ` ?- D,AB-\~ -]a@!->9@ D-C (-?@@-D-D-C-]t@]d@]@d@^@!- ?d@- D-D-- ?@T@, D @- ?@ D @- \- A` ` ?- D--^f@^K@^e@^@ -bb-^f@^K@^,@ -bbQ.< -;$.%..B D-ABB .\^=.> .'D.AD.C BC.? .-D.AD.D.CB.^^^^J. ? .4$.%..B D.D.BD. ? $ .$.%..B  $ @BD. ? . .$.%..B  $ @B. \. A , D..^^^^bb^^^bb /4\)/5 @C # Bfe1Two lines of 2-50 sections + one 1-50 2.5 hose //])/ 6@/C #Bf / #)/ 7P@/ C #Bf/LLLLLLLLLLL09 0 0 0C 0 0B 0 0 0 0  0  0  0 0 : 0H0 0I0 19 19@ 19A1 1 J 1KJ 1KK 1KL 1KM 1dd 1KJ 1KK 1KN 1dd2<>>?2\~ 2]b@!2>fffff@3 D2C (2?H@3D2D2C2]@]@h@]h@^@!2 ?@i@3 D2D2R2 ?P@4 <C #BfAC #BfBR2 ?@3 <C #BfAC #BfB2 \2 A>>?. 2 27 L2^f@^K@^e@^p@ 2bb2^g@^K@^@ 2bb(3<[[?4D2AB3\~ 3]a@!3>33333K@4 D3C (3?0@4D3D3C3]@]g@]h@^@!3 ?@i@4 D3D33 ?P@ D2 @3 ?@4 D2 @3 \3 A[[?2 2 3^f@^K@^e@^p@ 3bb3^g@^K@^@ 3bb(4<wwwwww?A D3AB4\~ 4]@b@!4>@9 D4C (4?Ж@5D4D4C4]@]g@]h@^@!4 ?@i@9 D4D44 ?P@3 D2 @4 ?@5 D2 @4 \4 Awwwwww?3 2 4^f@^K@^e@^p@ 4bb4^f@^K@^@ 4bbQ5<d $;$5%55B D4ABB 5\^=5>h 6'D5AD5C BC5?l 6-D5AD5D5CB5^^^^J5 ?p 6 4$5%55B D5D5BD5 ?t 2 .$5%55B  $2 @BD5 ?x 6 .$5%55B  $2 @B5 `5 A| ,2 5bbbbbbbbbbbQ6<[ 7;$6%66B D5ABB 6\^=6>̄ 7'D6AD6C BC6? 7-D6AD6D6CB6^^^^J6 ? 7 4$6%66B D6D6BD6 ? 5 .$6%66B  $2 @BD6 ? 7 .$6%66B  $2 @B6 \6 A[ 5 2 6bbbbbbbbbbbQ7<̜ 5;$7%77B D6ABB 7\^=7> 2'D7AD7C BC7? 9-D7AD7D7CB7^^^^J7 ? 2 4$7%77B D7D7BD7 ? 6 .$7%77B  $2 @BD7 ? 9 .$7%77B  $2 @B7 \7 A̴ 6 2 7bbbbbbbbbbb 8M8?#8>P{@< %278>u@8888 -8>@888>W@888>@888>@888>(@888 >@888 >h@8 88 >@8 88 \8 : & D8Total#8>@% %27#8>d@8 %27#8>h@8 %27#8>@8 %27 8DD#8>8@8 %27#8>d@8 %27#8>fffff&E@8 %27 8DD 99F9>UUUUU5b@&0%27BA%27BB9>effff@99:99 0-BA-BB9>–@R99>@599>g@999>h@999>@999 >@i@999 >P@5 99 >@M 99 \9 : 8 D9 Average9>f@9 9:99 0-BA-BB9>K@999>e@999>p@999>U 999>U 999>UUUUUf@999>K@999>333333,@999> 999>U 99 :a:~ :a.@ :EF:F:LLLLLLLLLLL;LLLLLLLLLLL <4\)<5 / C # BfM%Two lines of 2-50 sections 2.5 hose </])< 6?<C # Bf < #)< 7Q@4C # Bf<LLLLLLLLLLL=9 = = =C = =B = = = =  =  =  = = N =H= =I= >9 >9@ >9A> > O >KJ >KK >KL >KM >dd >KJ >KK >KN >dd?<??\~ ?]d@!?>23333@@ D?C (??@@D?D?C?]@]o@]@o@^@!? ?o@@ D?D?R? ?Q@A <C # BfAC # BfBR? ?p@@ <C # BfAC # BfB? \? P?4 ? ?F L?@f@@K@@e@@@ ?bb?@f@@K@@@ ?bbD6l2 B<0$:$$$^ "@ABCDEFGH@IJ@KLM@NOP Q R S T U x@V W (@<rq?AD?AB@\~ @]d@!@>23333@A D@C (@?@AD@D@C@]@]o@]@o@^ @!@ ?o@A D@D@@ ?Q@7 D? @@ ?p@A D? @@ \@ Prq?? ? @@ f@@K@@e@@@ @bb@@g@@K@@@ @bb(A<98?3D@ABA\~ A]@e@!A>G@F DAC (A?@FDADACA]@]o@]@o@^ @!A ?o@F DADAA ?Q@@ D? @A ?p@B D? @A \A P98?@ ? A@f@@K@@e@@@ AbbA@ g@@K@@@ AbbQB<0C;$B%BBB DAABB B\^=B>4C'DBADBC BCB?8C-DBADBDBCBB^^^^JB ?<C 4$B%BBB DBDBBDB ?@? .$B%BBB  $? @BDB ?DC .$B%BBB  $? @BB `B AH7 ? BBBBBbbBBBbbQC<qLD;$C%CCB DBABB C\^=C>PD'DCADCC BCC?TD-DCADCDCCBC^^^^JC ?XD 4$C%CCB DCDCBDC ?\B .$C%CCB  $? @BDC ?`D .$C%CCB  $? @BC \C AqdB ? CBBBBbbBBBbbQD<h6;$D%DDB DCABB D\^=D>l?'DDADDC BCD?p?-DDADDDDCBD^^^^JD ?t? 4$D%DDB DDDDBDD ?xC .$D%DDB  $? @BDD ?|F .$D%DDB  $? @BD \D AC ? DBBBBbbBBBbb EME?#E>@8 %?DE>q@EEEE -E>@EEE>@EEE>؇@EEE>p@EEE>$@EEE >@EEE >i@E EE >@E EE \E :9 ? Total#E>Ȁ@8 %?D#E>d@E %?D#E>h@E %?D#E>@E %?D EDD#E>@@E %?D#E>d@E %?D#E>fffff&E@E %?D EDD FFFF>e@90%?DBA%?DBBF>@FF:FF 0-BA-BBF>@@BFF>UUUUU@BFF>o@FFF>@o@FFF> @FFF >o@FFF >Q@B FF >p@2 FF \F :E ?  AverageF>`f@F F:FF 0-BA-BBF>K@FFF>e@FFF>@FFF>FFF>FFF>g@FFF>K@FFF>333333,@FFF>FFF>FF GaG~ Ga.@ GEGGFIQ I3I JR J4J J5J J 6J K7 KK@T@E D& KKP@KD9 K K Q@KDF K L8 LL@K D& LL@LD9 L L p@LDF L M9 MCMR -D   $ @ Single StageB VolumeM MM CM M-D   $@ Single StageB PressureM Nb NN33333b@L D&NNg@ND9N N o@NDFN Oc OO b@N D&OOh@OD9O O @o@ODFO P; PP@O D&PP@PD9P P @PDFP Q< QQb@P D& QQ@i@QD9 Q Q o@QDF Q R= RR@ D&RR–@D9R R UUUUU@DFR S> SS@Q D&SS@SD9S S UUUUU@SDFS T? TTGzz@S D&TTeffff@TD9T T @TDFT V_________V ~@ED V WlW Wk W W 1W 4$$$>,RET#, 1*, #,  $9  %F  St#M g%M  )(  ~  <\CC@7],@\^`Hl[9 $<Click to Reset Annual Data<i~~  <\CC@<],@\|H@\9 $<Click to Reset All Data< ~~  <]XPP?  g#]4@]H CHN I| 5<6Net pump pressure should be between 150 and 155 psi. <5  Bh] XPP?m "x]4@h]@ N ~5Oj !  o<pPer NFPA 1911: Gauge and Flow Meter test: If the gauge's reading is off by more than 10 psi, repair is needed.<_o  B] XPP?6z85 ]4@]0A J8Fbiv  <NFPA recommendations: The selected tip ideally has a nozzle pressure between 60 and 70 psi. Nozzle pressures less than 50 or higher than 100 should be avoided.<  B0^ XPP?8V9O ]4@0^A AII2 <Per NFPA 1911: Sufficient hose should be provided so that water flow velocity does not exceed 35 feet per sec (about 500 GPM for 2.5" hose).<Tl8t  B^ XPP?4 6=]4@^xC :K-LA|1KL <hsykes: DO NOT EDIT THIS CELL!<+~~  <0_CC@ S7 ],@0_CH^9 $ < Print Report<E   B_ XPP? ]4@_`F 9OzV O(<PMethod 1 Procedure: Fill the tank until it overflows. Fully open the tank-to-pump and discharge valves leading to water flow meter. Adjust engine throttle for required flow rate (-0% to +5%). Note discharge pressure. Close discharge valve(s). Refill tank. Open discharge valve(s), adjust throttle as needed to maintain pressure. Stop test when pressure has dropped by 5%. Note: This method determines how much of the tank can be flowed at the specified flow rate. It does not determine the maximum possible flow rate. See NFPA 1901 "Water Tank to Pump Flow Test" for additional details.<(xw{ O   B8 XPP? * ]4@8F -$eUN( <NFPA Requirement: Tanks less than 500 gallons must be able to flow at least 250 GPM. Tanks 500 gallons or larger must be able to flow at least 500 GPM. If a larger number has been included in the apparatus specifications, the flow test should be done at this larger number. The default number shown here is based on the specified tank size (cell L24) and the NFPA requirement. If your requirement is different, type over this number.<l t C  B# XPP?5x8]4@#G znUE5ɼlL <Note: This table is used for the tank-to-pump flow test. Default data is provided from the flow rate table above. Normally this table should not need updating; however, values may be changed. These changes will never automatically be reset.<~~ " <$CC@8.9-],"@$H#9 $0<1Click after updating pump data to active changes<0  ' Bt$ XPP? $]4'@t$Ty G N cqM- V(<WMethod 2 Procedure: a) Fill the tank until it overflows. b) Fully open the tank-to-pump and discharge valve(s) leading to water flow meter. c) Adjust engine throttle for maximum consistent discharge pressure reading. d) Close discharge valve(s). e) Refill tank. f) Open discharge valve(s), adjust throttle as needed to maintain pressure in step c. g) Record Pitot pressure. Note: This method determines the maximum rate at which water can be flowed from the tank to pump but not what percent of the tank can be flowed at that rate. See NFPA 1911 "Tank to Pump Flow Rate" for additional details.<(xy}-V  ( B$ XPP? "]4(@$y M4?8?Nya0 <NFPA Requirement: Tanks less than 500 gallons must be able to flow at least 250 GPM. Tanks 500 gallons or larger must be able to flow at least 500 GPM. If a larger number has been included in the apparatus specifications, the flow test should be done at this larger number. The default number shown here is based on the specified tank size (cell L24) and the NFPA requirement. If your requirement is different, type over this number.<l t C4hsykes 6hsykes 8hsykeshsykeshsykes'hsykes(hsykeshsykes hsykes4hsykes>@<d  {   00**** *+ 01 01 01 *+ *+ =>=>=>=>01*+*+ SS LL MM ::JJ PP QQ RR MM NN OO RR QQ PP SS TT SSTTSSTTPPQQRRKKLLMMNNLLMMNNOOOOPPQQRRII KK KKLL JJ JJKK FF==*+99000101&&***+''*+01 01*+*+01'' GG  01WW 00====NN OO => => => TT VV  =>=>=> 7.     ;0 LA   ;0 LA ;0 LA   ;0 LA   ;0 LA.$D$$57BD..-; -b laB$.$D$$57BD..2"; la,-b B$              ;0 LAvG ?A??2224GG?A24'' ##''; LAvA ::,,,-24#24?A?A#,-,- ;  LA&   ;0 LA,-,-; LAMM MM XH; l Single Stage d b$l Single Staged  b$B%   ; LA/  % 44e " NPFA 1911 Environmental Cond.:XNFPA requires the air temperature to be between 0 and 100 to run this test successfully.  d"lNPFA 1911 Environmental Cond.:\NFPA requires the barometric pressure to be at least 29 in Hg to run this test successfully." NFPA 1911 Environmental Cond.:ZNFPA requires the water temperature to be between 35 and 90 to run this test successfully.#Z +"|NFPA Procedure: NFPA FAILUREWith all intake valves open, all intakes capped, and all discharge valves closed and uncapped, a vacuum of at least 22 in Hg shall be developed using the pump's priming device.;The vacuum shall not drop more than 10 in Hg. in 5 minutes.  "LNFPA Test Site Requirement:MNFPA requires that lift may not exceed 10 feet to run this test successfully. u ed 6 NFPA 1901 Requirement:The time required to prime the pump shall not exceed 30 seconds if the rated capacity is 1250 or less. When the rated capacity is 1500 or more, 45 seconds is permitted. An additional 15 seconds is allowed when the pump has a 4" or larger aux. intake. "|NFPA 1911 Pressure Control TestNFPA Test FAILUREWhile delivering rated capacity at 150 psi, close all discharges no more rapidly than in 3 seconds and no slower than in 10 seconds.8The rise in discharge pressure should not exceed 30 psi.mpa ''"|NFPA 1911 Pressure Control TestNFPA Test FAILUREThe original conditions of pumping rated capacity at 150 psi shall be reestablished. Reduce the discharge pressure to 90 psi by decreasing the engine throttle without changing the discharge valve settings. Then set the relief valve for 90 psi.6The rise in dischage pressure shall not exceed 30 psi.T'' "|NFPA 1911 Pressure Control TestNFPA test FAILUREWhile delivering 50% of rated capacity at 250 psi, close all discharges no more rapidly than in 3 seconds and no slower than in 10 seconds.8The rise in discharge pressure should not exceed 30 psi.ti TGG'  Test Failure:Net Pump Pressure must be at least 150 psi. To increase Net Pump Pressure either the 'Pump Pressure Test Gauge' reading or Suction Pressure must be higher.'10lalall B$A&e $..'  Test Failure:Net Pump Pressure must be at least 150 psi. To increase Net Pump Pressure either the 'Pump Pressure Test Gauge' reading or Suction Pressure must be higher.'10lalall B$A&e $..'  Test Failure:Net Pump Pressure must be at least 165 psi. To increase Net Pump Pressure either the 'Pump Pressure Test Gauge' reading or Suction Pressure must be higher.'10lalall B$A&e ,-'  Test Failure:Net Pump Pressure must be at least 165 psi. To increase Net Pump Pressure either the 'Pump Pressure Test Gauge' reading or Suction Pressure must be higher.'10lalall B$A&e ,-'  Test Failure:Net Pump Pressure must be at least 200 psi. To increase Net Pump Pressure either the 'Pump Pressure Test Gauge' reading or Suction Pressure must be higher.'10lalall B$A&e 27'  Test Failure:Net Pump Pressure must be at least 200 psi. To increase Net Pump Pressure either the 'Pump Pressure Test Gauge' reading or Suction Pressure must be higher.'10lalall B$A&e 27'  Test Failure:Net Pump Pressure must be at least 250 psi. To increase Net Pump Pressure either the 'Pump Pressure Test Gauge' reading or Suction Pressure must be higher.'10lalall B$A&e ?D'  Test Failure:Net Pump Pressure must be at least 250 psi. To increase Net Pump Pressure either the 'Pump Pressure Test Gauge' reading or Suction Pressure must be higher.'10lalall B$A&e ?D2' NPFA 1901 FAILURETanks less than 500 gallons must be able to flow at least 250 GPM. Tanks 500 gallons or larger must be able to flow at least 500 GPM. If the specifications called for a higher flow rate, that rate should be tested.%0 Ll  B f' NFPA 1901 FAILURETank to pump intake line should be certified to sustain flow rate for at least 80% of tank capacity. This number can NOT exceed tank size.8e l<ll? ll<l B$ou/ AI%%88Ta  "|Pressure Control Test Test FailureWhile delivering 70% of rated capacity at 200 psi, close all discharges no more rapidly than in 3 seconds and no slower than in 10 seconds.8The rise in discharge pressure should not exceed 30 psi.0 ::2' NPFA 1901 FAILURETanks less than 500 gallons must be able to flow at least 250 GPM. Tanks 500 gallons or larger must be able to flow at least 500 GPM. If the specifications called for a higher flow rate, that rate should be tested.%0 Ll  B f\! Pump Stages:Value out of range.SEnter "1" for single stage pumps. Enter the number of stages for multistage pumps.Please check value. Most current pumps are single stage, however dual stage pumps are not uncommon. Some high pressure pumps use a third stage. A higher number of stages is almost nonexistentagss /  Va% @@raMM  Sheet1ggD ɀ 2l#,  dMbP?_*+%MIBMNP124C odXXLetterDINU"4ip "dXX??XU} m} $ } I }  }  } $ } I } $ 2  ;   @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @       *Z<9Fire Department Fire Apparatus Service or Acceptance Test    z ~@%Z    x    y       {  !"$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXY[\^`abcdefghijklmnpqrstuvwxyz{|}~ҋB `8@H<CMy Fire DepartmentS@ArialҋB `4@H, (Emergency One@ArialҋB `(@H,+1500@ArialҋB `T@H<-% Their Fire Department, Any Street, Durham, NC@ArialҋB `,@H,Cummins@ArialnsҋB `(@H,Hale@ArialnsҋB `,@H,+30.15ns@ArialnsҋB `(@H,+6G@ArialҋB `(@H,"3.33@ArialҋB `<@H,(Pumper 44 (Typhoon)@Arialҋ  i    |  i                 }                    D(leH222HHHHH ! " # $ % & ' ( ) * + , - . / 0 1   ! ! ! ! ! ! ! ! ! " " ~"!@`Z& "! b@#Z&"!@"Z&"!b@"Z& "!@"Z&"!Gzz@"Z&" 0ZM Volume" # # %#@";,. B%#!@d@";,.B%#!@#;,.B%#!d@#;,. B%#!h@#;,.B%#!23333g@#;,.B# @"ZM Volume# $ $ $!@%Z9 $!h@#Z9$!@%Z9$!@i@$Z9 $!–@%Z9$!effff@%Z9$ P#ZM Volume$ % % %!p@$ZF %!@o@$ZF%! @$ZF%!o@%ZF %!@@$ZF%!@$ZF% `$ZM  Pressure% & ' ( (( (( (( (( ( ) )) * *" * *#*$Z *% ** + +" + +% +$% ++ , - . ..&&& / 0 1'(((((((() ( TzFx2{Z2TR (<" (,# ,#  orM$ ce M$ 2%  * & (  v  s <A ?@TextBox3]h p0 >NForms.TextBox.1l: xp   6NMM? @ ]    ɀ"??3` /y` /y迪3d23 M NM4 3Q:" 150 testQ ;""Q ;!!Q3_4E4 3Q:# 165 testQ ;##Q ;!!Q3_4E4 3Q:$ 200 testQ ;$$Q ;!!Q3_4E4 3Q:% 250 testQ ;%%Q ;!!Q3_4E4D$% M<3O&Q4$% M<3O&Q4FA 3Of 3 b#M! M43*@@#M! M4523  O43"  P3O !% M 3OQ44444eee ~v   s <A ?@TextBox2]h  P0 >QForms.TextBox.1lh: ~v   s <A ?@TextBox1]h  |0 >SForms.TextBox.1\:~v   s <A ?@TextBox4]h  |0 >UForms.TextBox.10:~v   s <A ?@TextBox5  ]h  1 >,WForms.TextBox.1`,: ~v  s <A ?@TextBox6  ]h X 1 >YForms.TextBox.1\: ~v  s <A ?@TextBox7   ]h 1 >[Forms.TextBox.1t`:~v  s <A ?@TextBox8 ']h 40 >]Forms.TextBox.1\:~v  s <A ?@TextBox9 ]h D1 >4_Forms.TextBox.10\4: x  s >A ?@TextBox10?v ]h T1 >taForms.TextBox.1p: x  s >A ?@TextBox14 B `(@H,O78@ArialҋB `0@H, QMAX150-23a@ArialҋB `,@H,(ISL 400@Arial00ҋB `,@H,1234560@Arial60ҋB `(@H,+16@Arial60ҋB `(@H,"8G@ArialҋB `(@H,"2330@ArialҋB `(@H,"8G@ArialҋB `(@H,"33@ArialҋB `(@H,"508@ArialҋB `(@H,"1250@ArialҋB `(@H,"700@ArialҋB `(@H,"1250@Arial NʘYxMEr ]h d0 >hcForms.TextBox.1\: x  s >A ?@TextBox11  +]h t0 > \eForms.TextBox.1Xd : x  s >A ?@TextBox15  ]h 1 >HPgForms.TextBox.1`H: x  s >A ?@TextBox12#]h 1 >DiForms.TextBox.1`: x  s >A ?@TextBox13 ]h 1 >8kForms.TextBox.1|\:x  s >A ?@TextBox16?')]h J1 >,mForms.TextBox.1\:'x  s >A ?@TextBox17( *]h K1 >8ҽForms.TextBox.14\8: x  s >A ?@TextBox18()-]h L1 >ptԽForms.TextBox.1\p:x  s >A ?@TextBox190'Z)]h $M1 >hֽForms.TextBox.1\: ~v ! s <A ?@flowrate*+-]h! M1 ><\ؽForms.TextBox.1H\<:~v # s <A ?@tanksize*O+-]h# ;1 >xPڽForms.TextBox.1\x: x % s >A ?@flowrate2+,-]h% <1 >DܽForms.TextBox.1\:x & s >A ?@tanksize2+O,-]h& =1 >8޽Forms.TextBox.1\\: >@7 Sheet2ggD ɀ L  dMbP?_*+%"??1U>@7 Sheet3 VBA@v+3ч3Module1 # __SRP_8 Z__SRP_9]o(6 << < `@h AA"Macro recorded 11/6/2003 by hsykes& 14%PxpGJA$*\Rffff*2g41d273c5A"  N *`      0@ Xh     0 HX p      8H `p     (8 P` x < &G Reset_All Macro (Use when getting ready to enter data for a new truck)# Macro recorded 11/8/2003 by hsykesHC10$B@H B@ F10$B@H B@ H10$B@H B@ racK10$B@H\; B@ tesD11$B@HM B@ \THJ11$B@HLI B@ C:\L11$B@H;C B@ graC12$B@Hcr B@  OfF12$B@He1 B@ H12$B@H B@ J12$B@H B@ L12$B@H B@ C13$B@H B@ E13:F13$B@H B@ H13$B@H B@ J13$B@H B@ L13$B@H B@ F17$B@H B@ H17$B@H B@ J17$B@H B@ F19:G19$B@H B@ F21:K21$B@H B@ D24$B@H B@ L24$B@H B@ I27$B@H B@ 0=VLOOKUP(IF(L24<500,500,1000),pumpdata,12,FALSE) "($pumptest.xls!AnnualReset &B@(A9$B@Ho!Attribute VB_Name = "Module1" Sub Reset_All() X.rDescriptionacro recorded 11/6/2003 by hsykesProcDataVInvoke_FuncV \n149' $ ' Mm(Use when gettingady to e@nter dT for a new truck6'V8V7  Range("C10").Select  .ClearCo;ntsUFHKDT115Jr Lr C12r^q HJr "Lr C13pCE1h3:FrH^JLF17?"+sHp J29:G19@F21:K2?tt.D24 LI2?0$ [i26].Valu=VLOOK@UP(IF(<500,a1000),pump!,12,FALSE)Applica.Run "test.xls!Annxual"נAA!M1End rU~| 0  krU $`inNF#ThisWorkbook_Sheet1ouSheet2 8 Sheet3xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 NʩK#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}x .h@%@@" ophذAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub CommandButton1_Click() End 1 A = Nʒcx!tanksize, 35, 2, MSForms, TextBox TextBox3, 8, 3, MSForms, TextBox!TextBox2, 10, 4, MSForms, TextBox!TextBox1, 11, 5, MSForms, TextBox!TextBox4, 12, 6, MSForms, TextBox!TextBox5, 13, 7, MSForms, TextBox!TextBox6, 14, 8, MSForms, TextBox!TextBox7, 15, 9, MSForms, TextBox"TextBox8, 16, 10, MSForms, TextBox"TextBox9, 17, 11, MSForms, TextBox#TextBox10, 18, 12, MSForms, TextBox#tanksize2, 38, 13, MSForms, TextBox"flowrate, 33, 14, MSForms, TextBox#flowrate2, 37, 15, MSForms, TextBox#TextBox14, 22, 16, MSForms, TextBox#TextBox11, 23, 17, MSForms, TextBox#TextBox15, 24, 18, MSForms, TextBox#TextBox12, 25, 19, MSForms, TextBox#TextBox13, 26, 20, MSForms, TextBox#TextBox16, 27, 21, MSForms, TextBox#TextBox17, 28, 22, MSForms, TextBox#TextBox18, 29, 23, MSForms, TextBox#TextBox19, 30, 24, MSForms, TextBoxME(SLSSsN0{00020820-0000-0000-C000-000000000046} 2h@% %*p %* %* %*8 %*h0 %*` %* %*  %*(  %*X   %*P  %*  %* %*  %* H %* x@ %*p %* %* %*8 %*h0 %*` %*8@x@#*\R8004*#5f" ophAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Controltanksize, 35, 2, MSForms, TextBoxp3, 81710, 41, ^1@-,16k1<71K,191Z/@1[/w1[h@ 3A\hflowrdR!.&bAd.dba2 .@-2!D2!\'2 1>j2 M2?M_/%2`2_M!`.?.!`. 37`.PQ Sub11_Change() End Nʾ$#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}8(%HxAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2@LGNUserForm1Module2__SRP_2__SRP_3oxME(S<S<S<S<0{B258EC21-AB8A-450F-97F4-EB516A00A534}{A6286FA9-39B1-4B0F-B6AE-5D8FD252CFFF}h0(%X0 %0xAttribute VB_Name = "UserForm1" " Bas0{B258EC21-AB8A-450F-97F4-EB516A00A534}{A6286FA9-3@9B1-4BJB6AE-5D8FD252CFFF} dGlobal!SpacoFalse CreatablPre declaIdTru BExpose0TemplateDerivCustomizDrU~| 0  kxrU $`an$+Nhe 'AslI2w ByK ^ʈA3C32:C3k8HF I?YA4>o`C45:Cn4?g I?15u051:C53F| I?16o064:C6b/F I?0C40?#.#Jq 59 yn C7?i("pjqO`cYc0O`UYU1`GY59o9O`9 Y6?%:[a33@].ValuB=G+TIME(0`,5,0)x4U354657IF(@COUNT(PM,F37:0J)=0,",A36S 444 47,F447E4a52: 51> 552V$C54,$F54:$I54g55)5!5!5($&C56,F56:I5666*2#66JC$C67` 6*7` 66a68/# # 8!8!8 67 9/Q'69,F69:I698qtyC CA28End  Module3 Module4__SRP_4__SRP_5oxMExpGJAx"Attribute VB_Name = "Module3" X AnnualReset MacrU~| 0  kxrU $`n$+NsNMoxME(6 << < :`@h __"Macro recorded 11/7/2003 by hsykes 148%PxpGJA$*\Rffff*2d41d273c5_"  ^ *p     ( @P hx      "8` x     ( @P hx     0@ Xh       0 HX p  8(`8<<88x<<08p   X AnnualReset Macro (Use when getting ready to repeat a service test on an existing unit)# Macro recorded 11/7/2003 by hsykesM21$B@H B@ F22$B@H B@ H22$B@Hac B@ B@K22$B@Hes B@ B@J24$B@HTH B@ B@D25$B@H:\ B@ B@K25$B@Hra B@ B@D26$B@HOf B@ B@D27$B@H B@  Range("I27").SelectA Selection.ClearContentsK27$B@H B@ A32$B@H B@ C32:C37$B@H B@ X F32:I37$B@H B@ wp}wA45$B@H B@ C45:C47$B@H B@ wF45:I47$B@H B@ aA51$B@H B@ C51:C53$B@H B@ F51:I53$B@H B@ TA64$B@H B@ C64:C66$B@H B@ F64:I66$B@H B@ C40$B@H B@ J40$B@H B@ C59$B@H B@ C72$B@H B@ O32:Y37$B@H B@ O45:Y47$B@H B@ O51:Y56$B@H B@ O64:Y69$B@H B@ =A32+TIME(0,5,0) <($=A33+TIME(0,5,0) >($=A34+TIME(0,5,0) @($=A35+TIME(0,5,0) B($,=IF(COUNT(C37,F37:I37)=0,"",A36+TIME(0,5,0)) D($=A45+TIME(0,5,0) F($,=IF(COUNT(C47,F47:I47)=0,"",A46+TIME(0,5,0)) H($=A51+TIME(0,5,0) J($=A52+TIME(0,5,0) L($/=IF(COUNT($C54,$F54:$I54)=0,"",A53+TIME(0,5,0)) N($/=IF(COUNT($C55,$F55:$I55)=0,"",A54+TIME(0,5,0)) P($,=IF(COUNT(C56,F56:I56)=0,"",A55+TIME(0,5,0)) R($=A64+TIME(0,5,0) T($=A65+TIME(0,5,0) V($/=IF(COUNT($C67,$F67:$I67)=0,"",A66+TIME(0,5,0)) X($ &/=IF(COUNT($C68,$F68:$I68)=0,"",A67+TIME(0,5,0)) Z($9,=IF(COUNT(C69,F69:I69)=0,"",A68+TIME(0,5,0)) \($A29$B@H9o80AAttribute VB_Name = "Module2" Sub AnnualReset(), `.zDescriptionacro recorded 11/7/2003 by hsykesPro cDataXInvoke_FuncX \n14;' ' Mq(Use when gettingady tpeat a service test Wan exisuni:ts''`@  Range("M21").Select  .ClearContentFsF22HEKJ24p(D25p Kr D265r(7Attribute VB_Name = "Module4" Sub Printtest() X.rDescriptionacro recorded 11/9/2003 by hsykesProcDataVInvoke_FuncV \n1' ' Mmv% She@ets("Tk Results").Select%Active.Unprot "Range("C32If (Cell.Value) <> "" T8hen!59 !#Ѝ"$owg#l.EntireRow.HiddelTrue$End If(D26(((A\RD27)\KOr (K bA @EQ?QC45?QQ42:~49)f=>?&A`8:M88cPageSetupB.Areau$A$8:$M$`U 4 H B@ks.Add Before:=j aWind@Y edzOut Copies:=1,@llat ]9 HBA1`H > 0 GC}iKyp41:43%AHp`Q4"r6 #,6cFN$29:$Y$71ā==[?[{.[?8:d:$Fals'c DrawingObj X!WYntentScenarioZDi ns'r'!Fn\1XYo=4K22`VSummary2 With "F $ S>TitllsG#Column-!m Shape flowrC0 O!octanksizeoo odB4?  'PI1 COU_G/"(0ϗ T)FVo(o(%19_("___#tOe"XG3 0aa1:$J8$50      !"#$%&'()*+-./0123456789:;<=>?@ABCDEFGHIJKLMNOQRSTVW[YZ\^`abcefghjklmnopqrstuvwxy|}~D%/)/).LeftHeader(CPTerp .RighoFo MargiApplica.InchesToPo s(0.750 "3 onTopoo1Botto~moojoo0. rXas_XCHGrid0linedeCoLmmxl"No5NQuality%600%orizontall!CVertP/.Ori"!0ortraipr !DraftfrS@fSLerd ̱ .FirstPageNumber = xlAutomatic .OrdtDownTh@enOver@BlackAndWhiteFalse>Zoom,100(PrintErrorsxlDisplayed.End With ActiveWindow.SelectedSheets.COut Copies:=1, llate:=TruRows("1:50")!-'ion.@Entire.HiddenQjA:.Shape'flowr4)yNbjX&F:Left 333 GTop 555 ?tanksizbe?132?2? @67.7@ A 'ljbProtAwDrawingOz@zAntentScenario\Range("A1LQIfe("Test Results  Sub   0  P  `  p  Module5Module6__SRP_6__SRP_7oxMExpGJAx"Attribute VB_Name = "Module5" r !j(lNʁxME(6 << < N@wxME(6 << < b`@h "Macro recorded 11/9/2003 by hsykes 14`%PxpGJA$*\Rffff*2e41d273c5"   *( X`   (0H ` x2   ( @PX `x   6 8H`p  @X Th   "0 H X `h p   (08 @ `x   8Phx  (@Xpx  0  P  `  p         (  H  X h T     0 @  Printtest Macro d# Macro recorded 11/9/2003 by hsykes Test Results$dB@H ActiveSheet.UnprotectC32$B@HM21 f!$B@ C59$B@HB@ f!$59$hB@Hac !j(lB@kD26$B@HB@  f!$B@26$hB@HB@ !j(lB@kpD27$!$K27$!$B@27$hB@HOf !j(lB@kC45$B@H f!$42:47$hB@H !j(lkkA8:M88$B@H $A$8:$M$88 n!p(rA48$B@H fx n!tB@v z!|B@~ BA1$!$ C32$!$41:43$hB@Hr !j(l49$hB@H!! !j(l59$hB@Hq !j(l62$hB@H !j(l` $N$29:$Y$71 n!p(r z!|B@~kA8:M88$B@H4: $A$8:$M$88 n!p(r8:88$hB@HH !j(lM ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=TrueC59C32$B@HB@  f!$B@'Test Results'!F26$B@H7$ f!$Summary$dB@H n!p99q flowrate2 n%B@H (B@  tanksize2 n%B@H< (=A3344$hB@H$ !j(l0,kSummary$dB@H n!p99q ActiveSheet.UnprotectF43$B@H F f!$UNT(C4flowrate n%B@H,0)) (=A51tanksize n%B@H=A52 (0) L43$hB@HUNT($C !j(l0,kG36$B@H f!$,$F55:36$hB@HE(0,5, !j(lk $A$1:$J$50 n!p(r5+TIME n!p($999999? &%9? &%9 &%9) X &%9UNT($C? &%9? &%999 9X999 99 9 9 99d9 9q z!|B@~1:50$hB@H !j(lflowrate n%B@H (M (+ (tanksize n%B@H ( (+ ( flowrate2 n%B@H (M (@ ( tanksize2 n%B@H ( (@ (M ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=TrueA1$B@Hk Test Results$dB@HA1$B@Ho5`@h #Macro recorded 12/30/2003 by hsykes 14%PxpGJA$*\Rffff*2f41d273c5 "   *( X `hV  pumpsort Macro d$ Macro recorded 12/30/2003 by hsykesPumpMake &B@xBE31$     B@B@BE28$B@HoAttribute VB_Name = "Module6" Sub pumpsort() T.nDescr@iption|acro recorded 12/30/2003 by hsykesProcDataVInvoke_FuncV \n148' ' MlSu&  A@pplicaZ.Goto Reference:="PzMake7ASelecS Key1:=Range("BE31"), Ovr xlAscending, Header:=xlGuess 8_ 'Custom:=1,etchCas@ Falseie ntQ!TopToBot, %O?QNormal6Y28").j End @z rU~| 0  krU $`n0* pHd VBAProject4@j = r GJA J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\System32\STDOLE2.TLB# Automation`E OfficEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft S@hared\@10\MSO.DL L# 10.0 Ob Li`braryKMSFor ms>SFrms$3D452EE1-E0D8F`A-8-02608C4D0BB_VBA_PROJECTdir__SRP_0,__SRP_1P+le`OfficeuMSFormsCRefEditModule1b _Evaluate Reset_All~Range  SelectionZ ClearContents{i26ValueK Application*Run_ ThisWorkbook|Sheet1CommandButton1_ClickSheet2TextBox11_ChangecSheet3 UserForm1)Module2c AnnualResetpa33qpa34rpa35spa36tpa37upa46pa47pa52pa53pa54pa55pa56pa65pa66pa67pa68pa69pModule3dModule4e PrinttestfSheets  ActiveCellRowsU EntireRowHidden] ActiveSheet%N PageSetup PrintAreaP HPageBreaks`vAddrBefore ActiveWindow+SelectedSheetsPrintOut.Copies?CollatePrintTitleRows1sPrintTitleColumnsShapes< PrintObject! LeftHeader CenterHeaderD RightHeader LeftFooter CenterFooter RightFooter|S LeftMargin]InchesToPointsI RightMargin[ TopMargini BottomMarginu HeaderMargin8 FooterMargin PrintHeadings)nPrintGridlines@ PrintCommentsxlPrintNoComments PrintQualityxbCenterHorizontallyCenterVerticallyI Orientationw xlPortraitDDraft: PaperSize xlPaperLetterKFirstPageNumber% xlAutomatic@OrderAxlDownThenOver BlackAndWhiteZoom PrintErrorsxlPrintErrorsDisplayed6Top5Module5fModule6gpumpsort ReferenceeSortKey1OOrder1o xlAscending`HeaderMxlGuessY OrderCustom| MatchCase xlTopToBottom DataOption1 xlSortNormaltanksize`TextBox3STextBox2STextBox1STextBox4STextBox5STextBox6STextBox7STextBox8STextBox9S TextBox10 tanksize2flowrate flowrate2 TextBox14 TextBox11 TextBox15 TextBox12 TextBox13 TextBox16 TextBox17 TextBox18 TextBox19Workbookk   _a+-1579$273c5`Module44SFM260L'B _&/;"1jIqAaHq00}#@8@q#G 50 ABA777B25-A412-4B88-86EA-AE853C38976DOCUME~1\hsyk@gLOCALSTemp\Excel8.Ac7.exdHd<".E .`M 3RefEdithRfEbi3wJ2p4517F1 MǕREFEXDITBo! " Control5?5B6ar50 qDE4501765-13B8-50-B71h1542E67853BAF{5VBE\$4``@DE0FEB NioduleT1Gio4u1T 2 H1 "," Y!" +ThisWorkbookG Tiw"WxkbonkA2o%oF"e`Sheet! See Vtas  *\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{00020813-0000-0000-C000-000000000046}#1.4#0#C:\Program Files\Microsoft Office\Office10\EXCEL.EXE#Microsoft Excel 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\STDOLE2.TLB#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.2#0#C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL#Microsoft Office 10.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\System32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{BA777B25-A412-4B88-86EA-AE52E53C3897}#2.0#0#C:\DOCUME~1\hsykes\LOCALS~1\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{00024517-0000-0000-C000-000000000046}#1.0#0#C:\Program Files\Microsoft Office\Office10\REFEDIT.DLL#Ref Edit Control*\G{E4501765-13B8-4120-B715-01542E6753B0}#1.0#0#C:\DOCUME~1\hsykes\LOCALS~1\Temp\VBE\RefEdit.exd#Ref Edit ControlEF   GJA  N Module12g41d273c5Module1Y ThisWorkbook2B41d273c5+ThisWorkbookF% Sheet12C41d273c5- Sheet1K0 Sheet22c41d273c51 Sheet2HC  Sheet32E41d273c55 Sheet3$`%UserForm12F41d273c57UserForm1xModule22d41d273c58Module2MoModule32H41d273c5^Module3hModule42e41d273c5`Module4@wModule52J41d273c5Module5sModule62f41d273c5Module60xH`tf_N,yc&ʊ(B4J΢S2n}H(-QQ{fOrɒ!Ag*X@9rG`fL[F>LPži˚=K ? bX*I::ԘqBuAQg``Mrot9^GotoExcel+VBAWin16~Win32MacVBA6# VBAProjectstdo 2 K 2G, 2  2 2 Cp. 3 3 3 3 ))$ +UslerA@*;er+2/0,#(@ :B"\-b..$Mo.G]_?<}5Th_M4<4+`W4_4@w_S5_5Z5_5_s_S6_6Z6_6_YK