ࡱ> SR f2ɀ\pSetup Ba= ThisWorkbook=I=;(X@"1Arial1Arial1Arial1Arial1Arial1 Arial1$Arial1Arial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial1Calibri1Arial1@Arial1Arial1Arial1Arial1 Arial1Calibri1Calibri"R"\ #,##0;"R"\ \-#,##0!"R"\ #,##0;[Red]"R"\ \-#,##0""R"\ #,##0.00;"R"\ \-#,##0.00'""R"\ #,##0.00;[Red]"R"\ \-#,##0.00=*8_ "R"\ * #,##0_ ;_ "R"\ * \-#,##0_ ;_ "R"\ * "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ E,@_ "R"\ * #,##0.00_ ;_ "R"\ * \-#,##0.00_ ;_ "R"\ * "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_  0.000% 0.0%0.0000000000000000%0.000000000000000%0.00000000000000%0.0000000000000%0.000000000000%0.00000000000% 0.0000000000% 0.000000000% 0.00000000% 0.0000000% 0.000000% 0.00000% 0.0000% 0.00000 0.0000 0.000 0.0E+00 0.000E+00 0.0000E+00 0.00000E+00 0.000000E+00 0.0000000E+000.00000000E+000.00000000000000000%0.000000000000000000%0.0000000000000000000%0.00000000000000000000%0.000000000000000000000%0.0000000000000000000000%0.00000000000000000000000% 0.000000000000000000000000%!0.0000000000000000000000000%"0.00000000000000000000000000%#0.000000000000000000000000000%$0.0000000000000000000000000000%% 0.00000000000000000000000000000%&!0.000000000000000000000000000000%'"0.0000000000000000000000000000000%(#0.00000000000000000000000000000000%)$0.000000000000000000000000000000000%*%0.0000000000000000000000000000000000%+&0.00000000000000000000000000000000000%,'0.000000000000000000000000000000000000%-(0.0000000000000000000000000000000000000%.)0.00000000000000000000000000000000000000%/*0.000000000000000000000000000000000000000% 0.000000 0.0000000 0.00000000 0.000000000 0.0000000000 0.000000000000.083_ * #,##0.000_ ;_ * \-#,##0.000_ ;_ * "-"??_ ;_ @_ 4/_ * #,##0.0_ ;_ * \-#,##0.0_ ;_ * "-"??_ ;_ @_ 0.00%;[Red]\-0.00%General;[Red]\-General0.00;[Red]\-0.000.0%;[Red]\-0.0%0.0000;[Red]\-0.0000 0%;[Red]\-0%                                                                      ff + ) , *      P  P         `               a>  #    @ @                 " " " "   #     !            (      # " !   @  !  !# !  !         @ ||j2}(}C _ ;_ * "}(}D _ ;_ * "}(}E _ ;_ * "}(}F _ ;_ * "}(}H _ ;_ * "}(}I _ ;_ * "}(}J _ ;_ * "}<}K _ ;_ * " @_ "-"?}<}L ?_ ;_ * " @_ "-"?}(}N _ ;_ * "}(}O _ ;_ * "}<}P _ ;_ * " @_ "-"?}<}Q ?_ ;_ * " @_ "-"?}(}S _ ;_ * "}(}T _ ;_ * "}(}U _ ;_ * "}(}V _ ;_ * "}(}W _ ;_ * "}(}Y _ ;_ * "}(}Z _ ;_ * "}(}[ _ ;_ * "}(}\ _ ;_ * "}(}] _ ;_ * "}(}^ _ ;_ * "}(}_ _ ;_ * "}(}` _ ;_ * "}(}a _ ;_ * "}(}b _ ;_ * "}(}c _ ;_ * "}(}d _ ;_ * "}(}e _ ;_ * "}(}f _ ;_ * "}(}g ?_ ;_ * "}(}h ?_ ;_ * "}(}i_ ;_ * " 20% - Accent10 20% - Accent1 20% - Accent20" 20% - Accent2 20% - Accent30& 20% - Accent3 20% - Accent40* 20% - Accent4 20% - Accent50. 20% - Accent5 20% - Accent602 20% - Accent6 40% - Accent10 40% - Accent1 40% - Accent20# 40% - Accent2 40% - Accent30' 40% - Accent3 40% - Accent40+ 40% - Accent4 40% - Accent50/ 40% - Accent5 40% - Accent603 40% - Accent6 60% - Accent10 60% - Accent1 60% - Accent20$ 60% - Accent2 60% - Accent30( 60% - Accent3 60% - Accent40, 60% - Accent4 60% - Accent500 60% - Accent5! 60% - Accent604 60% - Accent6 "Accent1$Accent1 #Accent2$!Accent2 $Accent3$%Accent3 %Accent4$)Accent4 &Accent5$-Accent5 'Accent6$1Accent6(BadBad) Calculation, Calculation* Check Cell* Check Cell+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory Text65Explanatory Text0 : Followed Hyperlink 1GoodGood2 Heading 1( Heading 13 Heading 2( Heading 24 Heading 3( Heading 35 Heading 4( Heading 46( Hyperlink 7Input Input8 Linked Cell, Linked Cell 9Neutral$Neutral"Normal :Normal 2 ;Normal 3 <Note Note =Output"Output>$Percent? Percent 2 @Title Title ATotal TotalB Warning Text. Warning TextXTableStyleMedium2PivotStyleLight16`\4 Hazard Ratioalpha:  cov_inc_1: cov_inc_2:frrhat: frrhatcov: incrathat:" incrathatcov:max_cov:# # max_cov_ratio:' max_frr:$  maxcov_frr:! min_n_r:&  mincov_frr:" n_1: n_2: n_pos_1: n_pos_2: n_r_1: n_r_2: n_s_1: n_s_2: p_nr_1: p_nr_2: p_pos_1: p_pos_2: p_r_1: p_r_2: p_s_1: p_s_2: z: 8*"l3 A@@  **# Sample CountsTotal sample size-()InputsOutputs EstimatesSurvey 1Survey 2 HIV-negative/Test for Recent Infection/Assay Characteristics%Estimated False-Recent Rate (FRR) (%)CoV of FRR Estimate (%) HIV-positiveCoV of Incidence Ratio (%)sample proportionsHIV-positive, 'recent'HIV-positive, 'non-recent'survey 1survey 2bCoefficient of Variation (CoV) of incidence estimates (excluding test characteristic uncertainty)other parametersalphazmax cov estimated FRRmin cov estimated FRRmax cov incidencemax frrmin frrmin n_r max cov ratioIncidence Ratio CalculatorVCalculates the Hazard Ratio (ratio of two incidence rates, as observed in two surveys)>Recency test-positive (i.e. classified as 'recently' infected)*0 1[1 23wccB f2ɀ /:U[  dMbP?_*+%&?'?(?)?MBullzip PDF Printer<S 4XXA4PRIV0''''h<P4(?l hSMTJXBullzip PDF PrinterResolution600dpiPageSizeLetterPageRegionColorModelDefaultPDFSettingsDefaultColorImageFilterDefaultGrayImageFilterDefaultMonoImageFilterDefaultCompatibilityLevelDefaultAutoRotatePagesDefaultEmbedAllFontsDefaultSubsetFontsDefaultCompressPagesDefault" XX??&cU} IG} $JG} G} $ G} $ G} G} $ G} IG} $ G} $ G/ @@; @ ;    @@;@@@<FFFFFFFFFFFFFFFFFFFFFFFFFFFF H F I J*FFFFKFFFFFFFFFFFFFF F!0FFFFFFFLFFFFFFFFFFFFF4FFFFFFFFFLgFFFFFFFFFFFFF M FFOMN 7 Indicative dC% CIs, using input CoV&#Indicative 95% CIs, using input CoV&PPQgFFFFFFFFFFFFF R F~ C? S0Tm ?p?CCCCA U0VSkB?CCCCA F L C "Warning: Zero estimated FRR^CC ='Warning: Estimated FRR is greater than C d% "B  gFFFFFFFFFFFFF R F~ C>@WFFFF L CC D.Warning: CoV of estimated FRR is greater than dC %fCC A+Warning: CoV of estimated FRR is less than dC %@"B  gFFFFFFFFFFFF4FRFXWFFFFLgFFFFFFFFFFFF4FFFFFFFFFLgFFFFFFFFFFFF F M F Y Y * FFFYLgFFFFFFFFFFFF F R  F D@D @* FFFZLgFFFFFFFFFFFF F R F Db@D`f@* FFFZLgFFFFFFFFFFFF F R" F DI@DD@ FFFF  L CC CC B%`YError: Count of "recently" infected subjects cannot exceed count of HIV-positive subjectsuCC CC B%E4Warning: Number of "recent" infections is less than C @ "B gFFFFFFFFFFFF F G F# F @  % # F@ %  FFFF LCC CC B${eWarning: Each incidence estimator coefficient of variation (excluding parameter uncertainty) exceeds Cd%<CC lWarning: Incidence estimator coefficient of variation for study 1 (excluding parameter uncertainty) exceeds Cd%CC lWarning: Incidence estimator coefficient of variation for study 2 (excluding parameter uncertainty) exceeds Cd% ""B gFFFFFFFFFFFFFFFiiFFFF L xCCC CCC B$UNWarning: Numerator of evaluated incidence estimator is negative for each studyCCC RKWarning: Numerator of evaluated incidence estimator is negative for study 1}CCC RKWarning: Numerator of evaluated incidence estimator is negative for study 2 ""B  gFFFFFFFFFFFFFFFFFFFFF LJCoV of incidence estimator, excluding test characteristic uncertainty, is dCA% for survey 1 and @dCA% for survey 2vsCoV of incidence estimator, excluding test characteristic uncertainty, is 14.5% for survey 1 and 16.4% for survey 2  gFFFFFFFFFFFFF [F Y Y *FYFFLgFFFFFFFFFFFFF \FV]T?@CCCCCCCCAV]M} ? @CCCCCCCCA*FFFFLgFFFFFFFFFFFF4FFFh^FFFFLgFFFFFFFFFFFFFF uAIncidence Ratio (Survey 2 incidence / Survey 1 incidence ) (with @dC% Confidence Interval)@\YIncidence Ratio (Survey 2 incidence / Survey 1 incidence ) (with 95% Confidence Interval)FIEybҙ? 3CCCCCCCC S0_q[C? CCCCA `0a 6?CCCCA F L C (!Warning: Negative incidence ratioCCC CCC B%70Warning: ratio uses negative incidence estimatesECC  Warning: CI contains zero ""B  gFFFFFFFFFFFFF FFbͼT ?pCCCCCCCCCCCCCCAFRRRRp L ZCC @*Warning: Coefficient of variation exceeds dC % B  gRRRRRRRRFFFF4FFFFFRRRRLgRRRRRRRRFFFF4FFFFFRRRRccccccRRRRFFFFFFFFFRRRRcc  c cccRRRRFFFFFFFFFRRRRccc  c  ccRRRRFFFFFFFFFRRRRcc  d ! e18? CC! eIҦ!? CCcRRRRFFFFFFFFFRRRRcc  d! eL? CC! e,Ax? CCcRRRRFFFFFFFFFRRRRcc  d% e ekB? CC% ekGs? CCcRRRRFFFFFFFFFRRRRcc  d! ey? CC! eҶ% _ϛ? CCcRRRRFFFF4FFFFFRRRRccccccRRRRFFFFFFFFFRRRRcc  c cccRRRRFFFFFFFFFRRRRcc  d~  c@ ccRRRRFFFFDl@lL8<88lff|nl8 X88NZ8N !"#$%&'()*+,-. FFFFFRRRRcc d& c1\? CA( ccRRRRFFFF!FFFFFRRRRcc ! d~ ! f>@! ccRRRRFFFF"FFFFFRRRRcc " d~ " f@" ccRRRRFFFF#FFFFFRRRRcc # d~ # f?# ccRRRRFFFF$RRRRcc $ d~ $ f$@$ ccRRRR%RRRRcc % d~ % f% ccRRRR&RRRRcc & d~ & c$@& ccRRRR'RRRRcc ' d~ ' f>@' ccRRRR"(RRRRccccccRRRR")RRRRccccccRRRR"*RRRRRRRRRRRRRR"+RRRRRRRRRRRRRR",RRRRRRRRRRRRRR"-RRRRRRRRRRRRRR".RRRRRRRRRRRRRR"vZZZHHHH&&&&&&4(  n  c 4NChart 1  b]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PH@h0(  h@w3d23 M NMR R R R] S S4 3Q: survey 1Q ; Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]h S S43_ M , f @"B  ` MM<R R?= S S43_ M ̙/ f @"B  ` MM<R Rֹ S S43_ M 7 f ٖ@"B  ` MM<R RB{ S S4ES S 4D$% z03O&Q4$% z3O&Q4FA% 3O- 3" N Q3OQv2% z03O&#Q423 M NMR RR RR R R R]S S4<g|h?$3m?Xo~??b3*կ  / S S 4S S4S S4D- =s?=]?Ϧ'=?jhF?% Q 3O8&"Q Survey 123 M NMR RR Rv]S S4'<(@JLg?,ƫ? /S S4$[fgS S 4eee*ven-ZA̞ vn  c 4NChart 2 U]@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"@XX333333?333333?3&<3PHPl0(  l`v3d23 M NMR R R R] S S4 3Q: survey 2Q ; Q ; Q3_ M ff6 f O@"B  ` MM<R R R R8]h S S43_ M , f @"B  ` MM<R R?= S S43_ M ̙/ f @"B  ` MM<R Rֹ S S43_ M 7 f ٖ@"B  ` MM<R RB{ S S4ES S 4D$% Xy03O&Q4$% Xy3O&Q4FA 3O 3" 44D v`Yz?cHa6?<^?N?% eZ 3OS8&"Q Survey 223 M NMR RR Rv]S S4'<_%4?=? V/S S4$V[fgS S 4eee*Vven-ZA̞V >@Uvr7IL!Counts must be greater than zero.UTst AlCoV must be non-negative. zUg <FRR must be a non-negative percentage not greater than 100%.?@ACDEFGHIKLMNOPQRoot Entry FWorkbookSummaryInformation(BDocumentSummaryInformation8J