ࡱ>  bd'  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FF_L]Pe]WorkbookE6_VBA_PROJECT_CUR"C&0Pd]Pe]VBApd]d] g2\p$Taylor, Maxine (R&D Managment Block) Ba= ThisWorkbook=xKE$8X@"1Calibri1Calibri1Calibri1Calibri1Calibri1 Segoe UI1QTahoma1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1h7Arial1 Calibri1hCalibri1 Calibri1h7Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-[$-809]dd\ mmmm\ yyyy#,##0;[Red]General#,##0;[Red]\'\te\x\t\'#,##0;#,##0;0;[Red]General                                                                       ff + ) , *     P  P        `            a>   @  H   h@ @   H  `@ @   @ @  1 D !t@ @  1!t@ @   D       1               @ @  1)t@ @  (P  @ @   @ @   @ @   @ @   @ @   @ @   @ @   @ @    1      @ @   @ @    @ @   @ @   @ @   @ @   @ @   @ @   @ @   @ @   @ @   @ @   @ @  ||lT}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-} _-;_-* "}-}  _-;_-* "}-}  _-;_-* "}-}  _-;_-* "}-}  _-;_-* "}-}  _-;_-* "}-} _-;_-* "}-} _-;_-* "}A} _-;_-* "ef-@_- }A} _-;_-* "ef-@_- }A} _-;_-* "ef-@_- }A} _-;_-* "ef-@_- }A} _-;_-* "ef-@_- }A} _-;_-* "ef -@_- }A} _-;_-* "L-@_- }A} _-;_-* "L-@_- }A} _-;_-* "L-@_- }A} _-;_-* "L-@_- }A} _-;_-* "L-@_- }A} _-;_-* "L -@_- }A} _-;_-* "23-@_- }A} _-;_-* "23-@_- }A} _-;_-* "23-@_- }A} _-;_-* "23-@_- }A}  _-;_-* "23-@_- }A}! _-;_-* "23 -@_- }A}" _-;_-* "-@_- }A}# _-;_-* "-@_- }A}$ _-;_-* "-@_- }A}% _-;_-* "-@_- }A}& _-;_-* "-@_- }A}' _-;_-* " -@_- }A}( _-;_-* "-@_- }}) }_-;_-* "-@_-    }}* _-;_-* "-@_- ??? ??? ??? ???}-}+ _-;_-* "}-}, _-;_-* "}-}- _-;_-* "}-}. _-;_-* "}-}/ _-;_-* "}A}0 a_-;_-* "-@_- }A}1 _-;_-* "-@_- }A}2 _-;_-* "?-@_- }A}3 _-;_-* "23-@_- }-}4 _-;_-* "}}5 ??v_-;_-* "̙-@_-    }A}6 }_-;_-* "-@_- }A}7 e_-;_-* "-@_- }}8 _-;_-* "-@_-    }}9 ???_-;_-* "-@_- ??? ??? ??? ???}-}: _-;_-* "}-}; _-;_-* "}U}< _-;_-* "-@_-  }-}= _-;_-* "}A}> _-;_-* "-@_- }<}? 4_-;_-* "-@_}A}@ _-;_-* "-@_- }A}A _-;_-* "-@_- }A}B _-;_-* "-@_- }A}C _-;_-* "-@_- }A}D _-;_-* "-@_- }A}E _-;_-* "-@_- }A}F _-;_-* "-@_- }A}G _-;_-* "-@_- }A}H _-;_-* "-@_- }A}I _-;_-* "-@_- }A}J _-;_-* "-@_- }A}K _-;_-* "-@_- }A}L _-;_-* "-@_- }A}M _-;_-* "-@_- }A}N _-;_-* "-@_- }A}O _-;_-* "-@_- }A}P _-;_-* "-@_- }A}Q _-;_-* "-@_- }A}R _-;_-* "-@_- }A}S _-;_-* "-@_- }A}T _-;_-* "-@_- }A}U _-;_-* "-@_- }A}V _-;_-* "-@_- }A}W _-;_-* "-@_- }-}X _-;_-* "}-}Y _-;_-* "}-}Z _-;_-* "}-}[ _-;_-* "}A}\ _-;_-* "-@_- }A}] _-;_-* "-@_- }<}^ 4_-;_-* "-@_}A}_ _-;_-* "-@_- }A}` _-;_-* "-@_- }A}a _-;_-* "-@_- }A}b _-;_-* "-@_- }A}c _-;_-* "-@_- }A}d _-;_-* "-@_- }A}e _-;_-* "-@_- }A}f _-;_-* "-@_- }A}g _-;_-* "-@_- }A}h _-;_-* "-@_- }A}i _-;_-* "-@_- }A}j _-;_-* "-@_- }A}k _-;_-* "-@_-  20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%3Normal % 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`| DataSheet+ Hidden Data &Help,- AddedByUserIdLookUp;##+AmendedByUserIdLookUp:% CheckData7 ReasonForClosureOfTrialLookUp;A' TargetDateToRecruitPatientsAgreedLookUp;<" TargetNumberOfPatientsAgreedLookUp; UploadDatafF f0  A@@ ?T05/Sb*i>9V X~*n*i>9V X~PNG  IHDRj%sRGB pHYs+*2IDATx^x !;I%T( (]QAAņ*6#bD+`AQ& -"{  $wR4qƽ}2;;3;33qnh 1ߞƀ44hлiжDք1@Ӏƀ 4 h hHӀƀ 4 h hYӀƀ`@{4%h h641wMZ)41mMD41=E4<SM ai@c@;L5 h h041`buw(!>!|%5_򴹮z-}}UQ'Mh+TsË _6N]q瑞M.8ryv 4yAw ezS|/T5vp)5 ԯy LY+U]w͟Gܸ||*qK +;;Թێ %zQ}8Е/ЪzZ?D(["ysuQq")+jVSX<_sIвW|W,ߪjqsBc/|7 yRt}] [*8ź*31Z)F:Ђ~^&R}q{`I _]E&GwU_\ܰyc`wNKMR8A+ZcR8vjܪ0!ɽYkWVzUϱ 3ןH73FK.qIWIvdyƝfL_$/dO=ҾG/*+H)f_l۷^jḳDw[CtX<(`PR~V{JE>6= lBӆ K%__36_Q Y68]/zoZZG {E<䑖$sɾNiE7ȥâ-t(O+l4~xLbb.hQ5v Eo% ~j6 ).MὢBҢK;3.>= Xyu^vq LE /V= dWkwL'H?%^hX׆ ͨ rcp@JłT&]6O}c>rXgRAys"Qh+>x6K?~s?l=^G#؃l4؎r Y6ՉX8#g9k]xH~^8z$'Ԥ'jϋKmbmǽ; wWk}* wYBc aX*R>`Hk5J罳qsg89X+v|cqT l듘^_-ܭ/iF"QAׁ9FOQZ\)֡+Y_  Z Wa}RnS]Q2N==^^'!{TG_ 0H5[Iq[/K8OCȹ]`>!?qtÁ~{5Dtj6M9 W;YR;h;:e+ ==l`4Jh<% Um8K$|H<|r`y|]`!S,|;wj ly>wEhRAʅ|jLwEY-]'q}Z PZ,F 2 잻Xfow#D% 7m-h[W)Z<0mB[jeLÛPŐ`o l!fhAC е=ľyXFSó8X$fߩ$.5㓆1Q~u-SJPPXWcƘn"Z`9NrN1*(7TKfx*%]q'%8cړXQ)A6ОS {+#.&|hz $U2a%CDk'''iP"2Q'O]c,\(P.8E+G(V(o~>u0.Kv}#|W=؞ LNQHvDqPz8PU('F嫩_efNf5'3f)Cpra1偀4YD*-|F #]#c@9~WƑ1 /1 .^xa&Z`1"WzjyΜ9 Eiݺu:T#G\pϯlٲ(=zdݓ/_>}/_>GȲ ~%#rɒԩ[|_U߅cW&v=svZnwvc)ڠA+Ǘ߸qCAdd9s^ڵk︣_\kn2,YkXXX65]fRt!hs=%KSgW9jǎoDGaxԩ{dI 6$'s]v ;_ۘ_%#I||<[{ァ:Y7_w\^~ݶ>8'ͧGۤCdD3gF\qÇu~ڴw&b.\gVav6^6R@V_xdDqٲ!i0%JTgٲ!!EUmvމrlm%%rS/+ƜO޼yV! PWW`Mʌ5k矠!版QV^u-qtٲ_,}[ѣGASҥ;w|]zBz Fطoߋ/ѣ}a͚h /4ԛ2䩧ư/5jpԩ(Zy=#/t+W.h}/CaF FPE&ýn3g_nKh"7owgϞQ#UˣV13gر65kLڬY3,X}{CM׻wVZ3ǿxm۶DL&6~RJW']x}ѢmR%#"jk}Eo =z Ν;/t2:uA)]1gy4hО=Yx ZϠ7cΞVV5$ ѣxAR+7.4 %?OGhQiӦ?faEDOrXXH7m$UTUTo0AiF +;oR33ftf @*|!Z{+::SnZ~͡j tFekςOXnʕ̤Io%eN޽{Qy 5k~jժΓ~*WBrgϞ{]KsNΝp]df͚ 1٨!Ν33! ǟANԗYj.ZțoN^r.]ִi3ٳ߱f̘ս{a^7sg&֪UW_Aaav,X8rx`Ԩ'(1LCǟ_z trtÆM۷/-Nvia/mK.͟ 747qw`Ŋ۷7oOb vߞkh}-Z1=3D8; @A#¤IS ǧu6?s5j[gx(,L@@իTJ֭ۘ?&O~?޿?g|@裏rʍ~P](`{R2h]3k灁p.~֡CM&7l(/?8J*ݺud\e?j*b /4mz%(82{7$>ܳɮ];3㏉`oB6ZByC)A)W3N2r_ rt!(`" IH8/:3:x9C?UeUav-(.I.6\$_aÉp"|/Vnᵴ:0PII7ձ;2b+ t9k{e*$J(e ")Sކg+ Z F9ζlق(V0z?<<\&?whbԨ'2Sw+'O%H͛aНLCЮcJ?k*~" FrV!{/E䨶<+VT2Ba{W^C[neJj%4~aVZañ69H|)sep &.XK P[ T$K[;V/IN'O55|8`؜ 8+罽c44em:WOz@j>l)rJA& ,SIFϟspqq!d%@j%XM K*)cG~}kp=SʹʫEVp 962!kMJ2#XfEaSк^ p82GCrl'9vHAHΈrHjZ~yPøV; S)D~ zp6O\S ZK3U-`yx Ę21c۠Bi0f[٫ˤdɒ(écc嘼tɀ:SgL!Mu˻UrK7J(޻g0veap#IC6+XTf{I6w9^m/h ӿ_V\Q/6bC|Pr8~ ^o[Cu%/x68,:UJޞq\`y-]t`u~GE0ThF6irSraHb0:^J WSGy5kFWC@'iQ+Nf X>Jx|e)g/WC8GlO7Vp~7""­>7{GU!Q(TPH&\~V,Csj\ uFر\,-QfCbE<;{yS[6jH`EÆ ,8m9@ b짓20a;t舶Ͷw>'T$0*;UlWb۵k7a+llB%CKQn; V$IQ͛ 'y25+ϸ]܄B%q`8{Nxx.q^TɛB hpƥe悒T, qQ0m6Ȯ)AXN {`K[N CҐUsxe'|oٲսae6x=.VgdFM6`-@f۶~&"#.Nɘ˗2?K7e9=@&1 s4Us$4dyNfzĀfL"P7 lVQ!D`{=#{R\?{ĩ@Ĭ=f^!p$.GsUB 0^AvYMlK1ו*YH}\z/_%WSKϵvu7jfe/o\B[-*2+rIZ*楩~+krHnpTBq]~Ɣq1qNM]w]cu O^%x?l;ڋ52+2f' ۷0a46c^(-aBɳrZ mqN~njs 4'Yߝ&h+#SۯLe}SrdO+re0=rI0ZHϠND ā<POn&({xo IW;uH믿.2VnXsE _V޴iڵkt'+̤oLG351W__|d~L$z#Gn%bh T:4=d ĉ6[|33K8.n77[j)$ ^:%Қn$7ϙL(: ˴mzuH"?)ϟ7ֵM)^BL~'&)ZA}vjۓ6B P7bDKɄ  kzE .i5z,F4K\2ifJзdqxi9W Œ9HgFB!²/Pŋx%ԩo uԙ"2a ǎ4F?FtO*&bvmsB3jHҥ$89>|@>Lڒ,fL\< F7 $ږ&6R2*Pl_}5kכ.9)j.2d?ʼ ߦ.,(v=Cxz% |"MH@RZ /HHC & ɾ:A%-* \9E"C&`G4(Z c"n􇐝b@@Bt!^FOX5;U8؅3Cv@]tAJ8 (=! @Fq␁$hJ-2O0E1)Dfɻ եsIE*1_T9XF.a bC*q&MFR pJe#С? .dy籧8p$=SçįJ+^ȵL[#E_ NAzu#ӗO^:ҟ$ʎD9  EBAB}lC^+0ͅK)>JRHI^D>mIf^6lᅘfAmT' Z,-[3wESSpљzLļL}Қˆ$ I5qe`%iyOZnR 7L*de_pLW pDJy#\KRkJHFfV AfjP]IZ5hEjkVXUWx/1){ALGK{LO1GK"֠A%X 4RN>4Ԅo>) ɛ?nOͯY?κwߵ7ıwIx]|r? ܤhn7{Q XW} ;V"mf԰_{bqp=qOlZFAIjT^Vj:Ve2%1\ؖ[a X;píSQx@-I6xޖStMX,fRh l5LAԼ#x@7}MȺ+֯@ѬT*T:)-Js\T:9b3:`0Yw<ͶBwDfWu]w t*֪FGGrV.+j l:Yvh4fdQktH7xsߙJqQ&~uW?zv_EU#ᙹi255H K.ojJb)J%2T+VhZ#Pf'Sw wޕ= tOuo] 6y%VѪKKKKk˓c{*Lpafx|.ç5ؕj\2yKV7|*Z,eRxRi J2YFTjڲқ uw>@7 Oj#uW_N8ڲfKkW_̔ &v*ɑǩz4Y ~ Rg(ֳJА$":wN'^uJR2?GWgٻ+ V@̝?F ە&bͿ+R1ĈOjΤٴZ9vnJBI l^5I'6}KC]hww]mݺdcLngRdWWc[ZMjԫlR^.䳁Tz- Kf RO j-^nON[-yI\{r"-r_tqwɅo t[7i>aCXGCF_v1KZX"VTjR%(lt؛M1.o֫\.$|VCJ^ki5F_Ή==:|c *R"['qX\X[^ mndz oGwAA;-[X+[n8۝uW-^NUuTMzY^*WjUY(h*Do\k v%v@>.χә\!\b]HM;G&mod] oԥl& ֠ͯZv+vP/{Evk G-GXʟ}hTj;&`IR>gk+[JPAqo! IFMlCJ ђ5U\56,[VTFERAUJb{K#RTҌ%+ZW #V{Isr84[[[щKϿxZwOL6fU,*jݨHT27`ryşMbx5*󺄸\RMʚuy9Yed2]~ݡP*ZU6hZzhb/h*r6f52%Ļ|?n;wIv?koyEw~+pfWJ+sBy`do|)l6ZkLԆJ|B:֥$" J2kѮ!'WF^.'e C&q^KXjnunZ_kRD@htZ U.Tz=7e-X=ߺn] @7ۮ\lzy~rF/+ E4>22ɔq:!bѸfѩ5zUѤP!+Z !fPKux¿(Tv?{z=}tvz3O<)U`TM6Ю\\_޹6kgVV67chfV7%L:|*ǦcrQhٵoI j?v d_We pRw`r@6 z:6*":P T-rLh'R'wrw + +Qk1Zܵgx|(Yhb의<0L|'kuF&'+ ssKKH,ի,f'zRJ˅U9r]ZZ*kboh=6].ҹ'Vf֩F8 w8EAwvm i:*R8j}bIj4DPWч#Ʋt;]p.8ݏ]qhF `lԙ(w;]ڗW:mfɤ;,A(m|iԮ_.7a{j}#Ng/QVtW7Www qhJ1We~;WpnjrAǟv1w ~߸/Joſgmt] tJ 6iBr-K@2NwW 2aYl2hFΤ5zi-ѽnV"Q tiZM Tᩧ\]i U+UbR0 #)ۑ4{dr4_X z̉Sϝv2 %SQ)~3H*ѹ'Dt(|,fBWC|WC?{7CO\+cXjXT*k ieyP_S׉j**z#^8e|c1T5cd t6UGTK D`ol&ODST^Y=(R(n̰'LQ5[k{ڪFـ1C W^> /BsZAQq|wWfbD 7^KURBlnVCkhTZR,eKT%S䰣K̟fcr%P36jm<-u7SB!Hjqb"[ɻ|] et>%5fmsm=RN+o6dMVi0 X[Y!Þ ^IT&ɥъ%j5+9!uX]Pg4W} E+ BЋQwvRSyNS[|,WLpf]5whxKR-F 5O3`+3F9jm Y*v*jDX)x'P2?>9?DݸzM\< fRkr&VW"@!gڕ`P*۵fsqz6bbvmjeڕ3f/*mZXNoJV/W4Ti9YgJO)ǷMN7+mgi:r7ݯ cV1{W#o7^7d23%k T5M3\2JoQY՘BˊnYڜV p&z)5V9tRP"EGCFcTҔ*Y+ᕕF5rqZ]V3͓dEgMFp 33p -WTޚ~_?~sXtDtQhv^HJꌷm9#o\>͉UzݍgvW-_/y +YJ)WaB SV}l]L90d*+ lNWҹX-rL('׳Hgx XzZ]]KBUI<÷c򱤢TbhިZU8t^;Ψˋ 2oxaЛ;&M9f+~W\f3_Y-$g>rr,jd՚̵Ͼro<_GKƨSNƢQCNZC.:W* ۆ4:zoȼQ+YT2HfjkM˕>ltRVۭR%X*$7% .ZIG) oëRX+Uh}Cz.534zK HNd#>p'? X_zzPRhqӷ2,JT*{MֻމyܤWhT̬2h$:0-]..wͺ+Z Kt"1Nvb5_P%8v8<\BfR[%ѩBFJʉ|Moq-nF ^V.H,[&WLSj P }䃟K/xY8js\B@ gR VsxvΪWZŊ Dq[cۺr?S} 7\wWݲm:=^K˄Rs`wjJcڡWuDYPh'7nG0NYoS:,[L"4rVRȤK|Tj-,ro~'{VEK-rTw#4(gRqe|=Y[Ru˫pjv)qh-s+7d\֬QD3Dw =3x`K.,M:e^֓`]:zRTܜDw˥p.=8fVO(<'p?O =xR'~޿+#ܱ7(2$Rciq^R9!hҸX*I%M[eBHn³D&5I7Zm\F-rjJ8bh"|"-+:FmѼcٜA`.f`?ì7v zUjy62-%NkS1Ikj j#/f{vG#xv6^n3Y5bcZmhrڬИt/}+.W*ir ޖP60ek:767W7idw;n8ǟcX=escd6u`E;Jxl{7/! zDொα߸!~M+m; {=8uECQc0 ɚ}}H%3tTZӫMfZo11k1CS$"5rEKVO'փG%J)!"U$,kW?OgN|kYF+h!wbLo.Gp&E <2`s=^1k j1Z[e5R(UFcw|Sy'f/o4lR0zުM.,:CX\g+'.6nu'F8ĥр& 8˼~▻AE^-~J+ ?nDw;8 7FiEl6'B W/dl[9K<͎pҼpF)1킝(o.IXϭlx~moYn 6s2iuY9QI2UkLj\r8zb`Y.Zjs=d|&gldlpKX[JWYZտk5<ФKJj"d YZk*:7NNV2diڤ֩,zmcR7&#\]Pj.x8nDok-U-OfQz=V6@z]PHD:XYv}uk9}VL]:W>e:QF^Ko {IC=QFEi܄,b#հjvbiqC1%!.EՎ<ɃETng&wbwOXQ+UVj;[ ma?NGhG?'Bڥ^uN wFU!LzrKˑLA.r\xe{Z5[[)f3̌e*j-\:z?86{S>羭*!wK)L&j,lm|b1٨1z$IAzH 0oR(Y+BB*qW0Gl /y6Ēs@W+ L /tաRz EÔZt*xj-rr/#~ǂi ԴE3;TD;,%rw  7wj.^:(Ca)JH\L5En$Fsz_|aL-*k;( z4BJPTٍf@6E>hzހGcıP+PhRubZZ-*"xw荈o%A_PkʕN zҁ@y 9g׷|mgM`* EI\ǿ}5!Ab=` @+dhqF :ܺ?pM7Q.&-֙; Q ( E"rV,ңoț5+c;߮6mF EuhV5G4J rwUME[kPOMs幂pipzy cB3…ޔ)8өX+q_X~>a!z-ѦH<¥֬Uxq{D%h<bbJkA;٦U7[MOq`q1/ݑ.FTbѩA&5m l2iHx|\΋ ǞҤf7!;J B.:O1'/ A`OІ6{E/ժFl[M#Tr;o+s0" 7b);9u _ oFH,R$ ߁@Ern?bxl%wG< x lE|JXyYc%:) W|W*xTIRZY5YbB`>߮x=V_4 sKr).s{ɗz裹\7cHd l%Xw)3<1?괻PQ3sN-o[lΕW$4;>l~+I$Z=Avun:*l*Ut]uF7 RN#W=f+bqБ< XӀeryd:\vNg\\۷u"3~qkuW + ˁ;ہ׍Ѭ+l(TfGٰt}%oϡ{LL,sz{пdRQtۯكD# _InŖZ֝kU`)@m e4ct]K :zב[. ŋKFN-7nYc4MvL#7 f9Z65["w6FoD t3HSۥCo&"~x.w[|Z~^ _:I_y3E~͜~}w ؒv\bΗ8f%GnMdKvXřgvk&#S[fA]1乚̋_ekRT+M^$c"3;Y0?XƤ1`Ԫm@,ش5\)U?VҙURTҩ\K9 zX_o@РK%3?x_)[vyב>p:_ dfZKmU2YP }oGF~E*NgUk0W 8$,[- }q޸D;_?k{?^&l;vuQD7u\@7D[&oMjI&}ŏ;ehn)aXL2[HF3-LV˖ܐ7D[_pjyiixރڵyRv[]ڐY|}ڈ2q:IմZ>*,Ƀ[F!bO4d `Qdr8 lUkr>hD :*}{O\^εFh+)䢱h$ ף+˫+ 33(p^9|}iq:f\*™Jd)*oAНIUjhyvN1ߡJO_Ѩ6[rSRa_X!BwX xcѠ/h#QJ("PJtxh6O$tDS1&@)Ǩ>/ߡ{ "iE9]w'qo̡&iIi>7=t6@92YR{ Xja=;:#x. EB%htnzmk6cGP{[ѡCӷNf-*uZ{l.Stm#\rN9 a UHږO<=T4 YcМÄ:^u+@ZZ*gX*ӨPh4*H8M՚S)Tc暈ϒ'N$J?-™ Lh)VИOl6^+WI, ~:`GgHD&?4 gjcC\!ㇺzW@:NI-A,Pao45EC(mVpT /[TG{hB*W*ZhScM—o!Ie*rF2:|nHܮN8wRpWV L$\P_>3Pv!2Ŏ#njAb@0.IdLUQ׍e3gvR[̇o扗/iTzibȨgSkQQovKFV76АˇxxJBU[xWtl&mlljs ML4iFZ*$Z*llJ%GjC><=+  'N )׏]JmWed^tGУpa&fn ocod+\7Ⓒ $]i]$^6Bco W)EKyc"ؓ @+*̱it:ryy9txXLjfBr]'7{}3¯r$i[zlƹs'Lmk(!fªym)txdo2ݷ{}YͶ&ZjZ= V3}K(7—.]jԪ[QP䵜Q;R[:Yz!f1̧RMMX\ZW>n{8_F4;w-jbA%8g]5,vhMID]d4mnd3T|(׳h&\Dk̤5F9h.L'x$P hLfɔ7g:@/r.x)`hq Cj ^|.l%##l8sA&AQk|.Bد>ms„)*@[@3DS$EȆs`۔ L`*EU%L@5LN@?1|$b|@),H).l /G#=t޿/LRV-7kS1R5 %H-*Uأ+|ٗ&I2J)FͶJ"kPp 0Q!VHU]+7+ԫ !#BYR*kfѲs/b< uF#,z})]iX-HbTsJ!>uԡ5+xnK?6~J3*D,ZR*AP󧶖Wg]ryc~>YZwΟ8keҩD:lV) ro*8;Bf[2qcoޖ Ur \ݗ@7ds2bKۺhfߦPːq1,jH~Jt40Jxc= rfЛE5`5:vNG`P^LwoȗN/gs!-Wk7ϼxe@O}Խ}>Mp=t۱IĆUf)=2 FÃCB ZϦ IArb쎂!q2ً21\N'aPOdBs@*K$PftbzvXmD:yڵsW/nml_{o|ɳ KW{sg_]|f(h$'@X(x"RDXJjI*epǀNC7-JbQ X Ch5z<:bp"'H(E݈~1@@؜iQ*1D9p~bGO :,l$|"Ӊy6g~7GF g0 .PˋTXB0$u4=i͹F嶖mCx=na"+bЕ5fk7S32DE K_p]_,A1=eq@}lPi-S5޺kcwE7X͕wl+cc֩k45̳.=l1C]k .>hw֖QV}=,,oR^Sr1{rd;8͓fbgzo} W?SPuU٫̈ϧl2-VJnͮ'\o4IO( h 71_Fo2q$76 x, k7ɪhwOa뙚Ji-w,?mp*ЃjĢN~_~|Opr}jXV#Nd:B~ÑZˠ56<W5R.B<= f6bl(3*um+@)N4}#Lo |ߪeQ!'G =./F!o}˹r 0\k?vF~ d_}qq;N"U`SRkã5+\}82Dz0.Ӕ:[eNh `O2۬ɛ#NjaWb'#^;",fQ//\>WNp|iq9Ѷo.-4uӺ|v8t:uT35aԪ^!h0,i}͍UƦ:!eJn: 直'㡭W^3%{IpO~\ gxY)dݶ.2JoxF&:}Ջ:'/ ozz8L4.zynqVm!eD&:enRQp5fz5қpR>ۚD-z}=2j4hVr7K茎$6`I9'b Hˍht+Jen &{6u(2^ZXJev?mOB}}4nbvE&.d&SoҢ+1c<ʅ֢5*lJdmG/4d'Qʦ$]tvsAԉIx]>`Gj>@Zo8XA& .o|)Zࣷ?~AoКCDXm{{󮽻~a6'^YR>TSL 1K&j>kY]%SUmƮT8RH`V3FKs4iGAvk),P)@dn:U#%8 A] /I^wȨFiV+7>yZ|VG]Ie O6mq~÷q?hA:MэNRc 5*3 ^"N~čf`h//J8ݙ|._=v1R=gokkJf@Vח76_})T= kKsiKDZj*uڜ$&+C$34]U!ӴѡAN ߆"=1mny\Wryeb?2d2o3\r^d#JSvpM&@ljYdIe.AHk'1'Dᎃ/ԍj\l񇃛L)v9R]+KƞG>`*Z^ș-m}bWj\YGV4b1c[%3O/8+|pdVwu:+N]tz &(ZfkjF[MA?Z|8o( @qPhZ0Ydx:t!l.͛ &\}vk++154ŊuG'&O]r™>G>a녅ٓW.-/m8lX,zCOe}[qXt&EpШTDJ.FE@4IsmmM&o@oF|<-'qK`=J b9TX&ʕjMKA*^'ˀy]n]-o֝#q [{H1d:[)faI}p`B*{KiVxF 0f^[[DR!\r *jUXhfjEZ6^'r[VmԽ&KC:z P뀾 %)2v"0H *4ZeH]va}E!(!-;C7oo.6  o$!]v+fD4pg JrxsO=Ϟ~J9We(zmVlzEow0Tcj8LzmDĄMg{V0:ɬw#-pu:'SQuH":=3 *0r1hb6*PHNC.JbU'dˍ+O%bm5i{zFE]`hAJ2WVKW'>1H{9V6w NS/\JFB.\t9z>a' ~ZJxRh Z42̐q,LJ\*m2tZ'Rìj6g/ᷞzne}6X`.hfiubtY!ct8\oO#ۭVR?2[g^,U8*]g̮;U`nf1%ZjV ^ȥM"*GiNmkJL6mǸzùs_zU{꠽fYoQDQ5aOm+XՔu)'9/A ##(&$jX#,լ.MOpapK{Ñ/z\cێ#rBS?I42sF>}C}С[Q. =<+xGH o=. .o .]$\RIu7:# 5Y\62yeKWgO;Nxz&OPfq9mZ?vB٭8-fMF1=g)Y G(:Yi3|SY`ēэ9p+DܤXkVM]yߡ\y6dt^~2S@sf5W^< jMY6hK%R-:q n'k C^!U◿ߖ.MǓr1AG? y>ɑQ D̈lKسuD+Q䷍:Uܐw.MDCM9xEGHEX fBt87֟-\Ζ™V&.S M u={Rls+2l8420j*%Ozd̨j^;R[YT4jD讈6^buhhR]I$;0hvX)\O #xs%6Ct1Z1_j4"2atFbJJZo<< ?+XPP)䓅RDsK94B=&کVn rtTd&gt=p&|sR0_FZ(2RpZܒi9MymcQ_3|&f O}67gο&m gS|#9b@,& Z[PY|"l={>؇r:t(-QsX6#mڊ Te4)4>3f82:Ѓ# %s6>/r>_?K{1,eX6T^IX,ۏܿs屺B/{DP!_YG6 X׮^C 2IJI>d2>pJr=c01N 0:0"8sJyW]jݔG&1KVg fX_[_|}l"u))eÃՅfkJP2A6 tctjߡC]|WrYmS98of76n*}428M&q515҈F҅r%}Dkpvex R5`?:^>+;Xm^9}rl2Yt΀b_Ԗ.S,ukt *U(-WD΁Pa`8z gΟ~9 aU)YYéi,6;2[XUtU4:VV4s4٠RptM$C7_~ꭷ . Ͻ|gTD=nS{wqY-sr! lwSs2?I҅z[BǸ i).7kL#5~jF.=܀r;T!RϯMNbwQY7##mչ͍\KUO~rhdKKWp$$4b}}ks}VaO'oNZ-C>7frj?"c/UW'5u=ږܸRqMfMoUB៱!ĵnuQ^*dz $yr.ac~xt< 8қ Zh}:N˶ :J:T8s6ov25) o n81{x7z0$-/(C:8ʥSǿ~om,}G?|`tg]u) 72 ߼cFdTѩlJg˵SãjY ڔfj.z}Fഁ%ݸH8 ͤfu+_җ^ZV[F'ORJb0)24hٓ\bڥ +Rˍ+ٖ":תњj=+<&3JZIGjTIj(o*tj8}dDG~7>?+$G`ʡ&\O*f0D4(jhJ2[*lD2Gs;},)IDC肚V?C}}}@Y|.תD.Aeu+,4<N9O[Cb N 0e:£|5_6]bwMh"\PB,P)csaGNzj̗ڵ<+PAgf#"J[rruFAl{URZm^VH KB??A&a1A09_ܵvhVaΝC~rRD+(|اeVvkz![]{Lx-!@8Ctաx"3|R7R1JQD[)sͭ>;r>+t/h~Ǿk5>r-^<ͯEM}Y ڗw}Vu[xTb{x] N.Y^",d&''^y>EyMރBf A2P*a &FWiAo{-ʫdΞy(%ba:[d -A14sX3* h$\e]fH `m+c-An8S1|p7-ؠhEB&0ݤg?gL>{!q_;@tIFӀqہ:&#V#Xwt#S;GƄ8Vd"i'$uOD|RNZ2v\"HVľ6EJmF(l̠I㖭xd}k'g13f3s?gojK0ĤY*Vr˕,tVzio}ma!Wz`t$֮PXhB<,NuO"4Z{N?Z2w{Z 2YF5Lo*5 }>S>f~к΢0۠D;` ڬyc$%hӂ脲P29G\*W/^i"--honJrȤd'{G~<&t?O{P8 =̋s쾻V ' REBʚ x^9}v4z h=~{$2X<#)EYu#+d*I 8UZ~BT zR4UnlâȨoO|}wGGǢԶB3Q>pבOҭ&~d_kMKˁHB5XۊasxxHge9R{47>uVRm~f1B3:XF,??41&ރV!?FHy !,9`Fs3~+`|jX4b!.5 G0P:m,Kr$ .'Bl%ibg8]ĉC=_uԮ3h=wY,!zw|n8ygΓ1(`d_WgNcxiB}}Y+g Amnw.̴* 5p]*csR6z;j"Up/q61Rիj5p "c`xuyk*+r.KO%Rr͔Viǚ~m3ڑM8(!E^ճ]76L݅ö6aLZ$Lll{G5Far©kg ~~Q̽/U{@af`>c6S.0AoI"eCẓ;G'=P'K%JJfxtH:4퉻?ɟ˩O=ՙE@?gvuĦjyy1[y2E!89jI}ŽFw%k!ry/&r$,F/aڔF]UȲM!@]]~NJRP"byp z$5/>ŤF6;tzV XI58bVT}ߎGwخ3_O]\xdr0IO}wQ|4s"{*vfYgféQ@y!Wmu|91+&HRX"ovw2AU1۴B)8='VR,Xۄ4*jf<A+@ lD>HN_UdU `βJ,Rp,ZL֙Ek89%:A;9lyӏr8"ֽ.6Cmo݌ ?;3~2wù7/t8ntJ%al%U @崣6O}) vqdw//@+[|GwXkM2j:-F>xma"UZ5E.kG*| p[) >}}c\*$X8^[nGV+͕hpAz)6Sյ~DqQsЮC<Yp:j4 =%jK{fJٺgW?Z}GwZK E0!KSW7Gb5%v՗_<;>뿪W4>b:aXg)c5հfIt lN-5Dޞ: 1yXk Us)KD6T5\rmvLNڜ|XmsItN:>&ĩnlcC qyP\ٜ;F{V]O-@mǭ==&ELerr1?4:nsrHf.Jb`+7utiU" Cdc{ɾtv{phRz/]ު —dI~A_Ƈ[2Y"L t__0lYX>vcwܶLhב i͘{}~ l"NǟUwmn|pK/{{ wun1Sj”^9R&uLjOSxPoP;\ Z+fC>G>L*c&VoMs@pKyFg3h06*5=&CB~W_|pf $n1R|%w >F{{>\[8+nx .yŵͥ- };l#=r1eT `8{'lvǥ ujxg&Tu8m>Gg[s25Zf21(#Fڊـ-YZ&ʐ2 !d>o(Qo8ct(H4x]?ZGq/v#7m]6Ɏ)oNxnKKl?LLFo];9`SP ~W-1⁄"ӆTbk4Ky,ԉ(h !=F4;u3lykZw|lMd?Yc8Ue̩)b0YN$\s (1HϾtY2: c7874`X^x.`Ҽ=9 FS &obRcM~թji FK"1㴅|dZfqC Vbֆ``%XI72D1E9/уG374811GKհL*_ąfCB `UтNl N޻gӃAG*U @p ԺL~Ta#H}p}'Wz{3 CtV^s F 68FG}}Gnm zMK/JY"}2A!փ)wݱsrL.Gxym,CTy_c~~h \}m##== 6#]Lilkyw>aB;zV>>G}U`pՄy;bgSۑ5[ !h$07Hco2w}_XzViM*mXX+zwtt#m[HW.W!>V7r$xJ(5/rg7/m=rЧX@ϕdwq0s& _,5vNMzFʙ$"l lZ[mmVa}.c@)Bfd<uQF0/Jh[dK+&Fy{F#o/?siZ4U:A`S l]ܳbА΂Z`-ƶM \Sm+GYTF;`k( u.L^hvT0:7Oֿ#uy?N84*b@ ]+#Δ\ 9.B @'+t8@8X<잌gC|;%0 fsd4 6· 7cx\y{%yD͛TNvQ'dݲ&UL45J٭\]מrB]wވDb6j[9:o^8?M?>zuzJ,9C .q/Xo.@B|{Β`M b92zh]b hZ'cH,mtO>JR?*`Z(j/eR$*t2@U Ll3wTe#86[!*gD߷'pcʷGT@,5 M :[u۝8.m43E,n^}yFncooq^&؝;Fq18\z;02;dC`ܠlvb998sJs'[H?ؒ#^U ?x`=Sȟ1 }-;v4r?wjaq:'L++&R_4 ǒ"jI.*+c>NgBY 7Ri=;+W.=yTP8cTz0xz!YX n}vkˋ%*1 .< pby=)>q۫ T޸vE.Y`^`ۈB JWLڋAE`I7N7l6I W /{ܶy~׾~_<~EZb8ډ dT{Hb vCƬN zjKO]S r9nLj(GfdM ע^,yQDMsǥ1HOפ@"n᱉/NJXEȏ!\QGiG|p|ljo£7ih0嘤@(ƣ˙V).E2P*  PԀJ ~hH+9mo_<;w竔詔\MCfT -\Պ豐et\EO&@z8X7[R0 f0XMbdBo7!L\"0.,3 2QG~{%QftFqRXj#1Z&ƕg{#R4 $8P߹n8F1\OE#b2&@Uv+rRub2  gCi(w(`Tl6wR7gjn0l^_/y&_8>sѝjuQ1c$p*T cAE_`g9evyת*`p=G;n݋iRt /&#!r_6$HpҨvbIB׍(s5ΠE7 3BOdwd;P}Wb}؎~#6h@ج*U k^2<8|7;DFa*/-f4;fJkBQU `7 F{G~iT^g68jEyFfڬ+/R=[(|r%s, v?wǟ=҉}mq-U*3{Dc4s)՛v%rob'>h^qcgtoe#pƗ‹ГR$[Ƞ/ [:_6z1lͥfrY(W?p?j%+^Rtin2 5 "JVD%19z̽ob$Sh)7 pԌE h?{apuuՠQ>Ꮫ+@GXP;0;*dV”Y Pٙ#64bJK^&<B2 L3>:Ay=Vv8G4#Am|1͞"-RQ&*|Z*]m5?O2{_35yPt*[Ʊ"2‭o&Okj.`tKMHMH"iG_;;bwĺvؤ~neqgzS *WP5B@YKy==♧;z}!,Cv0S΢BSԲq66$jn-a_hÁVRJJuB'q FE  l&E=̬+>6DLNM{=t2hp8G|G?֭8bX-B כJiT-ɡ¼Cqd2o5g2 ȿ* ./%S4AM4m0zy('^۰_dԴWEATEx5&3۹kFj^^hȫ 1a!.%n[Ube)L6smfƸK_bhkE7gp*/Tp,Щngj.2S0`:^o #Y6VZR\KkJns,l-5F|6Q*f$H[[@]%##y_~I#}[.)`EۛؿtAxy0*:'&3=;={% 9^钥_?v=ΚfRNT,7 )" s*r>a}{r=;锐9^O˵Q؋\cgfRטm~ԩ?_,ZJ֒F< 74r\k:kQļy8ӈGvZC}6jf(b4l3X-26aA?f1rIYd88H ;T#ezѤ֧?xdGo R=Dr1ϫ Ũ^+|N쉤29y:^^[UhZDfX_O]:szeeя|xKX~y2Jmt7d-MIr~y{7@VDS$%i{e sGDcٙCay;vm{tgYSMر_oDY'+5،TNnO=@jr6ԩyV9zBKdDFTcbb*4PG2 r; zQp(<\t)@mN'5N&҅SOku?zO[m򑵐괅^-ln%rMxaMfu9/EvEolfP+d˯bX-^ qb'mjvC}`JDr5J>BPb &29ʅ'MXh}WE+l7Ex>'#'~!B⃓Fc鹗_zʅ3.rlv/Y]RPI鍊Gqh#C2P{0S(1"1~{޳#ӑP`g]ODy؆it/̐ZYBSl0&gŶ?#w'G9Y!_dX:\N=?~ep9rϨxX]^:ym5VE됿xt M _b]fF8?7W2z ::=cB CedabvvL7 gQ RPDN&22Z %/ؽ k4(ZsO.v=`i~H"- p?0y<0-?{vMV1w#$@ix7O*JE-I_UK }%[4AY#<2{||hr6ԗ/9~Bıdq찃зci3t}#@nMo;Tth߂sʆlיӖґ;őSer6=Im;w{inqL>_:1WC 2A '$0tB$Z\ 2h4(T[UZ4Gz-ZRՠLOz}Kzb׫+9ArZt+pa-h.|OJ2:<2m\f n2duf@ %tr;]EʥkzbZ+ijHbZØ=|t#=;]v[Tw0a ejt`&V177f$nf׷kn : b e`vg/ݽ{j**r4Db8h#{oM_똊7 .8 vfDW7oq=]_ZA6Z/wD6ggI7s_jkiCG{O904KL}ɵb [/$;{Ai2͉ UP`¥cTdEĭ2Q̗+:s}#&!r|2Oua NTҕ3c=r Connl`^ != U}=B;ֈ*1Ppㅗ<sg^znYtBV &g*tk\! ?$&Abddv"ArU  "cF,9.];)L,-/>}ɧ'ӯ~WOL zpv0) ` ֘CS:H"R9h7ka]E4Fœ:H`E=UzMbc'eIbbGnxՋJ*)b48dl5#J-rXW 8 b q8m>8D6]ř/% d$ BH*ߡL=>C t <1 -۲3,j6ޅVhұkBw;L"6fGQg LfffX, /3bB O(?4v#%K<$op۔(M4fC8z1dıRQ5H2 K83U\=u֣ ;8g5W/UK!3{Sس{-is֪嗎j,7|gƆGF+—^k)~DQH%|4ngP ˚_9yW9>x/EJ_w`O%y?'*C;wx B_2-f$ّ 砯kcѠ K.X =R^pKsltD 1+ ivZe<k[:k&$VxmeܵˉX4Lf `)پ;.^ݰp.V^<)t\./tN~* @nёdXYog>Nd+u;6]ۀ.hB…xZj<6sIgpA't,fP˜7m0I*N0\Xl}}3_EU,/)dBcuS5csHdEE BZZx+FwN}'1AWy|?ЃGzy{GvK>:F2Ht_Mb L()] GԌ>hgy/OnaD$X:#GqE"NSB1Xhsٍk>}gb{;`}.ɵ!ӃxL] E(A248ktg2Rff7M!!WY`i$~3sZ%fujzQ @Ġ_l!('fbqO!ZND7Սzxffyaqvy칕+Ph% jš'"ĭVӁhz~O?dODeC:$6`& &8^̣5:C[T@JӹT 1\kҬ{j[;r^knҔ*VtȬ;!7XZLIRI2sj:^}5ؐ:*bU3W(:Y hĶHRL#A<̙ Ҡ Rxѡ{NW/uwǜ^V?khTR/m0JqE<|-^;JT1ӂeEbR/}>hdVVep6P?ҩj>/[Bj}+8=5?օ=x6'+#Aau*(xWGC'^zY 9;R7Zk|]RxmV=1gFZk=^ypćX׵M.<% nTxyA@Xy\\ي&FNm2;."V̋/]?ytS"y:*w "A& Nk¥fOL W5ցFj۶A" ,fE2L,&It'*0D_kW+r\2P J)CRz$d@>*]vWDNxvs[Z0iӛ`9ߒD"Wאq3̾r<>-H~#:9ۊR bڏ=LfÎ{=LK ܳ7W+CaD|n 8t-n-dz"EcD ̄-+H 7LU֣əVa#֞A :r*qS -1k^$ ΘfDW]af*DAmq'3Y'^ X.iz`h^\z9Q.32}WϿev`1RBdb2??L~kwAhc؉P,];lW{|kWف*(-yءW)O<3OA'-8A[`D͎o ' 820z{}5&5{;Fjqr"],%=YXᑐoG}^! #ϯťlumxxȳ 7}e9*^d{@l15j`$ 2.ZDMN[ _+jWՍG{ԸS؊D{'kﲸ{]xQ"Syh81kBlJ/Q(MN:&fՑpNpaڑ`ޱǎݮ\53kY%:):-(cvy-8<}%J̄4E/ ͪJ1vAf qua _?Ӿ'o ׅNӑ{08ikg~%&KO_ܨl!sO\:RKe9ԻyDr:L&r>Ͼ}cO/ {kЧvt  3PРm`S@YHr{ofI++Pj{[6kHtÕd2%%bf~FkR&.B6Ȍ%0e"XP29:g^+*0kk3`aeWJPW96~K_dfJo^trPh1̖]iL4Д /^8‹a8^cf^lmjh2_9e +0*F:@5wI9}7T):΀'1YRRsuH#U,8Q0b|%JF2MÊ`N1Sc6@K90"Hɝ3= oEn?](r+:80[.nj!2BbhSZ7roB؊lS]&CҜeK0 -̬mD+81K d|P6x4@Nju`$GU6KW"PϿGBAA! ӯOJ͕̃{/O ?֤:-{`6[= @/\txs]wN:&-dj%0FJIn Z6/Ҽ[XD3wxP=MzFIwON뮣۴\Y#G$ gSBh@A4~!G#0j@jZυ: Yq!Dr@x<ښNd0%87/fm"68Ni]z3#/Ғk81G}~œo! _Z賘Ωn5H{*kWH$(rWrHB w mPt1$㧧.MJU4Ҽjȭ7/ʥKaEwĥ^.W)$Ki0TCY?qq|N v{Ft0fgF]%\{H,r#ͺ(F#\H9P %rnlly6\3Px4mpFu؍b>$Wα#=Q;¹LYLz`U=kKw7;E(6NSy|sE{楷o8Z_?r+wl۳PWXx .zXmxQ^# P'\_V*~ b+i*އ2`(|;R1撴.mjtw|nj k_da,HD}^3J -9dgEAFd")/ߚ"bJck vXg iNL:@ܞH'uŷο3c@}屧n]<*a<^ƨ\z9dsA q2z M勾fK%n3>>OT#M6DrKp:iWn\3 8.<dJ$3g~Ãב`5pA).@"bB]nv,ezI/;FVVϥSɡh睱ɕyͼ'Ϝf.M(F72}aEו  劥m{FO1xfhM ɦ~Nh&F,0tY\cI%k@e,5:H*:HD\|7DLhv[\&WZ Lwle~`8FRɷz9]sӵ(/]nO@JQǥtyTk7F7 #2Ή+_k-Ħ虓-!5-wX)l7޸X-̉n*>.TT'NPGr;x\h}.U8+/ʬĢbc]٨2:sau@{{y42r+n|s%#m8-K eHvm-֏D`Ӄ:Qu#);}szֲQ Jek5XhJ &:gvvo u 5MLdݐh.)f4]OD(7r; (d'P.Sh'1EbiQ6kܟ{Z.J-_߸vmS??=ٱ aW+$MC ;(Ө.$`6Np;}v+]1g2mӅ\}rucBbkV$|vvnf` H۬,ߝW~ZiK5 QjpMRƍ3G慚rW'ܻTZZR%/vWJ"Ԇ*BH,n0^Ln]~eޮc]^ &;[eG "FifJPKNl%J`0Q'Rd. 67`GR~y%F`ߎ?#y5XMdy 2J-% Ԥ9sgN^Fa\݂\*Հ6iJW.N;~WIHp#xJ/AG{`7~w:H!9'f ] L1ЎؑX[";![ڵcfF;<7 @E$BYߙe_u$$8,/޽g$ ӌ=G=30rsҥwMLW6+6>>uw hGHH'v?(9mB r%Z3׈Қ%v+72SKvwu[*%N#<_b 2E])U49}HɝJ .,Er53ssT[MK M`;@ `$u2`{;Ck`W_ωPY\=sc'wcp~0Ө6@S" vN -:jmfS$0._4(9YϥmJMr`XQ^-o\,y8̈ZpTU`!HB8ED!jsJRi*@UgG |4طOk8/rf4A?h^fy{Wq1j.7=6YԠi+;2xbtQ6T:=3TB΍sӦݏXwlIgT̷.o0B 8:qtt]P38vFAQgۉpg[\R2Аe+n$íW\dLbsYeu((_ ؃oC=hؽ[`ofje-tON֊5#(ɱۢ ] 6?gD $wBBˌ φ+VV錔@Gί\pos0D_2:;3!`/N3ZtNउn w)'|{!_&U=ȱ[HG+5q%0}A+6^±K"~©}Os* 7y tE$ H_V+Q2a.KM4gtqv=y?d3҄"FHܼz ɓbSnB`y^ӑ_hZ,6?k{$"0^{Un 4AII(RVj"c io5}O<`xp/UtrMdEi(d[ p2gz=mAQHHBrtA+\.#rm$鐕6! 2j$2bhiVժ|)udz dkm2 /'bhW\zݹZ*dnf]JSў񠶦1[=Qhd"_jVVӲC7a(a腃{Dzw $9um[># G{i< MbqLIQLlr:7>4(VLDl=Ail<33 _Ÿe\NG6 j-Jxsiyzel1=?2d !J\h x2)9 G;s=J(m 8;wzlN t>f*D2-&dס%əpf41`@Z9]@.(T` T 0D#I2g`/jZH;FzzW4 ڧ6E91e3r/6a'sj:{-lan[^`M`r/bL"@0WMÒ*fvq- BHjy*"oUg cv@Z+\aFD t\%!쫿+סUNA5M?B[ ؎Db‹_ǯ|뗦WA_GJz'Εˉ4Zk{pt$ F ^;X>*<N dQh'NmLWmť2-]Wg$p[޸qߢ1 &J=]pԍn\~-=EHtWL5VIfʴI$\V"2mUe7rɊ|\G( %t3\M#L F,X &8 R);m?rQ.^3~1e$Hrk??p͛_D0Vt'g>'~wjpW/DAqdWM7b/S+خ:"^pШ _V,Y8&K!'`7سs'=v7o^~;ʥ<́@>)H"zXR2RC>o3UWHҀ Lnq$V:<ȄJ7f&qZf[֠ j Mu`hxutc8݁#}'Wj͛޹Dĩ ЋKwgs(GE"&m {5|qyICOFn7$3D!U]F]իn:`=::{&EXY[-mvu;!ӵ"n27Ye'gN2\CEg=toI1 8h!PYlgˬ- + |HvY 1'/$鴍5MpWՅIc,rX4uYUЛպ05#g j(m[ N+z*8cjogA5:SzphQHcA ʱpXHi]Mf}ZˑyDG\B_"ga?Qou?\'ηMq&;%V N"[!0(T-؀x*?ʟ;=7bDyhna19[1Fs^ f39{^ 22nR1nW%0ߑ1aX+Eh182rfa gÑv" !kkxn+Bp<5Zb,=\M,f5rru6'\ e dxϝ;NwKgr˫ Zͨ|] r'IS5d5m3Z^‹o)"=C5&\eIr|6K\<b(I TTzkt`(K_Hf1HΡҐs44ٺ]ݝ.,,AD:8IT@hPQ ]˥2@<;nYyJ ݘf:yzի葅;N(cvw=h3 ְ D|F N* ܡ 2GikKy=WA}II} rj=W( $i2c7A{6W޸H`cɢIm6J2v{ĝx Fɤ1u9ѡoB9Ŏ#-Dy7 R2> .Z"_%9p@gt.7 ' ZK}[RICn_h=S}^g{wTQwd@ZR_,صϋ"GcE?H,SnL?3;ivQ).HU1SAc\?v8855ɸDj|Ϯ <}4b6 v9]t9j"Q!ҩr|i11Lgyy=kނBj u԰KG{\JOrx.ml;}A3n'h}c z}#!ۓ"lM HR.bӇ*rIѿ6  2& ިzX߼tj 2\b=P)7&ŜFu+4 T&YJ%&#n_koᣒ1b~?>e51Rd>wщA_y+> s%RxmסX(Z[]GQ. [> 6`<)8"nB XllhV 0_ZC\+׮DCE0Pl2:i3FIoփnHW~APؤw4y0[PBAeJgRboDH[  ٱyŅfSDkX"p$_*zp-?u,y+oʅ6>f--cci s\ SI;r{OD( N߇*--Pi`M8ׅ\&l}bnV[!P#Z@A-FmaaNָkfOM{ҠI*SHn:f{ef`*odi6͙s 04T7fo\785;BKߠ~4d'RZ>2LB4Ӽcl26Zm] OW̳u:$C쪐X @~g<шg= G{_e[l,. ~B1Qݺq\\6Lq ܉UBRC6^8aq4{P! 6N 溶Z ;RslD!BD1np׫UNexj?82 նx*!F+o ٻ]YXs LU>y;]N4cزV s <],^/d V*R2F+qR:<93Is lK-_FbWoog.=E|S&ԋYJ[SXekz~7bvplV  +Ձ52 R5 MDB&SO(-]F&JMRHWEM~P zCO^!Vt`ڟ+*L#f>iS7/~ cn\I![eZ!2Edz}1tz;e7BaN4\a|RqG,(픹3HxƵ<-]>v<&aKDZ\N Y-eѧko x"^Β7] 4Յ:|tW;cd}:ˍ}GN>> ~xgz}? SO~>˟yC< o׀a0Zsu =qSG?=8}~O2gܠ{ERAP|"ݠ: 'Z^ d,5#,( fi:?E."< ./u87n6FItpcd$B^we7dd%%"9rwT:~giiBCXkJf QqJ7u,cHeQ+5ӵ{'>|;!Ewts3:ssj#G^͵ɑ ;⛶#7*B+jWW^[WtwZg9ip0}N`PVa>qyjb.̖ J6IsB&&1MoCˤ+ifdx{Tmڒ5閭F QS-3ș>^<~rq@mR pp٦MfƬ W妑I!BJ6t멻w q9cv^89s):8ZٱtIGqci-YCGف B'Oxn/>bs _jbw:+<7˥dy#AR!\E,WypJ.; ZeeYt(CpENġaYTQ5C@µw]h-k=}xʹ* | ?iT d -cڵw='gGX%68ݤ=xraf73ef^~2VfummPЎlwk2Qf8hCFX)r 4=#GzMH'V.z3['_*\r+"gT>sԩc>%7- 4" t{PGgpSٿv#hg lM梵~s\K[ZR8I@K{Fd)"Յ4Yay.)i]HumQ,isZBSڕMTtP c|-QD@ɑ,o- >y1Nz{ycg?SO>vN|(p7Jd^o޸IgpASC~n"%qW[*<ʋ7/]KUsFN=BN.(YN[!Xjʭܪk8vh߀enN]QA3#v^<8GPN$2+oLڮ{+|rMhh# s@U w줺x 1Mؽ6 4.AvjpE1"V_)vPq F$bhz /B Y"(,kdQʯ<.K!p0!G*hnA"QC+JY9_Lk)oU}"]1@ !@3I+7H@i!0c|˰rzt}M{ Gvu5z=;v PZMN<} R"6G n4PܾyCB7㬬.dyŬ)Sa.*%x$L~2FJ w|nZZl a#=;@ t> Ja0'1Np:K6 D"]K2S'_x^1f:yg>S(xg|znB {O6lcl:~(L_6'fY}=Rd2O@9CɵMo ]f\"@DKwR mhm&XDHAs)gV._\Atba˞`1[qkxb1`8u#O==8# ey6+YuF|jY}H>t8//>{f``tBT:eea#J_Ͻ \u{.ᝄ}ޠ鑣~a-fUFfÇMY]K_r\>Jr°m&薳Sho l˞x/2ҽ@ m\;yr`[h.1$;;=~î={L3v}}Ǒ.#,{Ge \衙Ǿd҆L3lVk!Pod 1[E7Y/dO3|v>5.zj"BuǞL$]. 0b!fq'݆,'.޸}5SHhl%$l&Sg _cL#طMnry5\Z(ᾙԺ zhR6p􏞲 s|BWCw)M (AiE ]OgEAa ")U{aEA*ސHRWP؄LG䋔j2WGʼӄۋu-X[ h7\ %G87& -S˙\K n6sz!__Rܰs_xW9C:)fS~5=~#vsrɾu#Ȋ,_xL&h}6wJ~XX&?'MvOHjSΠ/>bu],lZd~ q!z *oeNcKbD LWki}/(G\DfEҭtm c4m@.٩s3(ʄd6$j#WB*61 p_7D5,%yDmM.@ATi7arip[f(h"q#:L]]{sչU]u^3гl حس\xϐ`qY١ EHzEdک^gcz G GeC):=q* ؃ X}P8=?W%@s)┪?R,$bSc[꽽.׀ {Ͷٱ[tra?LOa8b_D;Zɵ˷J5_}W?.lADTx'o&|;OyMmmB(1^ipBsSݖmrҭ|>fc_;C%l0_( g@5UDe)@Ĵ^bIE\1eZA0֟AMK d*W XMX&XAPKZS;.s7AK_MY+@X 1xZ֔ |(!FUx"r:J%"ΤGWoأ|F}o{vv |TT}i>o/]'yjRJ%D)~7vB gŲ^*>x YNFeufISURpĩ mӅd*6_ܢ",@sϿZ+.dn(:)H@w` O ok V.W&7d,ܘrA<$>[ǯ]WVg[qer h5ysjE)[̯DT-latFߎn)|ҪP JR̄wEH}ݟ{W^N^TS㫲T9BZj+$%PQ݁[ϼ=usnnR'Q2U$O׽,: ش_@rDUu5\ͻF I23HmO~E6Jʎ!HB|.AK/jVb"Y#]"R6k1=qwhPr|lzms󦋊y<6,^w(Foo pcl>H\R)B(zxAK_o : /;ɬM$[xLZKT,#)@Sy|,Up^AUh6RzV:{j-E7#."a(OWV$z3~4L~I */^Hzq߫b^.3|;׮8z o[$pȇh#G|ZQWke4ȅ*GVJ!x}7`tDX6>{_̱fs#qvppow@Ϟ:'?(PYK.Rtbj%k 7G"LV*lBii.}dsGBUfRD*S(8tZUAWcfKo]^ԶO}Y+;%f5PTՊFIčԮʃ[]RT\4G1r'oݮ@ڒb_]X uc~fb/~w_}yGw>+>ݯ_yܡ{ GC!oL@"wIzz L;w՛̰NHQ s:`tpN12Ubju{}S$sR_Új \$ nBD׮O֕7zfuOg+[7_^D'^e:=h.ml%^u_}PM߯Uk9$bgu>AS6Z37?ب1ZM.a ogĞ,`0Ƚ*N Qj<@5jQ}cVa!O7<ؽ|@Yzr6%{Ǩ{Ks503fΠ=M˫_ W'm#LdbMk+Skq5zis+2P ]GJJ 4^&IԊ6zAݹz5!k@m|(mq.3DQƊ+ꉌQHqX9 {AVm&+nlqa5ň"-a]A;H?:0.` B{C+h~ jbZ>+jX~DL/qwe0߫+3;(#'tq tnnn`?F_1c3!H4P;{cd3/|^yY̎C7ga6,HLA}.S20* xd:qrp7Kk#W5hQYK7wWy}0ݵgh{b0?T]&n.R uxev `HA5k'*WE-u7vXAMh&FK/8+d}ȡ=_kk1dۥ~Ëz.ohVV{}v؉uc呎bdvqs<v*RUR; zKg ~S9?Z3֡^Њw`'w,k,:zΌZNtwN},1^jŖF ރڟ?X8׃I J8T}3VB9ǚjEu8WϸĦkL|K}@ms|շnN46l@;ޚ^"ů=|z_zW3W-l܇0j3y\ȚIesh4\ܮ$$T0Sjry jՖP(uw/ro~Ubr€݂R0Z旖fB3]C}m;ׯ.X` k]~s7^;ʮ>0R\ad8[3w _gV}?t`o&̙JLMgxvDۻև} Rx/.MD/nIʕK@W8ё=&Bi%pGf4oo,7jFit1dn:\rh^RąmF==_'~ H&kB] xLD/og{B$B< D{Mpˋӗn^J5!in$/]fA`hܷ&CH{.(s)T%mP+%W=϶na[o]k;y q_]{[y-`BcKgK/?`z4r3EAB}}^Lkǁc{2k{;q eK8aߏJ`I1Ǒ\ٜ,qutA"@oCdbXO" *1hRx`DŽOpo F%Z e6뵵oVh@R |1(y/PBh)<*JEHAB_4PL@p‡.l]%ٖ#E:1 F}id#rʪ!/insmE{- ٣'SJ[^EI%2*|P  $Ec*-t!3rGȱ(et'4S.)M0,&7jz%"p!Ӌ^Ws+;`v80}lEP>`fe0k,"?$&@6zCA =ݽ; DGyBٶ+5A{we^.|̓MjarHꑘ܌2Ws#冮%dt+xi|Ngh)Y_SQj~ sE9LFO.W D;zn.pFۮR)N,Vfi;] dL<k5-]x#04?D˓NwApR"28AA+0״5#n,$Pg1ZJׂ[z fl)f %6#οyWJ ЛB2O V0?/{U>u! =@޽" ]WAAJ+W\)ŹD;~i(!=F' ETZa˶SC9:{Gy[| Gy?0q ilejp>| A'9$EQ#EJ |-M(y{{:@ю ]f8ͮ1y:(!9]~p~ 6(f[OnWJR<@m]2fjnܴBhT,aAY賬c19VQT=S{m#NL1_]|69n zSjfPR?8տZj* OP-y^Ru_إuIURH*"~ixʬhk~'C$&ajWrFtQ{a^I<"xQɮ$T}K 0(IDAT-Y g LB?s{*2+IHNUuG| 9T/5QjU>Oߞ=^h67t|5BM??7`UM4V*7gD|-pX"*M#z_zGDWo--J7n^?:+W- $6 ɵRdUNv+Ss,R)l4}nF%?5=șCm4w twt3Z1+[YZs? VPVq<[!DQl1tDCⷜԜ ;Ǽ q/#*R?-zoǀw ()/uȭoP$+!~zD1F2#Ri#?(T[w >BHk&?$(t#.W[- [1N%BK5?Z?En|}~)oC<D3hE']-V%Ց8XN7꙳sVY(dQpԞ5#X+ 2ꕮ˥Ȗj[.0&C CWnWMfNDeK&~<(>z>Cľ}V[&ecbmv5%Q+'\![^\g'\^C{snn B/a\Z-h"A_gxlB՜6]0 x'Cqi iJ`Q,A%gYKU(Bkm)$ U=~/JN %xS])nJ t3RJ]U'VX ̟jhUCL*~fu?:3\ygiq%`*dѮo˭jX#"qh#c U]5y!/ZkJ}^pN'0%39h݅$}FřJ'qhY)ťP>)Wa KRTT~_ lʙyn(߾3' #VhAy$z?=Asx1i :KJ& բ?5$տaD Bhz%+=rF gH*"_*@B̳cCa}(I|t(PDu:7"1v@g1.;WoCrp/yfJjPS {`ĽEN1C>8aUrQHA*^:v`?`^)b\Yx,>`GQ)OMOndzwt=qZfwuECJg Th>1X*LgdL&cjyzK ڣA_gE4bf-t[Fx. U"l#Qz(nTe[t؅Qd%#Xr9lH@Htޝhyӕ҂F3(lފ[ێXUW_gE|FowY`ACC {)S߭:GBl#rWKDnY!{160Y~t&[̮Hׁ:{k ty.s<2nxho챹-WS{Г# F'/޿I6}uhlJ.M ]>2x_.M|N~а]|%3=q}@5(r*$(|Z(1搄DmrI+B CSRoF{TKWC1@ {ʦ |/PD7/YJE2 tI6xd'gV3G^]Xe|-Uhv8~Pw7mlӤ%B`2@elC7Gu{[QhU+9d) 2|qފDFH2 V)WX]rM:ԵV~~KcaF:;X26uX6jJcg1].-j{ 4[)1 Чμo)s\(⹋ of3iSr{;Ks++ 6.{ M/BAJۋ3 w|3>j!W_*eݼkx5;Ɗ*#> ε8E~ օNְ+|UmrҕW@k5<.wmz]86FcSwdY=vOܸ|vۿz{ (W\8 p=i \ClѱFY0W r5Ap8`]U\>U<"X22*wnhM, +h o .[ۋ40ljZ}lJMEhn]iG4rUͬ%"vg{ aN$d| i L"t f6aαg^xV{IfUbf(X*~Csb Q3c'PǼd|QoxWW\/֊p-6ʆɜHh?ƲQR<~乏1^w WEص\ok2!tT8LP؈e~֍n7D3J VVǞ>dG0X_Z]|3"IPh[n[;mj0nϞ>|QP@4b2XW?'];u/]Xr ehʥQ:Q՚ԭ+7ֻ}փK ow'xk ]'Np6EշZ8 _l6"#8Sd` [wng_8zяmıjU#oՖA[IPQ)Aŕt L1s{zBd6v= מ.O[267 G\6}Yppi-fgq 6`!TDZ +\*&Ƈ_sho $V<*T(lw􎠊9s-bz4kioB2(ҥlր Lm𻭝]+D[K1\.:Ə=йO/oS)R5-XSoFө7cSSF- ll[[9j[uPى4f5K.ukn@gl.Z[ZsRy |' 3[E]$CTe-Y?Nά^V륍|.ogS|2ͭnvPFƫݹ67?5?zj$]%ԅ`ElqWn5VPFF1ǵRF͢GM@F RF帔WF~<]Lkܯ񶙊㥨R٢ځmjQje+IH@gCkak^Yhm,Eu˥JtXtF{CA{*x D{#]7J'ؾ=NOCR6[#LBɊY@BQfr^aSo+xlzϚ;Q'(N7Z%|1-z0i"F..Ϣ.+L|젡)W&,-qXY_Y5ht듏?xǫ酙䒧$#71lӻ?p5ޞj$=p{8-eKE$oZ:|tdL,Į^7oNGdxY#H[-XgioY|n: 3tX 9zLLK_f+ܾ~9_HCfrO=P C؝ $ fKkP `g2xuA]B0 AIaX;pS@\?_Gn6~f;ۂXR"߁qS ؚnUİderW(WB ,oo1Ւ<%1cNwvmY+;G_{`mz,"dBB2V%WQQg+ӰN\b;3zv&Pnƞʗ0#BE'7_,3Nthy09$1t֟{'>N4775u낦Eu=^{j!/<=s:n&S_j^|qFICIO9owvLvӘ[FRS4znGL,2Ӻ 5b*Z_ NLv̒(~_^.̍ӰLH惱O?=ZbsKwg8tbeEq}XUXUx [l~%; aAAV` KTaw!H(je zj(nry{QP)qGR^s׿?A}"B^ijtV@+ʊhQ aUy*f+o#n=n JsRh,覸ږf.b2PE 6b*/zf|F;UյY|SS$2 {w"_%yfhP벥' |pjia2dIuK4Q2_v:ˆ"+f<h?ҵj `x=@vD8Hʢ[ z!z+~!^eШԨU%xVGH ~.\2|7hVcw֖tSpO^ћ=6 jN Vnt X\^]XINoVi<.qe~] oP\Nñ2#3Ʋ~/yH[k3j]v_ZP6|. jB> jTު/-Eb8ՕCRHJ>U`Kl>a})[mv<[IyN 2}/'W !_aYA,z0^JHDt^ͪ@ pkMos,#)Ō\(9t<޷6#ob{W`{~+A BH D[i+oS{Q jlsX Q6\Y[EJ#kdo7^ 5])&kuNX0i|%^k)j=L֑EhsmEiv9e՚R -aH`b](8B@9M ,jy>PvqQ T%~(ZO8HQ'͆f{P5iyW޿WJv O ndzFK4׵,JC4b$H\[kjc?$JWy{*,>o^^j%mWy)ྙE©۠܃\"S*DzǦu2G[c%&؁F&z6k65=d ywݬ֥k 6qʀrOKnl4YAc ɖr*9aB;*;ZNrΥRH [®jd޵Ӛ۟͞޿JEdX \UL?8 (+?Kвsh/ ](*LiJ ^W#Sܐۯ+? RTN+ 9yz-PvUj`QxH֒AHV`xfhgҼfy-{M~'' [[W|#lQ` JS&$BCF@1o0cF*.=.okv/5=Za?}W`{W+poNE3˗jH}c\ɶ H.byWak~Zo ++3lZpKlڳu{W`{^ HO# ?~^^(t.Qa{W`{W`{~خ5~^^ l7g~^^{w`C-V^^^Nm~/^^^po˰lo^^i\?"9,IENDB`S AA@A@   MHidden Data KeyHidden Data Value:******** PLEASE DO NOT CHANGE ANY OF THESE VALUES ********User IdData Id Is First OpenDevelopment ModeSpreadsheetOne - Hidden DataXMLClass Spreadsheet Help)Check Rows to Delete on Upload SubmissionFALSENewPerfDeliveryDetail| Exbos.Applications.NHSRBVP.Components.BusinessObjects.NewPerfDeliveryDetail, Exbos.Applications.NHSRBVP.Components.BusinessObjects, Version=1.0.10.0, Culture=neutral, PublicKeyToken=null CTP Submission Platform Q2 17-18 PD 01/10/2016 30/09/2017Id Int32 None None true false false 1 Id Id false -1 None -1 true true true -1 false false false Value blank%X_@#TrustId Int32 None None false false false 2 TrustId TrustId false -1 None -1 true true false 1123 false false false SubmissionId Int32 None None false false false 3 SubmissionId SubmissionId false -1 None -1 true true false 6391 false false false MetaSubmissionId Int32 None None false false false 4 MetaSubmissionId MetaSubmissionId false -1 None -1 true true false 50 false false false *Research Ethics Committee Reference Number String None NotEmpty true false false 5 ReferenceNumber Research Ethics Committee Reference Number false -1 None -1 true true false false false false -Integrated Research Application System Number String None NotEmpty true false false 6 IntegratedResearchNumber Integrated Research Application System Number false -1 None 20 true true false false false false Name of Trial String None NotEmpty true false false 7 TrialName Name of Trial true -1 None 2000 true true false false false?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrstuvwxyz{|}~ eCustomWarningValidator> false !Target Number Of Patients Agreed?_ Int32 None None true false false 8 TargetTypeAgreedId Target Number Of Patients Agreed? false 2500 Type -1 2501 Not Available / Not Agreed 2502 Number Agreed 2503 Range Agreed true true false -1 false false false Not Available / Not Agreed Number Agreed Range AgreedIMinimum Number Of Patients Agreed (Enter Same In Both If Only One Number) Int32 None Integer true true false 9 MinimumTargetValue Minimum Number Of Patients Agreed (Enter Same In Both If Only One Number) false -1 None -1 true true false -99999911 true false false IMaximum Number Of Patients Agreed (Enter Same In Both If Only One Number) Int32 None Integer true true false 10 MaximumTargetValue Maximum Number Of Patients Agreed (Enter Same In Both If Only One Number) false -1 None -1 true true false -99999911 true false false 'Target Date To Recruit Patients Agreed? Int32 None None true false false 11 TargetDateAgreedTypeId Target Date To Recruit Patients Agreed? false 2600 Type -1 2601 Not Available / Not Agreed 2602 Date Agreed true true false -1 false false false Date Agreed0Date Agreed to recruit target number of patients DateTime None Date true true false 12 TargetDate Date Agreed to recruit target number of patients false -1 None -1 true true false 1753-01-01T12:00:00 true false false <Total Number Of Patients Recruited At The Agreed Target Date Int32 None Integer true true false 13 TotalPatientsRecruited Total Number Of Patients Recruited At The Agreed Target Date false -1 None -1 true true false -99999911 true false false )Date That The Trial Closed To Recruitment DateTime None Date true false false 14 RecruitmentClosedDate Date That The Trial Closed To Recruitment false -1 None -1 true true false 1753-01-01T12:00:00 false false false ,Total Number Of Study Participants Recruited Int32 None Integer true false false 15 NumberParticipantsRecruited Total Number Of Study Participants Recruited false -1 None -1 true true false -99999911 true false false Reason For Closure Of Triala Int32 None None true false false 16 ClosureReasonTypeId Reason For Closure Of Trial false 2700 Type -1 2701 Recruitment Finished 2702 Withdrawn By Sponsor 2703 Withdrawn By Host true true false -1 false false false Recruitment FinishedWithdrawn By SponsorWithdrawn By HostComments String None None true false false 17 Comments Comments false -1 None 500 true true false false false false AddedByUserIdUnknownAmendedByUserId? Int32 None None false false false 19 AmendedByUserId AmendedByUserId false -1 Site -1 416 Unknown true true false -1 false false false DateAdded DateAmended 14/EM/1267<4737 CARD PARADIGM LCZ696 in patients from Paradigm HF study 15/LO/1952CARD 5213 ORIONHStudy closed early due to study wide recruitment target having been metErrors 17/LO/0212ORION-3 Int32 None None false false false 18 AddedByUserId AddedByUserId false -1 Site -1 211 Unknown 416 Unknown true true false -1 false false false  DateTime None None false false false 20 DateAdded DateAdded false -1 None -1 true true false 2017-10-25T16:53:19.9828849+01:00 false false false  DateTime None None false false false 21 DateAmended DateAmended false -1 None -1 true true false 2017-10-25T16:53:19.9828849+01:00 false false false R #J tw FI Y82ccB~-z4nA_)k:~yw g2 8+z#'+/L1  dMbP?_*+%,&ffffff?'ffffff?(?)?MPRINTER2\PRINTER 4dhh EPSON BX610FW Series@@Open cfg file 4  hhL hh q**** q****d2" d333333?333333?&<3c!U} $ a} d} md} md}  C} C} AC} $C} C} C} C} C} C} C} C} mC} IC} f} If} f} j} md} Id} C} $ C+?\?\?\?\?\?\?\?\` XU XW XW X@ X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@ ]]] ]]] ]]]^ ]]] ]]] ]]] ]]] ]]] _ _ _ _ _ _ _ _! _&  _(  _*  _-  _/  _1 _3 _5 _: _< _> _@ _A_ _G `  a@"@b@b@bI@ TB~ X@UA XC X$ X@X@ X, Y@X@Y@X@ X7 T b= b= g @h @ kkV a"@c@c@cI@ WD~ ZHA ZE Z$ Z@Z@ Z, [@Z@[@Z@ Z7 WF e= e= e @i @ ccV a$@c@c@cI@ WH~ Z A ZI Z$ Z@Z@ Z, [@Z@[`@Z@ Z7 e= e= e @i @ ccV Q QQQQQQQQQQQQQQQQQQQDlL  X@!X@"X@#X@$X@%X@&X@'X@(X@)X@*X@+X@,X@-X@.X@/X@0X@1X@2X@3X@4X@5X@6X@7X@8X@9X@:X@;X@<X@=X@>X@?X@ Q!Q"Q#Q$Q%Q&Q'Q(Q)Q*Q+Q,Q-Q.Q/Q0Q1Q2Q3Q4Q5Q6Q7Q8Q9Q:Q;Q<Q=Q>Q?QDl @X@AX@BX@CX@DX@EX@FX@GX@HX@IX@JX@KX@LX@MX@NX@OX@PX@QX@RX@SX@TX@UX@VX@WX@XX@YX@ZX@[X@\X@]X@^X@_X@@QAQBQCQDQEQFQGQHQIQJQKQLQMQNQOQPQQQRQSQTQUQVQWQXQYQZQ[Q\Q]Q^Q_QDl `X@aX@bX@cX@dX@eX@fX@gX@hX@iX@jX@kX@lX@mX@nX@oX@pX@qX@rX@sX@tX@uX@vX@wX@xX@yX@zX@{X@|X@}X@~X@X@`QaQbQcQdQeQfQgQhQiQjQkQlQmQnQoQpQqQrQsQtQuQvQwQxQyQzQ{Q|Q}Q~QQDl X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQDl X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQDl X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQDl X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQDl X@X@X@X@X@X@X@X@X@ X@ X@ X@ X@ X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@X@QQQQQQQQQ Q Q Q Q QQQQQQQQQQQQQQQQQQQDl  X@!X@"X@#X@$X@%X@&X@'X@(X@)X@*X@ Q!Q"Q#Q$Q%Q&Q'Q(Q)Q*QJ /l(    NP X?H]4@ *5O[xaJ <System generated field<  N X?\ ]4@ ,H*͵qXK <Drop down options. Please indicate whether the trial has a fixed target (Number Agreed), range target (Range Agreed) or no target agreed or available (Not Available /Not Agreed)<   N X? X qz]4@ 2#Jtƃ =<>Drop down options. Indicate if a target date has been agreed.<=   N X? X l]4@ g8iXK,S= _<`Format dd/mm/yyyy. Please show the date agreed to recruit patients. Leave blank if unavailable.<_  N X? T H]4@  fAT8G݅cE. O<PPlease report the total number of patients recruited at the agreed target date.<O   N( X?^z]4@ ''n^BLny <Please only include records for commercial trials which have closed to recruitment within the reporting window. Format dd/mm/yyyy.<  NP X?UUz]4@ Y&+Y*B2nYʓ 5<6Please report the total number of patients recruited.<5  N X?]4@ nGW)d _<`Please use the free text comment box for more information about the trial. Character limit: 500<_   JA??Picture 3Tj`]&`  NA??Picture 203D ]&`~~  <VCC@_x],@9 $<Upload Submission<w~~ i <WCC@x],i@z29 $ < Validate <7   xX))@AA?$CheckBoxDelete_10 @` ]F   $  "  xX))@AA?$CheckBoxDelete_11 @` ]F   $  "  xY))@AA?$CheckBoxDelete_12 @` ]F   $  "  xY))@AA?$CheckBoxDelete_13 @` ]F   $  "  xZ))@AA?$CheckBoxDelete_14 @` ]F   $  "  xZ))@AA?$CheckBoxDelete_15@`]F   $ "  x[))@AA?$CheckBoxDelete_16@`]F   $ "  x[))@AA?$CheckBoxDelete_17@`]F   $ "  x\))@AA?$CheckBoxDelete_18@`]F   $ "  x\))@AA?$CheckBoxDelete_19@`]F   $ "  x]))@AA?$CheckBoxDelete_20@`]F   $ "  x]))@AA?$CheckBoxDelete_21@`]F   $ "  x^))@AA?$CheckBoxDelete_22@`]F   $ "  x^))@AA?$CheckBoxDelete_23@`]F   $ "  x_))@AA?$CheckBoxDelete_24@`]F   $ "  x_))@AA?$CheckBoxDelete_25@`]F   $ "  x ))@AA?$CheckBoxDelete_26@`]F   $ "  x ))@AA?$CheckBoxDelete_27@`]F  O $ "  x ))@AA?$CheckBoxDelete_28@`]F  O $ "  x ))@AA?$CheckBoxDelete_29@`]F  N $ "  x ))@AA?$CheckBoxDelete_30@`]F  N $ "  x ))@AA?$CheckBoxDelete_31@`]F  M $ "  x ))@AA?$CheckBoxDelete_32@`]F  M $ "  x ))@AA?$CheckBoxDelete_33 @` ]F  L $  "  x ))@AA?$CheckBoxDelete_34!@`!]F  L $! "  x ))@AA?$CheckBoxDelete_35"@`"]F  K $" "  x ))@AA?$CheckBoxDelete_36#@`#]F  K $# "  x ))@AA?$CheckBoxDelete_37$@`$]F  J $$ "  x ))@AA?$CheckBoxDelete_38%@`%]F  J $% "  x ))@AA?$CheckBoxDelete_39&@`&]F  I $& "  x ))@AA?$CheckBoxDelete_40'@`']F  I $' "  x ))@AA?$CheckBoxDelete_41(@`(]F  H $( "<  x ))@AA?$CheckBoxDelete_42)@`)]F  H $)< "<  x ))@AA?$CheckBoxDelete_43*@`*]F  G $*< "<  x ))@AA?$CheckBoxDelete_44+@`+]F  G $+< "<  x ))@AA?$CheckBoxDelete_45,@`,]F  F $,< "<  x ))@AA?$CheckBoxDelete_46-@`-]F  F $-< "<  x ))@AA?$CheckBoxDelete_47.@`.]F  E $.< "<  x ))@AA?$CheckBoxDelete_48/@`/]F  E $/< "<  x ))@AA?$CheckBoxDelete_490@`0]F  D $0< "<  x ))@AA?$CheckBoxDelete_501@`1]F  D $1< "<  x ))@AA?$CheckBoxDelete_512@`2]F  C $2< "<  x ))@AA?$CheckBoxDelete_523@`3]F  C $3< "<  x ))@AA?$CheckBoxDelete_534@`4]F  B $4< "<  x ))@AA?$CheckBoxDelete_545@`5]F  B $5< "<  x ))@AA?$CheckBoxDelete_556@`6]F  A $6< "<  x ))@AA?$CheckBoxDelete_567@`7]F  A $7< "<  x ))@AA?$CheckBoxDelete_578@`8]F  @ $8< "<  x ))@AA?$CheckBoxDelete_589@`9]F  @ $9< "<  x ))@AA?$CheckBoxDelete_59:@`:]F   $:< "<  x ))@AA?$CheckBoxDelete_60;@`;]F   $;< "<  x ))@AA?$CheckBoxDelete_61<@`<]F   $<< "<  x ))@AA?$CheckBoxDelete_62=@`=]F   $=< "<  x ))@AA?$CheckBoxDelete_63>@`>]F   $>< "<  x ))@AA?$CheckBoxDelete_64?@`?]F   $?< "<  x ))@AA?$CheckBoxDelete_65@@`@]F   $@< "<  x ))@AA?$CheckBoxDelete_66A@`A]F   $A< "<  x ))@AA?$CheckBoxDelete_67B@`B]F   $B< "<  x ))@AA?$CheckBoxDelete_68C@`C]F   $C< "<  x ))@AA?$CheckBoxDelete_69D@`D]F   $D< "<  x ))@AA?$CheckBoxDelete_70E@`E]F   $E< "<  x ))@AA?$CheckBoxDelete_71F@`F]F   $F< "<  x ))@AA?$CheckBoxDelete_72G@`G]F   $G< "<  x ))@AA?$CheckBoxDelete_73H@`H]F   $H< "<  x ))@AA?$CheckBoxDelete_74I@`I]F   $I< "<  x ))@AA?$CheckBoxDelete_75J@`J]F   $J< "<  x ))@AA?$CheckBoxDelete_76K@`K]F   $K< "<  x ))@AA?$CheckBoxDelete_77L@`L]F   $L< "<  x ))@AA?$CheckBoxDelete_78M@`M]F   $M< "<  x ))@AA?$CheckBoxDelete_79N@`N]F   $N< "<  x ))@AA?$CheckBoxDelete_80O@`O]F   $O< "<  x ))@AA?$CheckBoxDelete_81P@`P]F   $P< "<  x ))@AA?$CheckBoxDelete_82Q@`Q]F   $Q< "<  x ))@AA?$CheckBoxDelete_83R@`R]F   $R< "<  x ))@AA?$CheckBoxDelete_84S@`S]F   $S< "<  x ))@AA?$CheckBoxDelete_85T@`T]F   $T< "<  x ))@AA?$CheckBoxDelete_86U@`U]F   $U< "<  x ))@AA?$CheckBoxDelete_87V@`V]F   $V< "<  x ))@AA?$CheckBoxDelete_88W@`W]F   $W< "<  x ))@AA?$CheckBoxDelete_89X@`X]F   $X< "<  x0 ))@AA?$CheckBoxDelete_90Y@`Y]F   $Y< "<  x0 ))@AA?$CheckBoxDelete_91Z@`Z]F   $Z< "<  x1 ))@AA?$CheckBoxDelete_92[@`[]F   $[< "<  x1 ))@AA?$CheckBoxDelete_93\@`\]F   $\< "<  x2 ))@AA?$CheckBoxDelete_94]@`]]F   $]< "<  x2 ))@AA?$CheckBoxDelete_95^@`^]F   $^< "<  x3 ))@AA?$CheckBoxDelete_96_@`_]F   $_< "<  x3 ))@AA?$CheckBoxDelete_97`@``]F   $`< "<  x4 ))@AA?$CheckBoxDelete_98a@`a]F   $a< "<  x4 ))@AA?$CheckBoxDelete_99b@`b]F   $b< "<  z5 ))@AA?&CheckBoxDelete_100c@`c]F   $c< "<  z5 ))@AA?&CheckBoxDelete_101d@`d]F   $d< "<  z6 ))@AA?&CheckBoxDelete_102e@`e]F   $e< "<  z6 ))@AA?&CheckBoxDelete_103f@`f]F   $f< "<  z7 ))@AA?&CheckBoxDelete_104g@`g]F   $g< "<  z7 ))@AA?&CheckBoxDelete_105h@`h]F   $h< "<  z8 ))@AA?&CheckBoxDelete_106i@`i]F   $i< "<   z8 ))@AA?&CheckBoxDelete_107j@`j]F   $j< "<   z9 ))@AA?&CheckBoxDelete_108k@`k]F   $k< "<   z9 ))@AA?&CheckBoxDelete_109l@`l]F   $l< "<   z: ))@AA?&CheckBoxDelete_110m@`m]F   $m< "<   z: ))@AA?&CheckBoxDelete_111n@`n]F   $n< "<  z; ))@AA?&CheckBoxDelete_112o@`o]F   $o< "<  z; ))@AA?&CheckBoxDelete_113p@`p]F   $p< "<  z< ))@AA?&CheckBoxDelete_114q@`q]F   $q< "<  z< ))@AA?&CheckBoxDelete_115r@`r]F   $r< "<  z= ))@AA?&CheckBoxDelete_116s@`s]F   $s< "<  z= ))@AA?&CheckBoxDelete_117t@`t]F   $t< "<  z> ))@AA?&CheckBoxDelete_118u@`u]F   $u< "<  z> ))@AA?&CheckBoxDelete_119v@`v]F $  $v< "<  z? ))@AA?&CheckBoxDelete_120w@`w]F   $w< "<  z? ))@AA?&CheckBoxDelete_121x@`x]F   $x< "<  z ))@AA?&CheckBoxDelete_122y@`y]F   $y< "<  z ))@AA?&CheckBoxDelete_123z@`z]F  O $z< "<  z ))@AA?&CheckBoxDelete_124{@`{]F  O ${< "<  z ))@AA?&CheckBoxDelete_125|@`|]F  N $|< "<  z ))@AA?&CheckBoxDelete_126}@`}]F  N $}< "<  z ))@AA?&CheckBoxDelete_127~@`~]F  M $~< "<  z ))@AA?&CheckBoxDelete_128@`]F  M $< "<  z ))@AA?&CheckBoxDelete_129@`]F  L $< "<   z ))@AA?&CheckBoxDelete_130@`]F  L $< "< ! z ))@AA?&CheckBoxDelete_131@`]F ! K $< "< " z ))@AA?&CheckBoxDelete_132@`]F " K $< "< # z ))@AA?&CheckBoxDelete_133@`]F # J $< "< $ z ))@AA?&CheckBoxDelete_134@`]F $ J $< "< % z ))@AA?&CheckBoxDelete_135@`]F % I $< "< & z ))@AA?&CheckBoxDelete_136@`]F & I $< "< ' z ))@AA?&CheckBoxDelete_137@`]F ' H $< "< ( z ))@AA?&CheckBoxDelete_138@`]F ( H $< "< ) z ))@AA?&CheckBoxDelete_139@`]F ) G $< "< * z ))@AA?&CheckBoxDelete_140@`]F * G $< "< + z ))@AA?&CheckBoxDelete_141@`]F + F $< "< , z ))@AA?&CheckBoxDelete_142@`]F , F $< "< - z ))@AA?&CheckBoxDelete_143@`]F - E $< "< . z ))@AA?&CheckBoxDelete_144@`]F . E $< "< / z ))@AA?&CheckBoxDelete_145@`]F / D $< "< 0 z ))@AA?&CheckBoxDelete_146@`]F 0 D $< "< 1 z ))@AA?&CheckBoxDelete_147@`]F 1 C $< "< 2 z ))@AA?&CheckBoxDelete_148@`]F 2 C $< "< 3 z ))@AA?&CheckBoxDelete_149@`]F 3 B $< "< 4 z ))@AA?&CheckBoxDelete_150@`]F 4 B $< "< 5 z ))@AA?&CheckBoxDelete_151@`]F 5 A $< "< 6 z ))@AA?&CheckBoxDelete_152@`]F 6 A $< "< 7 z ))@AA?&CheckBoxDelete_153@`]F 7 @ $< "< 8 z ))@AA?&CheckBoxDelete_154@`]F 8 @ $< "< 9 z ))@AA?&CheckBoxDelete_155@`]F 9 / $< "< : z ))@AA?&CheckBoxDelete_156@`]F : / $< "< ; z ))@AA?&CheckBoxDelete_157@`]F ; . $< "< < z ))@AA?&CheckBoxDelete_158@`]F < . $< "< = z ))@AA?&CheckBoxDelete_159@`]F = - $< "< > z ))@AA?&CheckBoxDelete_160@`]F > - $< "< ? z ))@AA?&CheckBoxDelete_161@`]F ? , $< "< @ z ))@AA?&CheckBoxDelete_162@`]F @ , $< "< A z ))@AA?&CheckBoxDelete_163@`]F A + $< "< B z ))@AA?&CheckBoxDelete_164@`]F B + $< "< C z ))@AA?&CheckBoxDelete_165@`]F C * $< "< D z ))@AA?&CheckBoxDelete_166@`]F D * $< "< E z ))@AA?&CheckBoxDelete_167@`]F E ) $< "< F z ))@AA?&CheckBoxDelete_168@`]F F ) $< "< G z ))@AA?&CheckBoxDelete_169@`]F G ( $< "< H z ))@AA?&CheckBoxDelete_170@`]F H ( $< "< I z ))@AA?&CheckBoxDelete_171@`]F I ' $< "< J z ))@AA?&CheckBoxDelete_172@`]F J ' $< "< K z ))@AA?&CheckBoxDelete_173@`]F K & $< "< L z ))@AA?&CheckBoxDelete_174@`]F L & $< "< M z ))@AA?&CheckBoxDelete_175@`]F M % $< "< N z ))@AA?&CheckBoxDelete_176@`]F N % $< "< O z ))@AA?&CheckBoxDelete_177@`]F O $ $< "< P z ))@AA?&CheckBoxDelete_178@`]F P $ $< "< Q z ))@AA?&CheckBoxDelete_179@`]F Q # $< "< R z ))@AA?&CheckBoxDelete_180@`]F R # $< "< S z ))@AA?&CheckBoxDelete_181@`]F S " $< "< T z ))@AA?&CheckBoxDelete_182@`]F T " $< "< U z ))@AA?&CheckBoxDelete_183@`]F U ! $< "< V z ))@AA?&CheckBoxDelete_184@`]F V ! $< "< W z ))@AA?&CheckBoxDelete_185@`]F W  $< "< X z ))@AA?&CheckBoxDelete_186@`]F X   $< "< Y z ))@AA?&CheckBoxDelete_187@`]F Y  $< "< Z z! ))@AA?&CheckBoxDelete_188@`]F Z  $< "< [ z! ))@AA?&CheckBoxDelete_189@`]F [  $< "< \ z" ))@AA?&CheckBoxDelete_190@`]F \  $< "< ] z" ))@AA?&CheckBoxDelete_191@`]F ]  $< "< ^ z# ))@AA?&CheckBoxDelete_192@`]F ^  $< "< _ z# ))@AA?&CheckBoxDelete_193@`]F _  $< "< ` z$ ))@AA?&CheckBoxDelete_194@`]F `  $< "< a z$ ))@AA?&CheckBoxDelete_195@`]F a  $< "< b z% ))@AA?&CheckBoxDelete_196@`]F b  $< "< c z% ))@AA?&CheckBoxDelete_197@`]F c  $< "< d z& ))@AA?&CheckBoxDelete_198@`]F d  $< "< e z& ))@AA?&CheckBoxDelete_199@`]F e  $< "< f z' ))@AA?&CheckBoxDelete_200@`]F f  $< "< g z' ))@AA?&CheckBoxDelete_201@`]F g  $< "< h z( ))@AA?&CheckBoxDelete_202@`]F h  $< "< i z( ))@AA?&CheckBoxDelete_203@`]F i  $< "< j z) ))@AA?&CheckBoxDelete_204@`]F j  $< "< k z) ))@AA?&CheckBoxDelete_205@`]F k  $< "< l z* ))@AA?&CheckBoxDelete_206@`]F l  $< "< m z* ))@AA?&CheckBoxDelete_207@`]F m  $< "< n z+ ))@AA?&CheckBoxDelete_208@`]F n  $< "< o z+ ))@AA?&CheckBoxDelete_209@`]F o  $< "< p z, ))@AA?&CheckBoxDelete_210@`]F p  $< "< q z, ))@AA?&CheckBoxDelete_211@`]F q  $< "< r z- ))@AA?&CheckBoxDelete_212@`]F r  $< "< s z- ))@AA?&CheckBoxDelete_213@`]F s  $< "< t z. ))@AA?&CheckBoxDelete_214@`]F t  $< "< u z. ))@AA?&CheckBoxDelete_215@`]F u  $< "< v z/ ))@AA?&CheckBoxDelete_216@`]F v  $< "< w z/ ))@AA?&CheckBoxDelete_217@`]F w  $< "< x z@ ))@AA?&CheckBoxDelete_218@`]F x  $< "< y z@ ))@AA?&CheckBoxDelete_219@`]F y  $< "< z zA ))@AA?&CheckBoxDelete_220@`]F z  $< "< { zA ))@AA?&CheckBoxDelete_221@`]F {  $< "< | zB ))@AA?&CheckBoxDelete_222@`]F |  $< "< } zB ))@AA?&CheckBoxDelete_223@`]F }  $< "< ~ zC ))@AA?&CheckBoxDelete_224@`]F ~  $< "<  zC ))@AA?&CheckBoxDelete_225@`]F   $< "<  zD ))@AA?&CheckBoxDelete_226@`]F   $< "<  zD ))@AA?&CheckBoxDelete_227@`]F   $< "<  zE ))@AA?&CheckBoxDelete_228@`]F   $< "<  zE ))@AA?&CheckBoxDelete_229@`]F   $< "<  zF ))@AA?&CheckBoxDelete_230@`]F   $< "<  zF ))@AA?&CheckBoxDelete_231@`]F   $< "<  zG ))@AA?&CheckBoxDelete_232@`]F   $< "<  zG ))@AA?&CheckBoxDelete_233@`]F   $< "<  zH ))@AA?&CheckBoxDelete_234@`]F   $< "<  zH ))@AA?&CheckBoxDelete_235@`]F   $< "<  zI ))@AA?&CheckBoxDelete_236@`]F   $< "<  zI ))@AA?&CheckBoxDelete_237@`]F   $< "<  zJ ))@AA?&CheckBoxDelete_238@`]F   $< "<  zJ ))@AA?&CheckBoxDelete_239@`]F   $< "<  zK ))@AA?&CheckBoxDelete_240@`]F   $< "<  zK ))@AA?&CheckBoxDelete_241@`]F   $< "<  zL ))@AA?&CheckBoxDelete_242@`]F   $< "<  zL ))@AA?&CheckBoxDelete_243@`]F   $< "<  zM ))@AA?&CheckBoxDelete_244@`]F   $< "<  zM ))@AA?&CheckBoxDelete_245@`]F   $< "<  zN ))@AA?&CheckBoxDelete_246@`]F   $< "<  zN ))@AA?&CheckBoxDelete_247@`]F   $< "<  zO ))@AA?&CheckBoxDelete_248@`]F   $< "<  zO ))@AA?&CheckBoxDelete_249@`]F   $< "<  z ))@AA?&CheckBoxDelete_250@`]F   $< "<  z ))@AA?&CheckBoxDelete_251@`]F  / $< "<  z ))@AA?&CheckBoxDelete_252@`]F  / $< "<  z ))@AA?&CheckBoxDelete_253@`]F  . $< "<  z ))@AA?&CheckBoxDelete_254@`]F  . $< "<  z ))@AA?&CheckBoxDelete_255@`]F  - $< "<  z ))@AA?&CheckBoxDelete_256@`]F  - $< "<  z ))@AA?&CheckBoxDelete_257@`]F  , $< "<  z ))@AA?&CheckBoxDelete_258@`]F  , $< "<  z ))@AA?&CheckBoxDelete_259@`]F  + $< "<  z ))@AA?&CheckBoxDelete_260@`]F  + $< "<  z ))@AA?&CheckBoxDelete_261@`]F  * $< "<  z ))@AA?&CheckBoxDelete_262@`]F  * $< "<  z ))@AA?&CheckBoxDelete_263@`]F  ) $< "<  z ))@AA?&CheckBoxDelete_264@`]F  ) $< "<  z ))@AA?&CheckBoxDelete_265@`]F  ( $< "<  z ))@AA?&CheckBoxDelete_266 @` ]F  ( $ < "<  z ))@AA?&CheckBoxDelete_267 @` ]F  ' $ < "<  z ))@AA?&CheckBoxDelete_268 @` ]F  ' $ < "<  z ))@AA?&CheckBoxDelete_269 @` ]F  & $ < "<  z ))@AA?&CheckBoxDelete_270 @` ]F  & $ < "<  z ))@AA?&CheckBoxDelete_271@`]F  % $< "<  z ))@AA?&CheckBoxDelete_272@`]F  % $< "<  z ))@AA?&CheckBoxDelete_273@`]F  $ $< "<  z ))@AA?&CheckBoxDelete_274@`]F  $ $< "<  z ))@AA?&CheckBoxDelete_275@`]F  # $< "<  z ))@AA?&CheckBoxDelete_276@`]F  # $< "<  z ))@AA?&CheckBoxDelete_277@`]F  " $< "<  z ))@AA?&CheckBoxDelete_278@`]F  " $< "<  z ))@AA?&CheckBoxDelete_279@`]F  ! $< "<  z ))@AA?&CheckBoxDelete_280@`]F  ! $< "<  z ))@AA?&CheckBoxDelete_281@`]F   $< "<  z ))@AA?&CheckBoxDelete_282@`]F    $< "<  z ))@AA?&CheckBoxDelete_283@`]F   $< "<  z ))@AA?&CheckBoxDelete_284@`]F   $< "<  z ))@AA?&CheckBoxDelete_285@`]F   $< "<  z ))@AA?&CheckBoxDelete_286@`]F   $< "<  z ))@AA?&CheckBoxDelete_287@`]F   $< "<  z ))@AA?&CheckBoxDelete_288@`]F    $< "<  z ))@AA?&CheckBoxDelete_289 @` ]F   $ < "<  z ))@AA?&CheckBoxDelete_290!@`!]F    $!< "<  z ))@AA?&CheckBoxDelete_291"@`"]F   $"< "<  z ))@AA?&CheckBoxDelete_292#@`#]F    $#< "<  z ))@AA?&CheckBoxDelete_293$@`$]F   $$< "<  z ))@AA?&CheckBoxDelete_294%@`%]F    $%< "<  z ))@AA?&CheckBoxDelete_295&@`&]F   $&< "<  z ))@AA?&CheckBoxDelete_296'@`']F    $'< "<  z ))@AA?&CheckBoxDelete_297(@`(]F   $(< "<  z ))@AA?&CheckBoxDelete_298)@`)]F   $)< "<  z ))@AA?&CheckBoxDelete_299*@`*]F   $*< "!Passingham, Charlotte!Passingham, Charlotte! Passingham, Charlotte! Passingham, Charlotte! Passingham, Charlotte! Passingham, Charlotte!Passingham, Charlotte!Passingham, Charlotte>@Fsiri A      +#  C#e +#  C#e +#  C#e +#  C#e +#  C#e  Sheet1ggD g2 Y=  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3c!U} $ >} >} >} $ >} $ G}  G} D} $ >} $ G} $D} $ >} >} $ >} I >} $ >**,**,*,*,*,**,*, *, *, * *,K *,H*,*,$,$, DD DD ? DD D DD DD DD A DD DD DD DD @ @ KD K DD B F RD F DD B F >>> >> B~ E@ >>> >> B~ E >>> >> B~ ED@ >>> >> S S S > S S > S S S" S' S) S+ S. S0 S2 S4 S6 S; "SJ $S? &SK (SL K K K K K K K K! K& K( K* K- K/ K1 K3 K5 K: "K< $K> &K@ (KA H H H H I I J H I J H H H H H H H H H H H H H H H H H H H H H H H !H "H #H $H %H &H 'H (H )H > > > > G G D > G  D  >  >  >  >~ >@ ># > > > >~ >R@ ># > > > > > > > >~ >@ >7  > !>~ ">`j@ #>=~ $>z@ %>= &> '> (> )>~ >@ >$~ >T@ >,~ >@ >8~ ">z@ #>= $> %>~ >@ >% > >~ >@ >9 "> #> > > > >( TB*PP:::::&LLpPH  0(   >@ Sheet2ggD g2 :  dMbP?_*+%,&ffffff?'ffffff?(?)?MPRINTER2\PRINTER 4dhh EPSON BX610FW Series@@Open cfg file 4  hhL hh q**** q****d2" d333333?333333?&<3U} $ O} $ L} mL} $ O} $ L,O,O,O,O,O,O,OO,O , , P  M N d0 L(    JA??Picture 3 Z]&`  NA??Picture 203  ]&`>@A     Sheet3ggD dirSheet1Sheet2Sheet3 +  !"#$%&'()*,-./0123456789:;<=?@ABCDEFGHIJKLMNOPQRSTUWXYZ[]^_`abcdefghijklmnopqrstuvwxyz{|}ε0* pHd VBAProject4@j = r KZ J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\Syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE15\MSO.0DLL#M 1@5.0 Ob LibraryKMSForms>SFrms3D452EE1-E08F`A-8-02608C@4D0BB4 SINDOWS\sSFM20L'B _&/;"1jIqAHq00}#:0Bq# 50 A7D869F11-C274F05-8237-FF6D194098196UserdHRISD~2\AppData\Local\Temp\VBEc7.exdd<@".E .`M @MSXML2M@hXML25lb2F5078F18-C551-11D3 -89B9JF81FE221}#6msxml60.dll,, v @IWshRuntimeJ>$WFhRuTnsiHe i@bra`y`x ahb935DC20-1CF1D0-ADbC04FD58A 0B}#1vwshom.ocx#w Script HostKMo,de% "ҭThisWorkbookGT@i`Wbako k2` H1",s""+ShePet1G Seqt1 A2C P KT 2 2 2 42  dialogLogonGRi@Dl,g@Fog n62mͥ(e.Spreads!/OneUtilitiesG.pXe`d\2O]eU]l Jt`e 2'  o2/;hv!@#-`cessingG a-Pos@i@g/q2 }4~E NoPermi0 !"Ed8 N!P01j:jso 2JemM ; 7 [$CusptG&S/$p#$C0So0Ses2A  @<#+Constant0"h@eh ! atٟ0ne0s _ Z=0VS3=N3.=N3?N?N D3JҭKT#pJ c F0BHW0E(-x0BHW0E(-ӟJ cMEP[LSS86>" LJ0Ffn@h @ @ @ @ @p @X @@ @( @( @@ @X @p @ @ @ @h @P @8 @0 @H Bz "@` @x @ hxKZ*\R1*#278$*\Rffff*0@5aaa4cbc$*\Rffff*0A5aaa4cbc$*\Rffff*0<5aaa4cbc*\R1*#11c*\R1*#5b*\R1*#277`J"    D(p  NR  & 0  @ X ph    8 .( (8 2H ~X $x *b $ *b0 $8 *b`     h "P 2x * 0  ,    ] :GA@<j= Avoid processing during load even though events are disabled >!@|xkpH Check or more than once cell if so don't run as this is a copy or paste 4!B!D |k Mark as loading to stop recalls >(@ Remove protectionCall UnLockSheets Remove protection JHLNPRTVXZ\^`bd 0B@F1 Stop screen updating etc for performance reasons f(hp@@ f(j n f(lP 4!t f!p%rP 4!v 4!x 0%BPlease Select... 4!x 0,Bk( 4!v 4!x 0%BPlease Select... 4!x 0,Bk 4!v 4!x 0%BPlease Select... 4!x 0,Bkhk` Resume protectionCall LockSheets Resume protection JHLNPRTVXZ\^`bd 0B@F Resume screen etc updating z f(l f(j f(h% Mark as done loading to resume calls >(@oAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$BustomlizD2P Sub Works_Change(ByVal Target As R )  Dim rdIf HAS_AUTO0_RUNkJ Then Auto _Open' Avoid processing durload evthoughts P dised7S pdaOneUtilities.bL@@D@aW!2Exit@CEnd IfC' Check or moreD tH on@|cell if so don't @run as@is a copypastuFCU.Cs.Count > 1%MarkIKto @yp recallsC/E C' RemoveetectiokC UnLoct... ̡aɐ?v 11_¼./Es&16i W $sLsuhO N QTNNN>NL!:NTINN@PGNNRNOB OO&OIF=ONNNC?Hl5Ific_MORg' E}e }G)}Aq20WZҭ#pqF+1 F`V@NNp'x`V@NNp'qF+1ME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0%@p%|%Hx@x8KZ$*\Rffff*0B5aaa4cbc`xAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Zҭ#p~:vYJ {U F Fڑx Fڑ~:vYJ {UME(SLSS6"N0{00020820-0000-0000-C000-000000000046} 0%@p%ca%Hx@x8KZ$*\Rffff*0]5aaa4d26`xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU@@@~~~~~~~~~~~__SRP_0\__SRP_1 >__SRP_2(__SRP_3Vr      !"#%&)*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~K*   rU@@~~~~~~~~~~~ ~~~ ~~~ ~~~~ ~~~~~~ ~~~ ~~~~~~~~~~~~~~~ ~*"QdI5G#μg   aaA a aqkjjkAka!QQA1!QAq1a!araa}AkaP !Qa N!aaA  a  VBAProject ThisWorkbookSheet1Sheet2 dialogLogonSpreadsheetOneUtilitiesdialogProcessingdialogNoPermissionSpreadsheetOneCustomSpreadsheetOneConstantsSheet3F C:\Windows\System32\msxml6.dll1C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLLVBA  PF4C:\Program Files\Microsoft Office\Office15\EXCEL.EXEExcel Aqp0FC:\Windows\System32\stdole2.tlbstdole !L-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLLOffice .E .`M C:\WINDOWS\system32\FM20.DLLMSForms Q Q  }O7m@4C:\Users\CHRISD~2\AppData\Local\Temp\VBE\MSForms.exd Q  Q!MSXML2   5OՊ C:\Windows\System32\wshom.ocxIWshRuntimeLibrary  ! 0 DownloadData UploadData CheckData SetFreeze DeleteRows  Auto_Open PrepareDataEncodeUriComponentExecuteSecureRequestExecuteBasicRequestCreateDropDownCellLookUpIdFromValueLookUpValueFromIdGetDecimalValueReturnMyDocumentsPathCheckRangeContainsRemoveCharacters GetLastRow AppendElement3)6{O>`AppendAttributeGetBooleanValue GetIntValueGetStringValue GetDateValueUpdateErrorColumnmessOnemessTwo messThreemessFourmessFive LockSheets UnLockSheetsGetXMLDocument IsValidDate IsValidRowFLⒷd8OE@z{ FfnAȽs;DFWorkbook Workbook_Open x Spreadsheet One 2Spreadsheet in Debug Mode&m .VBE7.DLLq !(~ - DEBUGDF \q PSfĤIx8<2FJ c F0BHW0E(- WorksheetWorksheet_ChangeFF&mQ&mEFF1#a#&t a#&t&ma#F'F UploadData&mQ9DF CheckDataFF23&m3&m a# DATA NewPIDDownload&ta#8 http://localhost:49494/Exbos.Applications.NHSRBVP.Components.Web/SpreadsheetDataEntry/SpreadsheetHandler.ashx MODE EMAIL PASSWORD ID & https://ccfctp.nihr.ac.uk/SpreadsheetDataEntry/SpreadsheetHandler.ashx MSXML2.XMLHTTP <RESULT_OK/> &<RESULT_CANCELLED/> "<RESULT_SUCCESS/> <RESULT_FAILED/> <RESULT_DENIED/> Access Denied! + NewPIDUpload NewPIDDelete #Pr0t3ct3dSh33t# 01/01/1753 ,System generated field2 Format dd/mm/yyyy. Please show the date agreed to recruit patients. Leave blank if unavailable. Value  SelectSingleNodeZ bDrop down options. Please indicate whether the trial has a fixed target (Number Agreed), range target (Range Agreed) or no target agreed or available (Not Available /Not Agreed)" zDrop down options. Indicate if a target date has been agreed.* Please report the total number of patients recruited at the agreed target date.D Please only include records for commercial trials which have closed to recruitment within the reporting window. Format dd/mm/yyyy.qF+1`V@NNp' jPlease report the total number of patients recruited.2 Please use the free text comment box for more information about the trial. Character limit: 500 Please Select... New blank%X_@# 20 (q !O a TRUE&tQq a textPasswordȏ[qJ eImage1f This file can only be used in conjunction with the NHS Research Benchmark Validation Platform. When dowloading a spreadsheet from the system always choose the 'Open' option and not 'Save' or 'Save As'.qS V F3Dynamic(~ FALSE RELEASE %20qw Y"hUserFormJ2P?Jl6JPd6QZ %0q= Ac0 a %q eplabelCopyrightҋB ` textUsername aƨ߼Wp[Hmb6t|BB5go9@2ZMN؊#L.ds:'/CCפAq"-?@ labelPassword!-6S`  g Label3YL&i eImage2{lFWJO buttonCancel aZ aVbuttonOK?F` groupLogon labelEmailResultbuttonCancel_ClickbuttonOK_Click `&mag = &DocumentElement&mfҋB `&mn WpjO:Ja&d`˼Zn RB`uZG*4"'~NF.{{>lS#^CN1 M9^>3)6{O>` 1q aV0 groupLoading labelProgress  BContacting Validation Platform...&mApYl|q1 P V10:&mtqV QwPSq }AlertStyleOperatorFormula1, The email address and password you entered have not been recognised by the system.zf&N]y5F%Z^ch?QNkyFH܍j*K@d.'NW^E/E8OAS v5IIoFT@( { aVgroupPermissionsImage3 Add 0"h POSTOpen Content-Type Bapplication/x-www-form-urlencoded  setRequestHeaderSendResponseTextValidation DeleteType$f Modify \Error setting cell drop down valies for range " to target range   error code   description IgnoreBlankInCellDropdown -1Z q "h WScript.ShellDAKP mydocuments!5OՊ  T10: U10:&m'5OՊ &tъqi Address3)6{O>` R10: S10:"hqk 1"h&o:3q P aqx Q&m3)6{O>`&tі(m&tNodeValue3)6{O>`&ta true false -99999911 C10: D10:q- Z q  a dd/mm/yyyyq P  1(~ &yyyy-mm-ddThh:mm:ss &1753-01-01T00:00:00 &1753-01-01T12:00:00   2 3 4 5 A1: A10: B10:XML.Q $MSXML2.DOMDocument ,MSXML2.DOMDocument.6.0 ,MSXML2.DOMDocument.3.0 "MSXML.DOMDocumentLoadXML //RowsnodeName <DataTableDataExportContainerOfq , (//DataColumnSettings //MetaSubmission 0SubmissionRangeStartDate T&taq&t /&m   ,SubmissionRangeEndDate F//DataColumnSettings/ColumnSettingsSelectNodes3)6{O>` FriendlyName $CurrentDataServiceClearComments IdAddCommentComment shape Height BTarget Number Of Patients Agreed? Width NTarget Date To Recruit Patients Agreed? `Date Agreed to recruit target number of patients xTotal Number Of Patients Recruited At The Agreed Target Date Color Boolean RDate That The Trial Closed To Recruitment XTotal Number Of Study Participants Recruited Comments Value *.//DataTypeCache/item ./key/int ./value/string 99,999,911 VisibleInterior t//DataTableDataExportContainerOfNewPerfDeliveryDetail/RowsChildNodes CheckBoxDelete_2QF Name 99999911 TSpreadsheetOneConstants.DATA_STRING_SELECT $PropertyTypeString DateTime 1753-01-01q $o ? : LookUp&t3EntireColumn Hidden ErrorsqL  "hEntireRow <Error during data download - ( ) Download errorColorIndex F - Please enter a valid IRAS number r - Please enter the Name of Trial (up to 2000 characters) ']/DefaultValue ']/Name String nPlease indicate if Target number of patients is agreed ( Target number of patients agreed: please choose from the drop-down fields  Number Agreed Range Agreed jPlease indicate the minimum number of patients agreed" Minimum number of patients agreed should be entered as a number 2 Please remove minimum number of patients or review the 'Target number of patients agreed' field  jPlease indicate the maximum number of patients agreed ']/Visible" Maximum number of patients agreed should be entered as a number 2 Please remove maximum number of patients or review the 'Target number of patients agreed' field & Please indicate the total number of patients agreed at target date4 Please review minimum and maximum number of patients. The minimum cannot be greater than the maximum & Please indicate if Target Date Agreed to recruit patients is available nDate the trial closed should have the format dd/mm/yyyy* Target Date agreed to recruit patients: please choose from the drop-down fields  Date Agreed$ Please indicate the date agreed to recruit target number of patients  TPlease indicate the date the trial closed Text A, Date agreed to recruit target number of patients should have the format dd/mm/yyyyJ Target Date To Recruit Patients Agreed must be set to Date Agreed to enter a Value in Date Agreed field. All dates entered must be Valid Dates. Int32( Total number of patients agreed at target date should be entered as a number < Please remove Total number of patients agreed at target date or review the 'Target number of patients agreed' field  >//ColumnSettings[FriendlyName=' fDate trial closed should be within quarterly window" Please indicate the total number of study participants recruited vThe total number of study participants recruited is invalidcreateElement *']/PropertyTypeString X hPlease indicate the reason for closure of the trial & Reason for closure of the trial: please choose from the drop-down fields * Some data on the spreadsheet has failed initial checks (see highlighted data).appendChild Rows lAre you sure you want to carry on uploading your data?4 Warning - the system may substitute default data for any data that may break the database integrity. (Incorrect data types (<DataColumnSettings> *</DataColumnSettings> 8Error during data upload - ( Upload error 6Error during data check - ( Data Check error~:vYJ {U Fڑ8~N    bShowLogon sComponent bSpaceAsPlussCommandsData sRequestData RangeTarget sRangeSourcesValueiColumnsDefaultsIdvValue sRangeNamesStringToCheckInString  a xmlElementsNamesBoolsIntsStringsDateiRowsMessage irowindex Q0 P  pTarget !hg !hh !h!i !h!e iQR !hQj0sResult qQRP !|QRprU@@@@`rU@@@~x34aPv.111ѮA1 AQ a! Q!UA?p QNA3:A6a=<ABAmQB!qq1A?qB1aE!q@FHQJ!KaAMAa1Mqq1Q m!Q11a1-!1" tQAA!A!a1QAAQqA1!!aaAQ>AAa>!qZqq:8gg 7g$ "#Z$0g$ "%Z&0g.p'Z(8h gD)*g&+D)D&@g  %Z&@g  #Z$@g{g,Dg  %Z&@g{gg -Z.g gg4@p/Xlp@g  %Z&@g  #Z$@g{ggg4@p/Xlpg  %Z&@g  #Z$@g{gg00p1V2pgFHPXPHgp3X4)5Xa 0q0%Z& 6pXg07p1V2pgFHPXPHgfp80%Z& X6pXg09p1V2pgJP:8 PU;pPgp&lg:( <IppX (X`pXg:@pp`pgHp@X X`pXg:@pp`pg=PgPg=PgPqp0%Z& X6pXZ ggpp`<IXXpa (`pXg:@pp`pgHp@X X`pXg:@pp`pg=PgPg=PgPqp0%Z& X6pXggJP>8 PU;pPgp& g>( <IppX (X`pXg:@pp`pgHp@X X`pXg:@pp`pg=PgPg=PgPqp0%Z& X6pX ggpp`<IXXpa (`pXg:@pp`pgHp@X X`pXg:@pp`pg=PgPg=PgPqp0%Z& X6pXgg #Z$Pgy@gq0gq g0?p@VApg2g@B( "hghCUgB( "qp@k0k0P#Z$ PX6PpXg\@k0k0#Z$ XDXg)ghEDgFg)D gf@@k0k0#Z$ XGXg| @k0k0#Z$ pXHIJpXgghKDgLg)D gf@@k0k0#Z$ XGXg|0@k0k0#Z$ pXHIJpXg@k0k0#Z$ pXHIM@k0k`P#Z$ P0HIMPpX0gghND&gOg)D gf@@k0k0#Z$ XGXg|$@k0k0#Z$ pXHIJpXgghPDVgQg)D Jgf@@k0k0#Z$ XGXg|<@k0k0#Z$ pXHIJpXgghRDgSg)D zgf@@k0k0#Z$ XGXg|0@k0k0#Z$ pXHIJpXgghTDgUg)D gf@@k0k0#Z$ XGXg|$@k0k0#Z$ pXHIJpXg@k0k0#Z$ pXHIM@k0k`P#Z$ P0HIMPpX0gghVDgWg)D gf@@k0k0#Z$ XGXg|$@k0k0#Z$ pXHIJpXgghXDgYg)D gf@@k0k0#Z$ XGXg|0@k0k0#Z$ pXHIJpXgggz"qp  k0%Z& X6pXgB( "qp  k0P%Z& PX6PpXg^E k0%Z& p6pgbZ qk0%Z& p6pg8g([  eg2g\( "qp8k k0P%Z& PX6PpXg]( "qp8k qk0P%Z& PX6PpXg8q8g2.gb^8k k0%Z& p6pgf^8k qk0%Z& p6pg r g0q0gg2Fg>_p1X`VApXgq0g2d!gz@g@,6!gb)@k0k0#Z$ p6pg^ a@agPqp#Z$Ubpgg@q@g  g0q0g2 gy@g2,g@q@gq0gq(g2)g@c( "hghCU)gLPh8 PU;xPgx&<#gh( "qp@k0k0P#Z$ PX6PpX)ggb(k0%Z& p^\px%gpx`pdCXx`eC+0x`00fC+lp0$gb)@k0k0#Z$ p6pl%ggpx`gIXX(p`  @k0k#Z$ 6pXg)ggLh( iD(gJpx` pXX`pXgjD&gb)@k0k0#Z$ p6p'ggpx`Xp x`0 x`  0 pX0gf^@k0k0#Z$ p6pg)ggpx`pdCXx`eC+0x`00fC+lp0)gb)@k0k0#Z$ p6p)ggvpx`p@k0k0#Z$ X6pXggggg0q0g(r(gg2!gp@k0#Z$ pX6)KpX*g^k@k0#Z$ p6pggp@k0 #Z$ pX6)KpX+g^k@k0 #Z$ p6pggp@k0#Z$ pX6)KpXj,g^k@k0#Z$ p6pgg2!gr gq0g22g8gg8k k0%Z& pX6^T8k qk`P%Z& P6)T07lPpX2gt8k k0%Z& pX6^\pXz.g8q8gqg -g  qk0%Z& p)lpa 0h)m"hg 0`)="`g 0X)n"Xg 0P)o"Pgx 0gppPXxph`XPpg k0%Z& pk kxP%Z& PXHXp'Z(@eH`PpXgX@`HH @P'Z(PHUq`HPgrXPXg 0k0#Z$ XP#Z$0 Ppvl0kxH#Z$ HHX'Z(@eHPPHpXgJX@P @UqPgg0q0g r g2,gq0gq g@2(5g@s( "g@h( "g 0k0#Z$ p'0kxP#Z$ PXHXp'Z(@HPHpXgtD4gF 'Z(`puvpgg0q0g r g@203gZw 0#Z$ p6pgz@gk(g"@k(P7gq0g^)@k0#Z$ p6pg~l0@k#Z$0 pXxyzpXgzpl@k0#Z$ pXyzpXg@q@g 5g g g-Z.g gg g0'Z(8h g{g0'Z(8h g g 8 PPX {IXX| bgPg}PgPqp!(PpXg{?8((@xhPX`Hp(xph`XPPHHpX0lKJgg Hg ~g.p 'Z(8 h  gpHgHg gPgqgqgzgHLg^)k #Z$  x6 xgqg gzgHp1gzgHp1gH1g^  aaghPqx#Z$ Ubph xg`@[pxCP87 lx1gzplk #Z$  xPyz xPglk #Z$  xPy xPgvk #Z$  xP6K8 xPglk #Z$  xPy xPg  #Z$  xP6O8` hh xP8gpPgglk #Z$  xPy xPgk #Z$  xP6)C8k#Z$  6Kp+Xl xP  glk #Z$  xPy xPg  #Z$  xP6O8` hh xP8gpPgglk #Z$  xPy xPgk #Z$  xP6kC8k#Z$  6)C+pl xP  g(hhhglk #Z$  xPy xPgpPz gk #Z$  xP6I88PP` h   Kh xP8 z glk #Z$  xPy xPg(hhhgpPggk #Z$  xP6C8k#Z$  6C+pl xP ~gk  #Z$  xP6[k #Z$ 8 6)T7l  xP8  glk  #Z$  xPy xPrgpk  #Z$  xP6)K xP g(hhhglk  #Z$  xPy xPgpPrgglk  #Z$  xPy xPg(hhhgpPgggpk  #Z$  xP6)K xPfglk  #Z$  xPy xPgglk  #Z$  xPy xPg(hhhgpPgggk #Z$  xP6C8k#Z$  6C+pl xP gk  #Z$  xP6[k #Z$ 8 6)T7l  xP8 Lglk  #Z$  xPy xP gpk  #Z$  xP6)K xPdg(hhhglk  #Z$  xPy xPgpP gglk  #Z$  xPy xPg(hhhgpPgggpk  #Z$  xP6)K xPglk  #Z$  xPy xPgglk  #Z$  xPy xPg(hhhgpPgggk  #Z$  xP6[k #Z$ 8 6)T7k0 H#Z$ HpX6[7kh #Z$ 86 )T7l HxP8 pX82gk  #Z$  x86k #Z$ P 6 xP8 ,glk  #Z$  xPy xPglk  #Z$  xPy xPg(hhhgpPggglk  #Z$  xPy xPgpk  #Z$  xP6kK xPg(hhhglk  #Z$  xPy xPgpPgk  #Z$  xP6I88PP` h   Kh xP8 glk  #Z$  xPy xPg(hhhgpPggpk  #Z$  xP6K xP,g\k  #Z$  x x`glk  #Z$  xPy xP gpk  #Z$  xP6)K xPxg(hhhglk  #Z$  xPy xPgpP gglk  #Z$  xPy xPg(hhhgpPg ggpk  #Z$  xP6)K xP glk  #Z$  xPy xP gglk  #Z$  xPy xPg(hhhgpPgggpk  #Z$  xP6K xPV$gk  #Z$  xP6[k #Z$ 8 6)T7l  xP8 "glk  #Z$  xPy xPJ$gpk  #Z$  xP6)K xP#g(hhhglk  #Z$  xPy xPgpPJ$gglk  #Z$  xPy xPg(hhhgpPg%ggpk  #Z$  xP6)K xP>%glk  #Z$  xPy xP%gglk  #Z$  xPy xPg(hhhgpPggg\k #Z$  x x&glk #Z$  xPy xP(gpk #Z$  xP6)K xP'g(hhhglk #Z$  xPy xPgpP(gglk #Z$  xPy xPg(hhhgpPgg\k #Z$  x x^+gk #Z$  xP6ah88%Z&  ak0H#Z$ HpX6a%Z& 8a+lh HxP 8pX8X+g(hhhglk #Z$  xPy xPgpPggglk #Z$  xPy xPgpk #Z$  xP6)K xP,g(hhhglk #Z$  xPy xPgpPggk #Z$  xP68k#Z$  6+pl xP l.g(hhhglk #Z$  xPy xPgpPgglk #Z$  xPy xPgk #Z$  xP6kC8k#Z$  6)C+pl xP f0g(hhhglk #Z$  xPy xPgpP1gk #Z$  xP6I88PP` h   Kh xP8 1glk #Z$  xPy xPg(hhhgpPgggqg gggPp>2g 8IPPPghPgPgPgPqx!(?hxP8 2g g{ggg -Z.g gx %Z&  xP6)C8 l xP;gg~ %Z&  xP68/ l xP84g{ggqgpk %Z&  xP6)\ xP66g0gg|0q k %Z&  xP68`0 xP8grgrk %Z&  xP6)K  xP4g0P0gg0@/g8x383x8gg0xVxgN   @P3 U Pgzg %Z&  xP6lI88Pah  (  Sh xP8 g6qmlqnlh:gz %Z&  xP68V xP8gb  #Z$  xP6` xPg\PghPqxP18`hhxP8g\PghPqxP18`8hxP8gP8@`/x`x`Xxg\PghPqxP18`@hxP8ghU4:gX@X:ggX@gg4U2  gh7g\x8Px` hhhxggg~ %Z&  xP68/ l xP8;g{ggqgpk %Z&  xP6)\ xP=g0gg|0q k %Z&  xP68`0 xP8grgrk %Z&  xP6)K  xP<<g0P0gg0@/g8x383x8gg0xVxgN   @P3 U PgzgHg^  aaghPqx#Z$ Ubph xg`pxCP8@[7 lxGgqgqgz %Z&  xP68V xP8ggf k #Z$  xP6` xPg\PghPqxP18`hhxP8g\PghPqxP18`8hxP8gk %Z&  x)TPk%Z& 8^T 7l x8dBgkk #Z$  xP6I88P` h   `Xh xP8 BFggdPghPqxP18KhxP84Cgf8qkk #Z$  x6 xgghDCgkk #Z$  xP68@P` h88`Xh xP8g-Z.g g\x8Px` hhhxg g gpPg0 'Z(8 h  g{g g0 'Z(8 h  gX  8 X  8IPPXbghPg}PgPqx!(h xP8 g{Jhp`p(Xh@08`h HxP8 pX8>42gg 1g.p'Z(8h g ~gpXgXg`gqgqgzgX@g^)k#Z$ `6`gqg gzgp(gp g)g)gXpf1gzgXp`1gX`1gzplk#Z$ `Hyz`Hglk#Z$ `Hy`Hgvk#Z$ `H6K0`H:glk#Z$ `Hy`Hg #Z$ `H6O0` `H0gp`gglk#Z$ `Hy`Hgk#Z$ `H6)C0kx#Z$ 6Kx`+Hl`Hglk#Z$ `Hy`Hg #Z$ `H6O0` `H0gp`gglk#Z$ `Hy`Hgk#Z$ `H6kC0kx#Z$ 6x)C+`l`Hg(glk#Z$ `Hy`Hgp` gk#Z$ `H6I00@H`  xK`H0 glk#Z$ `Hy`Hg(gp`ggk#Z$ `H6C0kx#Z$ 6xC+`l`H gk #Z$ `H6[xk #Z$ 06)T7l `H0x$ glk #Z$ `Hy`H gpk #Z$ `H6)K`H< g(glk #Z$ `Hy`Hgp` gglk #Z$ `Hy`Hg(gp`gggpk #Z$ `H6)K`Hglk #Z$ `Hy`Hgglk #Z$ `Hy`Hg(gp`gggk#Z$ `H6C0kx#Z$ 6xC+`l`Hgk #Z$ `H6[xk #Z$ 06)T7l `H0xglk #Z$ `Hy`H~gpk #Z$ `H6)K`Hg(glk #Z$ `Hy`Hgp`~gglk #Z$ `Hy`Hg(gp`g ggpk #Z$ `H6)K`Hrglk #Z$ `Hy`Hgglk #Z$ `Hy`Hg(gp`gggk #Z$ `H6[xk #Z$ 06)T7k  8#Z$ 8`H6[7kX #Z$ (6)T7l8`H0x`H(gk #Z$ `06k #Z$ H6`H0glk #Z$ `Hy`Hglk #Z$ `Hy`Hg(gp`ggglk #Z$ `Hy`Hgpk #Z$ `H6kK`H.g(glk #Z$ `Hy`Hgp`gk #Z$ `H6I00@H`  xK`H0glk #Z$ `Hy`Hg(gp`ggpk #Z$ `H6K`Hg\k #Z$ ``glk #Z$ `Hy`Hgpk #Z$ `H6)K`Hg(glk #Z$ `Hy`Hgp`gglk #Z$ `Hy`Hg(gp`g4 ggpk #Z$ `H6)K`Hglk #Z$ `Hy`H. gglk #Z$ `Hy`Hg(gp`gggpk #Z$ `H6K`H#gk #Z$ `H6[xk #Z$ 06)T7l `H0x!glk #Z$ `Hy`H#gpk #Z$ `H6)K`H#g(glk #Z$ `Hy`Hgp`#gglk #Z$ `Hy`Hg(gp`g^%ggpk #Z$ `H6)K`H$glk #Z$ `Hy`HX%gglk #Z$ `Hy`Hg(gp`ggg\k#Z$ ``2&glk#Z$ `Hy`H'gpk#Z$ `H6)K`HJ'g(glk#Z$ `Hy`Hgp`'gglk#Z$ `Hy`Hg(gp`gg\k#Z$ ``*gk#Z$ `H6a00%Z& ak 8#Z$ 8`H6a%Z& (a+l8`H0`H(*g(glk#Z$ `Hy`Hgp`ggglk#Z$ `Hy`Hgpk#Z$ `H6)K`HT,g(glk#Z$ `Hy`Hgp`ggk#Z$ `H60kx#Z$ 6x+`l`H-g(glk#Z$ `Hy`Hgp`gglk#Z$ `Hy`Hgk#Z$ `H6kC0kx#Z$ 6x)C+`l`H/g(glk#Z$ `Hy`Hgp`81gk#Z$ `H6I00@H`  xK`H081glk#Z$ `Hy`Hg(gp`ggqg ggg g g g0'Z(8h g{g g0'Z(8h g8 X 0IHHbgPg}PgPq`!(`H0g{X2p8  hxPH0g@8`H0`H(gg #Z$ hHPh'Z(@H0Hhg4'Z(g4'Z(g{@0g2Hhgg$ @"#Z$0g$ @"%Z&0gzk@(gzgJk(@ Ng^ aagPq#Z$UbgVn`gaagPgD&g.@K gk@#Z$ 6X)C@k 8#Z$ 86Cx`7Hl8jgb@%Z& 6`g)D glPqk@#Z$ 6O@`@ggfk@#Z$ 6`gg^qX@%Z& 6gg@)agPqagPq'Z(@Vq888ggggqg xg0 Xp@"#Z$pg0 Xp@"%Z&pg g g g{Hhh(x`ph8@x`H a Z S S S S^C8q`8`8`8`brU@@@8`8a`P`__SRP_4(s__SRP_5 \\__SRP_6~4__SRP_7 rU@@@@~x !$Q%&(.11346aQq!#0q22QNA3NaPUZp B1PNRA?W!XXQbqd:>aXbQdkmoasuvAa==<pA<9m!m9:Q:6r=yAx7:;~~aa!Q}QxyAyу1ф1MaMq}t1Aq AAњ?Q1qaA!Q!Q1aQu4gg&Z"gJI(g,`gJI(g"qng6`KgrHxIIHggg g ZPg>8Pg  Zg (@Xp0`x Z`PgZPgZ g2 `xZ g{ggh`ZH VTgh`ZH VTgLZ8  Xg4p Z8 g.pZ8 h g8 Z8 Hg gAg gpAg8 Z8 Hg0Z8 h g4p Z8 g{4L&P H , ggbx&Z' H0(`H0g>@H!H)KHg&(Z"(gJIHH0(0Hg,H`HgJ*IHH0(0Hg,H`HgJIHH0(0Hg"qng  Z@"g  &Z'@"gL0+IHH#(H0g{gg 8Ph`x,&Z'p$g-gZ.x&Z' H(HgXEH0!0x/KH0gZ.x&Z' H(Hg p0ggZ)x&Z' H(Hg0gg*H1Hg\1k x&Z' H(Hg` x&Z' H0(2H0g 8Ph`x,&Z'p$g  &Z'@"g  Z@"ghxZH HVTHghxZH HVTHg% gg p-g` x&Z' H0(1H0g` x&Z' H0(2H0gx&Z' H0(!)KH0 g0 gg p0ggg{@, L&D(H0pggLg7gbg"gg8gg9gg*pl@(g.(3(g4g g az AZ 09 -> .> _> ~> >gT g  >*gT g pg^:@(5(O`gT( gg^;@(5(O`gT(gg@g:7I((`6(ggvppJX@p{&(*ggDg7gpg2EUFU2s2gg GZHg&GZH"gIDjgDJKPgp=gPgLPgMPgKPgppGZHH>?" x=ghP xphgLPgNPgKPgppGZHP>?" x=ghP xphgXLPgOPgKPg1agxPxgfLPgPPgKPgp=gxPxg QZRg0SQZR0@Ag BgCgQZRg BgDDgDdgTDNgDgL8UIPP#(P8dggEgggqg 4gDDg VZWgDtgTD.g VZWgDtgFD\gFtggggv (P,V xphP8LggDg0>BgYXggZgg.7[Xg.\@h]g&^_`g qag"b`gggvLP,gg g"degVp@d fghijg>  8P g$  c gVp@d kghijg>  8P gHlmpn  8lX@oX"qx`#( x`Hggg&dpg&dqgg{@h x`HggrD<gsg gg&'Xgp @kP&Z' P8( tKP8g ggx @qkP&Z' P8(q KP8g^ @kP&Z' P8(P8g ggXhg g0(P,pX,P8gg$sDu'Hgrg gg&'Xgp @kP&Z' P8( tKP8g ggt @kP&Z' P8(q KP8gb @qkP&Z' P8(P8g ggXtg g(P,pX,P8ggvVg2wrggggs 8gg07zXV{g^|I8x8y`gv`D &ggpg7DFggpggD@}KKgDL@~`ggLpqZ@ephx`g0x(qKvgg`ggx`&ggpL&h`x&ptggLg4@`gqjgZ@p pah4hpg&aqz`2Ng`qP@p p8`p8ggngvt@,hp8ggzgg>gkZ P8 8Z@eP8gqkZ P8 8Z@eP8grkZ P8 8Z@eP8ghPVr8Z8 @pAVrZ8 @pA2VrhZ8 P@pA2 P8hPjgpggqgg $gz>gpgggpL&nP8hPggBxegg4Ug{ @k DggBegqg<g4Vg{ `D  Ngg@Tp@XX@T(7lXgfgg,@g @2X(pgg2@vp>7D&Hgggqg 0p@`gg7D6gfggqg 0`@Vgg$@p>Bgfgg7Dpggg @}axI``H(H``Hg,gZxI@(`gDgggqg @2`H ggfkZ x`(`x`gLgPggpPqxkZ `(x`g{` @&x`\ggL@pI#(p@g{\8,p@\ggL@pI#(p@g{\8,p@\ggL@pI#(p@g{\8,p@\ggL@pI#(p@g{\8,p@\ggL@pI#(p@g{\8,p@  gg(@Xp,Zp$g xZ x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@vlZ (@XpOZ@ xX `@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(g(@Xp,Zp$g(@Xp,&Z'p$g{0 @J xX`@(2 gg(@Xp,Zp$g xZ x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@vlZ (@XpOZ@ xX `@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(gxZ0 x`vlXZ X@(@Xp(OZ@ xX`@(g(@Xp,Zp$g$ ,&Z'0g{ @J xX`@(gg g.7Xg>8?gwgg$cg.7Xg>8?$gwgg$cg.7Xg>8?gwgg$cg.7Xg>8?`gwgg$cgwx0@ gggpg(7dgpgggpggpP8< gggpZ @((Z@e@(gpZ @((Z@e@(gpZ @((Z@e@(gpZ @((Z@e@(gp Z @((Z@e@(gp Z @((Z@e@(gp Z @((Z@e@(gp Z @((Z@e@(gp Z @((Z@e@(gpZ @((Z@e@(gpZ @((Z@e@(gpZ @((Z@e@(gpZ @((Z@e@(gX@pC(XC7l@Pgp g*@pK@gp g@pC(XrC+C7xH`C07CrC+p7X(@C7C7hCP78 C7C`xrCH+07C7l@H(h` gpggpH b (@(xH0pX(hP8`H0 aS S "a $h   Z  "a  &o  &o  Z  S   S"a    Z    $h $h  0$h $h   ,$h !$h $ ("a %S 'SS )S *SS -S .S Z  1 Z , PCX` AqPPC@A`PP! `OOX ` !AaPFOXQ ` AaPFO@` O8! `P `PP@1 `1P8 ``! ` !^aPP`A` !^aPPP`aPOPA`aPOP`1aPOPA!`QaPOP"`qFP81%`8&`8Q#`8)`8*`8Q`8-`8.`@Q`QO@!1`ObrU@@8!/`Q`i\gg8` Z  Z\rU@@@x8`p8brU@@8 Z11__SRP_8 __SRP_9__SRP_a~__SRP_b $46& A?1MQ`1  `i$ggp>2g g>PgggRV vggggh(@Xp8P  Z pg.p 8g(p8h g2 8Hg~V r080@qA0`g`qlp Z ClZgblp@  Z gg`qlp  Z ClZgblp @  Z gg`qlp Z ClZgblp@  Z gggh(@Xp8P  Z pg2 8Hg*8h g0 8g pg0D D0`"a "aZrU@@@xH`8qbrU@@@@~x  brU@@@ 4brU@@@8__SRP_c__SRP_dj__SRP_e __SRP_fL P1JaJQ`1 DrU@@@ xbrU@@8P<A< fg1gagfhggpghxhi !iQQi`igd!eQe!e!RQR1Z !iQ!j`9 hRQjjgjh) t(gg`g(80g~g`g0@8gg`gg888gg`gg88"a "a Z  Z   Z ZrU@@@@hyQP@hP8`88! `8brU@@@8qpppqAp`QRq__SRP_10^__SRP_11j__SRP_12__SRP_13)      !"#$%&'(*+-./01246789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijkmnopqrstuvwxyz{|}~1ZhQj!rphRxgQrhigdbDrU@@@brU@@81{a{{{{`QR1ZhQj|phRxh| !iQ!j`ighgdcp$ggg$8 Z  Z\rU@@@8`P8brU@@@8P aQ`1 __SRP_14,__SRP_153jdialogLogon5 ThisWorkbook!lDrU@@@xb& ~  ҭmt|BB5go9@2ZMN؊#L.ds:'/CCפAqx:'/CCפAqt|BB5gME8PSPSSS>" <0{39916F02-E381-40B8-9A32-5A9D8FA2D04D}{D8BB044E-238A-4C82-98AC-2E6403E8E273} % % Ah+pxi,!h+i ``k `Pk % %b`@`(~pxHH`h`0pH4560S8(`(xxXKZ$*\Rffff*0Y5aaa4d26$*\Rffff*0A5aaa4cbc hpx"  B (0"8  @ P `"h  p  ]@( 'm` 'mH !' B@}o` !' B@oh`Attribute VB_Name = "dialogLogon" Bas0{39916F02-E381-40B8-9A32-5A9D8FA2D04D}{D8BB044E-238A-4C82-98AC-2E6403E8 E273} dGlobalSpacoFalse CreatablPredeclaIdTru BExpose0Templat@eDerivCustomizDP m_sResult As Sng Property PLet ()  = @ End " (G()8$C=I $-Sub tonCancel_Click&(D$%SpbdsheetOneConstants.RESULT_CANCELLEDCMe.Hidb% 1ivLIGOK|OKRҭs#pLⒷd8OE@z{ FfnAȽs;xfnAȽs;LⒷd8OE@z{ ME(SLSS6"N0{00020819-0000-0000-C000-000000000046} .`+p Xx%%*%PXXxxpKZ$*\Rffff*0?5aaa4cbc`" ophѰAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomi6zD2P Sub _Open() End 4~ҭ~˼Zn RB`uZG*4"'~NF.{{>lS#^CxS#^C˼Zn RB`uME_VBA_PROJECT1dialogProcessing" #dialogNoPermission&^SpreadsheetOneCustom*"$*w     k !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~a  *\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.8#0#C:\Program Files\Microsoft Office\Office15\EXCEL.EXE#Microsoft Excel 15.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\System32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.7#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLL#Microsoft Office 15.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{7D869F11-C2E1-4F05-8237-FF6D19409819}#2.0#0#C:\Users\CHRISD~2\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{F5078F18-C551-11D3-89B9-0000F81FE221}#6.0#0#C:\Windows\System32\msxml6.dll#Microsoft XML, v6.0*\G{F935DC20-1CF0-11D0-ADB9-00C04FD58A0B}#1.0#0#C:\Windows\System32\wshom.ocx#Windows Script Host Object Model KZ ҭ ThisWorkbook0?5aaa4cbc+ThisWorkbooks Sheet10@5aaa4cbc1 Sheet1KT`P Sheet20B5aaa4cbc} Sheet20dialogLogon0Y5aaa4d26dialogLogonmH .SpreadsheetOneUtilities0<5aaa4cbc>.SpreadsheetOneUtilitiesh0Hx`2 dialogProcessing0Z5aaa4d26 dialogProcessing~x$dialogNoPermission0[5aaa4d26$dialogNoPermission ;(SpreadsheetOneCustom0;5aaa4cbb(SpreadsheetOneCustom0`x.SpreadsheetOneConstants0A5aaa4cbc.SpreadsheetOneConstants=Z" Sheet30]5aaa4d26 Sheet30x`H-CazD.ԓI̤{a$03G -/Anxby`J$oJ&4Hj0PJ,_D~L0u;@~Ho"VuE3Z> v Excel+ VBAWin16~Win32Win64xMacVBA6#VBA7# VBAProjectstdole`OfficeuMSFormsCMSXML2OIWshRuntimeLibrary ThisWorkbook| _Evaluate Workbook_Open Sheet1Worksheet_ChangeSTargetFRange  rangeChanged (HAS_AUTO_RUNd (Auto_OpenV  SpreadsheetOneUtilities( (bLoadingData^rCellsCount0vProtectfPassword(PROTECTION_PASSWORDFContents=UserInterfaceOnlyNAllowFormattingCellshAllowFormattingColumns<AllowFormattingRowsAllowInsertingColumns}AllowInsertingRowsHwAllowUsingPivotTablesfAllowInsertingHyperlinks 9AllowDeletingColumns"AllowDeletingRows0 AllowSortingK_AllowFiltering8 Application*ScreenUpdating!  EnableEvents CalculationhxlCalculationManualWorksheetFunction&CountA38 EntireRowAddressRowxlCalculationAutomatic Sheet2 dialogLogonR m_sResultResultursResult buttonCancel_Click SpreadsheetOneConstants(RESULT_CANCELLED'Hide9zbuttonOK_Click1 (RESULT_OK| sFilenameasPartseSplit)ErroRaise vbObjectError Activate|Number-appExcelVisible WorkbooksBPath2Shapes<ItemzOnAction AutoRecoverdEnabled۪ (PrepareData_J sFirstOpen iArrayPartsbAiCountlValueKUCase5 xlSheetVeryHiddenMsgBoxR (IS_FIRST_OPENk((DEVELOPMENT_MODE>(DATA_ID(DATA_COLUMN_IDxlSheetVisible SpreadsheetOneCustom (DownloadDataQ(EncodeUriComponente sComponent_ bSpaceAsPlus lStringLeneasResult iCharCodeOGsChar<  sSpaceCharZviCursor&Asc!uHexJoinM&(ExecuteSecureRequestsCommandKsDataX bShowLogonG sLogonStatus sRequestData sResponseDataWiRetries (RESULT_FAILEDh(RESULT_SUCCESSShow(REQUEST_COMMANDk(REQUEST_USER_IDM^ textUsername}n(REQUEST_USER_PASSWORD  textPasswordW(REQUEST_DATA_IDv (REQUEST_DATA_VALUEr dialogProcessing  labelProgress}(ExecuteBasicRequests (RESULT_DENIEDHO dialogNoPermissionAxmlHttpRequest sRequestUrl#}(DEVELOPMENT_URLI(LIVE_URL& CreateObject(XMLHTTP_OBJECTIDHsetRequestHeader#7Send ResponseTextw(CreateDropDownCelli RangeTarget7 sRangeSource Validation DeletexAddrxlValidateListĤ AlertStyle7xlValidAlertInformation͈Operatork xlBetweenkFormula1ClearModify& sRangeTarget[ Description  IgnoreBlankRInCellDropdown9(LookUpIdFromValueKsValue$iColumnsDefault (DATA_STRING_SELECT irowindex(HIDDEN_COLUMN_DATA_START(DATA_ROW_MAXIMUM(HIDDEN_COLUMN_END_RECORD_VALUE(LookUpValueFromIdesId(GetDecimalValue̽vValueh IsNumeric$*Round(ReturnMyDocumentsPathyMws_WshShell0SpecialFolders(CheckRangeContainsG sRangeName|sStringToCheck}found+Right cellyRemoveCharactersyInStringYintLoopCounterintStringLength: intASCIIVallLCase: (GetLastRowRangeOnefrangeTwo rangeThree.iRowq bRowNotEmptyc(DATA_ROW_START (AppendElement± xmlElementIXMLDOMElementsNamedxmlDataElement OwnerDocument createElementH appendChildb(AppendAttributexmlDataAttributeIXMLDOMAttributeQ|xmlValueAttribute(createAttribute  NodeValue<setAttributeNodeQ(GetBooleanValueEBsBool k (GetIntValue{wsIntA(GetStringValuewesString (GetDateValueRsDate\dDateIsDate2 DateValue/(UpdateErrorColumnUsMessagemsExistingMessage_(ERROR_COLUMN_IDKvbCrLf(messOneAA(messTwo0] (messThree(messFourq(messFiveQ (LockSheetsMtrueeTvColumnsp9Locked RowsU (UnLockSheets Unprotect?(GetXMLDocument~o (IsValidDate (MIN_DATE_TIMEY5 (IsValidRowmRangeRec~u RangeIRASQ RangeNameRange8mRange9nRange10Range11Range12Range13Range14Range15Range16Range17sResponseDocument rangeSelected_xmlDataDocumentxmlDataDocumentToSavexmlNodeToDelete1 IXMLDOMNode5xmlNodeCxmlMetaSubmissionNodeUaxmlColumnNodeListIXMLDOMNodeList^ xmlColumnNodegk xmlTypeList xmlTypeNodegxmlRowNodeList xmlRowNoderxmlShortenedLRNElementxmlLRN  xmlFoundNodeg xmlAttributexmlMetaAttribute,{ sColumnNameBmranger rangeFreeze iHiddenColumnDataRowIndexh iColumnCountͪiHiddenColumnIndex %iHiddenColumnDataCountysTypeYqsHidden sWrongDate3sYearsMonthsDaysHint  ErrorHandlerO(REQUEST_MODE_DOWNLOAD_DATA1^LoadXMLDSelectSingleNodeW ParentNode RemoveChild(HIDDEN_ROW_CLASSO(HIDDEN_COLUMN_CLASSReplacefDocumentElementEnodeNamer(HIDDEN_ROW_XMLǗ(HIDDEN_COLUMN_XMLPXMLK Attributes getNamedItemU(DATA_ROW_COLUMN_HEADERSD SelectNodesg ClearCommentsf (HOVER_HINT_ID!  AddCommentCommentHsshapeHeight|(HOVER_HEIGHT_ONE_LINEV(HOVER_HINT_TARGET_NUMBER%I(HOVER_HEIGHT_FOUR_LINEB(HOVER_HINT_TARGET_DATE_AGREED}(HOVER_HEIGHT_THREE_LINE(HOVER_HINT_TARGET_DATE(HOVER_HEIGHT_FIVE_LINE(HOVER_HINT_RECRUITED_AT_TARGETVg"(HOVER_HINT_RECRUITMENT_CLOSED_DATE(HOVER_HINT_TOTAL_RECRUITED@(HOVER_HINT_COMMENTS'(HIDDEN_COLUMN_DATA_HEADER8(HIDDEN_COLUMN_DATA_SUBHEADER. ChildNodes5checkoCheckBoxi{ CheckBoxes̍xlOff' DateSerialUActiveWorkbookNamesοRefersTo SelectionZ EntireColumnHidden]iEndRow}Interior;Color2F (CheckDatae (SetFreezeLvbOKOnly (UploadData& xmlDocument} xmlDocumentColumnSettingsxmlDataColumnSettingsElementxmlColumnSettingsElementi xmlRowElementxmlClassElement(xmlValueElementi iColumnIndex sSettingXmlsVisible bValidData sNodeNameJ sDefaultValuemAsXml JlistCheckedRows CollectionW (DeleteRows checkDeleteb[ ColorIndexvbYesNovbNo%(OPTIONS_COLUMN_IDC asDeleteIdi`(REQUEST_MODE_DELETE_DATAv(REQUEST_MODE_UPLOAD_DATA=asCheckedAlreadyR asDeletionsn" iCheckCountiDeletionCountsChecksv= sDeletions ActiveWindow+ FreezePanesMzColumni sSubmissionIDwsConfirmationID-iDeletedRowCounti iRowCount: sCellValueZ(RESULT_DENIED_MESSAGE_(HOVER_HEIGHT_TWO_LINER+(DATA_STRING_NEWZ  Sheet3Workbookk WorksheetChange_Defaultj _B_var_UCaseaUserFormNbuttonOKImage1_ groupLogon8 labelEmailO labelPasswordLabel3,Image2` buttonCanceluflabelCopyrightbClick groupLoadinggroupPermissions8Image3a_B_var_iCursor _B_str_MidX _B_var_HexUCaptionx_B_var_sRangeTarget_B_var_irowindex _B_var_LeftQ _B_var_Right9 _B_var_celly Q _B_var_LCase' _B_var_Midp_B_var_xmlValueAttribute _B_var_Format _B_var_trueeA:_B_var_iEndRow_B_var_i _B_var_rangeFreeze_B_var_iRowCount   "$&(+1}#?$@ p!` "J@ "KT0L (PSPSSS6"<0<8<0{9D7F0817-1613-475A-910F-2A342293277E}{000F4EE1-F98F-46C0-B32E-F0E47B7B3E6C}8 0%h8% % %8xHHpKZ$*\Rffff*0Z5aaa4d26`hpx xAttribute VB_Name = "dialogProcessing"  Bas0{9D7F0817-1613-475A-910F-2A342293277E}{000F4EE1-F98F-46C0-B32E-F0E47B7B3E6C} dGlobaBlSpacoFalse Cre atablPr@edeclaI"dTru BEx0pose0TemplateDerivCustomizD G5ҭ Z^ch?QNkyFH܍j*K@d.'NW^E/E8OASxE/E8OASZ^ch?QNkyFHME0PSPSSS6"<8<0{806A8DDC-2AF1-4BA7-A108-D1E9E3F5ADD9}{D6F56440-272E-4E9F-A4B4-AB57971D5EF5} `@kP Xx%x% %8 %KXXPKZ$*\Rffff*0[5aaa4d26`hpx" ( B@o`XAttribute VB_Name = "dialogNoPermission"D Bas0{806A8DDC-2AF1-4BA7-A108-D1E9E3F5ADD9}{D6F56440-272E-4E9F-A4B4-AB57971D5EF5} dGlobalSpacAoFalse CreatablPredeclaIdTru BExpose0Template DerivCu@stomizDP Sub tonOK_Click() Me.HidHEnd ID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Module=SpreadsheetOneUtilities Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} BaseClass=dialogLogon BaseClass=dialogProcessing BaseClass=dialogNoPermission Module=SpreadsheetOneCustom Module=SpreadsheetOneConstants Document=Sheet3/&H00000000 nJ)(.,ҭxME8( 0(6 )L!L !L)L(  > "L"LL "LLL<<< <(<0<8<@H(%`X@`@8`B0`D(`F ``H`J````L`N`P``R`T H(% `pXk` ` X% x% % `% %  % &%`X`@`D`:`F`@p `Hh```PX`P `H`@`(8`0 ((0% hp(%   `8k22 x% % % % %   % &8 %`X```D`:`F`@ `H x` p`P h`` ` X`P`H H @ 8% 8   X 0(  ` (` `0 `   `(k ` k33 X (% x %`X``D` `:`F`@ `H ` `P` ` `x` p` h` ``X X`p  @%xh 80( pX@X@J0|f@ @ @ @ @0 (f| /@p @`X @P @H @H0 @x @ @ @ @  @O  @ @` @0x @H` @H @x0 @ @ @ @O   @@O 0 X @hO @@O h `6*@@ @ hI@T/A@O Z@8 @Px @hp @h @` @X @P @H s}@@O x@P( @  `@ pX8(@8 Hxf0@@` @X @p @ @ @ @x @x @h @P @08 @ Nh|@P @ @ @ @ @ @h @ p @X @P @H @0 @ @ @ @ @p @ @( @@ @Xh @P @8 @ @ @ @ @ @ @ H@ @P @ xl@h l @` 0A@@X p 0 H `  x ` @ x f0@N@ @  @8 @P @h @ @(x @` @H @0 @p @ @ @@ @X @ @ @ @0x @` @H @@ h|@8 @H @` @x @ @ @8 @ @ @p @ X @P@ @h( @ @ @ @ @ @ @ @ x3A# X 06w5A@ @ @( @@ @ @p @ h @P @H @>0 @ @  ( ! @ H"`"!!!0|6@!@ @ ( @" @" @0" @" @" @x" @" @" @ @"p @#X @h#@ @8 @ # @8# @P# @# @# @# @# @#x @#` @H @$0 @($ @@$ @X$ @p$ @ p P0KZ$*\Rffff*0;5aaa4cbb*\R1*#278*\R5*#0*\R5*#3*\R5*#8*\R5*#9*\R1*#2a6*\R0*#1d*\R1*#317$*\Rffff*0A5aaa4cbc$*\Rffff*0@5aaa4cbc*\R1*#129$*\Rffff*0B5aaa4cbc*\R1*#3c7*\R1*#12d*\R1*#11c$*\Rffff*0<5aaa4cbc*\R1*#92$*\Rffff*0Z5aaa4d26*\R0*#17*\R0*#f*\R5*#4*\R1*#11*\R0*#13*\R1*#136*\R1*#2d8*\R0*#14*\R0*#16*\R0*#1*\R0*#e*\R0*#2*\R1*#274Q Z >` T * Z( F B @ (X Z R Z8  Z "    L0 J N N  Np 6  > LH         ( 08@ H   PX`hpx       $$ .   8DH  4h$&         @  P  X  p 4     >   4  0  @ P X 0` F  V (0 F0 &fH $0p 0J   B : H8 :P 6h   : H : 6 H .JP   @ : H :6 P X:xH:6      (  8 P`h 80p "@ 4  \8  P X hxf&| . f(&|HBp 4 f&|8` <h f&| H `pf&| 6 f(&|HBp 8 f&|8` h f&|    (z 8@ ^x *b 2  *( Z@ 2<( 8b@$f`     R> (@H X p   b *^     (  8H  :X "  @   @LX  p  (   "b DL`b V0 8 @4L`J b  L @ f`  $$f 0 8L@ b  v     ( pH  *^h  p  *^  p  *^!H!P! X!p!x! ! !! 4!F!  "t8"`"p"  "  |" 4# @#  `#  <p# J# # #$$$($  0$@$H$P$ @`$(@$  $8$ $$ z% J% % *& R0& .& ,& ^& H'  `' Fx'' ''' (Z'   ' ' "(( ^( ,~8( ,zh( ( (  (  (  ( ( (  () ) 0) () 0) 08) H)\P) )") ) N) L * 8p* * >* L* H+P+ X+`+ h+p+ x++ +  ++++++++++++++,,  , , (, .0,  8@,x,6,  ,  ,,,,  , -^-0- @-  H-  X- h- - - --*^- `-   .,z.  2H. &. 8. 4. :/ X/ / 0  \0 6x0l0 v0l0N1`1h1  p1l1>1l1d2h2p2  *x2 l2L2F(3l`3303l3X(30484  4@4Vx4<4 l5v05 D(P5 l5 5 5 l5 N(5 86@6 H6 pP6 lp6 6 l6 n(6 (707 87 V@7<7 l7v7 D(8 l`8 8 8 l8 N(8 99 9 p9 l89 X9 l`9 n(9 99 : x:0: l: l: t(: h;p;x;  ;l;.p;V(;lH<h<0p<l<`(< =(=  0=*pH=\x= l=v= T(= l0> P> X> l`> `(> >> > p> l? 8? l@? (`? @@@ + + @*p8@<h@ l@v@ P(@ l8A XA `A lhA \(A AA A pB l B @B lHB (hB BB C   C\ Cl@Cv`C8(ClCC ClCF(DPDXD\`DpD B(D l8E XE`EhE   (pElEpEN(El(FHFPF>XFJ(FlFGG   Gl0GLPGB(GlGH0Hl@HX(`HHHH H H HH TH  PI 4`I  J JJ J  J J J     |J |pK |K |pL .xL   M @M  ,~PM M M  M "pM MM *|MN "r(N $PN  xNN  8N N 0NNN  N  O   O (O 60O 6hO .zO O bO O X\O PP R\hP P  PP  J\P  8Q PQ hQ   Q QQ  Q  4Q Q  \Q R  |R |R |S |S       T (T ,~8T hT pT     xT "pT  T T *|TU  "rU  $8U  `U pU  8U U 0UNU  U  U   U *^V `8VXV`V.zhVVfV  VX\V 0WR\HW W  W@W DX*PX X X XNdXfY0Y 8Y$PYxY $YY$YY$Z8Z@Z  2HZ Z J\Z Z [  [  8[ @[X[ p[ x[["r[ 4[ [  [ [   [ \ \  (\\@\ `\ h\  p\ \  0\\ \ \ 0\X\  ] "(]  ,0] :`] ]] ]] ]] ]  ]]]]]^^^^ ^(^0^8^@^ H^P^X^`^h^p^x^  ^  .^ ^ ^ 8^^6^  (_ @_H_P_  X_ h_^x__ _  _ ____  _  _ ` ` (` 8`,zH`  2x` &` 8` 4a :Ha a  b 8b  \Hb 6blb vcl cN@ccc  clc>cldd0ddd  *d ldLdF(Helee0eleX(f`fhf  4pfVf<gl@gv`gD(glgg glgN(hhhph xh phlh hlhn(hXi`i hi Vpi<iljv(jD(Hjljj jljN(j0k8k @k pHklhk klkn(k l(l 0l x8l0llllmt( mmmm  mlm.pmV( nlxnn0nln`(nPoXo  `o*pxo\olovoT(pl`pp plp`(pqq q p(qlHq hqlpq(q0r8r@r # # Hr*phr<rlrvrP(slhss sls\(st t (t p0tlPt ptlxt(t u(u 0u  8u\Pulpuvu8(uluv vlvF(8vvv\vpvB( wlhwwww   (wlwpwN(xlXxxxx>xJ(xly8y@y Hyl`yLyB(ylz8z0@zlpzX(zzz z  {{{  { ({ 0{  08{ H{ P{ X{ 0`{\p{ { "{ ${ 4| 4| (| "0| 8| 6H| | >| L|  } (} 0}8}@}H}P}X}`}h}p}x}}}}}}}} $}$} } ~ J~ *^8~ &Vh~  .~~ >~ (b~ (  HfPp (^x *      8 @ H P VX V V V` V V Vh " " &0 X L` L  < *H "x  \  0 @ nH  8 l h  2 Ȇ VІ ( 0 8 @ bH  d  P( Nx >Ȉ  4 H DP  & ȉ .Љ    d  P N؊ 8( ` 4h  D  &  .( X ` h dp ، P N0 6  4  D H &P x .    dȎ 0 P8 N 2؏  4 P DX  & А .ؐ    d  P N >0 p 4x  D  & 0 .8 h p x d  P N@ 4 Ȕ 4Д  D X &`  .  ȕ Е dؕ @ PH N : ( 40 h Dp  &  .  ( 0 d8  P N 6H  4  Dș  & @ .H x   d  P NP 2 ؛ 4  D h &p  . М ؜  d P PX N * ( 40 h Dp  &  .  ( 0 8 @ :H  \  (  0 8 @ H P X *` J J 0 8 @ XT************************************************************************************7 Copyright (C) Exbos Limited 2012. All rights reserved.N Exbos Limited is a Limited Liability Company registered in England and Wales.$ Registered company number 06130291.8AS***********************************************************************************? THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY< OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT9 LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND" FITNESS FOR A PARTICULAR PURPOSE.S***********************************************************************************K THIS CODE IS LICENSED FOR USE ONLY WITHIN THE NIHR ONLINE FINANCE PROJECT.S THIS CODE MAY NOT BE USED IN ANY OTHER PROJECT, EITHER WHOLY OR PARTIALLY, WITHOUT PRIOR WRITTEN PERMISSION.S*********************************************************************************** F This function is called automatically the first time a spreadsheet isD downloaded from the system. Any user and data information passed byG the file name will be available in the constants module at this point.G You can use the utilities module to make any required requests back toH the system and perform any required authentication. The function should0 populate the spreadsheet ready for use offline. 7Exbos LimitedECreated]x]]]]]] ]@]`]]]]]] ]@]`]]]]]]]0]H]`]x]]]]]]] ]8]P]h]V0 Unprotect J 0B J |B f(j1 Request the return data document from the system !X $'- Must have a successfull response to continue  !   |(  0(|  !e  |(|k Show processing form B@A@ Load response .  %Z  |(  0(|@k87 cuts off data if saved to cell - so try to remove data .  %Z  |(  0(|k//Rows %\.  !^B@`Save Class Name !h!jDataTableDataExportContainerOf$f !b !d |%B(//DataColumnSettings %\.  !^B@` !p !l !n |%B(//MetaSubmission %\. SubmissionRangeStartDate !r%t.8 8SubmissionRangeStartDate .%\!dT$#'L L$'N L$'P L$|'R R/ P / N  |%B(dX 8!T$#'L L$'N L$'P L$|'R R/ P / N  |%B(kSubmissionRangeEndDate !r%t.8 8SubmissionRangeEndDate .%\!dT$#'L L$'N L$'P L$|'R R/ P / N  |%B(d 8!T$#'L L$'N L$'P L$|'R R/ P / N  |%B(k Unprotect Set correct sheet 0B Load Columns !v'X'B'F#//DataColumnSettings/ColumnSettings %x."  " FriendlyName %\!d': :CurrentDataService FriendlyName %\!d X B 0%B( X B 0%BB@z'T :Id !|'T T T X B 0%BB@~ ! X B 0%B!!(k( :!Target Number Of Patients Agreed?e !'T T T X B 0%BB@~ ! X B 0%B!!( X B 0%B!!! X B 0%B!!(k@ :'Target Date To Recruit Patients Agreed?e !'T T T X B 0%BB@~ ! X B 0%B!!(k :0Date Agreed to recruit target number of patientse !'T T T X B 0%BB@~ ! X B 0%B!!(k :<Total Number Of Patients Recruited At The Agreed Target Datee !'T T T X B 0%BB@~ ! X B 0%B!!(k0 :)Date That The Trial Closed To Recruitmente !'T T T X B 0%BB@~ ! X B 0%B!!( X B 0%B!!! X B 0%B!!(k@ :,Total Number Of Study Participants Recruitede !'T T T X B 0%BB@~ ! X B 0%B!!(k :Commentse !'T T T X B 0%BB@~ ! X B 0%B!!(k k Fill Column Headers !p ! F |%B( FriendlyName %\!d ! F |%B(Id ! F |%B(Value ! F |%B( ,Get Any Type Id's and Values For This Column !Z'@.//DataTypeCache/item %x.( Tif there are some write them to hidden sheet - to use in ranges and drop downs later * ( ./key/int *%\!d @ F |%B(./value/string *%\!d @ F |%B( @ '@ !^ @ F |%B( !^ @ F |%B( F 'F B 'BkPHLoad Data Rows://DataTableDataExportContainerOfNewPerfDeliveryDetail/Rows %\!., clean sheet'B  " !v 'X X, b] X B 0%B(CheckBoxDelete_ X 0%.  ( X 'X B 'Breset !v'X loop rows . ,4increment active row and reset and keep column count X 'X'B'Dget fieldnames from columns  " store nameName %\!d': :CurrentDataServicecheck attributes : .!r%t.6 6we need to get node : .%\!d X B 0%B(d0we just use attribute !Z D |%B !^>yes get the hidden column ref and get it from look up function 6! -99999911 6!99999911 6! 99,999,911 X B 0%B(d( 6! D*SpreadsheetOneConstants.DATA_STRING_SELECT$` X B 0%B(kdno get it from cellPropertyTypeString %\!dDateTime 6! $'  1753-01-01 X B 0%B(d 6!$ 6!$ 6! $$' If IsDate(dDate) Then _Sheet1.Cells(irowindex, iColumnCount).Value = Format(Format(dDate, "dd/mm/yyyy"), "dd/mm/yyyy") Else$Ridiculous american conversion  X B 0%B( End Ifkd 6! -99999911 6!99999911 6! 99,999,911 X B 0%B(dH 6! X B 0%B(k kkk B 'B D 'Dkbespoke to this sheet X 0%B!Please Select... X 0%B(k` X 0%B!Please Select... X 0%B(k X 0%B!Please Select... X 0%B(kset up dropdowns'F'B  " !Z'@ !Z '- check if look up data exists in hidden sheet @ F |%B! !^ @ F |%B! @ F |%B! !^b @ '@  'x ! F |%B $f-$f/$f?$f:$fLookUp'. !Z F |%B  F |%B$6.< . < !B@4= .'. ! B 0%B 0!!D B 0%B$6., , .A@* Set RangeTarget = Nothing Set ranger = Nothingk B 'B F 'F Formatting'B'F  "Visible %\!d'JPropertyTypeString %\!d'H get range ! B 0%B !\ B 0%B$6B@H If sType = "Int32" Thent If Sheet2.Cells(SpreadsheetOneConstants.HIDDEN_COLUMN_DATA_START, iHiddenColumnDataCount).Value = "" ThenD Selection.NumberFormat = "#,##0;#,##0;0;[Red]General" End If# ElseIf sType = "String" ThenK 'Selection.NumberFormat = "#,##0[Red];#,##0[Red];0[Red];General"' 'changed mind allow anything% ElseIf sType = "DateTime" ThenW Selection.NumberFormat = "dd/mm/yyyy;[Red]General;[Red]General;[Red]General" End If Jfalse !(kp B 'B F 'FHErrors !v ! 0%B( !'X$' X  b'B X ! 0%B($@ X 0%!t!($@ X 0%B!( X 'XPAA Hide processing form B@A@ Clean up.A f(j|V f(jAError during data download - ( !) !H  Download errorA@oH G This function should be called by the "Upload" button displayed on theF spreadsheet main sheet. The function should use the utilities methods1 to upload the completed data back to the system. 7Exbos LimitedECreated]](]@]`]]]]]] ]8]P]h]]]]]]]](]@]X]p]V UnprotectA f(j1check for last row - three empty rows signify end'$'% actually returns first of empty rowsADO CHECKS HERE'''F !'X X  b X ! 0%B( X 'X !'X  bespoke checks !'X  X  b]CheckBoxDelete_ X 0%. X$ !set id$@ X 0%B!(+RW Removed as no requirement regarding thisPlease enter a valid REC number2Sheet1.Cells(irowindex, 5).Interior.ColorIndex = 2-If Sheet1.Cells(irowindex, 5).Value = "" Then3Sheet1.Cells(irowindex, 5).Interior.ColorIndex = 22Call UpdateErrorColumn(irowindex, Sheet1.Cells(SpreadsheetOneConstants.DATA_ROW_COLUMN_HEADERS, 5).Value & " - Please enter a valid REC number")bValidData = FalseEnd IfURW Removed [ Sheet1.Cells(irowindex, 6).Value = "" ] as no requirement regarding this/Please enter a valid Integrated research number X 0%B!( X 0%B!  X 0%B!( X !v 0%B!# - Please enter a valid IRAS numberA'k Trial Name X 0%B!( X 0%B! X 0%B!  X 0%B!( X !v 0%B!9 - Please enter the Name of Trial (up to 2000 characters)A'k #Target Number of Patients available X 0%B!( X 0%B!Please Select... X 0%B! X7Please indicate if Target number of patients is agreed A X 0%B!(' X 0%B!-1$N-1e X 0%B!( XJTarget number of patients agreed: please choose from the drop-down fields A'k -Target Number of Patients Minimum and Maximum X 0%B! Number Agreed X 0%B! Range Agreed X 0%B!$h X 0%B! X 0%B!( X 0%B!e X5Please indicate the minimum number of patients agreedA X 0%B!('d8  X 0%B!( X@Minimum number of patients agreed should be entered as a number A'k d X 0%B! X 0%B!(dh  X 0%B!( X`Please remove minimum number of patients or review the 'Target number of patients agreed' field A'kk X 0%B! Number Agreed X 0%B! Range Agreed X 0%B!$h X 0%B! X 0%B!( X 0%B!e X5Please indicate the maximum number of patients agreedA X 0%B!('dp X 0%B!( X@Maximum number of patients agreed should be entered as a number A'kd X 0%B! X 0%B!(d X 0%B!( X`Please remove maximum number of patients or review the 'Target number of patients agreed' field A'kk X 0%B!$h X 0%B! X 0%B!$h X 0%B! X 0%B! X 0%B!  X 0%B!( X 0%B!( XePlease review minimum and maximum number of patients. The minimum cannot be greater than the maximum A'kkDate agreed available X 0%B!( X 0%B!Please Select... XGPlease indicate if Target Date Agreed to recruit patients is available A X 0%B!(' X 0%B!-1$N-1e X 0%B!( XQTarget Date agreed to recruit patients: please choose from the drop-down fields A'k Date Agreed X 0%B! Date Agreed X 0%B$ X 0%B!( X 0%B!e XEPlease indicate the date agreed to recruit target number of patients A X 0%B!('d X 0%B!( XRDate agreed to recruit target number of patients should have the format dd/mm/yyyyA'kd X 0%B! X 0%B!(d X 0%B!( XTarget Date To Recruit Patients Agreed must be set to Date Agreed to enter a Value in Date Agreed field. All dates entered must be Valid Dates.A'k?k?Total number of patients X 0%B! Date Agreed X 0%B!$h X 0%B! X 0%B!( X 0%B!e XBPlease indicate the total number of patients agreed at target dateA X 0%B!('d> X 0%B!( XMTotal number of patients agreed at target date should be entered as a number A'k>d> X 0%B! X 0%B!(d= X 0%B!( XtPlease remove Total number of patients agreed at target date or review the 'Target number of patients agreed' field A'k=k<Date Trial Closed X 0%B$ X 0%B!( X 0%B!e X*Please indicate the date the trial closed A X 0%B!('d< X 0%B!( X7Date the trial closed should have the format dd/mm/yyyyA'k; X 0%B$ X 0%B!$ |%B$ X 0%B!$ |%B$  X3Date trial closed should be within quarterly windowA X 0%B!('k:k:!Number of Participants Rectruited X 0%B!( X 0%B! X@Please indicate the total number of study participants recruitedA X 0%B!('k9 X 0%B! X 0%B!  X;The total number of study participants recruited is invalidA X 0%B!('k8Reason For Closure X 0%B!( X 0%B!Please Select... X 0%B! X4Please indicate the reason for closure of the trial A X 0%B!(' X 0%B!-1$N-1e X 0%B!( XIReason for closure of the trial: please choose from the drop-down fields A'k87k07 X 'X7k7k7N****************************************************************************** NSome data on the spreadsheet has failed initial checks (see highlighted data). 6Are you sure you want to carry on uploading your data?  dWarning - the system may substitute default data for any data that may break the database integrity. Incorrect data types$ A|X5kP5kH5 Show processing form B@A@u*********************************************************************************************************************u*********************************************************************************************************************u*********************************************************************************************************************u********************************************************************************************************************* ! ! |%B! Load Initial Document . !l !n |%B! %Z|x2kp2'F ! F |%B!'_2  ! F |%B! ' F 'F ! F |%B!  ' .  B@Z !h !hB@kH1Rows %.  !hB get data rows !'XRows to Delete] ! ! |%B! $+    !b !d |%B! %. ID !v 0%B!': get datatype//ColumnSettings[FriendlyName=' :']/PropertyTypeString %\!d'H GetDefaultValue//ColumnSettings[FriendlyName=' :']/DefaultValue %\!d' get value $ $'P//ColumnSettings[FriendlyName=' :']/Name %\!d' HString an attribute   PAdx. a new element   PAk@.  B  ! !p$'k-u*********************************************************************************************************************u*********************************************************************************************************************u*********************************************************************************************************************u********************************************************************************************************************* Load Initial Document . !l !n |%B! %Z|+k+'F ! F |%B!'_0+  ! F |%B! ' F 'F ! F |%B!  ' .  B@Z !h !hB@k`*Rows %.  !hB get data rows !'X  X bCheckBoxDelete_ X 0%. ! X$''D !b !d |%B! %._`) !v  0%B!': get datatype//ColumnSettings[FriendlyName=' :']/PropertyTypeString %\!d'HGetDefaultValue//ColumnSettings[FriendlyName=' :']/DefaultValue %\!d' get value is it a look up !Z D |%B !Z D |%B !^>yes get the hidden column ref and get it from look up function X  0%B! D-1$N'Pdx'no get it from cell Is It hidden//ColumnSettings[FriendlyName=' : ']/Visible %\!d  X  0%B(k& HBoolean X  0%B! $'P HInt32e X  0%B! $'P HStringe X  0%B! $'P HDateTimee X  0%B! $'Pk%k%,right got type, name and value - build it upBuild Container Node//ColumnSettings[FriendlyName=' :']/Name %\!d' HString an attribute   PAd$ a new element   PAk$  ' D 'D !v  0%B!  Bk($ X 'X$ Show processing form B@A@ Execute upload ! !p$'AA Refresh B f(j|X#VP#A f(jError during data upload - ( !) !H   Upload errorA@o"%Dim xmlDocument As MSXML2.DOMDocument3Dim xmlDocumentColumnSettings As MSXML2.DOMDocument]`]]]]] ] ]@ ]X ]p ] ] ] ] ] ] ] ]0 ]H ]` ]x ] ] ] ]0 ]H ]` ]x Vx! f(j UnprotectA1check for last row - three empty rows signify end'$'% actually returns first of empty rowsDO CHECKS HERE'''F !'X X  b X ! 0%B( X 'XP !'X''''  bespoke checks !'X  X  bset id$@ X 0%B!(+RW Removed as no requirement regarding thisPlease enter a valid REC number2Sheet1.Cells(irowindex, 5).Interior.ColorIndex = 2-If Sheet1.Cells(irowindex, 5).Value = "" Then3Sheet1.Cells(irowindex, 5).Interior.ColorIndex = 22Call UpdateErrorColumn(irowindex, Sheet1.Cells(SpreadsheetOneConstants.DATA_ROW_COLUMN_HEADERS, 5).Value & " - Please enter a valid REC number")bValidData = FalseEnd IfURW Removed [ Sheet1.Cells(irowindex, 6).Value = "" ] as no requirement regarding this/Please enter a valid Integrated research number X 0%B!( X 0%B!  X 0%B!( X !v 0%B!# - Please enter a valid IRAS numberA'k` Trial Name X 0%B!( X 0%B! X 0%B!  X 0%B!( X !v 0%B!9 - Please enter the Name of Trial (up to 2000 characters)A'kX#Target Number of Patients available X 0%B!( X 0%B!Please Select... X 0%B! X7Please indicate if Target number of patients is agreed A X 0%B!(' X 0%B!-1$N-1e X 0%B!( XJTarget number of patients agreed: please choose from the drop-down fields A'k-Target Number of Patients Minimum and Maximum X 0%B! Number Agreed X 0%B! Range Agreed X 0%B!$h X 0%B! X 0%B!( X 0%B!e X5Please indicate the minimum number of patients agreedA X 0%B!('d X 0%B!( X@Minimum number of patients agreed should be entered as a number A'kd X 0%B! X 0%B!(d8 X 0%B!( X`Please remove minimum number of patients or review the 'Target number of patients agreed' field A'kk X 0%B! Number Agreed X 0%B! Range Agreed X 0%B!$h X 0%B! X 0%B!( X 0%B!e X5Please indicate the maximum number of patients agreedA X 0%B!('d@ X 0%B!( X@Maximum number of patients agreed should be entered as a number A'kd X 0%B! X 0%B!(dp X 0%B!( X`Please remove maximum number of patients or review the 'Target number of patients agreed' field A'kk X 0%B!$h X 0%B! X 0%B!$h X 0%B! X 0%B! X 0%B!  X 0%B!( X 0%B!( XePlease review minimum and maximum number of patients. The minimum cannot be greater than the maximum A'kXkPDate agreed available X 0%B!( X 0%B!Please Select... XGPlease indicate if Target Date Agreed to recruit patients is available A X 0%B!(' X 0%B!-1$N-1e X 0%B!( XQTarget Date agreed to recruit patients: please choose from the drop-down fields A'k Date Agreed X 0%B! Date Agreed X 0%B$ X 0%B!( X 0%B!e XEPlease indicate the date agreed to recruit target number of patients A X 0%B!('dp X 0%B!( XRDate agreed to recruit target number of patients should have the format dd/mm/yyyyA'kd X 0%B! X 0%B!(d X 0%B!( XTarget Date To Recruit Patients Agreed must be set to Date Agreed to enter a Value in Date Agreed field. All dates entered must be Valid Dates.A'k k Total number of patients X 0%B! Date Agreed X 0%B!$h X 0%B! X 0%B!( X 0%B!e XBPlease indicate the total number of patients agreed at target dateA X 0%B!('dh  X 0%B!( XMTotal number of patients agreed at target date should be entered as a number A'k d X 0%B! X 0%B!(d  X 0%B!( XtPlease remove Total number of patients agreed at target date or review the 'Target number of patients agreed' field A'k k Date Trial Closed X 0%B$ X 0%B!( X 0%B!e X*Please indicate the date the trial closed A X 0%B!('d  X 0%B!( X7Date the trial closed should have the format dd/mm/yyyyA'kp X 0%B$ X 0%B!$ |%B$ X 0%B!$ |%B$  X3Date trial closed should be within quarterly windowA X 0%B!('khk`!Number of Participants Rectruited X 0%B!( X 0%B! X@Please indicate the total number of study participants recruitedA X 0%B!('kx X 0%B! X 0%B!  X;The total number of study participants recruited is invalidA X 0%B!('kReason For Closure X 0%B!( X 0%B!Please Select... X 0%B! X4Please indicate the reason for closure of the trial A X 0%B!(' X 0%B!-1$N-1e X 0%B!( XIReason for closure of the trial: please choose from the drop-down fields A'k X 'XkkA@AA f(j|VA f(jError during data check - ( !) !H  Data Check errorA@o(  0%B!v$6!H'> ( (o  / Physically deletes rows from excel spreadsheet 8Exbos LimitedFCreated]@ ]` ] ] ] ] ] ] ] ]( ]@ ]X ]p ] ] ] ] ] ] !J 0B !J |B$ ! ' !v 'X X  !v   bCheckBoxDelete_ X 0%. !CheckBoxDelete_ X !] X 0%B! X 0%B!  ! ! |%B!'    X 0%B!'d X 0%B!'k  ! ! |%B(dXA XX X$6!t(k kk X 'X !J 0BF !J |BFA@AAoO*******************************************************************************O*******************************************************************************O*******************************************************************************O*********************USED TO POPULATE CHECKBOXES ON SHEET**********************O*******************************************************************************O*******************************************************************************O*******************************************************************************Public Sub CheckboxBuild() Dim irowindex As Integer Dim iFromTop As Integer Dim iColumnCount As IntegerF Call Sheet1.Unprotect(SpreadsheetOneConstants.PROTECTION_PASSWORD)F Call Sheet2.Unprotect(SpreadsheetOneConstants.PROTECTION_PASSWORD)6 irowindex = SpreadsheetOneConstants.DATA_ROW_START$ Application.EnableEvents = False Do While irowindex < 300U Set cell = Sheet1.Cells(irowindex, SpreadsheetOneConstants.OPTIONS_COLUMN_ID)* cell.EntireColumn.ColumnWidth = 15h Set check = Sheet1.CheckBoxes.Add(cell.Left + cell.Width / 2, cell.Top + cell.Height / 2, 70, 7)2 check.Name = "CheckBoxDelete_" & irowindexe check.LinkedCell = Sheet2.Cells(irowindex, SpreadsheetOneConstants.OPTIONS_COLUMN_ID).Address check.Caption = "", cell.Font.Color = RGB(255, 255, 255)O Sheet1.Rows(irowindex).RowHeight = Sheet1.Rows(irowindex).RowHeight * 2\ Set cellReasons = Sheet1.Cells(irowindex, SpreadsheetOneConstants.REASONS_COLUMN_ID)^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetATypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address8 check.Caption = "A - Permissions delayed/denied". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetBTypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address2 check.Caption = "B - Suspended by sponsor". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetCTypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address/ check.Caption = "C - Closed by sponsor". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetDTypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address, check.Caption = "D - Sponsor Delays". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetETypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address7 check.Caption = "E - Staff availability issues". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetFTypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address. check.Caption = "F - No patients seen". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetGTypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address3 check.Caption = "G - No patients consented". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetHTypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address0 check.Caption = "H - Contracting delays". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetITypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address+ check.Caption = "I - Rare diseases". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 1^ Set check = Sheet1.CheckBoxes.Add(cellReasons.Left, cellReasons.Top + iFromTop, 70, 7)J check.Name = "CheckBoxReason_" & irowindex & "_" & "NotMetJTypeId"H check.LinkedCell = Sheet1.Cells(irowindex, iColumnCount).Address# check.Caption = "J - Other". Sheet1.Rows(irowindex).RowHeight = 175= Sheet1.Cells(irowindex, iColumnCount).Value = "False" iFromTop = iFromTop + 15' iColumnCount = iColumnCount + 13 cellReasons.Font.Color = RGB(255, 255, 255)U Sheet1.Cells(irowindex, SpreadsheetOneConstants.REASONS_COLUMN_ID).Value = ""! irowindex = irowindex + 1 Loop# Application.EnableEvents = TrueD Call Sheet1.Protect(SpreadsheetOneConstants.PROTECTION_PASSWORD)D Call Sheet2.Protect(SpreadsheetOneConstants.PROTECTION_PASSWORD)End Sub^Attribute VB_Name = "SpreadsheetOneCustom" '*PV Copyright (C) Exbos Limited 2012. All !s reserved.9 +is a8Liability^mpany9gisterUin England Wal$es(Reconumber 06130291ԃTHIS CODE AND INFORMATION PROVIDED "AS" WITHOUT WARRANTYOFY KIND, EER EXPRESSOR @IMPLIEINCLUDINGD BNOTLIMIT TO THE EIES MERCHABILITY*FITN - A PARTICULAR PURPOSEMR]MILICENA;"USE ONLYKINB5NIHRINE FI@NANCE WJxECT(@BaMAY @F BE 7AdBWOF5RO YWHOX>`ALLY,h(PRIWRITTEN PERMISSvEE Sub DownloadData(bShowLogon As Boolean)  ' Thifuncti!`call`gauatiy the first tia sh is dfHromsyqm[{`suzBqd inform` passbyE !#le nwi@be avai8lab`{Aconstants modua@A`point. You can utieto mak "quireques` back toiper`d'hen;'+., (,should popxula +y ` offli$neejC 9 IP\sC `_h s!2 sz2pe_ sWrHong? sYeaMonthm"Day]Hpt Orror GoTo EH0l' Unprot%FZC S1.5(PTPP_PASSWORDԊ 2 App&lwEnaEv@gsFals4  `' Rs~return dUǩsm=P͔ec`SPred(.REQU EST_M_DOWNLOAD_DATA, ""\,  M FhmuccP~f.uv tinu4IfxP  SULT_FAILr _P_"n63@2.Visi= xlbVery[S11 i`t SubSEs nt  CALTq+B  t EIf'Pow 1ingmdialogPro.! (0tDos,S' LoqCSp[= GetXMLDocument If Not x@mlData.Load(sResponsed) Thenv~Sheet2.Visible = xl$VeryPHiddV1#+Exit Subi@End If ' cuts off d if saved to cell - @so tryr`emove(=SbevToS]G>evNodeToDele.th {3Sct@Single ("//Rows").Par@.RBYChi\ldA 'BXClass NameCĎCms(S@preadsOneCtants.HIDDEN_ROW_CLASS, \ COLUMN ).ValudItem("RangeStart3ee aec `I\oth`8̥sWrong Split!RlO.Text`PT")(0DtAsYear Left( , 4AMonthMid6, 2DayRigh *L2, 7Bs+ "/" x+ sC(ElsD"r$ ,z-ate, !7K$!kJ@mlAgB_Y#lBYg`, S,e ,0,,d,o,o,R3o,b(= o,o,.h`,8o,o,P-o, o,}B;o, 4= ?O "Cun1qaService" "CurrService" Th,en+'_at`buteHa]AE$>.s.)dItem(Hlea P GIs Noth{#  'weed to !no@CCElse_A jucuse FA 2 5= N_YSTART0) "?oA 2'yp41`the h=ref>it6PFk up fun=Ao_*L"W"-911" Orm$7/4/),P,9q2f$$g]!]QdkUpұFLId(5 Ѷ"  t$RING_SELECT"=V ) 'n '0IB( )G 'a@~mat(d, "dd/mm/zy" )m'-'Ridiculous ~riccon`si_Qo7"O '<- ?< If xmlAttribute.Value = "-911" Or"D,J,9Then  Sheet1.Cells(irowindex, iColumnCount)"QElseMsAnd IfE Py+ 1!iHidde]^Ib 8+ 2 E GNextG'bespoke to this s}58I  Please Select...HNyX"11" "1~6" wc95'set up dropdowns*GDatawGELQdOcFor EachNodpe InALishIN RoweU@SpreadKOneConstants.HIDDEN_COLUMN_DATA_STARTa '_K -)i' check if` look"%! ex`s in hBl`2%n) Mj<> ?!END_RECORD_VALUE A i =@!sR""u'..Do Whil@sA0?@D7PeadLLo op+sRangeSourcReplace(11HEA8DER&4=A, H" "@")@-U/?: & "pkUp,|jSDr r( /=/=$= s z)+ActiveWorkb`=.Names.Add :=, RefersTo:=  <"="I1!Targ= ŔOROWP, B6a91.Gs.R,\CWteDaDa1 c , 61% 'Nopng #.} 6a< J9Ma!WQcW 'mmatti <p/r/r(rsC t.SP le("Visibl@e").TesTyp1GPPertySpngNG'*7+(++RT+*?<MAXIMUM- 'a0 e"Int32vmEl8%%m@0ion.Numb erS'"#,##0;S0;[Red]GeneralaX 2Eԩ5}: wrS0c 'Dchad m allow an.y@ "*"`eT8imeo/(dd/mm/y -Fg-A&8"fa0& CG`EntirЫJ.TruFumnCount = iCol@+ 1 i`Hidde|Data`+ 2axNext Sheet1.Cells(SpreadsOneConstants.DATA_ROW_COLUMN_HEADERS, 0ERROR-ID).Value"Erro8rs"| irowindexAFSTART i@EndRowG@etLast() Do While .< = &1'+Ys(*).@Entire@.Interior.or9RGB(255, : )1)S0, 15304LD$@ƣLoop Call CpheckHSetFreezeG' e processin@g formC d@ialogP. DoEveCC' Clean u& xml#Docum 3Noth B-PLockysApplication@dable1TruD0 Ex@it SubC  ºHandler:bMsgBox h du r#d  download - (" & .N umber")+" +Descripa, vbOKOnly, "D%esbSiC Up A'ej'' Thi@s func should b(e c@Ae y the "C " button display  s' maiVn . e useb utilities method8' to@"$Acompl et@'back!Asystem.Exbos Limi` C d Dim"ZYAs ObjecCɠ`tGbUnkkQrkFalsYk'czv 4t& `dthPz emptys signify elndw0  ' actu` eturnbirst of#SyB DeZ@\'DO CHECKS HEREC8= yd/f1q"$#7=Ȩ  Ϥ<ϤE?a4{q!1) ̿q If% > 0Mqzn'bAk&i eoos!=1s(=R< e}M p#A`es("%C_!?5y_Is"O2 And ) 1?%'set ~iAEy/s/=n q_ , 'RW Removas no` requregard\)y'P0dTa valid RpEC n'5CJ@= 2 'If Sheet1.Cells(irowindex, 5).Value = ""` Then'Interior.ColorI`V2QCall Update Error=umn sSpreadsOneConstants.DATA_ROW_COLUMN_HEADERSq& " - Pl@ease eV a valid REC numbPer")bi dDatanFalse'End IfRW Removed [6 ] as no requ0irem8garding thisEtgr@fdsearchIWU*T@Len(B) > 20&\?xIRASWam~ WWg+'Trial NamxcU17).D, BDuOr IueI0?J 6s?Jߡgߡ̡"0Jthe6 of c8(up tok!charac`s)L'8L='Target N"Patis availablP?8_SNXS FSSelect..." @UUd  OJlv&"Pic^ i cqpigrei  c O>x0:߂ %o EyLookUpIdFromdĐu, 15, "-1")aCpek n_^// a: pӎchoo @f pe drop-down fields  ===Minimum aMaxuO75tCA7hYRang ﺍ?828d5o< Y.J,Jjm4!//_-/ ;2? 1* ]7t shoupld btՐaaDE/ {ZOFKCC8-ook   Sheet1.Cells(irowindex, 9).Interior.ColorI\ = 022  $Call Updat@eErrorumn "Please remove minimum number of patients or$view the 'Target(agreed' field ")bValidDatakFalseEnd If If H8).`ue^" NA" OrRange  pThen0x#I&sc(%101%) AL <> "" _A Yԫ4E@}5_)=')3ic@¶maxö0Hz ?e3g*.ag%/"M=- shDoube ered as aŎ1 _&,][*-\p77EEEշGդڟ _p+_p&ackamadgfg4 >/wOn xOnxO33lwBaoU.Vcannot. Xrrran:sY 4,Y0;/'0e 3@ availa 'TotalW]1).#0= "(0? @q@ IsNum`c(v`3 ) A`& <> ̤% 4`$a o%$jt<Ŵ2?0P x02pn5/IM. l }l}5tk tpPNJas a9_. IeYI;//__Ϫ]  5..O##Dremop$$t< orview'Dv_@' Br? ?&?&Z?&K_U'2hTri nClosed*IsAhU4))Ev**4A# q*440Vwv6 ''Ցtc#WL?b/> ]r)oo_9 If IsValidDate(Sheet1.Cells(irowindex, 14)) Then u.!) < .2z2, 7qOr O>O8"gCall UpdErrorColumn "[ trial closed should be within quarterlyndow")<.In&ior.GorIA = 22*b aFalse End IfWW'Number of PMicipants Rectru0itedVM5)?UMQ"" Please ic the totnDstudy pErecCE]F4 9 ?3< j03 3"1s 1 is8v!2U2#?| i2`a'RSon For CurX36pGF$9C #pgSel..\."D)x D "xr&f&à&B{BDDn)7vWEbLookUpIdFr5Sw?One Const!.OPTIONS_COLUMN_ID\,  R)m=1' L p@ IDFDocum+Set x mlGetX|ML./ytHIDDEN_ROW_0,Ѵ SpreadsheetOneConstants.HIDDEN_COLUMN_XML).Value) Then  Exit Sub,8End IfiHiddenColumnDataCount = 1-If S2.C ells(#DATA_SUBHEADER, sp <> ""sy O sXml\""|Do % .+ῂ - 2!l1+ 2OLoop Until{7]y=yO O]" "" Then  dsXml = "" TDo "P+ Sheet2.Cells(SpreadsOneConstants.HIDDEN_COLUMN_DATA_SUBHEADER - 2, iHiddenuns + 2"Loop Untilig E 8" f CAaa"checkDeletet1.CBoxes("ec_" &  If Not H AD= 1 AA2s@id(F)Ti#TID#1KA {D?Class?t(痁2CLASS, ?!D/'as!Nam4:Fdc)+/$+'XtypeSsT@I l"S`LctSleNode("//3b[Fri@dly='!M& "']/Pro perty! Str ").Text`DefaultIw) ;+v!s' is it a look upo:-yyyG\lB7)>!5?N_END_RECORD_VALUEEC6'yesYthe h c ref aJ!0frome functio1N`= kUpIdF'EUr;?P@03Sex, "-1UiEls8F'no; c /"'Is ItToe$/>>ץ> 2Vi`sibleD28F~a Uv' N1Ts9?UuP"Booleano#Kd#s#0,> ffQ# Int32o ?  n/  `"9 So o o e?Fm eTimeo~ qo o o o  .G 'right got q, nQUm I _MLM A#I< b_= $#"o F;C"aoG`>Integerc C/sS`ng ATCou|nt /Ls(XmlGsTypem sVi|siAmd bpid Boolean( b0&?  Defaultb i ha swaBs2>edAlty()m asDDsCB/&i/%@  OnOor GoTodXCSoWov]B`S'ttectCb\Un}gg03'cw `t {0Zthk@ emptys signify si= 0 GetLast ' actueturns first of#S'DO CHECKS HEREX(="w۬io6a6== STARTsDo We 'E< Daz,$ERRORID)ϞP`  S iB6/;1v0= ũ7p Ifu > 0 TheE:!'bke +;? ?2'set iVO!A, 1).Sr0ior.dA= RGB(053, 204G'RW RemovedO nod rirgardathiP]se>ta valid `REC n';  5 'vaq%" sb, )2'Spe}(% research M#rior.ColorIYT2!If Len(s) > 20 Then!ʯEFCall UpdA@Error0u mn^SpreadsAiOneConstants.DATA_ROW_COLUMN_HEADERSn& " - a8RAS\!Trial NamЮqV7).yHOzr0q-?B?Bs>(?B,B 0BthBe2 of c4(`up toac haracs)sD Dca'Target NC"Patis availablH/vuA8_JEFJlSelect..." @L""ic` i8''p'i'gre8?&mYBB`ookUpIdpFrom"ִ., 15, "-1")_Nۀ [T1"VP/a.: pchoo@f pse drop-down fields )o/666Minimum aMax#t ?5qOFݏ%xp%Ec0< =/ H/*l\C_m+ s+(G o-O'1e/ / / ?|?>2 should btXaė>(O?Cq?Q<1_(: i__OO3[`0 /3 Vvor@view]%V!!'#_O O O CO!F!?^Zߏ_$??^ a@?^10O^? f_^Zo&c&Qo^o^,ҳheet1.Cells(irowindex, 10).Value = "" Th en Call UpdateErrorColumn "Pl ease icL the maximum number of patients agreed" )sSInte rior.orI22Mbu@idDataFalseE  IM should be ered aDnd IfKJUIf N&0`$ygremovor review'Target' fieC@_cE@,?BIsNumyc(;9$) A@ <>A_ { ] >au /?8* ]EXmiZna`;.!" ecannotȠraanBbE_?^?^X["' e availablP:1).t0;nxO1pFVzSelect...Gif dIEA~ toKcruitGij5 S o?qapLookUpIdFromrIu, 21, "-1") qO<O O f?sts: pchoo f5drop -downds 33#.%q8(.gt `Is2e2))og2<0 2 ()Q 7_"o "G:<"IntHor.ColorIoi2aEtYE/AE%Call UpdErrorumn Y"Pl ease \ic the to a` at target A٪pEEXftj$XUÓS shoul d be @fered as ai??6&6m;wf\f9dfSQs>j rem0ove _@)j oBrviewq'Tm$H' fie@FCCuCO+%/M/' riClosedobFbe4))8=4).IhIy` \` q%Xc  sg-ߢU_o6S |u|Erolmk$gj)Sha 7formjdd/mm/y?1++V1 b%/) < 22, 72Or / 1>87 ?҅nwithin qua"rly 1owg_/A%P&&g? s[_'tPicipa RectruitR665_Nߦ Np!_ UAstudy`rtrec_   ? r_#OO > 9= @9_ W < 0mP.G isvQ_ W _ux&?f 'Ron F0urhS611#x1-Sel;..."oH ; Call UpdateErrorColumn(irowindex, "Please 8ic@ the r$on for closure of2trial ") Sheet1.Cells d16).Interior.orI} = 22IbValidData$False'EIf LookUpIdFrom5ue(C, 31}-(1")/" ThenEGjR: pchoo fydrop-dowiel dsh"Vnd I>fKCFP+ 1 gpGEC DoEven tsCLSetF0reezĀLockBf Applion.En0able(Tru Exitp Sub Handler:MsgBox " during @a check - (" & .Number " +BDescript1, vbOKOnlyBCe,"/UB3 Pub@5 &(urange)`"Re10, uAddress).SelectActiveW@ow.Panes Ht_c0-D@ t`eRows!B'' PhysAExbos LimitedC  CDimCAs B<@HC 6gp geri@HiddensName!Sng VCou nt!.sResponseDocum@~ s`XthXml sTypsVisi~2 "1H#Boo@{d2iR!oNodeu!sDefPaultsvmiss}ID1-nfirmaaSifd S-cLl@UnprotP=(BS2OneCtaW.PROTECTION_PASSWORDw|2.~ i = GetLast()Qo c DATA_ROW_STARTNABw/= COLUMN_HEAD8ERSWjDo !@lő < (W +svW ?,D> \>es("e?_1b zK0d.'= & G3Q1)= 1/s>, DNo`u >)."" A`#, 1Empty _ N24 #OP-S_ ID,A# %(A9 z @?I& ;ϵA_:n"µoaU2tjB60Q` ϟ 1c"A*7X )tir,u]W'<=?A?AetB?Ax 1 OA(ck.xAB Suspesd by sp7or? v?? ? @, ; ? ? pQ& #&6-? E? @.@bbk@3& @C? @c@ 8 C0 Close 'O@{_rr=O@5O*). e  % O@`. lO@  ``D `` 6O@- DA@s? ays?}w???'p1/`}>= ?%lSE/`+`Etaff availabi lity ue 2Џ CJZo@ " &R @  / `|`F Id" ' check.LinkedCell = Sheet1.4s(irowindex, iColumnCount).Ad dressCa ption"F - No patients s8een3kRowj).HeightF17503Valuealse viFr`omTop+ 1 4 x JSet Boxes (cReasons.LeftL, I+ I,h 70)1N4amoC/)_"X & ـ""NotMetGTypeGc<e4M??J??M7H@WUh9H@Contracting deladys߀ex߀ߔ.?@߀~= B߀Ʃ߀ll߀ Ì.߀ex̀I?@?@I @Rare dise?͟???_Cƙ??J????JOther??_wO'%~p<50<: ?|F@O.Cor RGB(255, E<}VSpreadsOnepTsta.REASONS_COLUMN_ID)w׀0՜aL8oopS \Applicon.EnableEv= TrueQCa$ Pro`tect( PROTECTION_PASSWOLRDk2.ot ob# End `Sub SpreadsheetOneConstants0%*SpreadsheetOneUtilities0PROJECT(APROJECTwmT"ҭ=xME(6 <<<h @@p @@ HꐐH H 0 H ` H H  H( HJ H HꘘP BʘBʘnBʘdB\'B ʐ|@h H"ʐp8H$ʐH&ʐH(ʘ B*ʘ0 $B,ʘ` <B.ʐ xH0ʘ B2MSXML2.XMLHTTP Access Denied! @: @0@` H%"Hꐊ H % H  H P H  HX H8 Hv Bʘ@ BʘZpBʘlBʘbB-* "` G!nt1ʐ0 H#1ʐ`xH% - Aʐ8H'ceʐH) ʘB+ Aʘ 0B-ʐVP`H/0%ʘB1ʐ^H3. 0 @@ P`@P pP`0p p 0` ` 0 -` %`mhttp://localhost:49494/Exbos.Applications.NHSRBVP.Components.Web/SpreadsheetDataEntry/SpreadsheetHandler.ashxcFhttps://ccfctp.nihr.ac.uk/SpreadsheetDataEntry/SpreadsheetHandler.ashx4- A  LMODEEMAILPASSWORD 60IDDATANewPIDDownload NewPIDUploadc NewPIDDelete#Pr0t3ct3dSh33t#%7System generated fieldDrop down options. Please indicate whether the trial has a fixed target (Number Agreed), range target (Range Agreed) or no target agreed or available (Not Available /Not Agreed)=Drop down options. Indicate if a target date has been agreed._Format dd/mm/yyyy. Please show the date agreed to recruit patients. Leave blank if unavailable.nt5OPlease report the total number of patients recruited at the agreed target date. - Please only include records for commercial trials which have closed to recruitment within the reporting window. Format dd/mm/yyyy. 5Please report the total number of patients recruited._Please use the free text comment box for more information about the trial. Character limit: 500Please Select...New blank%X_@#h4 0 O KZ$*\Rffff*0A5aaa4cbcJJ Z >` T * Z( F B @ (X Z R Z8  Z (08z@R8 Pp0@Pp        0 @ P` "xJ`l\  B lX        8  H  X h  T************************************************************************************7 Copyright (C) Exbos Limited 2012. All rights reserved.N Exbos Limited is a Limited Liability Company registered in England and Wales.$ Registered company number 06130291.8AS***********************************************************************************? THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY< OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT9 LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND" FITNESS FOR A PARTICULAR PURPOSE.S***********************************************************************************K THIS CODE IS LICENSED FOR USE ONLY WITHIN THE NIHR ONLINE FINANCE PROJECT.S THIS CODE MAY NOT BE USED IN ANY OTHER PROJECT, EITHER WHOLY OR PARTIALLY, WITHOUT PRIOR WRITTEN PERMISSION.S***********************************************************************************]]]]@]0]mhttp://localhost:49494/Exbos.Applications.NHSRBVP.Components.Web/SpreadsheetDataEntry/SpreadsheetHandler.ashxp]Fhttps://ccfctp.nihr.ac.uk/SpreadsheetDataEntry/SpreadsheetHandler.ashx`]MSXML2.XMLHTTP] ]]]]]Access Denied!0]MODE ]EMAIL`]PASSWORDP]ID]DATA]NewPIDDownload] NewPIDUpload] NewPIDDelete]#Pr0t3ct3dSh33t#]  ] ] P]@]]p]]]]'] 01/01/1753]System generated field]Drop down options. Please indicate whether the trial has a fixed target (Number Agreed), range target (Range Agreed) or no target agreed or available (Not Available /Not Agreed)@in]=Drop down options. Indicate if a target date has been agreed.0 ALLY,#h(PRIWRITTEN PERMISSvEE@Global@_FIRST_OPAs Bool ean HAS_AUTO_RUN DATA_IDAIntegerFBCOLUMN5EVELOPMENT_M'[B D(URJL Sngahttp://localhost:49 /.Applicati@.NHSRBVPD.Cwone.Web/Dat@aEntryHler.ashx D##LIVE _Rs`ccfc@tp.nihc.uk x XMLHTTP_OBaK. MS2.S|ULTCa`LL?? %SUUa?_DOWNLOAD_kNewPIDDownload_XUP?g?3Upt REyELETE_"T`elete=`_T`_`X__#Pr0t3ct3dS`h33t# A_ROW_TPHEApDERSqRP9SNUASTPr10HENC13`/SUB42 = 150H?D1 7OHCL-`_f/<MAXIMUM]D00MIN!Ep_TIMB.`01/ 1753 OVER_HIkXѱym g enerafi4el-HgGET_NUMB@Drop d@1 $op3k Pyse indqle wheth @ 0pP|hafixtargeNsAgreed), range R or noa1available (Not A/=/ P)E_AG REXns. I if 4 d been S >.@#"Format dd/mm/y.show tocruit p Leave bk un7RECRU_AT_S  dreport1totof E q gbCLWE!Honly%cludeords f` Pmercip %s&ichpclos&m` withӣa ing@n@,. _OTA?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijlmoqrstuvwxyz{|}~U L\,ҭhxME ! p(69L!L> "LL"LLLL " "LL"LL"PLLLL<<<<<<<<<<<<<f&&P(%h <`xo99`` % `kooH``` ``+`kFFii  `h ````+`kP__ipii ````+`H Pkh((\i` ` ` *h`!o(&&I, HI.  N `$k iPiRIT  ``'kx ibiRIT +dP`()k0if +l `0*k  o%+tx `+`k  iv ,@ix`z +8 ``-8k i.```+ `X/Pk !!$  % / %  %``  `(2kx E) %i iP  %  `2kX Q)x %i iP X  % x `4k8  _iX IT   `5k  ii ITx6   `6+h  si IT  X`7Hk }i IT ` `h9Hkii` ``:@k `X<@k `=@k h`H?@k `@@k `8Bk p``Ek+`pHo +@`Ik   I +`Jk 11IX  % % % K0% P% p% % % % % % 0% P%@ @send @8 x ph ` Xhx  XPevel>p0`H *0fn: a@8 @ @x @ @x @` @H @0 @ @p @ @P @h @ @ @ @ @ @p @X @(@ @@( @X @ @ @z R`Hx0Xph|*0Jio@ @ @ @x @H` @H @0 @( @0 @ @` @x @ @ @ @h @P @8 @  @8 @P @ @U1@ @ @ H0Xph@`@ @ @ @p @X 0# @@ #$ Show oc@( @  p*Platfo@ @ >$Ppx@x`xRThe ess an~ h@ @ @( @ @X @ @p @x @p @h @P @ 8 @ @0  @ @ h8!P! !!`! " @ @h! @! @! @!h @P (H#$X#"h"p#"@" @" @# 6:>@" @" @#p @(#X @@#@ @x$( @$ @ @F @# @# @# @0$ @ @ @H$x @`$` @$H @$0 @$ @ @ %x%x&&%(&x%%%@N %x%@&|\@% @X @& @& @P&p h&(&@X &P&@P @&8 @ @& @ P&x'((('P('''@` ''h(|@ ( @X @8( @( @x(p (P(@X )x(@P @(8 @ @) @ x(0)*)*)`d))hj@ *8+ +P+*+*`l** @h+ @ @ @ `,@,,p,- ,X,8,`t H, ,-|6@, @, @ @ @~x @p @(-h @--@`_ P-(-(- /h.P...8..`(...@. @. @. .. @ H/. @/ @0/p @h @P @8 .  H00`0/000` 0/06f@1 @x0 @0 @0 @0h @0P @ 18 @ @P1 @81 @1 @h1 @1 @1 @1 @1 @1 @ @2h @P x 2@2 @ 3 33@3 @ @ @3 @ 4X 8 55444@ 44P@05 @H5 @`5 @x5 @5p @5X @@ @5( @ 6x666@ 6x6hl@ h 7 777@ 77@ @p8 888p888@ 8p8@ 9 @9 @ @89 @x @P9` @H  ::8::0@ @P: @h: @: @: @:x @` @H ;;;@; @; @; @< @(< @@<p @X @@ (==<@@= @X= @p= @= @= @=p @X @@ >>p>@> @> @> @? @? @0?p @X @@ @@?@0@ @H@ @`@ @x@ @@ @@p @X @@ AxA`A@A @A @A @A @B @ Bp @X @@ BpDDCBJ06|???@ @ C @8C @PC @hC @Cp @CX @C@ @C( @C @C @D @(D @@D @XD @HE @Dx @D` @EX @D@ @D( @E @0E @ @ @ FGG0FFJ06|:@ @HF @`F @xF @F @Fp @FX @F@ @F( @G @ G @8G @PG @hG @G @ @Gx @G` @(HX @G@ @H( @@H @XH @ @ IxI`IIIHI(I` 8II E>@ @ @ HJ JJHJJ`J` pJHJ;@J @ @ Xx88KLKKKK` KK>06@`L @Lp @HLX @0L@ @xL( @M @ @L @L @L @L @L @ Mx @hM` @8MH @PM0 @M @M @M @M @(N @M @M @Np @@NX @N@ @XN( @pN @N @N @N @N @O @HO @Oh @0OP @`O8 @O @xO @O @O @O @O @P @hPx @ P` @8PH @PP0 @P @ @P @P @ 0/X@XH/KZ*\R5*#8$*\Rffff*0<5aaa4cbc*\R1*#3c4*\R6*#2a*\R1*#278*\R5*#9$*\Rffff*0?5aaa4cbc*\R1*#136*\R0*#f*\R0*#e*\R0*#14*\R0*#16$*\Rffff*0@5aaa4cbc*\R1*#129*\R1*#11c*\R1*#137*\R1*#318*\R1*#317*\R1*#3c7*\R1*#12d*\R1*#331*\R1*#5b$*\Rffff*0A5aaa4cbc$*\Rffff*0B5aaa4cbc*\R1*#278*\R1*#92*\R0*#17$*\Rffff*0;5aaa4cbb*\R0*#10$*\Rffff*0Y5aaa4d26*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#C:\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#44$*\Rffff*0Z5aaa4d26*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#C:\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#51*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#C:\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#41$*\Rffff*0[5aaa4d26*\R1*#76*\R1*#78*\R1*#74*\R0*#18*\R6*#5*\R6*#1*\R6*#2*\R1*#277*\R5*#0*\R5*#5*\R0*#13O Z >` T * Z( F B @ (X Z R Z8  Z"  ( T8 T T .@ p > L  & J0 ,HJX "p6 Fr   >   (0 2X hp $hx$h L 4 . 8 ( 08  "@ 8h 0x 4 "  P R P` P 2 8 >H L        b  0@ >p  D  & J , J , J0  H "h  x      L      ,     Z  X@ Z`   Z *\` (,@  p      $ & &( &P :x  & $h$h 00 0` 2 2 H H h 1 x  &   ``  (0 X h p  <  B   X XP T  > LP        . @  P"p       *   .  8  H h  p>   ^  @ X^`      :  B   P PH R L &@ h >x L    ( @P  Xx,2  2 &  80  @ DX 6x 6 ,X .f H  h .0x          < X h x \L        @  P  0X          (  8  X h  x         B   J! HP! H! *! " > " L`" """  &" "  # # 0# @# H#X#  `#.# 6#.#@&# $ "0$  @$P$  X$p$ x$" $ $ L$ D$ 0% >@% J%   n% @&"H&.VX&>&  >& $&  P&.V8'  8h'>' 'H( P(  X(&p(&(  (( ( B ( ( ( (( &( )"p )  H)P)  X)$xp) ^)  )) ) )  ) B ) $) * ** & * @*"pX*  **  *t* b*  ** * +  +  B + + R(+ L+ P+ > , J`, , ,2, ,-- - B - (-00-^P- p- B x- --  ----  D-D-- L-0.  . (.0. 8. H. P. B X. `.h.p.  x.4. .Z.&. `./ /  / B(/ 0/8/@/ H/P/  X/h/  p/ "/(/(/ Zh/X0 `0h0x0 0 000 00 " 0 0  (0B0 141  (1 " 01 81  (@1Bh1 1<141   1 B 1 .112 ,2  2 B  2 2(2H2`2 h2  p2 B x2  222 2  2 B 2 2 $222 223,3,@3&ZP3 x3333  3 " 3 3 f3 4 4  4 $p(4 P4 "X4 L`4p4 "x4 L44 "4 L44 "4 L44 "4 L44 "4 5d5 45 <5 454064h646  06 P7 4X74747484884p8 b8 9  9 "(9 09dH9 49 <9 4(:4`:4:4: 0; P8; 4;4;4;40<4h<4< d< $@= P= BX=  `= ".h=>=== $=&.=>==> $>&.>>@>P>X> $`>".p>>>>> $> > B >>  >(> ?? ?? ?(? B 0?8?@?H?P?X?`?h?p?x????? ? "?"?"?" @"H@"p@"@"@"@"A"8A"`A"A XAA0AA ABB B BT************************************************************************************7 Copyright (C) Exbos Limited 2012. All rights reserved.N Exbos Limited is a Limited Liability Company registered in England and Wales.$ Registered company number 06130291.S***********************************************************************************? THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY< OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOTr perf9 LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND" FITNESS FOR A PARTICULAR PURPOSE.S***********************************************************************************4!vK THIS CODE IS LICENSED FOR USE ONLY WITHIN THE NIHR ONLINE FINANCE PROJECT.S THIS CODE MAY NOT BE USED IN ANY OTHER PROJECT, EITHER WHOLY OR PARTIALLY, WITHOUTh PRIOR WRITTEN PERMISSION.S***********************************************************************************]X M Called automatically by Excel this function performs all the action that areN required to prepare the downloaded document ready to be filled with data. TheM custom data fill method is thecalled but only if this is the first time that' the document has actually been opened. 7Exbos LimitedFCreated]p] *!' .$'$' -$'  $DEBUG  Spreadsheet OneSpreadsheet in Debug Mode B@kk 0B !] ( *!\ *! !B@ *B@B|k UploadData 0!%( CheckData 0!%( f!( f(h f(j n f(l': Call prepare data'@A'@ Resume screen etc updating/searc z f(l Exbos Limited/oECreatedX.Au]]0]H]`]xCheck for first openme="Te |%B!'l>http)Check first open or previously saved edit $TRUEo:> Extract file name data (USERID-DATAID-LIVE/USERID-DATAID-DEV)//[O *!'late .$'es/m$':u ($' <$'me -$'t">  Check filename if valid.W  Hide sheetsnt_id=  0(pID]  |(e_ty Throw errorect_urThis file can only be used in conjunction with the NHS Research Benchmark Validation Platform. When dowloading a spreadsheet from the system always choose the 'Open' option and not 'Save' or 'Save As'.A@]/oa|XkP Unlock sheetiveO J |BFost] Pull partsrespon (token%FALSE |%B($$RELEASEFALSE |%B( (ncel=1dhTRUE |%B(  (es> k0$ (ame="L !  |%B(.n  |%B! (e= Lock sheethHost" J |BF  SaveRoutine Q Modified freely avialable function to encode a URI component we will likely needQ to perform some heavy encoding as we will be sending Xml documents to the serverM which would generally break a standard post request without proper encoding.Ɗ( 7Exbos LimitedpyECreated Uni]0]H]]] Grab lengthsts. 'u Defualt to empty'( Only process if we have an actual value   Encure sufficient length  Set space charoo +'wxxxyydH %20'k0  Loop chars    Get character code  $ ' $'  Adjust as required  Fine as iazLAZL09L-K.K_K~KKT  + Space KT  + Needs encodeLT%0 $ + Encode restS% $ +nx  Return result string $'k(i  J Sends a request command and data to the finance system performing a logonJ opperation and ensuring authentication before checking the response. ThisK command will perfom all required functions for logon and access denied. If/wF the function returns SpreadsheetOneConstants.RESULT_FAILED you should=nTP abandon any further processing.a 7Exbos LimitedAECreatedH]]]] Default to failed !'ZX' Loop until successU1'  !  !  k Show logonk G ~B@j( ~!'2 If the dialog was shown we need to make a request  !  Build requestq != $' & != ~!!d$'k & != ~!!d$'i & ! = !'  & ! = $'  Show processing formh+ B@!Contacting Validation Platform... (XA@  Execute the response $':  Show processing formhe5 B@+FAIA@ 6 Check for logon failure if failed ask for logon againg  ! !'s~t  !e !'A@RThe email address and password you entered have not been recognised by the system.A@asid !')Gkk Incrememnt retriesnce sy  ') Check if it failed and return the result  ! Show permission error wi` B@ Return failure resulte H !'bos  !e  Show permission error B@ Return failure result !'  !e Return failure result !'dP Success return data 'k i C Sends a request block to the finance system and returns a responseB block both in simple text format. No attempt is made to check theB request or response. No authentication is performed and no dialog$ with process notification is shown. 7Exbos LimitedECreated]]] Set default response to failed !' Check mode and set URL ! !'d !'k Create request object "$ ./ Make a synconous request to the finance systemPOST  B@ Content-Type!application/x-www-form-urlencoded B@$  B@& !(' Clean up. Return result 'i E Forces a given range of target cells to become drop down lists whose> values can be selected from a seperate range of source cells. 7Exbos LimitedDCreatedh Set range of possible values (Can't detect validation easily so have to use VBs rubbish error handling) ,!0B@2 6l :8 >< .@ ,!0B@4 !7 Clear error so we can double check for another problem B@BI Modify range of possible values because the add failed meaning we likely 6l :8 >< .@ ,!0B@D2 If we have and error style then we have a problem !.Error setting cell drop down valies for range F  to target range . error code ! description !H A@kk Set regardless ,!0(J ,!0(L Clean up.,oPh P !V-1'Nz k X !Z !\ Check for End X R |%B! !^yk Check for match X R |%B! P X R |%B!'Nz@k80 T'Ni   b-10 !V'`zk X !Z !\ Check for End X R |%B! !^yxkp Check for match X R |%B! b X R |%B!'`zk T'`i K Forces a decimal value to be return if a joker has been entering string inF numeric fields. This is not for use on validated fields where we dealI with this more forecfully. Technically it returns a double but it works.7Exbos LimitedDCreated Check and force down f$h f$j'dd'dkiP] WScript.Shell$ .n mydocuments n%r'li]`'z x z'tzPkH v$= v v $|'vk ~ v$6 ~! x'zyk ~ z'tix]] ] ' $'    $$' a z   $ 'k i8 ] ] ] ] ] !'' b  0%B!v$6.   0%B!v$6.   0%B!v$6. !t f!p%r !t f!p%r !t f!p%r'd  'kx  !'kX 'iH ] " Create new element and set values  !%. P (d  Bo ] " Create new element and set values  !%. P (  !B@  B@o@ $true $false T'k $'i x $h  -99999911'k 'i   T'k` 'iP  ]@ $ T'k  01/01/1753'k  $$ dd/mm/yyyy$' $' yyyy-mm-ddThh:mm:ss$' 1753-01-01T00:00:001753-01-01T12:00:00'k@ 'i0 X]  ! 0%B!'   'k    ! 0%B(o 1A@o `2A@oh 3A@oH 4A@o( h5A@o ensure unlocked JHLNPRTXZ\^ `bd 0B@F A1: 0!!D 0%B!v$6(A10: 0!!D 0!!D 0%B!v$6(A10: 0!!D 0%B!v$6(B10: 0!!D 0%B!v$6(C10: 0!!D 0%B!v$6(D10: 0!!D 0%B!v$6(*RW Commented Out As Comments Were UnusableIRange("Q10:" & Sheet1.Cells(Sheet1.Rows.Count, 17).Address).Locked = TrueR10: 0!!D 0%B!v$6(S10: 0!!D 0%B!v$6(T10: 0!!D 0%B!v$6(U10: 0!!D 0%B!v$6(V10: 0!!D 0%B!v$6(V10: 0!!D 0%B!v$6( JHLNPRTXZ\^`bd 0B@F J |B@Foensure unlocked JHLNPRTXZ\^ `bd 0B@F A1: 0!!D 0%B!v$6(A10: 0!!D 0!!D 0%B!v$6(A10: 0!!D 0%B!v$6(B10: 0!!D 0%B!v$6(C10: 0!!D 0%B!v$6(D10: 0!!D 0%B!v$6(*RW Commented Out As Comments Were UnusableJRange("Q10:" & Sheet1.Cells(Sheet1.Rows.Count, 17).Address).Locked = FalseR10: 0!!D 0%B!v$6(S10: 0!!D 0%B!v$6(T10: 0!!D 0%B!v$6(U10: 0!!D 0%B!v$6(V10: 0!!D 0%B!v$6(V10: 0!!D 0%B!v$6( JHLNPRTXZ\^ `bd 0B@F J |B@opMSXML2.DOMDocument$ . !zXkP B@BMSXML2.DOMDocument.6.0$ . !zk B@BMSXML2.DOMDocument.3.0$ . !zk B@BMSXML.DOMDocument$ . !zPkH B@Bi0' $  ! 'kd'ki@]]]]]8]X]x]]]]]]8' X 0%B!v$6. X 0%B!v$6. X 0%B!v$6. X 0%B!v$6. X 0%B!v$6. X 0%B!v$6. X 0%B!v$6. X 0%B!v$6. X 0%B!v$6. X 0%B!v$6.  X 0%B!v$6.  X 0%B!v$6. X 0%B!v$6. !  ! ' ! e' !  ! !V !  !  !  ! !V !  !  !  !  !  ! !V ! e'k0=i(= =<Attribute VB_Name = "SpreadsheetOneUtilities" '*PV Copyright (C) Exbos Limited 2012. All !s reserved.9 +is a8Lia by^mpany9gisterUin England Wal$es(Reconumber 06130291ԃTHIS CODE AND INFORMATION PROVIDED "AS" WITHOUT WARRANTYOFY KIND, EER EXPRESSOR @IMPLIEINCLUDINGD BNOTLIMIT TO THE EIES MERCHABILITY*FITN - A PARTICULAR PURPOSEMR]MILICENA;"USE ONLYKINB5NIHRINE FI@NANCE WJxECT(@BaMAY @F BE 7AdBWOF5RO YWHOX>`ALLY,h(PRIWRITTEN PERMISSvEEGlobal bLoadingData As Boolean Sub Auto_Open() ' Callfa matic!y bytcel th`nfunction pe`rformputhe atha t aree requipto p@ e dow nl documentvady be fib@with d. Th cust om method @  only ifcrst |ti@a&h"actu# een o 'C'/l'@JC 1B\a(1)!DEBUG"!Err.Raise vbObject or + 1000 h "LDebug Mo 0C Á;ppExu@?Neww.ApZc@=oaD.@VisiblT @Modifi` fB aviala}fe  0URI weဣlikeu@per soheavy rQ@sen2Xmla A serve4' whiwould gener0k!°dard po`Exbos Limited "e="02/12/2011">C  Dim4 lLpI oLo$ngas0ul t(iCha rCIntegs]"%c' Grabb `gth# = p +ZDefualtemptys/0,"AhuOn&c#h܀8 act H> 06G'C=@urufpfici6 1Re3жgLen) As String   ' Set space chardIf bS\AsPlus Then:zs B'32 ' Needs enw0@ 15OU"%0" & Hex@eJ"E zst!O ! EÓ!NexteZg' Return> sńDUric@AJoin(eD, ""#O ABz@ Functio@% Execute"SreRces2tbpma , sData,howLogonBooleaL'anEaqu ` da to the@ finan system pe rform` aL l op`a aensuA aunticcbeeck#a res`se*. i'&willm a@ f(s @ Baccess denied.a = preadsheetOneConstants.RESULT_FAILED you shoul' ab.any r`r proA. "Exbos LimiteXdC d Dim sGStat`i&RKO7Bijries!TI`ntegec'` Defam`Nfail% = S?5EDC G@d "uuP)l suG" = 0Wfh+<>K#SUCCESS A5J &CANCEL!'< iS  0 S1@|s a@\blo|tobyfinance system(}#% #both in simple texormat. No at pt is mado cB@ rrdmorc cuntica"A f` no db wi`proAb4notifhsIn.DExbos LimitedC d Dim xmlHttp%uula1:=sRc(3Y0 .Numb><> 0OO6&rtwe%do00p7zݐmC1QC1'Nodify 70/aA a0cl m@ likely7mM?s`:?d???e90 &re2$sn  ^rMsgBox "7 ]t!C d76Cp 1C" +0b@CK"FGMB cA$+ "@scrip+!306?9'YregardlSIgnoreBlank`хr6ation.InCellDropdown = True ' Clean upI S2.s(M).N*END_RECORD_VALUEQA#Jor!IAGI.matchÇ. + 1/ĀuAvcE# NextAA EC ˅kAId(sI&dˀ= Or "0"a XYOkc!P&iAfcxf~fndgNffH%faft}= Ge,?[p(dGff  fGetDecimal (vfVari )a Do'' Sces a d# v to be retu rn ifjoker has0en e! s  iD>' numerfields.`ois @notBuse on idated  where we al with s mo@ecfully echnica `c"! butworks.Exbos Lim2i`  ="9/12/2011">C{k CBmaUP c`P0:IsNcD),LLRouDnd, 24Els!+_0##'{KZ R!MyDoc Path(b&Aa@Dim ws'Wtshhl0= Object("WScript.R"0  ws.Sp*alFolders("mydUMf Ҝ`tains(sName˱ sTo&BBool 3S=fAS= FaF#\jMj `"C/HA6LeftH, "=x= Righ[LenXx) -p3oE ach cy In `b6L\q1ygX# Sa&Priv LRemoveCharactQ*In$!2 !$intpC$d w$#g`Q)?ntASCII`>dj=  tCv Case( = 1 To`tYS  =0 c(MidA*$  ">= 97 A TY< 22 S.+ oou ."%PHo#TXLastRow3T Iޗcr2wooyhr0m!iob@EmptyKS'_ 灧ST` o While PiVF (`et1e݃ .Addrz lY, 1).Address) Set rangeThree = R0(Sheet1.Cells(iRow + 2If Application.Works!Func"Co untA(One.EntireV)q0 Ands#@wo<@u !TXhenfbMNotEmptyQFalseEӁ= 1gIf Loop SpreadConstants.DATA_ROW_START G0 E, GetLastRN Pub SubendEleme@nt(xml As MSXML2.I@DOM, sName@StringV8aluH6Dim Data#CAN' CAte@ new e& a8s@vs A=.OwnerDocu7.c(B1D.TextNs5!CCallIappMChildMH81ZeYR]AtPbute]BbC+]t /k/b$ /F 0 .NodeB 1@5;' `H :/k!8i mBo olean(sbDefault2|LCase) <> "true"BNf"H} = s I~&i EQ Int yIsNiric(s aa Or " = "-911"`a}Î9sD*8*cCW(sAvtd% IG,Ǿ qAL0 @ 01/@1753(1EFormat(ñLeftc~0)), "dd/mm/y"p- = '<-mm-ddThh:mm:ssqy -01 T00:"q&x12t%0F %pUpdateErrorColumn(up*PegernMagn sExxist@qnIE^=2 N, πÀERROR_COLUMN_ID).CLen(m)p > 0E# .& vbCrLpPQ? ? ? - & sSubmP(p'MsgBoxx "F(Two20A3Foure4ic—itve5 L(ockrs1'ensure unBlped 4Protect Password:=PROTECTION_PASS@WORD, t`s:=B\, User.rfac eOnlyAl8lowA-ҿ:=Tl, 3@G1p_ InpaUs PivotTab leKfHyperlinkD  wxe SorA ilt>eS'/#"A1:" &[<9 <[.W.edI Name>7>8;899101011223_3W4_4W5_W16_17_ΙûIf (E .@uAEmpty Andҁ) ThenC FalsDE@_@AL*()8lOrSpreads!~OneConstants.DATA_STRING_SELECT)g9 100C11Le12p(1364650$6L&?17 KFIE`NIfc  FunctioM - HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="D8DA7482788278867C867C" DPB="7371DF8667A367A3985D68A3ACC30F785630C1B05BC8AD02E144262EA85162EB1561203F67" GC="0E0CA223A6254026402640" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C SpreadsheetOneUtilities=0, 0, 0, 0, C dialogLogon=0, 0, 0, 0, C, 26, 26, 1341, 548, C dialogProcessing=0, 0, 0, 0, C, 52, 52, 1367, 574, C dialogNoPermission=0, 0, 0, 0, C, 78, 78, 1393, 600, C SpreadsheetOneCustom=0, 0, 0, 0, C SpreadsheetOneConstants=26, 26, 1043, 352, Z Sheet3=0, 0, 0, 0, C ThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2SpreadsheetOneUtilitiesSpreadsheetOneUtilitiesdialogLogondialogLogondialogProcessingdialogProcessingdialogNoPermissiondialogNoPermissionSpreadsheetOneCustomSpreadsheetOneCustomSpreadsheetOneConstantsSpreadsheetOneConstantsSheet3Sheet3$  #?}C3^0R KQDBTahoma(74buttonOK+$@ Image1( #groupLogono$! Image2dialogLogon'1*d]Cd]f+o)/pni27- n``Cd]Cd]( "8buttonCancel'+@H  # }1vLogon DetailsR KQDBTahoma , 2DlabelEmailig q0 2<labelPasswordrg : ( 4textUsernameg  ( 8textPasswordg ( 2Label30#2labelCopyrightc(OK OuTahoma:4R KQltJFIF``hExifMM*>F(1N``Paint.NET v3.5.10C   (1#%(:3=<9387@H\N@DWE78PmQW_bghg>Mqypdx\egcC//cB8Bcccccccccccccccccccccccccccccccccccccccccccccccccc" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ? ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( *fY}E|vZʹׯb2i&Di"`9EZ&3H΂.Y+O?Kk0fj]=Q~]6?u Bj\"UP&}^F$Lr<J(Ӽ09ر=kMF&nX`UrV׉[|Fq89EkwPK4L<`:ҸRU(lnl2m3[lRᔎIm ʡchϗGM[TAOG>\GpQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQE! kZs3Z] `s-'V[fI_.$EL:΀::+"Vwີ-[7Y^(-jӋ@9~xh J6Gh_,~|T~'sMj4Ec^xk#̳) {<~u5guUS.@=yEdk׿c0\ܩqUK%4$'htW=[o+9Os7T?k[]\[yw3Ko(}O{#ӗIR21Fڪ-zQ[ !Y`NA9ӎMmQ\×w X16y=;zM&\+-,іfS<4v&D%1pV]׆RYvn?Zo[\_d2$>vLm_CQ 8BO! K3*Ԕv38rmAMvqbn.c]]I֫h&7vW:Q q'Da85vĶWWq[iԴmY>?ʑxP0=BE @icy0o8Zich$k>x~+_Q|lQ:cڛ7-M.ӬϏdyv,y$Ij,Ӧ(\ē6-Ժ,4Ƶfj&s{Ъlу~f:\[2(a23ϽKYQ@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Pfk}H."` Pwa=kxY%+p$k+–oڮKʉRq}wP^.d{gI.'8᳸ךhfMW8k<ˈ#`U[=Ar?ZҺYE-lHGPv|>]y[`*rUA#*կ i ]\;yx@v@NkogYkx*e+,`}7enN8!TD{JF85@*A[+Qnb@gI#ЗVѺW?*e~v#>Š/o5q˶I'%23ڮkr oi\E)"F?utPeV.2ۆm9?]\׾)-e_ L1U2Tԭu JOt©q}:zW_Eg<쑂_eP''뛾ҮG[{xݤ]1${d~UQ@^r&}C[{q!Sm|:Q["UfFO٫k1LXsY>!mtk-=dtx‚:U_Q{O^ɩAT}x>t5I9 Y!ޘCYKiwi %!3V$}"WAB&"H42  L4҈6C ?#r 3B )a ,#!H$pt1D6a0' -ȐH8!WX1IC 1 +(aG!|矀ZX4EU\an1GwGU1naU16" "NZr&FBy:*FVa**)zǬ޺Rkʇj{P!jk{L[x؁~kΞ -(誫 zENnGxPB2GtQ+zL B 9,a!K.uD+!?8G2CBш" 8`Dq!,C/tG'-Q1 Z?ѵB:6!=!lGzpUۆGN̝С),ryth #@kAF]sskˆ%|i!ӱ t kͅPi 0>FqB ~f#0 a` uqDA<"mnѬwHu? c ƁSSX=a:#Q? mh+hA b@4bIcwCD`{4$olpCbJ +CZ`>XLE(X(\ p?: "0BL! ܠ9G@;(Cancel OuTahomafo,.CompObjpCompObj+0a ( Email Address @Tahoma(Password @TahomaH,{5TahomaH,*{5Tahoma(Please enter the username and password you use to logon to the Online Tool and click OK. You will only be asked for your password the first time you download a file and when you upload the file back to the system.!/5Tahoma(Copyright (c) Exbos Limited 2013. All Rights Reserved. Software developed in the United Kingdom by Exbos Limited the bespoke software specialists.!/"5Arial n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} dialoVBFrame1dialogProcessing":3Cd]Cd]fo28gLogon Caption = " Online Tool - Logon" ClientHeight = 7020 ClientLeft = 45 ClientTop = 375 ClientWidth = 7440 StartUpPosition = 1 'CenterOwner TypeInfoVer = 63 End $  '}C3%R KQDBTahomag$@ Image1( #groupLoading$& Image20'2labelCopyright? DH  % }1; Processing RequestdR KQDBTahoma80 %2@labelProgressa" (Please wait...ue!/{uTahoma n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q Microsoft Forms 2.0 FormEmb:4R KQltJFIF``hExifMM*>F(1N``Paint.NET v3.5.10C   (1#%(:3=<9387@H\N@DWE78PmQW_bghg>Mqypdx\egcC//cB8Bcccccccccccccccccccccccccccccccccccccccccccccccccc" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ? ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( *fY}E|vZʹׯb2i&Di"`9EZ&3H΂.Y+O?Kk0fj]=Q~]6?u Bj\"UP&}^F$Lr<J(Ӽ09ر=kMF&nX`UrV׉[|Fq89EkwPK4L<`:ҸRU(lnl2m3[lRᔎIm ʡchϗGM[TAOG>\GpQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQE! kZs3Z] `s-'V[fI_.$EL:΀::+"Vwີ-[7Y^(-jӋ@9~xh J6Gh_,~|T~'sMj4Ec^xk#̳) {<~u5guUS.@=yEdk׿c0\ܩqUK%4$'htW=[o+9Os7T?k[]\[yw3Ko(}O{#ӗIR21Fڪ-zQ[ !Y`NA9ӎMmQ\×w X16y=;zM&\+-,іfS<4v&D%1pV]׆RYvn?Zo[\_d2$>vLm_CQ 8BO! K3*Ԕv38rmAMvqbn.c]]I֫h&7vW:Q q'Da85vĶWWq[iԴmY>?ʑxP0=BE @icy0o8Zich$k>x~+_Q|lQ:cڛ7-M.ӬϏdyv,y$Ij,Ӧ(\ē6-Ժ,4Ƶfj&s{Ъlу~f:\[2(a23ϽKYQ@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Pfk}H."` Pwa=kxY%+p$k+–oڮKʉRq}wP^.d{gI.'8᳸ךhfMW8k<ˈ#`U[=Ar?ZҺYE-lHGPv|>]y[`*rUA#*կ i ]\;yx@v@NkogYkx*e+,`}7enN8!TD{JF85@*A[+Qnb@gI#ЗVѺW?*e~v#>Š/o5q˶I'%23ڮkr oi\E)"F?utPeV.2ۆm9?]\׾)-e_ L1U2Tԭu JOt©q}:zW_Eg<쑂_eP''뛾ҮG[{xݤ]1${d~UQ@^r&}C[{q!Sm|:Q["UfFO٫k1LXsY>!mtk-=dtx‚:U_Q{O^ɩAT}x>t5I9 Y!ޘCYKiwi39q1D P@< z ?\k{8pCD@ 5t} M[IC'Xp~(`? ( E (۟H@;(Copyright (c) Exbos Limited 2013. All Rights Reserved. Software developed in the United Kingdom by Exbos Limited the bespoke software specialists.M 1"uArialai036 n``Cd]Cd]fo57@CompObjpCompObj49aVBFrameBdialogNoPermission&<Cd]Cd]f3    edded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} dialogProcessing Caption = "Online Tool - Processing Request" ClientHeight = 5490 ClientLeft = 45 ClientTop = 375 ClientWidth = 7440 StartUpPosition = 1 'CenterOwner TypeInfoVer = 17 End $  * }3)R KQDBTahoma$@ Image1,#groupPermissions0(2labelCopyrightga$$)4buttonOKk$* Image3<H  & }1; PermissionsgR KQDBTahoma0(&2|Label3O\)FSorry, you do not have permission to access the o;Ai03? n``Cd]Cd]f o>@|:4R KQltJFIF``hExifMM*>F(1N``Paint.NET v3.5.10C   (1#%(:3=<9387@H\N@DWE78PmQW_bghg>Mqypdx\egcC//cB8Bcccccccccccccccccccccccccccccccccccccccccccccccccc" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ? ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( *fY}E|vZʹׯb2i&Di"`9EZ&3H΂.Y+O?Kk0fj]=Q~]6?u Bj\"UP&}^F$Lr<J(Ӽ09ر=kMF&nX`UrV׉[|Fq89EkwPK4L<`:ҸRU(lnl2m3[lRᔎIm ʡchϗGM[TAOG>\GpQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQE! kZs3Z] `s-'V[fI_.$EL:΀::+"Vwີ-[7Y^(-jӋ@9~xh J6Gh_,~|T~'sMj4Ec^xk#̳) {<~u5guUS.@=yEdk׿c0\ܩqUK%4$'htW=[o+9Os7T?k[]\[yw3Ko(}O{#ӗIR21Fڪ-zQ[ !Y`NA9ӎMmQ\×w X16y=;zM&\+-,іfS<4v&D%1pV]׆RYvn?Zo[\_d2$>vLm_CQ 8BO! K3*Ԕv38rmAMvqbn.c]]I֫h&7vW:Q q'Da85vĶWWq[iԴmY>?ʑxP0=BE @icy0o8Zich$k>x~+_Q|lQ:cڛ7-M.ӬϏdyv,y$Ij,Ӧ(\ē6-Ժ,4Ƶfj&s{Ъlу~f:\[2(a23ϽKYQ@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Q@Pfk}H."` Pwa=kxY%+p$k+–oڮKʉRq}wP^.d{gI.'8᳸ךhfMW8k<ˈ#`U[=Ar?ZҺYE-lHGPv|>]y[`*rUA#*կ i ]\;yx@v@NkogYkx*e+,`}7enN8!TD{JF85@*A[+Qnb@gI#ЗVѺW?*e~v#>Š/o5q˶I'%23ڮkr oi\E)"F?utPeV.2ۆm9?]\׾)-e_ L1U2Tԭu JOt©q}:zW_Eg<쑂_eP''뛾ҮG[{xݤ]1${d~UQ@^r&}C[{q!Sm|:Q["UfFO٫k1LXsY>!mtk-=dtx‚:U_Q{O^ɩAT}x>t5I9 Y!ޘCYKiwi %!3V$}"WAB&"H42  L4҈6C ?#r 3B )a ,#!H$pt1D6a0' -ȐH8!WX1IC 1 +(aG!|矀ZX4EU\an1GwGU1naU16" "NZr&FBy:*FVa**)zǬ޺Rkʇj{P!jk{L[x؁~kΞ -(誫 zENnGxPB2GtQ+zL B 9,a!K.uD+!?8G2CBш" 8`Dq!,C/tG'-Q1 Z?ѵB:6!=!lGzpUۆGN̝С),ryth #@kAF]sskˆ%|i!ӱ t kͅPi 0>FqB ~f#0 a` uqDA<"mnѬwHu? c ƁSSX=a:#Q? mh+hA b@4bIcwCD`{4$olpCbJ +CZ`>XLE(X(\ p?: "0BL! ܠ9G@;requested information. !/uTahoma n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} dialogNoPermission Caption = "Online Tool - Permissions" ClientHeight = 5955 ClientLeft = 45 CCompObjpCompObj=BaVBFrame=SummaryInformation(DlientTop = 375 ClientWidth = 7545 StartUpPosition = 1 'CenterOwner TypeInfoVer = 10 End Oh+'0@H` Lee Hesselden(Taylor, Maxine (R&D Managment Block)Microsoft Excel@~@d] FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q fDocumentSummaryInformation8xCompObjkExbos Limited  DataSheetHelpAddedByUserIdLookUpAmendedByUserIdLookUpReasonForClosureOfTrialLookUp(TargetDateToRecruitPatientsAgreedLookUp#TargetNumberOfPatientsAgreedLookUp  Worksheets Named RangesA՜.+,0H X`x  fExbos Limited  DataSheetHelpAddedByUserIdLookUpAmendedByUserIdLookUpReasonForClosureOfTrialLookUp(TargetDateToRecruitPatientsAgreedLookUp#TargetNumberOfPatientsAgreedLookUp  Worksheets Named RangesA/,8[0+ *H 010 *H 0R +7D0B0 +7{zjnl&{Ɲ0 0 *H Kc<,E1m\u] 0 04NW I/7+m0  *H 01 0 UUS10U  thawte, Inc.1(0&U Certification Services Division1806U /(c) 2006 thawte, Inc. - For authorized use only10Uthawte Primary Root CA0 061117000000Z 360716235959Z01 0 UUS10U  thawte, Inc.1(0&U Certification Services Division1806U /(c) 2006 thawte, Inc. - For authorized use only10Uthawte Primary Root CA0"0  *H 0 YԜǤϝYs E ,nhl[HhIY7 3w-4M Ҹɗ6$_DboZ(\z tf/j8TDoN )>~qe Q{"` [ߺQ[ .b+NLdχXJOhJ/|qrg2ɒ\څS}+ 􌝑jR 6w{PD>n)i9I& {@-'a~|՝B0@0U00U0U{[Eϯz1jFWHP0  *H yKg nEU?%W:vLPvdr և2Awٳ`nDDUbw\HI|;Ws7/x\hG``=" rs|/>j'ZMd a9{"@yo=yv7!6c 3ADc B?,vcYݏ.A.Gϼ3 a~~+G'0]7\9+{Vh00q6ݱ;+T0  *H  01 0 UUS10U  thawte, Inc.1(0&U Certification Services Division1806U /(c) 2006 thawte, Inc. - For authorized use only10Uthawte Primary Root CA0 131210000000Z 231209235959Z0L1 0 UUS10U  thawte, Inc.1&0$Uthawte SHA256 Code Signing CA0"0  *H 0 ULf(~FS}'gʷ%S㾛#\Bd%X"Ǯ"tith0d8>sW5WPfvqcɺѹ,(! A /€{SlDchG+*[Iaikx&i08NZUP֪8GC\MsIœiwW3BwĻ9\:d'W@S)4_00/+#0!0+0http://t2.symcb.com0U002U+0)0'%#!http://t1.symcb.com/ThawtePCA.crl0U%0++0U0)U"0 010USymantecPKI-1-5680UWT)ܷ0U#0{[Eϯz1jFWHP0  *H  $;נ6C hј1n?{kLl {PՁ,)A,Y-G@=y5L'gEżNU{҇0l̙5m`h)YKFɎuO N'D3s oulD>ɽ,VwF,巧7uUwM^6)ʅEArWuy[4md B:Fd_G:(TOCoI^B (G n00Р{ N~qS7 !0  *H  0L1 0 UUS10U  thawte, Inc.1&0$Uthawte SHA256 Code Signing CA0 160215000000Z 180316235959Z01 0 UGB10UWest Yorkshire10UBradford10U  Exbos Limited10U System Development10U Exbos Limited0"0  *H 0 12L) 8K<:ċ;݅,wYyd"YsKq"Č`1xlw^ypc-v,:-2OB "hҌ~Z4)nƪu /p'/ f`)9p+n|p;-?.FV9m"ҲxQoK$}~j>$@<m 'd@${M^>u 1&z>ͭ L/JOS¬I|00 U00U#0WT)ܷ0U͡n(<-UT0+U$0"0 http://tl.symcb.com/tl.crl0U0U% 0 +0nU g0e0cg 0Y0&+https://www.thawte.com/cps0/+0# !https://www.thawte.com/repository0U000  +70W+K0I0+0http://tl.symcd.com0&+0http://tl.symcb.com/tl.crt0  *H  US)F%;`s񭔨'iԢkzBQU46v9!C(C{կnSi&>w*82I—;9Fl%ڋjڋV+㔽qNHZZSCHZS`o('S)vD(җc1FBQe3gXVj.Yٹ+[\F>fD8?@baJ5` 96gc ۊd100`0L1 0 UUS10U  thawte, Inc.1&0$Uthawte SHA256 Code Signing CA{ N~qS7 !0 *H p0 +7 100 *H  1  +70 +7 10  +70 *H  1=>];:<ߓ$VH0  *H ׸}И͒' `a6i i%F;iV`koK ,?E_m'"dl냎Ut-8ĭhKx$ 7;1]N^1p^W%P2ٳ}dy B|Nc([˔~\ $ZcEɲ  X( 7ׯQZe+4c!)vBbl (`*>񘆫-Z(nC%6cP|<`#2{4CERT +ޣgq=B'm8jBv5Mي 00Р{ N~qS7 !0  *H  0L1 0 UUS10U  thawte, Inc.1&0$Uthawte SHA256 Code Signing CA0 160215000000Z 180316235959Z01 0 UGB10UWest Yorkshire10UBradford10U  Exbos Limited10U System Development10U Exbos Limited0"0  *H 0 12L) 8K<:ċ;݅,wYyd"YsKq"Č`1xlw^ypc-v,:-2OB "hҌ~Z4)nƪu /p'/ f`)9p+n|p;-?.FV9m"ҲxQoK$}~j>$@<m 'd@${M^>u 1&z>ͭ L/JOS¬I|00 U00U#0WT)ܷ0U͡n(<-UT0+U$0"0 http://tl.symcb.com/tl.crl0U0U% 0 +0nU g0e0cg 0Y0&+https://www.thawte.com/cps0/+0# !https://www.thawte.com/repository0U000  +70W+K0I0+0http://tl.symcd.com0&+0http://tl.symcb.com/tl.crt0  *H  US)F%;`s񭔨'iԢkzBQU46v9!C(C{կnSi&>w*82I—;9Fl%ڋjڋV+㔽qNHZZSCHZS`o('S)vD(җc1FBQe3gXVj.Yٹ+[\F>fD8?@baJ5` 96gc ۊd