{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Tools","Graph","Sheet3"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Tools","index":0,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,null,"Clinical Trials to Calculate Test Sensitivity and Specificity"]
[]
[null,null,"1.  Instructions: Fill in the number of patients involved in the clinical trial:"]
[null,null,"Total Number of Patients with Disease:",10000]
[null,null,"Total Number of Patients without Disease:",990000]
[]
[]
[null,null,"2.  Instructions: Fill in the upper left and lower right cells (blue):"]
[{"$nulls":4},"Disease +","Disease -","Total"]
[null,null,null,"Test +",9990,990,10980]
[null,null,null,"Test - ",10,989010,989020]
[null,null,null,"Total",10000,990000,1000000]
[]
[]
[null,null,null,"Test Sensitivity:",0.999]
[null,null,null,"Test Specificity:",0.999]
[]
[]
[]
[null,null,null,"Tool to Investigate False Positive and Negative Percentages"]
[]
[null,null,"Instructions: Select values for the following parameters:"]
[]
[null,null,"Number of Patients:",1000000]
[null,null,"Proportion of patients with disease:",0.01]
[]
[null,null,"Test Sensitivity:",0.999]
[null,null,"Test Specificity:",0.999]
[]
[{"$nulls":4},"Disease +","Disease -","Total"]
[null,null,null,"Test +",9990,990,10980]
[null,null,null,"Test - ",10,989010,989020]
[null,null,null,"Total",10000,990000,1000000]
[]
[null,null,null,"False Positive Percentage:",0.09016393442622951]
[null,null,"See Sheet 2 for graphs!!","False Negative Percentage:",1.0111018988493661e-05]
[]
[]
[]
[]
[null,null,null,"Tool to Investigate Referral Bias and Apparent Sensitivity and Specificity"]
[]
[]
[null,null,"Instructions: Select values for the following parameters:"]
[]
[null,null,"Number of Patients:",10000]
[null,null,"Proportion of patients with disease:",0.25]
[]
[null,null,"Test Sensitivity:",0.75]
[null,null,"Test Specificity:",0.85]
[{"$nulls":8},"Instructions: fill in the referral rates"]
[{"$nulls":4},"Disease +","Disease -","Total",{"$nulls":5},"Disease +","Disease -","Total"]
[null,null,null,"Test +",1875,1125,3000,null,"Pos. referral rate:",0.32,null,"Test +",600,360,960]
[null,null,null,"Test - ",625,6375,7000,null,"Neg. referral rate:",0.035,null,"Test - ",21.875000000000004,223.12500000000003,245.00000000000003]
[null,null,null,"Total",2500,7500,10000,{"$nulls":4},"Total",621.875,583.125,1205]
[]
[null,null,null,"False Positive Percentage:",0.375,{"$nulls":7},"Apparent Sensitivity:",0.964824120603015]
[null,null,null,"False Negative Percentage:",0.08928571428571429,{"$nulls":7},"Apparent Specificity:",0.3826366559485531]

