ࡱ> ?b>  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry F`)y@hWorkbook+s_VBA_PROJECT_CUR")(.w`)yVBAwx f2ɀ\pSakamoto Daiki Ba=*( ThisWorkbook=x-8X@"1 -3 000001 -3 000001 -3 000001 -3 000001 x-3 000001 x-3 000001 -3 000001 x-3 000001 -3 000001 -3 000001 h8-3 000001  -3 000001 <-3 000001 4-3 000001 -3 000001 4-3 000001 -3 000001 ,8-3 000001 8-3 000001 8-3 000001 -3 000001 ?-3 000001 -3 000001 >-3 000001 -3 000001 -3 000001 -3 000001hCalibri""#,##0;""\-#,##0""#,##0;[Red]""\-#,##0""#,##0.00;""\-#,##0.00#""#,##0.00;[Red]""\-#,##0.007*2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ?,:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\) m/d/yyyy                                                                                 ff         `      &  ( P P    a>                ||DQ}-} .00\)_ *}-} .00\)_ *}-} .00\)_ *}-} .00\)_ *}-} .00\)_ *}-} .00\)_ *}-} .00\)_ *}-} .00\)_ *}-} .00\)_ *}-}  .00\)_ *}-}  .00\)_ *}-}  .00\)_ *}-}  .00\)_ *}-}  .00\)_ *}-} .00\)_ *}-} .00\)_ *}A} .00\)_ *ef;_ @_ }A} .00\)_ *ef;_ @_ }A} .00\)_ *ef;_ @_ }A} .00\)_ *ef;_ @_ }A} .00\)_ *ef;_ @_ }A} .00\)_ *ef ;_ @_ }A} .00\)_ *L;_ @_ }A} .00\)_ *L;_ @_ }A} .00\)_ *L;_ @_ }A} .00\)_ *L;_ @_ }A} .00\)_ *L;_ @_ }A} .00\)_ *L ;_ @_ }A} .00\)_ *23;_ @_ }A} .00\)_ *23;_ @_ }A} .00\)_ *23;_ @_ }A} .00\)_ *23;_ @_ }A}  .00\)_ *23;_ @_ }A}! .00\)_ *23 ;_ @_ }A}" .00\)_ *;_ @_ }A}# .00\)_ *;_ @_ }A}$ .00\)_ *;_ @_ }A}% .00\)_ *;_ @_ }A}& .00\)_ *;_ @_ }A}' .00\)_ * ;_ @_ }-}( .00\)_ *}}) .00\)_ *;_ @_ ??? ??? ??? ???}A}* e.00\)_ *;_ @_ }-}+ .00\)_ *}}, .00\)_ *;_ @_    }A}- }.00\)_ *;_ @_ }A}. .00\)_ *;_ @_ }}/ }.00\)_ *;_ @_    }-}0 .00\)_ *}-}1 .00\)_ *}-}2 .00\)_ *}A}3 .00\)_ *;_ @_ }A}4 .00\)_ *?;_ @_ }A}5 .00\)_ *23;_ @_ }-}6 .00\)_ *}U}7 .00\)_ *;_ @_  }}8 ???.00\)_ *;_ @_ ??? ??? ??? ???}-}9 .00\)_ *}-}: .00\)_ *}-}; .00\)_ *}}< ??v.00\)_ *̙;_ @_    }A}= a.00\)_ *;_ @_ }-}> .00\)_ *}-}? .00\)_ *}-}@ .00\)_ *}-}A .00\)_ *}-}B .00\)_ *}-}C .00\)_ * 20% - 00000 1M 20% - 00000 1 ef % 20% - 00000 2M" 20% - 00000 2 ef % 20% - 00000 3M& 20% - 00000 3 ef % 20% - 00000 4M* 20% - 00000 4 ef % 20% - 00000 5M. 20% - 00000 5 ef % 20% - 00000 6M2 20% - 00000 6  ef % 40% - 00000 1M 40% - 00000 1 L % 40% - 00000 2M# 40% - 00000 2 L渷 % 40% - 00000 3M' 40% - 00000 3 L % 40% - 00000 4M+ 40% - 00000 4 L % 40% - 00000 5M/ 40% - 00000 5 L % 40% - 00000 6M3 40% - 00000 6  Lմ % 60% - 00000 1M 60% - 00000 1 23 % 60% - 00000 2M$ 60% - 00000 2 23ږ % 60% - 00000 3M( 60% - 00000 3 23כ % 60% - 00000 4M, 60% - 00000 4 23 % 60% - 00000 5M0 60% - 00000 5 23 %! 60% - 00000 6M4 60% - 00000 6  23 %"00000 1A00000 1 O %#00000 2A!00000 2 PM %$00000 3A%00000 3 Y %%00000 4A)00000 4 d %&00000 5A-00000 5 K %'00000 6A100000 6  F % (0000/0000 I}%)0000 00y0000 00  %????????? ???*i0a00g00j0D0Ai0a00g00j0D0  e%+ 00000 ,00^ 00  -000 00A000 00 }% .`D07`D0  % /{o{  }%  0fJTe- fJTe %1Ah:SR02, Ah:SR0 [0.00]3QW0 1?QW0 1 I}%O4QW0 2?QW0 2 I}%?5QW0 3?QW0 3 I}%236QW0 41QW0 4 I}% 7ƖGƖ %OO 8QRoQR  ???%????????? ??? 9fe-5fe %:;(  [0.00] <eQRoeQR ̙ ??v% +jn % =oD07oD0  a%XTableStyleMedium2PivotStyleLight16` TestResultTestDataqHiddenQQ8 BBD!R    %m   .  @   d<  d  Q "   <3 A@@  ;ValuetextBelgiumMoscowNigeriaPeruRussiaSwissgProvider=SQLOLEDB;Data Source=MERCURY\SQLEXPRESS;Initial Catalog=Test Database;Integrated Security=SSPISELECT * FROM dbo.PersonID 5Country 5City 5Name 5Sex 5Age 5Date 5Datected 5Assigned 5Fixed 5 Confirmed 5Open 5Closed 5Total 5Detact 5Gompertz 5America 5Tokyo 5Taro 5Male 5Osaka 5Hanako 5Female 5Canada 5Nagoya 5Sapporo 5English 5Mishima 5French 5German 5Hawaii 5Italy 5Japan 5Korea 5a 5b 5c 5DeutschKyoto 5Yokohama 5Tanaka 5Suzuki 5Satoh 5Saitoh 5Mike 5James 5Martin 5Eric 5Female 5Male 5 Properties 5Name1 5Name2 5Name3 5Name10 5Name11 5Name12 5Name13 5x 5y1 5y2 5y3 5Name15 5Invalid 5Name20 5Name21 5Name22 5Value 2 5 Properties 2 5Conv 5Day 5Date 5NOET 5NODF 5ROFC 5sqerr 5VBA Toolkit V1.00 Test Result Test NameResult DataGridTestDataGrid.FindRow 1PassDataGrid.FindRow 2DataGrid.FindRow 3DataGrid.FindColumn 1DataGrid.FindColumn 2DataGrid.FindColumn 3DataGrid.FindCell 1DataGrid.FindCell 2DataGrid.FindCell 3DataGrid.Find 1DataGrid.Find 2DataGrid.Find 3 MetadataTestMetadata.CountWorksheets 1!Metadata.CountVisibleWorksheets 1 Metadata.CountHiddenWorksheets 1Metadata.FindSheetName 1Metadata.ContainSheetName 1Metadata.ContainSheetName 2Metadata.SetNameToCell 1Metadata.SetNameToCell 2Metadata.SetNameToRange 1Metadata.SetNames 1Metadata.SetNamesToRange 1$Metadata.SetCustomDocumentProperty 1&Metadata.SetCustomDocumentProperties 1 ChartsTestCharts.AddChart 1Charts.AddChart 2Charts.AddScatterChart 1Charts.AddBurnDownChart 1Charts.AddBurnDownChart 2QualityIndicatorTestQualityIndicator.Show 1QualityIndicator.Show 2QualityIndicator.Show 3QualityIndicator.Show 4QualityIndicator.ShowFull 14QualityIndicator.RatioOfFaultDetectionInComparison 1QualityIndicator.Gompertz 1DataAccessTestnameageTaroHanakoDataAccess.Export 1 5 ClipBoardTestClipBoard.CopyRowsFrom 1ClipBoard.CopyRowsFrom 2ClipBoard.CopyRowsFrom 3t tPvvw_wDx/y}zb{9|'}}O ~ "| m A  Z ccBOUj_ KU f2ɀ ;}  dMbP?_*+%&ffffff?'ffffff?(?)?"O333333?333333?m&<3U} -;)      AV W X BY Z C[ \ C[ ] C[ ^ C[ _ C[ ` C[ a C[ b C[ c C[ d C[ e C[ f C[ Bg h C[ i C[ j C[ k C[ l C[ m C[ n C[ o C[ p C[ q C[ r C[ s C[ t C[>F0!)")#)$)%)&)()))*)+),)-).)/)12345789: !Bu "v "C[ #w #C[#'( $x $C[~ $' %y %C[~ %' &z &C[ (B{ )| )C[ *} *C[ +~ +C[ , ,C[ - -C[ . .C[ / /C[ 1B 2 2 3~ 3(@ 4~ 4$@ 5 5C[ 7B 8 8C[ 9 9C[ : :C[2J2**  (   j  c 0N 000 1 ] @  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH!0(  !h3d23   MR R R RI3~S S4 3Q:  xQ ; QQ3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q:  y1Q ; QQ3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q:  y2Q ; QQ3_ M 7 f Y@"B  ` MM<R R R R5S S4ES S 4 3Q:  y3Q ; QQ3_ M ff6 f d@"B  ` MM<R R R RjVS S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FAm  3OK,; 3 bR RR RV Vd&! 4u,՛4 .` (QRS S43* &! ! R R4u,4u,k4S S4523 M  MR R4n]S S43" 4S S4DK,; % +Nh 3O+&Q &Charts.AddChart 123 M NMR RR Rr]S S4'<,-{ܩ xxxxxxxxxxxxxxxxx /S S4k4 [S S 4ee?$@i@@@?{Gz@zGJ@p= ף@433333?@m@@}@@@?@N@@?333333?@R@L@e*vja-JPi rj  c 0N 000 1 "]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH !0(  !h3d23   MR R R RI3~S S4 3Q:  xQ ; QQ3_ ff6 MM f O@"B  ` ffff66R R R R#rx\ "-S S4ES S 4 3Q:  y2Q ; QQ3_ 3f MM f PM@"B  ` 3f3fR R R Rݥ_|X "-S S4ES S 4 3Q:  y3Q ; QQ3_ 2 MM f Y@"B  ` 27R R R RF  "-S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FAm P 3OK3 u 3*&! R RR R4u,S S43* &! ! R R4u,4u,k4S S4523 M  MR R4n]S S43d"  3O '5% 03O&Q423 M NMR RR R R R4]S S4<+ k4 /S S 4S S4S S4DK3 u % +Nh 3O+&Q &Charts.AddChart 223 M NMR RR Rr]S S4'<,-ݩ xxxxxxxxxxxxxxxxx /S S4k4 [S S 4ee?i@@@?zGJ@p= ף@433333?@}@@@?N@@?333333?R@L@e*vja-JPi rj  c 0N 000 1" 2]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH0!0(  !h3d23   MR R R RI3~S S4 3Q:  y2Q ; Q ; Q3_ ff6 MM f O@"B  ` ffff66R R R R#rx\ "-S S4ES S 4 3Q:  y3Q ; Q ; Q3_ 3f MM f PM@"B  ` 3f3fR R R Rݥ_|X "-S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FAm P 3OK3 u 3*&! R RR R4u,S S43* &! ! R R4u,4u,k4S S4523 M  MR R4n]S S43d"  3O '#% 03O&Q423 M NMR RR R R R4]S S4<7 k4 /S S 4S S4S S4DK3 u % s+h 3O+&Q 4Charts.AddScatterChart 123 M NMR RR Rr]S S4'<,4$  xxxxxxxxxxxxxxxxxxxxxxxx /S S4k4 [S S 4e????433333?433333?????333333?333333?ei@@@zGJ@p= ף@@}@@@N@@R@L@e*vja-JPi rj  c 0N 000 12 B]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH@!0(  !h3d23   MR R R RI3~S S4 3Q: TotalQ ;Q ;Q3_ M ff6 f Od@O"B   ` MM<R R R Rz/:b S S4ES S 4 3Q:  OpenQ ;Q ;Q3_ 3f MM f PM@"B  ` 3f3fR R R Rݥ_|X r"-S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA2  3OK" 3 b ! N -&! R RR R4u,D0rS-@T?j`k`paS S43* &! ! R Ru,u,k4S S4523 M  MR R4n]S S43" 43" 4S S4DK" % + h 3O)+&Q 6Charts.AddBurnDownChart 123 M NMR RR Rr]S S4'<,5qa! xxxxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4e @ @@@@@`@`@@@@@@@@@@@ @ @ @@ @@ `@ `@ @ @ @ @ @ @@@@@ @ @@@@@`@`@@@@@@@@@@@ @ @eY@Y@Y@V@Y@@T@Y@R@Y@P@Y@L@Y@I@Y@F@Y@D@ Y@ B@ Y@ @@ ^@ H@ ^@ E@ ^@ C@^@A@^@>@^@;@^@8@^@5@^@2@^@0@^@,@^@(@^@$@^@"@e*rvja-JP rPi rj  c 0N 000 1B R]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PHP !0(   !h3d23   MR R R RI3~S S4 3Q:  OpenQ ;Q ;Q3_ ff6 MM f O@"B  ` ffff66R R R R#rx\ r"-S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA:P  3OK{ 3 b ! N -&! R RR R4u,D0rS-@T?j`k`paS S43* &! ! R Ru,u,k4S S4523 M  MR R4n]S S43" , <JJ3O, =4% 03O&Q423 M NMR RR R R R4]S S4<Ck4 r/S S 4S S4S S4DK{ % + h 3O)+&Q 6Charts.AddBurnDownChart 223 M NMR RR Rr]S S4'<,5q! xxxxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4e @@@`@@@@@@ @ @@ `@ @ @ @@@ @@@`@@@@@@ @eY@V@@T@R@P@L@I@F@D@ B@ @@ H@ E@ C@A@>@;@8@5@2@0@,@(@$@"@e*rvja-JP rPi rj  c 0N 000 1R b]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH`$!0(  $!h3d23   MR R R RI3~S S4 3Q: DatectedQ ;Q ;Q3_ M ff6 f Er@"B  ` MM<R R R RDS S4ES S 4 3Q: AssignedQ ;Q ;Q3_ M 3f f FC@"B  ` MM<R R R RvM)S S4ES S 4 3Q: FixedQ ;Q ;Q3_ M  f N@"B  ` MM<R R R RaS S4ES S 4 3Q:  ConfirmedQ ;Q ;Q3_ M ff6 f qX@"B  ` MM<R R R RTFS S4ES S 4 3Q:  OpenQ ;Q ;Q3_ 31 MM  $$dR R R Rcp? r"#S S4ES S 4 3Q: ClosedQ ;Q ;Q3_ 4 MM  %%dR R R R( r"#S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA 3OK& u 3 b ! N -&! R RR R4u,D0rS#@T?j`k`paS S43* &! ! R Ru,u,k4S S4523 M  MR R4n]S S43" > 83O? Ik% 03O&Q423 M NMR RR R R R4]S S4<1k4 r/S S 4S S4S S4A 3O3 b !"N#! MR RR RbNrS#?T?_`dyyyy/m/dj`k`S S43* &! R R4u,k4S S43"  4S S4DK& u % +)h 3O+&Q 2QualityIndicator.Show 123 M NMR RR Rl]S S4'<,3m; xxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4e @ @ @ @ @ @@@@@@@@@@@@@`@`@`@`@`@`@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @ @ @@ @@ @@ @@ @@ @@ `@ `@ `@ `@ `@ `@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@@@@@@@ @ @ @ @ @ @@@@@@@@@@@@@`@`@`@`@`@`@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @ @e????@@@?@@@?@@?@@?@?@ ?    @ @   ?  ? @ @  ?  @ @ @  @ @ @ @ @  @ @ "@ @"@@@.@ @@@@,@@@@@,@@@@&@@?@$@@@@?&@@@@$@ @@ @$@??? @$@??? @$@?@&@e*rvja-JP ri rj  c 0N 000 1b r]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PHp(!0(  (!h3d23   MR R R RI3~S S4 3Q: DatectedQ ;Q ;Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q: FixedQ ;Q ;Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q:  ConfirmedQ ;Q ;Q3_ M 7 f Y@"B  ` MM<R R R R5S S4ES S 4 3Q:  OpenQ ;Q ;Q3_ ff6 MM  ##dR R R R\ r"#S S4ES S 4 3Q: ClosedQ ;Q ;Q3_ 31 MM  $$dR R R Rcp? r"#S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA 3OK& u 3 b ! N -&! R RR R4u,D0rS#@T?j`k`paS S43* &! ! R Ru,u,k4S S4523 M  MR R4n]S S43" > 83O? IY% 03O&Q423 M NMR RR R R R4]S S4< k4 r/S S 4S S4S S4A 3O3 b !"N#! MR RR RbNrS#?T?_`dyyyy/m/dj`k`S S43* &! R R4u,k4S S43"  4S S4DK& u % +)h 3O+&Q 2QualityIndicator.Show 223 M NMR RR Rl]S S4'<,3Pl; xxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4e @ @ @ @ @@@@@@@@@@@`@`@`@`@`@@@@@@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @ @@ @@ @@ @@ @@ `@ `@ `@ `@ `@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@@@@@ @ @ @ @ @@@@@@@@@@@`@`@`@`@`@@@@@@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @e????@@@?@@@?@@?@@?@?@ ?   @ @  ?  ? @ @ ?  @ @ @ @ @ @ @ @ @ @ "@ @"@@@.@ @@@@,@@@@@,@@@@&@@?@$@@@@?&@@@@$@ @@ @$@??? @$@??? @$@?@&@e*rvja-JP ri rj  c 0N 000 1r ]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH,!0(  ,!h3d23   MR R R RI3~S S4 3Q: DatectedQ ;Q ;Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q: AssignedQ ;Q ;Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q: FixedQ ;Q ;Q3_ M 7 f Y@"B  ` MM<R R R R5S S4ES S 4 3Q:  ConfirmedQ ;Q ;Q3_ M ff6 f d@"B  ` MM<R R R RjVS S4ES S 4 3Q: ClosedQ ;Q ;Q3_ 31 MM  $$dR R R Rcp? r"#S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA 3OK& u 3 b ! N -&! R RR R4u,D0rS#@T?j`k`paS S43* &! ! R Ru,u,k4S S4523 M  MR R4n]S S43" > 83O? IY% 03O&Q423 M NMR RR R R R4]S S4< k4 r/S S 4S S4S S4A 3O3 b !"N#! MR RR RbNrS#?T?_`dyyyy/m/dj`k`S S43* &! R R4u,k4S S43"  4S S4DK& u % +)h 3O+&Q 2QualityIndicator.Show 323 M NMR RR Rl]S S4'<,3l; xxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4e @ @ @ @ @@@@@@@@@@@`@`@`@`@`@@@@@@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @ @@ @@ @@ @@ @@ `@ `@ `@ `@ `@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@@@@@ @ @ @ @ @@@@@@@@@@@`@`@`@`@`@@@@@@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @e???@?@@?@?@?@@ ?    @   ?  @ @  ?  @ @  @ @ @ @  @ @ @"@@@ @@@@@@@@@@@@?@@@@?@@@ @@$@???$@???$@?&@e*rvja-JP ri rj  c 0N 000 1 U]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH0!0(  0!h3d23   MR R R RI3~S S4 3Q: DatectedQ ;Q ;Q3_ M ff6 f O@"B  ` MM<R R R R8]hS S4ES S 4 3Q: FixedQ ;Q ;Q3_ M 3f f PM@"B  ` MM<R R R R3YlS S4ES S 4 3Q:  ConfirmedQ ;Q ;Q3_ M 7 f Y@"B  ` MM<R R R R5S S4ES S 4 3Q: ClosedQ ;Q ;Q3_ ff6 MM  ##dR R R R\ r"#S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA 3OK& u 3 b ! N -&! R RR R4u,D0rS#@T?j`k`paS S43* &! ! R Ru,u,k4S S4523 M  MR R4n]S S43" > 78R3O? 8IG% 03O&Q423 M NMR RR R R R4]S S4<9 k4 r/S S 4S S4S S4A 3O3 b !"N#! MR RR RbNrS#?T?_`dyyyy/m/dj`k`S S43* &! R R4u,k4S S43"  4S S4DK& u % +)h 3O+&Q 2QualityIndicator.Show 423 M NMR RR Rl]S S4'<,3o; xxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4e @ @ @ @@@@@@@@@`@`@`@`@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @@ @@ @@ @@ `@ `@ `@ `@ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@@@ @ @ @ @@@@@@@@@`@`@`@`@@@@@@@@@@@@@@@@@@@@@ @ @ @ @e???@?@@?@?@?@@ ?   @  ?  @ @ ?  @ @ @ @ @ @ @ @ @"@@@ @@@@@@@@@@@@?@@@@?@@@ @@$@???$@???$@?&@e*rvja-JP r@ rj  c 0N 000 1 U"]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH4!0(  4!h3d23   MR R R RI3~S S4 3Q: DatectedQ ;Q ;Q3_ M ff6 f Er@"B  ` MM<R R R RDS S4ES S 4 3Q: AssignedQ ;Q ;Q3_ M 3f f FC@"B  ` MM<R R R RvM)S S4ES S 4 3Q: FixedQ ;Q ;Q3_ M  f N@"B  ` MM<R R R RaS S4ES S 4 3Q:  ConfirmedQ ;Q ;Q3_ M ff6 f qX@"B  ` MM<R R R RTFS S4ES S 4 3Q:  OpenQ ;Q ;Q3_ 31 MM  $$dR R R Rcp? r"#S S4ES S 4 3Q: ClosedQ ;Q ;Q3_ 4 MM  %%dR R R R( r"#S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA 3OK& u 3 b ! N -&! R RR R4u,D0rS#@T?j`k`paS S43* &! ! R Ru,u,k4S S4523 M  MR R4n]S S43" > 83O? Ik% 03O&Q423 M NMR RR R R R4]S S4<1k4 r/S S 4S S4S S4A 3O3 b !"N#! MR RR RbNrS#?T?_`dyyyy/m/dj`k`S S43* &! R R4u,k4S S43"  4S S4DK& u % +[ h 3O+&Q :QualityIndicator.ShowFull 123 M NMR RR Rl]S S4'<,7# xxxxxxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4e @ @ @ @ @ @@@@@@@@@@@@@`@`@`@`@`@`@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @ @ @@ @@ @@ @@ @@ @@ `@ `@ `@ `@ `@ `@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@@@@@@@ @ @ @ @ @ @@@@@@@@@@@@@`@`@`@`@`@`@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ @ @ @ @ @e????@@@?@@@?@@?@@?@?@ ?    @ @   ?  ? @ @  ?  @      !"#$%&'()*+,-./0123456789:;<=H`ABCDEFGYJKLVNOPQRSTUIWX[\]^_a/btdefghijklmnopqrsZuvwxyz{|}~ @ @  @ @ @ @ @  @ @ "@ @"@@@.@ @@@@,@@@@@,@@@@&@@?@$@@@@?&@@@@$@ @@ @$@??? @$@??? @$@?@&@e*rvja-JP ri rj  c 0N 000 1 "U2]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH8!0(  8!h3d23   MR R R RI3~S S4 3Q:  NOETQ ; Q ;Q3_ ff6 MM   dR R R R\ r"#S S4ES S 4 3Q:!  NODFQ ;!!Q ;Q3_ 3f MM  !!dR R R RYW r"#S S4ES S 4 3Q:"  ROFCQ ;""Q ;Q3_ 2 MM  ""dR R R Rb  r"#S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FAK{I 3O0f 3*&! R RR R4u,S S43* &! ! R R4u,4u,k4S S4523 M  MR R4n]S S43d"  [3O 55% 03O&Q423 M NMR RR R R R4]S S4< k4 r/S S 4S S4S S4AK{I 3O3*#! M43* &! R RR R4u,k4S S43d" 4S S4D0f % +W % 3OtJ&Q l4QualityIndicator.RatioOfFaultDetectionInComparison 123 M NMR RR Rl]S S4'<,P4+< xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4e@@@@@@ @ @ @@@@@@@`@`@`@@@@@@@@@@@@@ @ @ @ @  @  @ @@ @@ @@ `@ `@ `@ @ @ @@@@@@@@@@@@@ @ @ @@@@@@@`@`@`@@@@@@@@@@@@@e$@?4@?>@?D@@I@@N@@Q@@T@@V@@ Y@  @  [@  @  ^@ &@ @ @`@ 1@ /袋.@ a@ 5@ xxxxxx@b@>@@d@@@?@e@A@ |?f@A@g@A@i@C@?@j@D@y 5?k@D@y 5?l@D@?n@E@?@o@E@18?e*rvja-JPri rj  c 0N 000 1 2UB]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH xxxxxxxxxxxxxxxxxxxxxxxxxxx r/S S4k4 r[S S 4!e???@@@@@@@@@@@@@@@@@@ @ @ @"@"@"@ $@ $@ $@ &@ &@ &@ (@ (@ (@ *@ *@ *@ ,@ ,@ ,@.@.@.@0@0@0@1@1@1@2@2@2@3@3@3@4@4@4@5@5@5@6@6@6@7@7@7@8@8@8@9@9@9@:@:@:@;@;@;@<@<@<@=@=@=@>@>@>@?@?@?@@@@@@@ @@ @@ @@e?#?1\?@L}?1\?@:b6?1\?@.f?1\?@zEy@jY?(@g6R@Ѥ?.@ m#@+N_)w?.@8ф-@+N_)w?.@KNz4@+N_)w? 3@ m0H9@  &m3? 7@ ph?@ H3? @@ 1BSxB@ cO? F@ J `D@ z_Y? J@ #C G@ @%$?L@TI@jY?M@?bJ@n}ܗA?M@.K@A{?M@SҰfM@A{?M@dM@A{?N@;rWN@+N_)w?N@dVdVO@C?N@3`#O@C?N@v:vP@C?Z `sBP@s*bP@Kq{P@P@qTP@B?P@kVSP@\QP@>xqP@  }wP@ e*rvja-JPri >@445ggD f2ɀ &OR  dMbP?_*+%&ffffff?'ffffff?(?)?Mz\\Betelgeuse\Canon iP7500-1C76 ߁ 4d A4BJDM 0Rt,T`Op,T`OpRt,TT`Op,TT,TT`OpXX'  d Rt Rt.Q Rt   \\Betelgeuse\Canon iP7500 ߁ 4d A4T1~" d333333?333333?&<3U} }  }  } @}  } }  } } } ` } } } }  } }  } } !` } ""` } ##} $$ } &' } )) &**?******** * * * * ******************* ? ? ? ? ? ? <   N M ? ? ? ? ? ? ? ? ? ? ?Q ?R !?S "?T $?P %? &? '? (?U )?O~ ?  =~  $@> @Y@Y@> @?!? DD~ >@$@ #!? %@$@??%#&@? %%@%5'@#?!D#'D$'D%'D$AA+(/, rc?!'D'D&@AQ!)1\?( D&D#'@ L  >  >@@ DY@  L(V@D?A>@@ D~ ?LLL~ ?>@ D 4@ D  #!?! %@$@@$ D$~ %?#&@@$ %%@%5'@L}?'D#'D$'D%'D$AA+(-Wo @)D'D&@AQ!)1\?( D&D#'@ ! ?~  >`@ >>`@ LY@@T@L?A>`@ L> @ L >@    L #!?! %@$@@$!$$ L~ %@#&@@& %%@%5'@:b6?'D#'D$'D%'D$AA+(bÈ(@)D'D&@AQ!)1\?( D&D#'@ />@Y@R@>@~ @@>@@ D@  #!@! %@$@@$$~ %#&@@& %%@%5'@.f?'D#'D$'D%'D$AA+(R@)D'D&@AQ!)1\?( D&D#'@ $>@Y@P@>@@>`@ I@  #!@! %@$@@$$~ %@#&@@& %%@%5'@zEy@'D#'D$'D%'D$AA+(D1=l/@)D'D&@AQ!)jY?( D&D#'@ &>@Y@L@>@~ ?@~ @>@ N@  #!@! %@$@@$$~ %@#&@(@& %%@%5'@g6R@'D#'D$'D%'D$AA+(jʪ]C@)D'D&@AQ!)Ѥ?( D&D#'@ '>@Y@I@>@~ @~ ?@~ @>@ Q@  #!@! %@$@@$$~ %@#&@.@& %%@%5'@ m#@'D#'D$'D%'D$AA+(:46;@)D'D&@AQ!)+N_)w?( D&D#' @  (>@ Y@ F@ >@ ~ ?@ ~ @>@  T@  #!@! %@$@ @ $$~ %#&@.@  %%@%5'@8ф-@'D#'D$'D%'D$AA+(71:?)D'D&@AQ!)+N_)w?( D&D#' "@  ) > @  Y@  D@  > @ ~ ?~ @ ? ~ @ >@  V@  # !@! % @ $@"@ $$~ %# &@.@  % %@%5 '@KNz4@'D#'D$'D%'D $AA+ (CWN9@)D 'D &@AQ! )+N_)w? ( D &D#' $@  * @~ ? D E F G >@@  Y@  B@  >@@ ~ ? @  @   LLL >@  Y@  # ! @ ! % @ $@$@ $$~ %@# &@3@  % %@%5 '@m0H9@ 'D#'D$'D%'D $AA+ (߲G@ )D 'D &@AQ! ) &m3? ( D &D#' &@  + A~ ? $@$@ i@  D  @@& D  >`@  Y@ @@  >`@ ~ ? ?  @   > @  [@  # ! @ ! % @ $@&@ $$~ %@# &@7@ % %@%5 '@ph?@ 'D#'D$'D%'D $AA+ (uB )R@ )D 'D &@AQ! )H3? ( D &D#' (@  B % ? D ?~ p@ zGJ@  D  p= ף@& D  >@ ~ ^@, H@ D ?A >@ ~ @~ ? @  @   >@@  ^@  # !&@ ! % @~ "@ $@(@ $$~ %$@# &@@@ % %@%5 '@1BSxB@ 'D#'D$'D%'D $AA+ (Lw? /@ )D 'D &@AQ! )cO? ( D &D#' *@  > C~ >@% 433333?D ?~ @m@ @}@  D  @@ & D  >@ ^@   L E@ >@~ @ @@ @ @  >`@ @`@  # !1@ ! % @ "/袋.@ $@*@$$~ %(@# &@F@  % %@%5 '@J `D@ 'D#'D$'D%'D $AA+ (~tTv#@ )D 'D &@AQ! )z_Y? ( D &D#',@ %?D ?~ @N@ D@ & D>@^@ C@>@~ @@@"@@ >@ a@  #!5@ ! %@"xxxxxx@$@,@$$~ % @#&@J@ & %%@%5'@#C G@ 'D#'D$'D%'D$AA+(-XCrF@ )D'D&@AQ!)@%$?( D&D#'.@  H  I%?D?~  D & D>@^@ A@>@~ "@@@.@ @  D>@ b@  #!>@! %@~ "@$@.@$$~ %@#&@L@& %%@%5'@TI@'D#'D$'D%'D$AA+(LgA@)D'D&@AQ!)jY?( D&D#'0@ %333333?&D?~ @R@ DL@ & D>@^@ >@>@~ @@@,@~ @>@ d@  #!@@! %@"?$@0@$$~ %@#&@M@& %%@%5'@?bJ@'D#'D$'D%'D$AA+(_cuѨ6@)D'D&@AQ!)n}ܗA?( D&D#'1@> @^@ ;@> @~ @@@,@@ >@ @e@  #!A@! %@" |?$@1@$$~ %?#&@M@ %%@%5'@.K@'D#'D$'D%'D$AA+(K:hQq"@)D'D&@AQ!)A{?( D&D#'2@ >@@^@ 8@>@@@@&@@ >@ f@  #!A@! %@~ "$@2@$$~ %#&@M@& %%@%5'@SҰfM@'D#'D$'D%'D$AA+(O֭1?)D'D&@AQ!)A{?( D&D#'3@ >`@^@ 5@>`@?@$@@ > @ g@  #!A@! %@~ "$@3@$$~ %#&@M@& %%@%5'@dM@'D#'D$'D%'D$AA+(zgh?)D'D&@AQ!)A{?( D&D#'4@  J~  @@>@^@ 2@>@~ @@?&@@ >@@ i@  #!C@! %@"?$@4@$$~ %?#&@N@& %%@%5'@;rWN@'D#'D$'D%'D$AA+(l `d@)D'D&@AQ!)+N_)w?( D&D#'5@ *   ~ (@  K~  @@>@^@ 0@>@~ @~ @$@ @ >`@ @j@  #!D@! %@"y 5?$@5@$$~ %?#&@N@& %%@%5'@dVdVO@'D#'D$'D%'D$AA+(Byu|q@)D'D&@AQ!)C?( D&D#'6@ *    ~ $@  L~  p@>@^@ ,@>@~ @ @$@ >@ k@  #!D@! %@"y 5?$@6@$$~ %#&@N@& %%@%5'@3`#O@'D#'D$'D%'D$AA+(v޾%@)D'D&@AQ!)C?( D&D#'7@ * " 2 :~ @>@^@ (@>@~ ??? @$@ >@ l@  #!D@! %@~ "@:@$@7@$$~ %#&@N@& %%@%5'@v:vP@'D#'D$'D%'D$AA+(W['@)D'D&@AQ!)C?( D&D#'8@ * # 3 ;~ X@>@^@ $@>@~ ??? @$@ >@ n@  #!E@! %@"?$@8@$$&@5'@Z `sBP@'D#'D$'D%'D$AA9@ * % 4 ;~ I@> @^@ "@> @~ ?@$&@& >@  @o@ #!E@! %@"18?$@9@$$5'@s*bP@'D#'D$'D%'D$AA:@ *  5  ~ D@$@:@$$5'@Kq{P@'D#'D$'D%'D$AA;@ * 0 6 ;~ @@$@;@$$5'@P@'D#'D$'D%'D$AA<@ *  7 ;~ 5@$@<@$$5'@qTP@'D#'D$'D%'D$AA=@ * 1 8 ~  @$@=@$$5'@B?P@'D#'D$'D%'D$AA>@& * 1 9 ;~ @$@>@$$5'@kVSP@'D#'D$'D%'D$AA$@?@ $$5'@\QP@'D#'D$'D%'D$AADEl*8*8UQQq )!)")#)$)%)  $@@@!$$5 '@>xqP@'D#'D$'D%'D $AA ! !$@@@ $!&@5!'@}wP@ 'D#'D$'D%'D!$AA"$>#$> #&,#' $&-$' ZX#@%$> %&.%'6?dfp Q*,(  j  c 0N 000 4*919]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PH@!0(  @!h3d23   MR R R RI3~S S4 !!3Q:& TotalQ ;!&&QQ3_ 3f MM  !!dR R R RYW r"#S S4ES S 4 !!3Q:' GompertzQ ;!''QQ3_ 2 MM  ""dR R R Rb  r"#S S4ES S 4 3Q:)  ConvQ ;))QQ3_ ff6 MM  ##dR R R R\ r"#S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA 3O 3*&! R RR R4u,S S43* &! ! R R4u,4u,k4S S4523 M  MR R4n]S S43d" W '3OV G5% 03O&Q423 M NMR RR R R R4]S S4< k4 r/S S 4S S4S S4A 3O3*#! M43* &! R RR R4u,k4S S43d" 4S S4D k4 r[S S 4!eee*rvja-JPri rj  c 0N 000 31+]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PHD!0(  D!h3d23   MR R R RI3~S S4 3Q:  NOETQ ; Q ;Q3_ ff6 MM   dR R R R\ r"#S S4ES S 4 3Q:!  NODFQ ;!!Q ;Q3_ 3f MM  !!dR R R RYW r"#S S4ES S 4 3Q:"  ROFCQ ;""Q ;Q3_ 2 MM  ""dR R R Rb  r"#S S4ES S 4D$% 03O&QR R ]4S S4$% 3O&Q4FA2  3O 3 b/N -&! R RR R4u,J6rS#@T?_`j`k`S S43* &! ! R Ru,u,k4S S4523 M  MR R4n]S S43"  [3O 55% 03O&Q423 M NMR RR R R R4]S S4<k4 r/S S 4S S4S S4A2  3O3 b/0N#! MR RR RbNrS#?T?_`dyyyy/m/dj`k`S S43* &! R R4u,k4S S43" 4S S4D k4 r[S S 4eee*rvja-JP ri P>@U44A """5 TestDataSheetggD f2ɀ s  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U>@5 HiddenSheetggD ThisWorkbookK__SRP_2" __SRP_3&+TestDataSheet#.  !#$%&'()*,-/0123456789:;<=?ABCDEFHJKMNOQRSTUVWXYZ[\]^`abcdefghijklmnopqrtvwxyz{|~8'r#<ieNH+C&FEekxEekieNH+C&MEPSLSS6" <<<N0{00020819-0000-0000-C000-000000000046} *@`@|k  0`  i2 %@ %&8 %,@@Q$*\Rffff*0T5105d233$*\Rffff*0U5105d2334 "  0 @ "  H P p  x ### j[̒lj ### ,B@.SE\USEo8@ ### j[̍폜 ###15 ,B@4lsoxpNAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Option /licit4 P$( Sub _Ope(n() ' ### j[̒$ Controls.AddMenuxEnd+5BeforeCly(Cancel As BooleanA폜 @DeleteW!rU 0 y +4 1 ` ` IW<   $0 0 @  44PrU @$`(A` #n'x#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0QxAttribute VB_Name = "TestDataShe et" Bas0{0002`0820-C$0046} |GlobalSpacFalDse dCreblPredec$laIdTru BExposeTemplateDerivBustomizaD2rU~| \DataGrid M__SRP_6>r__SRP_7!@Tests $cZ':zxkp D H'D D B  D H e':z k ### Declarations ###] ### Main ### J B D @ J <%L d J':zk ### Default ###':iP ##########S ## Ώۗ (Column) ɑ΂āAw肳ꂽ Text i[Ăs (Row) TB ### Validations ### <'Nzkx P'P P  P H e'Nz(k R'R R  R F e'Nzk T F'T T R  T F e'Nzxkp ### Declarations ###] ### Main ### J R T J P <%L d J'Nzk ### Default ###'Ni ##########) ## Ƀ}b`Z (Range) ԂB  ### Validations ### <.Vzk ^'^ ^  ^ F e.Vzk ### Declarations ###]]]  ### Find Key Column number ### < X ^$:'b b.Vz k ### Find target Row number ### < Z b$N'f f.Vzk" ### Find target Column number ### < \ ^$:'d d.VzPkH ### Default ### f d <%L.Vi ##########6 ## Ƀ}b`ZɊi[Ă镶ԂB 8 ### Declarations ###]  ### Find Text ### < X Z \ ^$V.j j'hz(k  ### Default ### j!l'hiAttribute VB_Name = "DataGrid" Option Explicit " ' #  Ώۍs (,xME (0>0`6 <+:`@66)=`h%idxi@atiBiD01`J+N`@66)=`h B%idxiP'DiRiT`J+V8`@<<)=`h%iX #iZi\i^΂%`bi[`dT`f+h`x)=%iXiZ i\i^' j8%8 T8%h8`@Q*\R1*#384*\R1*#253$*\Rffff*0V5105d23f  Z B         (0  8HP p         (@ ` hpx       ZB(   8  X hx      (0  8HP p            ( @ P X 0pB     08@ Hhpx   &    & (8@H   (Px     <BH   Xx         x ##########T ## Ώۍs (Row) ɑ΂āAw肳ꂽ Text i[Ă (Column) TBl ### Validations ###nl <002':z(k @at'@ @  @ F e':zk B'B B  B H eRow) ɑ΂Aw肳ꂽ Text @i[B(Column9TB PubAt FuncFind%(ByRef Sheet As Works , ByValcSng, _ %=Integer, Stalrt8EJ)/= SidZals ImIs Nothing Thend-1 Exit P Ifǃ/}= 0 +CaElse@ t < 0) OrBw@ > Max )?%e%I\'K ) + -Cs-C,-O-MC CX< ,\0B[RDeclarRDim iZBDinYFor=i To &YLy.Cells!N, i)@[K_=_ia0`nd=N@ fa8ultƎHm (Eآʛ`q_^S(=y`#+#`A= _`Owu2Field hOpP=#RowWIntepger)c ' ### DeclaraIs!Dim cell?Range 6 TexZtSz=Cu(,xp,/h\)1If>Is Noth ThenMA!>= "" Exit  End8 If*xfaul[&].N&rU @` 9=@`Yq=H`!=@`!=nrU~|  <,L$@ @ P <%L!|(XdP r @ P <,L$@ @ P <%L!|(k @ '@o ### Move Chart ###  <%L! !!  !( <%L! !!  !( !!d <%L!  ''d  'ko ############# ## Show Test Resulth & t %% t &%B@kpoh ############# ## Clear Test Result0 Delete All Names B@Com& Delete All Custom Document Properties B@ Delete "TestResult" Worksheet  t %G t %B@jo` ############# ## Test Suitsp] !!.<] ### Title ### <%L  V ! Test Result9l5|!5|(5|(~q` Test Name <,LResult <,L ### Initialize ###- <%L('J'' ### DataGrid ### < JA@ ### Metadata ### < JA@ ### Charts ### < J  A@ ### QualityIndicator ### < J  A@ ### DataAccess ### < JA@ ### CopyRowsFrom ### < JA@ Change Worksheet Name  t %G t <(j ### Complete Message ###Test of  V ! is completed! A@o ### DataGrid ### DataGridTest < @ nB@x ### FindRow ###DataGrid.FindRow 1 @ <,L vMishima 8%N < @A@DataGrid.FindRow 2 @ <,L vJapan 8%N  < @A@DataGrid.FindRow 3 @ <,L vKanagawa 8%N < @A@ ### FindColumn ###DataGrid.FindColumn 1 @ <,L vCountry 8%: < @A@DataGrid.FindColumn 2 @ <,L vTaro 8%: < @A@DataGrid.FindColumn 3 @ <,L vBirthday 8%: < @A@ ### FindCell ###DataGrid.FindCell 1 @ <,L vCityOsakaID 8%V!l < @A@DataGrid.FindCell 2 @ <,L vCountryItalyID 8%V!l  < @A@DataGrid.FindCell 3 @ <,L vCity San FranciscoID 8%V < @A@ ### Find ###DataGrid.Find 1 @ <,L vCityNagoyaID 8%h23 < @A@DataGrid.Find 2 @ <,L vCountryKoreaID 8%h11 < @A@DataGrid.Find 3 @ <,L vCity San FranciscoID 8%h < @A@o0 ### Metadata ### MetadataTest < @ nB@x" ### Worksheet Count Functions ###Metadata.CountWorksheets 1 @ <,L !  < @A@!Metadata.CountVisibleWorksheets 1 @ <,L !  < @A@ Metadata.CountHiddenWorksheets 1 @ <,L ! < @A@! ### Worksheet Neme Functions ###Metadata.FindSheetName 1 @ <,L TestData % < @A@Metadata.ContainSheetName 1 @ <,LH TestData % < @A@Metadata.ContainSheetName 2 @ <,L) \ hoge % < @A@ions ### Set Name Functions ###z`Metadata.SetNameToCell 1 @ <,L0 v   % < @A@<Metadata.SetNameToCell 2 @ <,LL U }GxME( <><< <( tH`tH+v % xX izat)<%i@86iPh  i )<%i@iP `)<%)%ii% 0  p >> <%`J`` X<<)<x%i@ (FF)<%i@ h--)<%i@ii % (PKK)<px%i@ii %` ` h)<%i@` )<(0%i@pxHrH0 (XPxpH(8% HPQ   0@ 4XB   "    0 8" P X`,x,  " 8 8@8x &   0"P Xp   "   , 0 $@,h   "     (,@p       (0   8P `x     @    P&p F  "   &(   P (h6 (4 (( 8P  , 2 , 2@ ,x 4  * B( *p J * D h & @ & H &X F   "  &   ( 0@(p 8( 6 0 (P .x2 20 2H,    " .2 .@0p 0B & *@0p 0D 8 :PD <( @ H" ` $h     (D &@ (hf&  @ .`h&  @ 0`J& 0(bX&  " 0 .8 hp    .  & .  & .  P &0 .X  8&X 2L &@ hJt H  * &(! P!2h! ! "# *8#&h# # #" # (# #   #D$ P$`$&x$$ *$$ $ %" % ( %   H% .h%L% .%T& .p&8& &&x ### Constant ###]DPassP]DFailx]D TestResult- ### Sample Data Sheet (Worksheet Object) ###H 6.vatiP ### Print Test Name ### @ '@1 z @ P <,L @ P <%L!|(~ @ '@o ### Test Item ###X  p @ P% v  % < @A@Metadata.SetNameToRange 1 @ <,L vI4 v%`J4 v%` % < @A@ ### Set Name set Functions ###Metadata.SetNames 1 @ <,L## Dec v  % < @A@Metadata.SetNamesToRange 1 @ <,L v Properties 2Value 2 % < @A@G1 ### Set Custom Document Properties Functions ###$Metadata.SetCustomDocumentProperty 1 @ <,LGI2 v%`!lI2 v%`!l % < @A@&Metadata.SetCustomDocumentProperties 1 @ <,L. v  % < @A@o  ### Charts ###遖( ChartsTest < @ nB@x ] ### AddChart ###Charts.AddChart 1 @ <,L <O11:R17 v%`Charts.AddChart 1 %.>9  < @A@ G <   A@jCharts.AddChart 2 @ <,L <O11:O17 v%`Q11:R17 v%`$  Charts.AddChart 2 %.c  < @A@ G <   A@j ### AddScatterChart ###Charts.AddScatterChart 1 @ <,L ( <O11:O17 v%`Q11:R17 v%`  Charts.AddScatterChart 1 %.  < @A@: G <   A@jct ### AddBurnDownChart ###Charts.AddBurnDownChart 1 @ <,L <T1:V26 v%`Charts.AddBurnDownChart 1 %.[hS  < @A@ID=B G <   A@j (Charts.AddBurnDownChart 2 @ <,L <T1:T26 v%`V1:V26 v%`$Charts.AddBurnDownChart 2 %.ault D  < @A@ G <   A@jalo ### QualityIndicator ###QualityIndicatorTest < @ nB@x]] ### Show ###.QualityIndicator.Show 1 @ <,L, <X1:X26 v%`Y1:Y26 v%`Z1:Z26 v%`AA1:AA26 v%`AB1:AB26 v%`AC1:AC26 v%`AD1:AD26 v%`QualityIndicator.Show 1 % .'  < @A@ Dec G <   A@jpQualityIndicator.Show 2 @ <,L'' <X1:X26 v%`Y1:Y26 v%`AA1:AA26 v%`AB1:AB26 v%`AC1:AC26 v%`AD1:AD26 v%`QualityIndicator.Show 2 % .  < @A@ G <   A@jDQualityIndicator.Show 3 @ <,L, <X1:X26 v%`Y1:Y26 v%`Z1:Z26 v%`AA1:AA26 v%`AB1:AB26 v%`AD1:AD26 v%`QualityIndicator.Show 3 % .##  < @A@#### G <   A@j߶QualityIndicator.Show 4 @ <,Lal' <X1:X26 v%`Y1:Y26 v%`AA1:AA26 v%`AB1:AB26 v%`AD1:AD26 v%`QualityIndicator.Show 4 % .  < @A@ G <   A@j ### ShowFull ###QualityIndicator.ShowFull 1 @ <,L!. <X1:AD26 v%`QualityIndicator.ShowFull 1 %. .  < @A@ G <   A@j ### ROFC ### 4QualityIndicator.RatioOfFaultDetectionInComparison 1 @ <,Lration vAF1:AF26 v%`AG1:AG26 v%`AH1:AH26 v%`AI1:AI26 v%` %' <AF1:AF26 v%`AG1:AI26 v%` 4QualityIndicator.RatioOfFaultDetectionInComparison 1 %. ! %'    < @A@ G <   A@j ### Gompertz ###QualityIndicator.Gompertz 1 @ <,L - vAK1:AK34 v%`AM1:AM24 v%`AN1:AN34 v%`AO1:AO24 v%`AP1:AP24 v%`AO36 v%`AN36 v%`AN37 v%`AN38 v%` % '# <AK1:AK34 v%`AM1:AN34 v%`AP1:AP34 v%`$ QualityIndicator.Gompertz 1 %. ! %'    < @A@ G <   A@joh ### DataAccess ###(DataAccessTest < @ nB@x] ### Export ### <B33 v%`!lB34 v%`!l @ % '  @   '@  record(s) @ <,LkXDataAccess.Export 1 @ <,L  < @A@o ### ClipBoard ### ClipBoardTest < @ nB@x ### CopyRowsFrom ###ClipBoard.CopyRowsFrom 1 @ <,L vCountryEnglish %!$6:$6 < @A@ClipBoard.CopyRowsFrom 2 @ <,L vSexFemale %!$23:$24,$27:$27 < @A@ClipBoard.CopyRowsFrom 3 @ <,L vSexBisexual % < @A@o lAttribute VB_Name = "Tests" Option Expl@icit ' ### Con stant `Priva* tPass As Sng"TFail **ResultSheet ` ; Sample@ Data ; @(WorksF Object)cFunc~source()T 2 Set xGEnd , kSub `print(ByVal , ByRefrGT RowI@nteger Column)&A6 = A+ 1 B.Celhls(,A)D<( .Font .Bold rue  K>"CJ= Itefm lHdoGCriteria5BooleanE;G0~GIf Then2IE J gor@JRGB(0, 255hElsDO A1 0XIf# 6Move Char̅6m`B?7{WZ9OffsetX9Z#Y(".Pare QLeft+Z1, 4).+ (Widtph * d"JTtop 3  Height Y K&%>{p10A1).!+P%&xaEY0c KI%r?t=D !v@vcub ?ShowaC(AMetad .a`tain3ThisAwbook,&) K! r.s(p@ p^y!h\C`r=  *Q' Dele`Alls#Custom@ Docum Z Propertiev #"7 |" SC)_y(rAtve{s w.`a'##' p&itp*PW'Dbs&DimS5BL}2 ets.AddSiHG, jky$# Tit CWi GcBe?, 1B<.MuInq" @& " V"`Vers`Info(rmaA.$Textrb3+BqbzSizh* 2S G|A S P1%R/=L2B )Initial =Q[= 45sjiP4jPkS!GridAdo5'q, ia*25esiJ`&, k=QutyIndicatpdoqAcceWC*Copys FrJClipBoardY'ngeH##INot U@ncus ::Kore%:117 99"8= "End Subc 8MetadC9Privatbe doe( ByRef As Works# 0Integer)Eas.printAName " ,1c  B FunctionsPf. sQe= (2 +wv) Visible1Hidden3= ? Ne@>5{| q|2>#C_Q(A!v2bookX'}|?`!C'_vContain ? > Truen%o ̎Mo hogebFals? 7 :Set 9 [C sTo+9J.ZQuP10,z )`   ao ll  P10sRangeb ܮ.c"I4" ("J_#  s!?Yjus 10J14iǯ>kbT&sTou "Properties$Hs2o 21/ ! soCustom Documexnt HU6itRcUDy- ym6%2, %%I&:C 4?c!$?3O3; ?PChartth3, SPoTsiX Ybs 7_Dim au*Y+Addȳ PSheet.Cells(Row, 1) = "Char@ts.Add$ 1"et active.= R(, sourceDataRange("O11:R17"), Title: =j)kdoTe st No rIshing, l%25If1 Then mo_h,hPositionXY 32Un:(OQxlXYScatterLines, xlColumnTrue,y2"?_k?__`' ### 9CCi  `kBd+m /n7{,*,Ig2f7BurnDown7o7dd*7T1:V26s-_/otf_/a")z*T*TV.Ač ..ٿ.g߿. End Suba^QualityIndior Privatbe dom!( ByRefc As Works, #Integer"kY#s.printName "/ st"+y1SDim  ResultBoolean, #28YSShowύ̍ .CS_DgX1:X._c /Y1:Y1љZ1:ZAA1:AA/)B B#/ ݚACC D D#41ϝ 8ϝϝRp ?jrtϝޝ Sn R# ?&##gom#Cf?&2&"A"O+t.4)""oc\s""OￊFO]O]S"ӯ 3d"`_P"""o`׿E|ٿE ###?)+A!C!D !!™DD D) 4!J_P!!!urcɴeDataSheet.Range("Y1:Y26"), Nothing, sourcAA1:AVAVDBDBD_X D6D6True, "QualityIndicator.Show 4")UdoTest activeChart Is, RowH, 25If Then mo%/, 2Pos@itionXY |' ### \Full@).Cells(L1) =y$1"et t= (\X#\D][h[[ROFCZRarOfFaultDete@onInComparison `Resk^2( c, jAF@jFƕGGHHI@ICap mSOb`s.AddSstersN"Af$xlXYD LinesNoMarkers,"lLegend:=ÇTitle:=<1E=2 =d 2nd Axis(ȁ.Parent, 3*&deEAnd a( TDwhkG^ertziʹ&eEbpѲKUK3M@M2ZN@N_qTAOO P@PC#Q AO3{N78")yrt<dyAUnpmAqD_ 2Abq/z_?_?_?O)mp,=|s.==2===q(=,C=KEHSubr @Accesss>Private  doA(ByRefV As@ Works , JqIntXr'#s.printNamet ""\B O1SDim records ExpoPS= .Cj.E+B33").Valu_+R+B+?5S+ 60> ~0B3 ``eQ+ + & "d(s)If#S?RT-h  $ ClipBoard$doo$o$o$ n$_$ 3"CopysFrom w/"v.nt_!m"Country "English2)r8$6:$6P  , #?b2D"  "Sex@"Female2qz 23:$24,$27p67    rd}3 &Z  Bisexual"),DataAccessd__SRP_8GT__SRP_9 IMetadata!@krU P` Aqq=nrU~|      /ME ### Validations ### <8'z`kX 6  8  :  <  6 F  8 H  : F  < H 'zk ### Declarations ###] ### Main ### > <!! 6 8 <%L!l'@dH 6 8 <%L!l'@k @ : < <%L( ### Default ###'i ########## Query) ## w肵͈ (Range) ɖO‚B  am ### Validations ### < 'z@k8 B D'zk ### Declarations ### #] ### Error Handler ###$ ### Main ###  > <!! B!l'@dp B!l'@!kX @ D(  ### Default ###'z  --- Error Handler ---$'ete Ali ##########es ## SĂ̖O폜B ### Validations ###% (None)% ### Declarations ### #]P ### Main ###st S F !H FB@!. Fo ########## Title& ## ɏ]ĖOZbg쐬B  psult ### Validations ###( <'zXkP <  < H  8  8 H 'zk R <'R R  R F e''zk T F'T T R  T F e'zhk` ### Declarations ### #]x] ### Main ###  @ R T DataA @ 8 <%L!l @ < <%L!l < @ 8 @ < >$'sheet 'zkxkph ### Default ###ss'i@ ########## !? ## ɏ]āAw肵͈ (Range) ɖOZbg쐬B % ### Validations ### J L'zxkp N'N N  N F  N R e'zk ### Declarations ###]] ### Main ### < J N 8%:'8 8 'zkx < L N 8%:'< < 'z8k0 < 8 < R T >$' 'zk ### Default ###'i ##########8 ## w肵OhLg vpeB[ ɐݒ肷B ### Validations ### (None) ### Declarations ### (None) ### Main ###$ PT V Xl !RB@$ "Type" is dummy. ### Default ###'zh --- Error Handler ---$'i0 ##########L ## ɏ]āAw肵OZbghLg vpeB[ ɐݒ肷B ### Validations ### <'zpkh P  P H 'z8k0 R'R R  R F e'zk ### Declarations ###]@]X ### Main ### J R F J P <%L!l J P <%L!l J P <%L!l$' 'zkk ### Default ###'i ##########8 ## SẴJX^ D@xME(0><<6 "+ `@\\)=`h%ixiati t NaiR@1iBi(iest `% %`J!|` @ %Q*\R1*#384$*\Rffff*0W5105d23fb  R B$x       (0  8HP p        0H h   * ( 0@  P pF .8@0Hx    "      08 @` p x ##########t ###K ## f[^x[Xւ̐ڑNG̎sу[NV[gւ̏os % ### Validations ### <' Rz(k R'R R  R F e%' zk B'B B  B H e' zxkp ### Declarations ###]H]h] ### Error Handler ###$ ### Connection open ###    B@ ### Query ###   & ( B@< ### Add field name ###  B@* J !,!. J %,! R B J <,L% R 'Rk ### Write ### 'J B@* !0b  !,!.  %,!l$2  %,!l$-  %,!l( Z1ڂ '-' ̏ꍇ "'" t'  %,!l R J B  <,Ld  %,!l R J B  <,Lkkxp J 'J B@4 ### Arrow interruption ###FA@ ### Connection Close ### B@B ### Default ### J' z --- Error Handler ----$' imAttribute VB_Name = "DataAccess" Option Explicit ' #  f[^x X̐ڑNG̎sуBNV gNos Pubk Func{ort(ByRef Sheet As@ Works , _ ByVal Conne8Sng+ , !Query u!Sho@wFieldBoolean,tartRowIntegerColumn ;UserIDZKPasswor{K)+ idasكIIs NothiKThenC@}@^-1  itgEnd MaxZ) ?)f)F*K+,,AutDeclar uDim c NeDODB.Ge rsRecIse{a Ai(J, jKError Handler'LO@"GoTo dU' openG `.O!'%cce, Ebu #~,rs ,&, ada Forwa@rdOnlyALockRe@ Add fƒn !_&^MoveFirsd--` i`ldo @bs 7unt - N!a.CeldlsFc, fN+ i) & (i).AcaNexFn=+%{Ac5Wri@FF+LDo WhiDleAEOF Fa}'!!j?!A- (IsNull(j).que)n$(Leftp, 1q'"-"n) <>!; ' Z1 '-' ̏ꍇ "'" t܉< ;M=j &GG( O ! O9a [k)A%i /`%s3)AFw i0xrruC*DoEven tssSLoop}=xHCloseH")#DefaXultiicExs' ---RVT 9S:x)QhLg vpeB[폜Bp ### Validations ### (None) ### Declarations ###] ### Main ### ( !R (B@ (o ##########0 ## ݂ Workbook ̃V[g̐JEgB !\!.'iP ##########7 ## ݂ Workbook \V[g̐JEgB   'i ########## @7 ## ݂ Workbook \ K 2-xME P0>0`< `@'+`` //)=%)Bons %)D%i> `@@ p` Fh%+` 99)=!%i8i<iR8 #iTXi>  &`@p` ####+` 55)=%iJ0iLPBiNpns #iR #iTPi> F`8B@`<` ####+`X ixalidiP+p` 22)=%iP iR`J` R ` (x %+` +P ` + `  <efau%`J #+h ` )a(0 %ins #`J L+ ` )aN %ihPp ph % h@ Q*\R1*#384*\R1*#253*\R1*#386$*\Rffff*0X5105d23f  & BH `  x (0   8X   `x,     ( 0@Bp          @   H`h         0"P X x         , BP h  8  8@H  P`h      @  "@  hpx      FB$    8Xx *       ( @  ` p x        "        0 8 @ >X B         P p       R B@ P  p                 @ H   P h   6           ( 0 >H"        ( 8 @ 6XB    >B    ( >@B       0B @ Hh        ( 08@ H ` p x >B     ( 0 @x ########## ## w肵ZɖO‚B V[g̐JEgBP]]'J < !\ # <!^G J 'Jj` <ta.Set J'i ##########v) ## w肵O Worksheet ‚B ### Validations ### < `  ' @z`kX ### Declearations ### ]P ### Main ### J `!!.< @ J `%!  Set N J'z k  ### Default ###'## Deci ########## 7 ## w肵O Worksheet 邩ǂmFBh `  %'z k  ### Default ### C'i Attribute VB_Name = "Metadata" Option Explicit " ' #  w肵ZOB Pub| Fun"cSetToCell(ByRef Sheet As Works , _ ByVal 1Row"Inte ger, Coplumn  =Au~e> }<2InL3Boolexan)X m,isfIuIs Nothing ThenFalseExit End If2(< 1) Or s ?EK R@'F> Max  CMCDeDeclaraHeDim val,ueMtSngIMaintW /G=ø.& "!" &sV,DP.IC EʁdBo. :,Wueb=G$M]Defaultg"XTru`X AU倃#͈ (Range) "??%!?Hc= gIuN4roĚ#Z_r_r Error HandlerPO"GoTo d# {!|{fb$xugR#r?rE7r le9' ---3@<d: K7k>C#>SĂB폜jSub Del@eteAllAs|()C@/5' oone/`!`targ>! ["F'Each IЈveabooksC . Nextx3PCCRɏ]āpbg쐬]soRXi<b ""#(.)nWRc , |, hP^!5  + 3u>#E']\q!߳>&A`t`AeoOb쐬B Public Function SetNamesToRange(ByRef Sheet As Works, _  ByVal fColumnTitleTStr`ing, @HueBIOpL1HRowKInt@eger, #Start#End3 !8Inn9Boolean)x' ### nhida^sIf ( = "") Or ( pThen = FalsepExit w MaxUC3dM2AD'C]Declar]DimHo\ Res|ul~ICMxainzziDataGrid.PFindC(,M, N)]^LkQ(I!= ? X X?4=F/+,!riō, ER, `V, H}.ot ppdp;EWfaAMG:Tru} !% #  A  w肵OhLg vpeB[ ɐ 7CustomDocumentProperty` =Xg뻅aW8B'`one2s}D ktOn Error GoToCHandler/%A`vebook. ies.8Adda:=) , LinkToCont:=9Source:=Typqmso , ' "" is dummy.#De/J8% dQ' ---4P(:7a"Tj+T+`+ɏ]@āAi,Zbg,,_ P Ps[,d1E/@_#Is Noth >H  Q1oUI ($< 1s|}o|tqЉ}= ̉F g ljOMr~t O 8 qi!߆Y#LF@Li L$.Cells(i, .'ue <>pIvySw0wA$wq1 0xqrO O()05W NextALWe?2tc&WQQ SẴJX^ _}T}`폜lSub DeleteAll/#(vP?J'y1/s/p/̈́Y.Each In _zϊ.fa?1jdj݂2 `V[i̐ j8JE%&Counts(a$e! <=\. o4 `o a \V[g̐JEhB Function CountHiddenWorksheets() As Integer 0 R =v -Vis0ibleGEnd z' #   ;book1҃?iDim SywUw i i{0For Each#In ZAv|^.+sS"If.S Then *i + 1NextlEi$w肵`OYB} ‚!LFindHName(ByRef< BAe69, ByVal LStringQB{ idasA ;E(Is NothBOr (B= "")IC 7C&A-DNExitȚ@IfI$DeclearM%Main2As1 ToBK.Ps.p $<+| LwdwK邩mFϑnt)MM)8nAA,MetaMa.'BM,"Vf)"lKCo+`False1?L,1p Tru@ o-__SRP_aL__SRP_b PConstant_Charts "1"rU H `9Y=L `yY=$ `H `9qY=L! ` 9qY=,I `Yq8q ` Yq=$ `$ `$ `$ `49 `Y=4a `Y=n?+ixMEHʐFL`LꐰHfEʐHL `(Q   ,8 P  ` p x& ########## Grobal Constant ##########]$ VBA Toolkit`]$]$]$Attribute VB_Name = "Constant" Option Explicit " ' # Grobal f4` Publ6 AddInAs$ SngVBA Toolkio1Vers4lDoO1 *M axRowO10 23 xColuDmn255;rU~|  \rU T `1Ii==h ` ## Declarations ### ]( ### Error Handler ### H$ ### Main ### t!!.tions  / ^C~Ô (H) ʒu擪Ɉړ %L9v 5x(zHk@ ### Set Source Data ### h B@|< ### Implicit Settings ### 9~ ### Option Settings ### n9n 9 j j9jkq ### Default ###  <! %.9zP --- Error Handler ---!$.i ############# ## Uz}ljB $H # ### Validations ### j  j  j  j  j ##.zHk@ ### Declarations ###]]] ### Main ###% <  j n  $. P.zk $. J !. #  J$$.PHd@ .Fk( J !!.  J %( ### Default ### .i #############+ ## w肳ꂽf[^A 2 ɐݒ肷B ### Validations ###  <'zk ### Declarations ###  (None) ### Main ###  !%( ### Default ###'ix #############$ ## o[_E`[gljB % ### Validations ### <.zk ### Declarations ### ]p ### Error Handler ###$ ### Main ### < h     %. G$j0u If Not ((activeChart.SeriesCollection.Count = 3) Or (activeChart.SeriesCollection.Count = 2)) Then GoTo ErrorHandler h!!.  % 9j 5!B@qXkP ### Default ### .z  --- Error Handler ---$.i.Attribute VB_Name = "Charts" Option Explicit H' #  Otlj送B Pubr FuncAdd(ByRef Sheet As Works , DataAreaRange, _ ial(VNTHype)Xl, (PlotBy%RowColRShowLegendBoolean'Titl:Sng)>U RidasbI~Is Nothing ThenSExit EXIf3(|<> xlzumnsV D D=C;DeclarA eIHK;IError HandhlerMO@BGoTo   MainS@U!= Ap+.& s.@IWith.-A' ^C~Ô (H) ʒu擪ړhh "" .HasC= TrueB,.Ca  l GG7#Source Ap''.Oug_C Im @t\`.DisplayBlaxnks`M]Oted' #| WC"*{=@}14#-A@5015'= f 0ALa'gDefault+Wŧi1LocW(xlEAsO@bject,c.A)# ' ---iFn  l:- HF ĎUz}S ter(dcXBQ HƣYIncludeField7&? ?!Xl_??̓?l2(fQ WxlXY+Lines?d&2NoMaLHIxME P0>0`0l0p006 <+H`@ CC)=`h%)hx%)jP`%)n` %i i'% @%+`22)=ons %)%)%i )j@Huery`%)nhpO` %i alidi % % %`Jons +`P )px!%i!l+`h)))=dler%)h (%i Hi% %H%Q*\R1*#384*\R1*#253*\R1*#3d*\R1*#16*\R1*#383*\R1*#2b5$*\Rffff*0Y5105d23f   B@ X x           8 P  6X          8@   H X` h p     B$  8NX      $ 8HPX `h x        0 @ H 2`B       (@  `x   *B    (H Pp   x( | Ph        x ############# ## OtljB ### Validations ### <x.zhk` n  n r 'nk0 #rker,Smo`oCi5Sr ?s ?s+;sSKlA l>xb(E7i1Intr32sGj > u7(2, b-,WF, cN?M, #t?L)0tMs 06;x;(2 V Fi03 0.CounO5Un0(Hx, #i)8NexTElstZ s1qrieslpW = (i).XpIuespx S)aY08!'1 oZoZ# w肳ꂽf[^A 2 ɐ!1b2ndAxisd[target#90LiByXSepIndeb3$2As $Y a0oN&(-) Or (I= 0){ d Fa! ! BC (NoneT( 8 ~% ).Groupp 2"|!eo _DE`g |icJBurnDown|!{߱<ݟڟlCPWs%pS%c%#7:摁 1$$ $_gUg/[ 2ӟrӮdler  P' ### Main@dSet activeChart =  s.Add(Sheet, DataArea, xlLineMa rkersColumnShowLegend, Title)dIf cIs Nothing Then GoTo ErrorHan' 7( ((.Series sleon.Coun3) Or #+2))=[{2r6> 2ÃWithrS\(1.THypexlClustered,Format.Fill.TwoorGradDie}msoHorizontal, 1End A(CAIf AADefau ltˆBurnDown+*cxit FuncAC' ---t uA y: APD*__SRP_csr__SRP_duControls]__SRP_4}t 1Ii===4 `!=L `Ii=nrU~|  #q Ai 1a y  /8 Q$*\Rffff*0U5105d233*\R3*#50*\R1*#385*\R1*#125*\R1*#114*\R3*#8c*\R3*#4d*\R3*#4e*\R3*#30*\R3*#4f* $0  H$h$  6 &0&X 4 $   8Pp   H 0 H" h p.x    t(WI  xxME8 (L> LLLLL<<<␲ H␶P H␸H H␼p 8 Hx H  H  H @ H H 0 H H VBA &Toolkit #Count &All Worksheet 4@` * 8##% . ` |k: x % H -% % ####% % 8 #% X% x%  %  H% ons % % j% ` CC`ar `!z X%`enu ` `eet ,%% ` 55`.`9z` orks`H sibl% ` ::C`bleW H %`dden` `. 9z% ` ++}`u ##`!``lNam` <8 #%  `   "`   $P`   & `  , ` ␮H␰H␴( H␺x H␾X H H  H h H@ H( H  @p  P   xP@hith, %t@X t @0p @` `Count &Visible Worksheet!.Count &Hidden WorksheetVersDelete All &Names...)Delete All Custom &Document Properties...t..."Create &Chart...Create &Burn Down Chart...Show &Quality Indicator...sult &Import...&Version Information...#######Show &Test Result...teImport from Database Create ChartlaBurn Down Chart`Quality IndicatorNumber of Worksheets Confirmationor<Provider=;Data Source=;Initial Catalog=;Integrated Security=e SELECT * FROM`@@ Xp ` @H\ @@X '@xT '@PO px1 (Tru@L d, xherwis@8 @( $@ @(  @ @ @p e: @ $`art % %` % `%@(P8`%p 2h`%P<`%F( `%Q(`%H\X@`%x(pp`%X{|`%@   "( 0P.QX   8l   *(X` x    .  $  @H   ,P  $   *  8 @" H px >  6  (0 &8`h     0    " (  P X ` 0h     "     ( D@  "        8  @  H  h p x        * 0 8  P  X  `      "        (   0 P   X 0p    8X`px  n8@HP  8X   :  .08 @.`   ("         (H   P0h  n 08X`hp  <x   2  : `h p.   ("  08 @H P X `   B  n <  8  X<h   6 0 8 &P" x     . "0X 4p6    $,   P:` >&  ( 0 2H"  D   6" ( L0   6"  L 0 8 :P"  T    N(" x j  x ########## Strings ##########]D VBA &Toolkit]DCount &All Worksheet]DCount &Visible Worksheet.]DCount &Hidden Worksheet ]DDelete All &Names...(]D)Delete All Custom &Document Properties...P]DCreate &Chart...H ]DCreate &Burn Down Chart...x]DShow &Quality Indicator...p - Const dbGroupCaption As String = "&Database"]D &Import...]D&Version Information...]DShow &Test Result... ]DImport from Database]D Create Chart ]DBurn Down Chart%]DQuality Indicator@id]DNumber of Worksheets ]D Confirmationh]D<Provider=;Data Source=;Initial Catalog=;Integrated Security= ]D SELECT * FROM ########## ## j[폜B]  Worksheet Menu Bar t%!, !z  B@|0k( o ########## M ## j[ljB @ ### Initial Check ###.] Worksheet Menu Bar t%!, !z |`kX H ### Menu Control ###(] lWorksheet Menu Bar t%!,%.  (zefau# ### "Count All Worksheet" Menu #########] !,!.f[  9zShowNumberOfAllWorksheet99qH' ### "Count Visible Worksheet" Menu ###] !,!. Decla  9zShowNumberOfVisibleWorksheet99q& ### "Count Hidden Worksheet" Menu ###] !,!.##  9zShowNumberOfHiddenWorksheet99q# ### "Delete All Names..." Menu ###.]  !,!. Decla  9zDeleteAllNamesFromWorkbook9##9q8 ### "Delete All Custom Document Properties..." Menu ###]@ !,!.   9z-DeleteAllCustomDocumentPropertiesFromWorkbook99q ### "Create Chart..." Menu ###]` !,!.  9zCreateChartWizard999q8) ### "Craete Burn Down Chart..." Menu ###] !,!.  9zCreateBurnDownChartWizard999q) ### "Show Quality Indicator..." Menu ###] !,!.  9zShowQualityIndicatorWizard999q ### "Database" Group ### Dim dbGroup> Set dbGroup = menuControl.Controls.Add(Type:=msoControlPopup) With dbGroup .Caption = dbGroupCaption .BeginGroup = True End With ### "Import..." Menu ###] !,!.  9zImportFromDatabaseWizard999q ### "Version..." Menu ###] !,!.  9zVersionInformation.Show99q# ### "Show Test Result..." Menu ###] !,!.  9zTests.ShowTestResult99qpoh ########## ## Create Chart Wizard  ### Declarations ###]`]x]]]]] ### Error Handler ###$ ### Main ###Input Range of chart:  !$' G$j2Input 2 (xlColumns) if series direction is Column, otherwise input 1 (xlRows): (Option) $' 2  ' 1e r'd$xkp"Input 1 (True) if you need Legend, otherwise input 0 (False): (Option) $' 1' 0 e'd$kInput Chart Title: (Option) $' ### Create Chart ###   %` n   %. Chart created successfully! A@|k --- Error Handler ---$Chart creation failed... A@oh ##########! ## Create Burn Down Chart Wizard ### Declarations ###]X]p]]] ### Error Handler ###$ ### Main ###Input Range of chart:  !$' G$j"Input 1 (True) if you need Legend, otherwise input 0 (False): (Option) $' 1' 0 e'd $ k Input Chart Title: (Option)  $' ### Create Chart ###   %`   %. (Burn Down Chart is created successfully! A@| k  --- Error Handler ---$Chart creation failed... A@o8 ##########! ## Show Quality Indicator Wizard ### Declarations ###]]0]P]h]] ### Error Handler ###$x  ### Main ###'Input data source area (Range) as Text:  !$' G$j $`."Input 1 (True) if you need Legend, otherwise input 0 (False): (Option) $' 1' 0 e'd8 $0 k( Input Chart Title: (Option)  $' ### Create Chart ###     %. *Quality Indicator is created successfully! A@|P kH  --- Error Handler ---$  ### Default ###$Quality Indicator creation failed... A@o ########## ## Import From Database Wizard ### Declarations ###]]](]@]X]p ### Main ###Input Connection String:  $' G|j Input Query:  $' G|jInput User ID: (Option) $'Input Password: (Option) $' !!.< ### Import from Database ### <     % '  ! record is imported successfully! A@  e % record(s) are imported successfully! A@dData import failed! A@ko ##########, ## Show Number of All Worksheet Message BoxThis Workbook includes  Worksheet(s). A@o( ##########0 ## Show Number of Visible Worksheet Message BoxThis Workbook includes  Visible Worksheet(s). A@ox ##########/ ## Show Number of Hidden Worksheet Message BoxThis Workbook includes  Hidden Worksheet(s). A@o ##########3 ## Delete All Nemes from this Workbook Message BoxP:Do you really want to delete all names from this workbook? ( $ * B@ko ##########H ## Delete All Custom Document Properties from this Workbook Message BoxODo you really want to delete all Custom Document Properteis from this workbook? ( $ * B@ko\Attribute VB_Name = "Controls" Option Explicit " ' # Sngs$ P0rivast menuCa As`VBA &Toolkitk 7countAllWorkshPeetMHC) z&+ ,P NVisible&R+Hidden* * ~deletVehs|D Ł|&...|%CustomDocutProp`ertie :&E oreaCharn &B .cBur`nDown#A  showQualityIndicatorXS & E=' dbGroupR&DatabasefbImtpoH&E˴versInformaV1&V 0 K A#TestResul77" #+ dD Fr`O WizardTitle j f` &B; CCK.J ?In qI H Nu@mberOfS!s0% ofC!ponfiCssageBox X8m defaB necM+8vider=;7 Source=;Initial C @log!tegr@d Secur`q=!$QueryTextK SELECT * FROMf  j[폜$Bub SXub 㨂go( ) Dim ctrlACommandBar` a AFor EachIn ,Apr.gs(*"F a ")O   IfB .=Theng.c ExitEnd IfN!*1_Xlj_ Add/ ÀG heckCar Goo "!2" 2ϓ&%Seԓ^=%(.(Type:=mso PopupP. ?'> s pf-"s-ࡓnu_Z70 Ss Wit08nu OOnAN!{aoYAGB0eginFalse!# ]"t " Fb&PtIIQ$ ?l?o=O ̻n`"PhY*ηo _?`aVoup OO++(+Å_,g@N@so Oo@j@<@Guo?*cp?B!bookTru??PD? U ٿA_#Set deleteAllCustomDocumentPropertiesMenu = PuCo@ntrol.s.Add pWith#^f.Caption\".@OnAcA"DFromWorkbook"DBeginGroupDFalsBeEnd k  X' ### "Create Chart..8." Di8m cAs CommandBar" & 5,W izardITruHFaceIdO17C!XNa Burn DownP RO TV X Z [422\[Show Quality IndicatorTsdF_W -.;. _.eL.33\.DatabaseL" ' db' ¯Cg(Type:=msoPopup)# ikc$'. gz'> w  "ImpovdbG J?FÄ CA;C¥6B՞528CVersTovInforma_' ((s@) x .Q8d4ww$w Test@ Resulow 5!BQC_w8o sW oySubS @;;! ~ Public (F;Declar*sA"NPAЏText `StringWplotBy?CcEnumXlRowCol=LegendsQ#qBool(eanmcaTixtle_ aveA#+Error Hler'On GoTo4Maind=P}putBox("In Range of R :",M,g le1resseIf <"" Then  y h 2 (xlpumns) if ser diRr iQl," & vbCrLf"otherwise iRF1@!s):(O)rdrG "2" Or (K")afr)= Epð,1?/6Q ϡ=IfcY0 aVryou need 1q0 (2rt8& "13%# s:= aT0!.!#oCOB'*q~*`׉*S@[@]I=bkR(veSheet, 0eet.Range(dataAreaText), PlotBy:=pEnum, ShowLeg end:=,, Title:=chartCaption)  If Not active"CL Is$hing Then'+MsgBox "&cted successfully!"r*Wizard~LExit SubEnd If ' --- Error H@andler f  : Fl failed...E(;A<#!C## Cc Burn Down ~i Publicc|(' / Declaras!Dim As Str@aG >sz GFlagABoolear΅M I&7CIC8n<OnDuGoToDsMainHG= Input)("B  of B5:d¢@eleon.Addr@j"" `.g)1 (True) if you ne@," & vbCrLf"otherwise ia 0 (False):y(Oz^">1C/ GH= [E$(0") Or 0ˉ b #!.AZ0Wģ)nLzGK-[ĊdSe+=&sSX(ASh, 3Ʃë.??!0aeɥis c%Ŋ ƾ-W# Qualitydicata4Inccc ccRP\o!e3#eR_8mer~tyq 3?e?er?e 8?e oBa` source$ a (") as Qf&ofsgXof1RofDQBup re"?hhhwhtkhorc-2Tn i'ii"id"ii(0i(iO0hqDAh_(V(!c0h h=.JF;h ), ,# Cs-OOft HUOf=?(Q@OOr:SCDefault's r | i!p!Import @From Dbap9zsaUCoioi#cConns_M!`query9\buserIDpasswdrecorDds1Int rSRWorks!cn ϯ='bdb/#t0L _usPerIDU ID:" & v bCrLf"(4Op)PGpaPsswd1PoLrd=2Seh"e= AveWorkbook.S s.Add' ###  f  hrecSskAccess.Exg(,΀, a , Tru@l0,f G], GGK 1A(Msg@ & " is iB ed su(fu0lly!j:=CܔCElse > (s) are!:!="_ failed7nd IfZE@B C Show Number of PAll AJsLM!`@age 1 Public}cOf (B' ?,Visible?-- Of =_=HiddF =Off \Delete[Nem@P tS c]Na  !Z("Do (you`a@ want to ds` nwd? ^vbYesNoCancel, confirma!q"_)@Cͧetad.edPECustom Docume Properti_ho$DCDree  e0H0 dS%#      !"$&,'()*+-[.0b12345678\:<F>?@ABCDE9GHIRKLMNOPQ;STUVWXYZr]^_facdeohijklmn`pqstuv yi Q I IA 0   QX\:`%pt$ t dp H\ QX[Tx)tp\PLx lL0/Lq xPSl'%'%'%'(%8 %X\:`%pt$ t dp H\ X $ QH)tp\X H HW A 6 l        |cHW A 6 l      |cHW A 6 l      |cHW A 6 l      |cHW A 6 l      |cHW A 6 l      |(`%cHW A 6 l      |(`%cHW A 6 l      |(`%cHW A 6 l      |(`%cHW A 6 l       |cHW A 6 l| !|  "|  | |c|0tTP|Hx,Ltp\X0   0   0   0   0   0   0   0 P  0     9rU $`$`$`$`$!`$I`$q`$__SRP_5 QualityIndicator"5__SRP_er__SRP_f`$`$ `$ `nrU~| \rU L`IAons ### <esult..zk ### Declarations ### Cha]]] ### Main ###Qu f[^\[XGA̍쐬 ..hrkshee 0G h 0$.hj<Pr 2G h 2$.hj=;In 4G h 4$.hj * F 6G h 6$.hj 8G h 8$.hj :G h :$.hjar  OtljB < h    x %. .zk Ot̏ύXB 8 : 8 : !!. 'Jdx !!.'Jk` J J !!. J % 9j >9< @9qk ### Default ### . !B@Hi #############A ## s (ROFC) ZoAw肵 (Range) ɏo͂B ##Hc ## [SEC BOOKS] ESQR Ver.1.1 ugݍ݃\tgEFAJ i荞݃KChv P102 B ##I ## ROFC: sC (Ratio Of Fault detection in Comparison) (ID=PD41)C ## NOET: eXg{ڐ (Number Of Executed Test Items) (ID=B41): ## NODF: os (Number Of Detected Fault) (ID=B42) ##! ## (Ql)= ## ROFE: sC (Ratio Of Fault Elimination) (ID=PD42)8 #; ## TLOC: \[XR[hSs (Total Lines Of Code) (ID=B10)6 ## NOTI: eXgڐ (Number Of Test Items) (ID=B40)@ ## NOEF: Cςݕs (Number Of Eriminated Fault) (ID=B43): ## ROFD: s (Ratio Of Fault Detection) (ID=B44) ##  ### Validations ### <'zk B D F'zk) .!!. B!!. D!!. F!!. .!J!. B!J!. B!J!. D!J!. D!J!. F!J!.'zk H?'H H  H e'zk ### Declarations ###]@]X]p] 'Ld('Lk ### Main ### J L .!J!. L$. J$. L$.  H  'P'N  L J $. P 'Ny`kXP N N B%J N D%J J B%J N B%J ) J D%J N D%J  J B%J N B%J  N D%J N B%J J F,JkPkH@ ### Default ###'i ############# ## SycȐ߂B ' ### Validations ### <'zkx . R T X Z \  ^'l  m( xME(0>0`06 0+`@)=`h%)hx%i ixH%+`QQ )=8@Cr%).`hSh%)0- C%)2taba%)4&V%)6%)8(0%):PX%i xix %  -% h%`J####+`8 NN)=X`%).%%)B%)D%)F%i ύiH`L :`N!`P x`J``!.+` AA )= efau%).@H%)RhpA #%)T%)VH%)X%i )Z(0%)\PXC%)xmpar%)^g%`J Tes`L (Nu  %Q*\R1*#384*\R1*#253*\R1*#383$*\Rffff*0Z5105d23f  , BP `      $B$     (HPX `  x $$$$ $H$p   (    ( H h        0 @ H H`  j ( P8 J @  ( D@ B < F @X B   $ 0 8 @ H     0 @ ` h p x               8 X  `  x         b (         " B$( @  ` p x  h    (  H hpx      f0 &H20h p$ R(   0H P`x #############ring& ## iwWOt (S) \BCohe ### Validations ### <..z`kX h!!.De.z0k( ### Main ### : < h% h% h% h% h% h% h%  x % .ʒix ############# ## iwWOt\B # ", ### Validatizk3A] .!!. R!!. T!!. V!!. X!!. .!J!. T!J!. R!J!. V!J!. V!J!. X!J!. .!J!. R!J!. 'zk Z!. \!. !. ^!.'zk ### Declarations ###]] ### Main ### 'Ld 'Lk Gompertz (Output Data) J L .!J!.= \!*EXP(- !*EXP(- ^!* J$.!)) J+T` Square Error / Convergence Rate J L R!J!.=POWER( J$T!- J$R!, 2) J+V= J$R!/ \! J+X Least Mean Square Error =AVERAGE( V!)'Z ### Solver ### Z!bd \  ^$!fh GRG NonlinearjA@`A@l ### Default ###'i }Attribute VB_Name = "QualityIndicator" Option Explicit " ' #  iwWOt (S) \B Pub FuncYShowFull(ByRef Sheet As Works , DataAreaRange,` _ al(VQLegend*Bool ean, %ChartTitleŁSng) r.t +ida-Xs|;IWIs Nothing` ThenSepExit E[If? 1{.Columnsunt p<> 76CC;Main9 1 .8(m, +(1)i3234567Oċ"-, )CA AaÂԼݺ޹Gaug¤ Regist8ere¶DAssignResClo# StatusOpenbJ Cqqqqq_qEqErdDeclar Dim ave"J!%]&*MAiaIntr#Nqc' f [^\XGA̍8쐬v = oJ#` HI lUn@( ,(e$ &P on  V  U j + b '1 ?aVm1c <àDdlje!K 1*=cPs.Add+-], xl#hClu3H's,{owU0"3u Y?: PrrcF̏`ύX( 0 ) Or n)\w zA ˃i`h.Series`leĀ- 1agElse_t_Co D1!For 1 i 1VErTDFi_m(?Row>. E@ fE G#?ZWE ZFinalTerfm@0 K!.:1C&EL< 0CFo55Ÿ' ### Declarns,Dim sta@rtPosi As IntegerGirmediate( bV@ant,< jHITIncludeFieldName 2= 21#a"?E6AC&MainG%For iBK To McCG W!+(#=( ) + (cm(i) -r) * (1 J)) $;= 0Qg!j1ig`2b(j) > k 3!afjk !oP!h5NexdJ'ভzAb.A(1)yA@@^ a() =f %?! aƨAH= ?!#) /C#))aNO ]"]^#$}Rfw?OYDiomTruP !熁1D0X$  SycB Publicv Gompertz(ByRef SheetASWorks=,E9Ra nge, SInputData8OuttSquareErr0PbzConver genceVald[Boolean< LeastMp' b c)Q  idp@ǠL@RY7(WoabckHg7!1 8!cQXr_Įw/#9'?/ qcH ) I (oi \I ߐ;$A^0)00*orAabc*)'1 v 1C!CiqF>kpOSS00?OO = LS'Ff (* b$ p .S"=" & a.Address"*EXP(Z-aboacbess & "*"PGauge(i).Addr@))" N ext ,' Square Error / Convergence RateLF6i = startPosition To InputData.Rows.Coun[e[Z?"=POWERb(Out; -X , 2a(0/am Least Mean l9AVERAG>Ek ### Sol .Ok SetCell:=7), MaxMinVa2, ByChange:=Ung(a, b, c, En(gin1Desc:="GRG NonlarĈ"B Tru )C'. Default1Gom`pertzE End Func ==`(ayIA========h`a9Qi=====`,a AQa==========n'0#xME (HiddenSheetVersionInformation&__SRP_10h__SRP_11 SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0QxAttribute VB_Name = "HiddenSheet" Bas0{00020820-CA$0046} |G lobalSpacFalse dCreatablPredec$laIdTru BExposeTemplateDerivBustomizD2Lz<xME(6 << <+p@` +`  `@(%Q$*\Rffff*0[5105d23f    B8  @ P X ,pB    " B P `x ############# ## Version d!f'pi( #############& ## Text information of Version number @ d!f0.00$'i0 #############H ## Show Version  Version  Version InformationA@ hoAttribute VB_Name = "VersionInformat(" Op Expl@icit ' #   Pub\ Func|0() As Do:eG Constant.AddIn&EndJText "i of numberOrSng2O,= F(U, "0.00")YShowSub  (&CMsg0Box & " " &$W, Titl(e:= )@+rU~| arU $` $`$`n QClipBoard Release&<License=_VBA_PROJECTJ-xME(<><`< <+@FF)<`h%iXxiZiRi^%`P J8 `. rp%`J`QI       !"#$%'()*+,-./0123456789:;<=>?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrstuvwxy{|}~ B    @PX`  hx   (0@ HP   "X      (8@  HX`h   p$    (x ## ### Validations ### <p.z k R'R R  R F edl.zPkH ^at'^ ^  ^ F e.zk ### Declarations ###8]] F]@]X]x ### Find Search Column ### < X ^$:'P P.zHk@ ### Main ###&V'. J R F J P <%L Z( J .+J . '.k .%.zk ### Join ###$J <%J.r J . r J$J <%J$.r ### Default ### r.iAttribute VB_Name = "ClipBoard" Option ExplicitD Pub4 Func:CopyRowsFrom(ByRef Sheet As@ Works, _ ByVal Keyޅ"Sng, ue<9<)Startw)Integer, #Field #)/RangehK' ### р=idaksIkIs Nothing ThenSy Exit End IfC3l= 0 1 1(lse(< @0) Or > Max)W< FZ,,F,F,DIXC{D eclar{Dimlumn Rs(TĞpCounJscrapLi' CC,Fi2Separch(CCo,=  (,,) 37f-1DZ ZDc Maink&GCFor i`g&ZToXA @B.Cells(i,!)`C߫sb7 i s+ UANex'!>/_?%g # c'Joi'A J=.b0)<%*`;o%-Un (B r,. i)E Default; ?  A*EwyxME v@ z@h@Q   b " *   " :8  @ X  h   2    x ##########[ ## ̃AhC̃^Cg (BuiltinDocumentProperties = ^Cg + o[W) ݒ肷BRx  V !Title &,x^o8 ########## ^ ## BUILD@4 Set Version to Title of Buildin Document Properties FA@v Clear Test Result nB@ Find  Do Test Suite nB@^$:+ Clear Names and Custom Document Properties # B@#&V B@ JoAttribute VB_Name = "Release" Option Explicit ' #  ̃AhC^g (BuiltinDocumentProp@erties̃J+ o[W) ݒ肷B PrivaSub setOTitle() ThisWorkboo$k.4("6")AFAddIn& " V" & Vers~Informat. TexEnd L:BUILDcub FdT' Set5 to I ofQin   r' Cr Test Resul`"s.ED@% SuiteC |DoCRs aHCustom1Metadata.DteAllO`c 0* pHdToolkit 0VBA @@ Baterials\i Hx~THIS SOFTWARE PROVIDED BY THE COPYRIGHT HOLDERS AND@NTRIBUDTO"AS@"ANY EXPRESS OR `IMPLI@RANTIES, INCLUDING,  NOTA9LIMIT T O,B OF MERCHAB ILITYFITNF@A PARTICULAR PURPOSE 6DISCLAIMED.  EVENT SHALL:#;A1COH;BE LI`ABLE ;D`IRECT6GCPNTAL, SPECIEXE!@CARY,d SE QU  DAM@AGES (#, @4CUREM "SUBSTITUTE GOOD.SERVICE S; LO!1F USEATA@& &BUSI'INTERRU@PTION)=W$R CA@D,ON##<`CORY!2!b1, WHE>N#DA"S ECT&GT NEGLIGE(NCE#OWISE)@7IGA6WA`UT`/HY,; IF ADV D$2 ASIdG'CH/bPub Sub Show() MsgBox _ a"o" & vbCrLfj2SXy oeѨs!?I#"bkokXt Tb /d/d/d PF.O) "(Cont@inue)"]itle:=834>"PY(=iii "ii`H?fiOT ?:j}nFjD jj jjey kRzkkgkkkkO`~?l?l?l?lT?l?l;lll2l ulllY l mRp| mmmc7 E``m 8R 8 H x ##########233tReleasey8}License0S5105d233|License2Pmp 0`8HPg/G`0Y o~[SQM6Z8y+QVTw%LesjLŠ^ND[_^MGΤB¨nm@dkg2xMEP 0@Q   ,( X x   X8   (  P  Rx   " ` 8R 8 H x ########## #% # Copyright (c) 2012, Daiki Sakamoto # All rights reserved. # # Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: # - Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. # - Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer(R # in the documentation and/or other materials provided with the distribution. # # THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT{ # LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHTic # HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT # LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON # ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THEK # USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. # ##########,  #%# Copyright (c) 2012, Daiki Sakamoto  All rights reserved.   Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: K - Redistributions of source code must retain the above copyright notice, : this list of conditions and the following disclaimer. F - Redistributions in binary form must reproduce the above copyright H notice, this list of conditions and the following disclaimer in the I documentation and/or other materials provided with the distribution.   (Continue)LicenseA@   THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT  HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT  LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON  ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE I USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.LicenseA@o@8<Attribute VB_Name = "License" Option Explicit ' #  Copyright (c) 2012, Daiki SakamotoN All Ps reserved.`Redis{and use in source binary forms, with orout modifica, are permitted providthat the"llowing condismetB:I - Ks ofHcode mustgtaT*above(Qnot,8is lp 8sFclaimer} B6BrdnuMDEC cdocumentZAf/ao@r mAX bNamepropertyText Excel+@ VBA@Win16~@Win32@Win64x@Mac@VBA6#@VBA7#@ Toolkit>@stdole`@Officeu@ADODBs@SSCE-@MSFormsC@ Solver@ ThisWorkbook|@ _Evaluate@ Workbook_Open@ ControlsK@(AddMenuControlw @Workbook_BeforeClose@Cancel@(DeleteMenuControl|]@ TestDataSheet@ DataGridS$@ (FindColumn@Sheet[@ Worksheet@Row@ StartColumn@ EndColumnnS@(MaxRow+@ (MaxColumn'@i`@Cells@(FindRow@Columni@StartRow@EndRow@(FindCell@KeyName@KeyValuef@ FieldName@FieldRowi@Range @ keyColumn@ targetColumn@ targetRowӅ@(Findn@cell@ValueK@ Testsd@testPassCf@testFail @testResultSheetNameZ@sourceDataSheet@ printTestNameͥ@TestName@FontU@Bold@doTestY@Criteria7@Color2F@ moveChartw@Chart?@OffsetX:@OffsetY:@Parent@Top5@Height|@(ShowTestResult@ Metadatao@(ContainSheetName@Sheets @Copyƿ@(ClearTestResult1@(DeleteAllNames`@!(DeleteAllCustomDocumentPropertiesbn@ActiveWorkbook@Deletex@(DoTests@Addr@ja@kb@ (AddInName@ VersionInformation#s@ ( VersionText0@Size@ ColumnWidth@doDataGridTest2@doMetadataTestD@ doChartsTestR@doQualityIndicatorTest/@doDataAccessTest@doClipBoardTestMb@MsgBoxR@Title~@(CountWorksheets3 @(CountVisibleWorksheetsp@(CountHiddenWorksheets J@ (FindSheetName@ (SetNameToCell@(SetNameToRange@(SetNames@(SetNamesToRangeI @(SetCustomDocumentProperty@(SetCustomDocumentProperties@ChartPositionX@ChartPositionY}@ activeChart @ Charts@(AddChartY@Union@xlXYScatterLinesbS@ xlColumnsh@(AddScatterChart<@(AddBurnDa *\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.7#0#C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE#Microsoft Excel 14.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.5#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\MSO.DLL#Microsoft Office 14.0 Object Library**\G{2A75196C-D9EB-4129-B803-931327F72D5C}#2.8#0#C:\Program Files (x86)\Common Files\System\ado\msado28.tlb#Microsoft ActiveX Data Objects 2.8 LibraryF*\G{CE4AACFA-3CFD-4028-B2D9-F272314F07C8}#4.0#0#C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\sqlceca40.dll#Microsoft SQL Server Compact Control*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{7CEE0985-08BF-4E43-880F-AB292B17D780}#2.0#0#C:\Users\DAIKI~1.SAK\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\CC:\Program Files (x86)\Microsoft Office\Office14\Library\SOLVER\SOLVER.XLAM*\C..\..\..\..\..\..\Program Files (x86)\Microsoft Office\Office14\Library\SOLVER\SOLVER.XLAM3q M VBA ToolkitQ  ThisWorkbook0T5105d233'ThisWorkbookrTestDataSheet0F5105d2337TestDataSheetx-DataGrid0V5105d23f8DataGrid0 Tests0H5105d233n TestsHGDataAccess0W5105d23fDataAccess@`Metadata0X5105d23fMetadata-x2Constant0K5105d233dConstant+iE Charts0Y5105d23f ChartsINControls0U5105d233,Controls xI QualityIndicator0Z5105d23f QualityIndicator s(HiddenSheet0O5105d233oHiddenSheet0-$VersionInformation0[5105d23f$VersionInformation<ClipBoard0Q5105d233 ClipBoardQ  Release0R5105downCharte@Resultur@Result2@ QualityIndicator!@h Show@( ShowFullѦ@!( RatioOfFaultDetectionInComparison]@xlXYScatterLinesNoMarkersv@ ShowLegendH@ (Set2ndAxisJ@( Gompertz@recordsQ@ DataAccess@(Export@ ClipBoardy@ ( CopyRowsFrom7@Address@ConnectionString@Query%@ ShowField@UserIDj@Password@conJ@ Connection@rs_@ Recordset@ ErrorHandlerO@adOpenForwardOnlyD@adLockReadOnlyQ@ MoveFirstN@Fields7@Count0v@EOF@IsNull@MoveNextL!@NameRowI@ NameColumn@ValueRowF@ ValueColumnX@@ InWorksheet`|@ valueName @ NameRange@ ValueRange@ targetNamem@Namesο@NameColumnTitleF@ValueColumnTitle@TitleRow@ PropertyName@CustomDocumentPropertiesޖ@ LinkToContentL@ LinkSourceg@msoPropertyTypeString4@DocumentProperty&V@ Worksheets@Visible@Book@Workbookk@ Constant@ (AddInVersionK@DataAreaɁ@ ChartType?@ XlChartTypeZ@PlotBy$@XlRowColg@xlRows@ Application*@HasTitle{@ ChartTitle_@Captionx@ SetSourceDataa@DisplayBlanksAs@ xlNotPlotted@ HasLegendB@Location-@xlLocationAsObject@XData܅@YData3@IncludeFieldName@ xlXYScatter)@xlXYScatterSmooth@xlXYScatterSmoothNoMarkers@xo@SeriesCollection;:@XValuesb@ targetChart@ ChartObjectƹ@ SeriesIndex@ AxisGroupg@ xlLineMarkersa@Columnsp9@xlColumnClusteredr@Fill,@TwoColorGradientk@msoGradientHorizontalG@ menuCaption@countAllWorksheetMenuCaption@ countVisibleWorksheetMenuCaptionv@countHiddenWorksheetMenuCaption"O@deleteAllNamesMenuCaptionb@,deleteAllCustomDocumentPropertiesMenuCaption\@createChartMenuCaptionu@createBurnDownChartMenuCaption_b@showQualityIndicatorMenuCaption@dbImportMenuCaptionp@versionInformationMenuCaption@showTestResultMenuCaption9@dbImportFromDatabaseWizardTitle@createChartWizardTitler@createBurnDownChartWizardTitle@showQualityIndicatorWizardTitle@showNumberOfWorkSheetsTitle M@confirmationMessageBoxTitleK@defaultConnectionString*@defaultQueryTextdi@ctrl@CommandBarControlP@ CommandBars @ menuControl@msoControlPopupl)@countAllWorksheetMenu:@OnAction@ BeginGroup@countVisibleWorksheetMenu@countHiddenWorksheetMenu@deleteAllNamesMenu"@%deleteAllCustomDocumentPropertiesMenuIh@createChartMenu@FaceIdi@createBurnDownChartMenuo@showQualityIndicatorMenu@ dbImportMenu@versionInformationMenus"@showTestResultMenu@(CreateChartWizard/@ dataAreaText@ plotByText@@ plotByEnum@showLegendText@chartTitleCaption@InputBox @ SelectionZ@vbCrLf@ ActiveSheet%N@(CreateBurnDownChartWizardL@showLegendFlago@(ShowQualityIndicatorWizard=@ dataAreaRangeC@(ImportFromDatabaseWizard@ queryText@ userIDTexte@ passwdText@(ShowNumberOfAllWorksheet@(ShowNumberOfVisibleWorksheet1@(ShowNumberOfHiddenWorksheet@(DeleteAllNamesFromWorkbook o@ vbYesNoCancelq@vbYesa?@-(DeleteAllCustomDocumentPropertiesFromWorkbook@Gauges@ Registered@AssignedE@Released@Closed,@ StatusOpen @ StatusClosed@ MarkerStyle@xlMarkerStyleNoneg@ xlSecondary6@NOETv<@NODFC<@ROFCAS@FinalTermRatio g@RowsU@ startPosition+@intermediatePositionp{@intermediatePoint@ InputData@ OutputDataY@ SquareError1@ Convergence@LeastMeanSquareErrorm[@aX@cZ@SolverOkC@SetCellY@ MaxMinVal7.@ByChange@Engine@ EngineDescb6@ SolverSolveQ@ HiddenSheetRG@( Version@scrap>@ Releaseoa@!setBuiltinDocumentPropertiesTitleP@BuiltinDocumentProperties_@( BuildE@ Licenseoq@ BeforeClose~;@Itemz@ e *    o  "&$'-&o .u '7"9+, -}$/0@@@P    $ @ dirG__SRP_0g__SRP_1%dQPROJECTwmzA@ Tolkit2=    Q %<9stdole> sMdYe h%^*\G{00020430v-C 0046}#2.0#0#C:\Windows\SysWOW64\22.tlb#OLE Automaption0EOfficEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42EProgram Files (x86)\Common \Microsoft Shared\OFFICE14\MSO.DLL#P 14.0 Object LibraryNADODB> DOBT1A75196C-D9EB-4129-B803-931327F72D5C18T1@Ztem\ado\ms@28ZG.ActiveX Data.s 2 .8/SSCE>*SSCE/@/CE4AAC_3CFD-4028-B2D9-F272314F07C8}#H/&SQL ServHer epaTE$di\v\sqlceca400.dllb Co`ntrol@)MSForms>M@3Frms3@30D452EE1-E08FAA-8-02608C4D0B B4HNFM20 BW/;~1`cgj!j00}#0j#`@0`! 7CEE098c8BF-4E43-880F-AB292B17D78 wUsers\DAIKI~1.SAK\AppAF\Local\Temp\VBE@c".exdh2@.E .`M ASol?ES2lv~r6N`*\C`'Is\w$s\SOLVER@.XLAM]# .L.\L ce AM3q MbThisWorkbookGU@T`i RW@rUbo2E` H1",r""+`{@Test