{"sheet":"Graph","index":1,"n_rows":133,"n_cols":9,"rows_kept":133,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,"Note: Uses population, sensitivity, and specificity values from the second tool on Sheet 1"]
[]
[]
[null,null,"Percentage of population with disease (d)","False Pos. Proportion","TP","FP","TN","FN","False Neg. Proportion"]
[]
[]
[null,null,0.00100000000000001,0.9901087150240597,9.990000000000101,999.9900000000009,998990.01,0.01000000000000011,1.0010110010908928e-08]
[null,null,0.00200000000000001,0.9804109965096669,19.9800000000001,999.9800000000009,998980.02,0.02000000000000012,2.002042002761148e-08]
[null,null,0.003,0.9709012175466532,29.97,999.9700000000009,998970.03,0.030000000000000027,3.0030930056102007e-08]
[null,null,0.004,0.9615739672282484,39.96,999.9600000000008,998960.04,0.040000000000000036,4.0041640102375294e-08]
[null,null,0.005,0.9524240403847987,49.95,999.9500000000008,998950.05,0.050000000000000044,5.005255017242607e-08]
[null,null,0.006,0.9434464278974979,59.94,999.9400000000009,998940.06,0.06000000000000005,6.00636602722494e-08]
[null,null,0.007,0.9346363075542595,69.93000000000002,999.9300000000009,998930.07,0.07000000000000008,7.007497040784061e-08]
[null,null,0.008,0.9259890354126539,79.92,999.9200000000009,998920.08,0.08000000000000007,8.00864805851952e-08]
[null,null,0.009,0.9175001376374081,89.90999999999998,999.9100000000009,998910.09,0.09000000000000007,9.009819081030897e-08]
[null,null,0.02,0.8334444814938314,199.8,999.8000000000009,998800.2,0.20000000000000018,2.0024020815370137e-07]
[null,null,0.03,0.769355086963214,299.7,999.7000000000008,998700.3,0.30000000000000027,3.0039032719115244e-07]
[null,null,0.04,0.714408233276158,399.6,999.6000000000009,998600.4,0.40000000000000036,4.0056046420151107e-07]
[null,null,0.05,0.6667778519012677,499.5,999.5000000000009,998500.5,0.5000000000000004,5.00750625187156e-07]
[null,null,0.06,0.6250938203652742,599.4,999.4000000000009,998400.6,0.6000000000000005,6.009608161528657e-07]
[null,null,0.07,0.588308018368068,699.3000000000001,999.3000000000009,998300.7,0.7000000000000007,7.011910431058203e-07]
[null,null,0.08,0.5556049822064059,799.2,999.2000000000008,998200.8,0.8000000000000007,8.014413120556015e-07]
[null,null,0.09,0.5263407438626069,899.1,999.1000000000009,998100.9,0.9000000000000008,9.017116290141955e-07]
[null,null,0.1,0.5000000000000002,999,999.0000000000009,998001,1.0000000000000009,1.0020019999959928e-06]
[null,null,0.2,0.33311081441922585,1998,998.0000000000009,997002,2.0000000000000018,2.0060100059779115e-06]
[null,null,0.3,0.24962443665498266,2997,997.0000000000009,996003,3.0000000000000027,3.0120300480117618e-06]
[null,null,0.4,0.19951923076923092,3996,996.0000000000009,995004,4.0000000000000036,4.0200681803563426e-06]
[null,null,0.5,0.1661101836393991,4995,995.0000000000009,994005,5.000000000000004,5.030130481584697e-06]
[null,null,0.6,0.14224384659416153,5994,994.0000000000009,993006,6.000000000000005,6.042223054706293e-06]
[null,null,0.7,0.12434259954921123,6992.999999999999,993.0000000000009,992007,7.000000000000005,7.056352027289942e-06]
[null,null,0.8,0.11041852181656288,7992,992.0000000000009,991008,8.000000000000007,8.07252355158747e-06]
[null,null,0.9,0.09927870166299345,8991.000000000002,991.0000000000009,990009,9.00000000000001,9.090743804658108e-06]
[null,null,1,0.0901639344262296,9990,990.0000000000009,989010,10.000000000000009,1.011101898849367e-05]
[null,null,2,0.04675572519083974,19980,980.0000000000009,979020,20.000000000000018,2.0428174538323273e-05]
[null,null,3,0.03135100193923726,29970,970.0000000000009,969030,30.00000000000003,3.095783542814689e-05]
[null,null,4,0.02346041055718477,39960,960.0000000000009,959040,40.000000000000036,4.170663552571218e-05]
[null,null,5,0.01866404715127703,49950,950.0000000000008,949050,50.00000000000004,5.2681487725213405e-05]
[null,null,6,0.015440210249671498,59940,940.0000000000008,939060,60.00000000000006,6.388959877331977e-05]
[null,null,7,0.013124470787468256,69930,930.0000000000007,929069.9999999999,70.00000000000006,7.53384850506921e-05]
[null,null,8,0.011380504700643257,79920,920.0000000000008,919080,80.00000000000007,8.703598938160938e-05]
[null,null,9,0.010019819423034582,89910,910.0000000000008,909090,90.00000000000009,9.899029895070292e-05]
[null,null,10,0.008928571428571437,99900,900.0000000000008,899100,100.00000000000009,0.00011120996441281148]
[null,null,11,0.008033941144610948,109890,890.0000000000008,889110,110.0000000000001,0.0001237039202896922]
[null,null,12,0.007287181185823127,119880,880.0000000000008,879120,120.00000000000011,0.0001364815067558347]
[null,null,13,0.006654428636989451,129870,870.0000000000008,869130,130.0000000000001,0.0001495524929250168]
[null,null,14,0.006111426947129056,139860,860.0000000000008,859140,140.0000000000001,0.00016292710175961283]
[null,null,15,0.005640345056403455,149850,850.0000000000008,849150,150.00000000000014,0.0001766160367361358]
[null,null,16,0.005227781926811058,159840,840.0000000000008,839160,160.00000000000014,0.0001906305104131918]
[null,null,17,0.0048634712293449,169830,830.0000000000007,829170,170.00000000000014,0.00020498227506209776]
[null,null,18,0.004539415411868915,179820,820.0000000000008,819180.0000000001,180.00000000000017,0.0002196836555360283]
[null,null,19,0.0042492917847025535,189810,810.0000000000007,809190,190.00000000000017,0.00023474758457090632]
[null,null,20,0.003988035892323034,199800,800.0000000000007,799200,200.00000000000017,0.0002501876407305481]
[null,null,21,0.00375154335644411,209790,790.0000000000007,789210,210.0000000000002,0.0002660180892300679]
[null,null,22,0.0035364526659412434,219780,780.0000000000007,779220,220.0000000000002,0.000282253925895515]
[null,null,23,0.003339984384488595,229770,770.0000000000007,769230,230.0000000000002,0.000298910924544486]
[null,null,24,0.00315982038915683,239760,760.0000000000007,759240,240.00000000000023,0.00031600568810238617]
[null,null,25,0.002994011976047907,249750,750.0000000000007,749250,250.00000000000023,0.0003335557038025353]
[null,null,26,0.0028409090909090936,259740,740.0000000000007,739260,260.0000000000002,0.00035157940285590687]
[null,null,27,0.0026991052281298555,269730,730.0000000000007,729270,270.0000000000002,0.0003700962250185051]
[null,null,28,0.002567394094993584,279720,720.0000000000007,719280,280.0000000000002,0.0003891266885318809]
[null,null,29,0.00244473521107362,289710,710.0000000000007,709290,290.0000000000003,0.000408692465965783]
[null,null,30,0.0023302263648468727,299700,700.0000000000006,699300,300.0000000000003,0.00042881646655231604]
[null,null,31,0.0022230813841098026,309690,690.0000000000006,689310,310.0000000000003,0.0004495229256692095]
[null,null,32,0.0021226120614308915,319680,680.0000000000005,679319.9999999999,320.0000000000003,0.0004708375022070513]
[null,null,33,0.0020282133559363096,329670,670.0000000000005,669329.9999999999,330.0000000000003,0.0004927873846429536]
[null,null,34,0.0019393511988716515,339660,660.0000000000005,659339.9999999999,340.0000000000003,0.0005154014067426636]
[null,null,35,0.0018555523836711405,349650,650.0000000000006,649350,350.0000000000003,0.000538710173926428]
[null,null,36,0.001776396136338405,359640,640.0000000000006,639360,360.00000000000034,0.0005627462014631407]
[null,null,37,0.0017015070491006336,369630,630.0000000000006,629370,370.00000000000034,0.0005875440658049359]
[null,null,38,0.0016305491268672433,379620,620.0000000000006,619380,380.00000000000034,0.0006131405705434367]
[null,null,39,0.0015632207472707719,389610,610.0000000000006,609390,390.00000000000034,0.000639574928662797]
[null,null,40,0.0014992503748125952,399600,600.0000000000006,599400,400.00000000000034,0.0006668889629876632]
[null,null,41,0.0014383929006777528,409590,590.0000000000007,589410.0000000001,410.00000000000034,0.0006951273269811133]
[null,null,42,0.001380426504188882,419580,580.0000000000007,579420.0000000001,420.0000000000004,0.0007243377483443714]
[null,null,43,0.0013251499511786873,429570,570.0000000000006,569430.0000000001,430.0000000000004,0.0007545712982135968]
[null,null,44,0.0012723802599291113,439560,560.0000000000005,559440,440.0000000000004,0.0007858826891476752]
[null,null,45,0.0012219506776271949,449550,550.0000000000005,549450,450.0000000000004,0.0008183306055646488]
[null,null,46,0.0011737089201877943,459540,540.0000000000005,539460,460.0000000000004,0.0008519780708253082]
[null,null,47,0.0011275156363017497,469530,530.0000000000005,529470,470.0000000000004,0.0008868928557949964]
[null,null,48,0.0010832430630780777,479520,520.0000000000005,519480,480.00000000000045,0.0009231479344564976]
[null,null,49,0.0010407738459654718,489510,510.00000000000045,509490,490.00000000000045,0.000960821993019335]
[null,null,50,0.0010000000000000009,499500,500.00000000000045,499500,500.00000000000045,0.0010000000000000009]
[null,null,51,0.000960821993019335,509490,490.00000000000045,489510,510.00000000000045,0.0010407738459654718]
[null,null,52,0.0009231479344564976,519480,480.00000000000045,479520,520.0000000000005,0.0010832430630780777]
[null,null,53,0.0008868928557949964,529470,470.0000000000004,469530,530.0000000000005,0.0011275156363017497]
[null,null,54,0.0008519780708253081,539460,460.00000000000034,459539.99999999994,540.0000000000005,0.0011737089201877945]
[null,null,55,0.0008183306055646487,549450,450.00000000000034,449549.99999999994,550.0000000000005,0.001221950677627195]
[null,null,56,0.0007858826891476751,559440,440.00000000000034,439559.99999999994,560.0000000000005,0.0012723802599291115]
[null,null,57,0.0007545712982135972,569430,430.00000000000045,429570.00000000006,570.0000000000005,0.0013251499511786869]
[null,null,58,0.0007243377483443716,579420,420.00000000000045,419580.00000000006,580.0000000000006,0.0013804265041888815]
[null,null,59,0.0006951273269811135,589410,410.0000000000004,409590.00000000006,590.0000000000006,0.0014383929006777524]
[null,null,60,0.0006668889629876632,599400,400.00000000000034,399600,600.0000000000006,0.0014992503748125952]
[null,null,61,0.000639574928662797,609390,390.00000000000034,389610,610.0000000000006,0.0015632207472707719]
[null,null,62,0.0006131405705434367,619380,380.00000000000034,379620,620.0000000000006,0.0016305491268672433]
[null,null,63,0.0005875440658049359,629370,370.00000000000034,369630,630.0000000000006,0.0017015070491006336]
[null,null,64,0.0005627462014631407,639360,360.00000000000034,359640,640.0000000000006,0.001776396136338405]
[null,null,65,0.000538710173926428,649350,350.0000000000003,349650,650.0000000000006,0.0018555523836711405]
[null,null,66,0.0005154014067426635,659340,340.0000000000002,339659.99999999994,660.0000000000006,0.0019393511988716522]
[null,null,67,0.0004927873846429535,669330,330.0000000000002,329669.99999999994,670.0000000000006,0.00202821335593631]
[null,null,68,0.0004708375022070511,679320,320.0000000000002,319679.99999999994,680.0000000000006,0.0021226120614308923]
[null,null,69,0.00044952292566920963,689310,310.00000000000034,309690.00000000006,690.0000000000006,0.002223081384109802]
[null,null,70,0.0004288164665523161,699300,300.00000000000034,299700.00000000006,700.0000000000006,0.0023302263648468722]
[null,null,71,0.00040869246596578304,709290,290.00000000000034,289710.00000000006,710.0000000000007,0.0024447352110736195]
[null,null,72,0.0003891266885318809,719280,280.0000000000002,279720,720.0000000000007,0.002567394094993584]
[null,null,73,0.0003700962250185051,729270,270.0000000000002,269730,730.0000000000007,0.0026991052281298555]
[null,null,74,0.00035157940285590687,739260,260.0000000000002,259740,740.0000000000007,0.0028409090909090936]
[null,null,75,0.0003335557038025353,749250,250.00000000000023,249750,750.0000000000007,0.002994011976047907]
[null,null,76,0.00031600568810238617,759240,240.00000000000023,239760,760.0000000000007,0.00315982038915683]
[null,null,77,0.00029891092454448594,769230,230.00000000000017,229769.99999999997,770.0000000000007,0.0033399843844885953]
[null,null,78,0.00028225392589551493,779220,220.00000000000017,219779.99999999997,780.0000000000007,0.0035364526659412442]
[null,null,79,0.00026601808923006786,789210,210.00000000000017,209789.99999999997,790.0000000000007,0.0037515433564441103]
[null,null,80,0.00025018764073054807,799200,200.0000000000001,199799.99999999994,800.0000000000007,0.003988035892323036]
[null,null,81,0.00023474758457090627,809190,190.0000000000001,189809.99999999994,810.0000000000007,0.004249291784702554]
[null,null,82,0.0002196836555360284,819180,180.00000000000023,179820.00000000006,820.0000000000007,0.004539415411868913]
[null,null,83,0.00020498227506209778,829170,170.00000000000017,169830.00000000003,830.0000000000007,0.004863471229344899]
[null,null,84,0.00019063051041319184,839160,160.00000000000017,159840.00000000003,840.0000000000008,0.005227781926811057]
[null,null,85,0.00017661603673613585,849150,150.00000000000017,149850.00000000003,850.0000000000008,0.0056403450564034546]
[null,null,86,0.00016292710175961283,859140,140.0000000000001,139860,860.0000000000008,0.006111426947129056]
[null,null,87,0.0001495524929250168,869130,130.0000000000001,129870,870.0000000000008,0.006654428636989451]
[null,null,88,0.0001364815067558347,879120,120.00000000000011,119880,880.0000000000008,0.007287181185823127]
[null,null,89,0.00012370392028969218,889110,110.00000000000009,109889.99999999999,890.0000000000008,0.00803394114461095]
[null,null,90,0.00011120996441281145,899100,100.00000000000006,99899.99999999997,900.0000000000008,0.008928571428571438]
[null,null,91,9.89902989507029e-05,909090,90.00000000000006,89909.99999999997,910.0000000000008,0.010019819423034586]
[null,null,92,8.703598938160932e-05,919080,80.00000000000003,79919.99999999996,920.0000000000008,0.011380504700643262]
[null,null,93,7.533848505069205e-05,929070,70.00000000000001,69929.99999999996,930.0000000000008,0.013124470787468267]
[null,null,94,6.388959877331981e-05,939060,60.00000000000011,59940.00000000005,940.0000000000008,0.015440210249671484]
[null,null,95,5.268148772521345e-05,949050,50.000000000000085,49950.000000000044,950.0000000000008,0.018664047151277015]
[null,null,96,4.170663552571221e-05,959040,40.00000000000007,39960.00000000004,960.0000000000009,0.02346041055718475]
[null,null,97,3.095783542814692e-05,969030,30.000000000000053,29970.000000000025,970.0000000000009,0.03135100193923724]
[null,null,98,2.0428174538323293e-05,979020,20.000000000000036,19980.00000000002,980.0000000000009,0.046755725190839696]
[null,null,99,1.0111018988493678e-05,989010,10.000000000000018,9990.00000000001,990.0000000000009,0.0901639344262295]
[null,null,100,0,999000,0,0,1000.0000000000009,1]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}