{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Welcome","Page2","Page3","Page4","Page5","Page6","Results","Page8","Advanced_options_menu","Advanced_options_1","Advanced_options_2","Advanced_options_3","schematic","lower_bound_results","upper_bound_results","ranges","bounds","calcs1","dropdown","text_inserts"],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Page2","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Size of population served by STD program (all ages)"]
[]
[null,"Reported number of chlamydia cases"]
[null,"Reported number of gonorrhea cases"]
[null,"Reported number of syphilis cases\n(Primary, secondary, and early latent)"]

{"sheet":"Page3","index":2,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Amount of budget decrease"]
[]
[]
[null,"Amount of budget increase"]
[]
[null,{"$f":"IF(OR(C10<0,C13<0),\"Note: Please do not enter negative values\",\"\")","v":""}]
[null,{"$f":"IF(C10*C13=0,\"\",\"Please do not enter values in both boxes above.  You can enter a budget decrease in the top box, OR a budget increase in the bottom box.\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IFERROR(IF(OR((C10/Page2!C13)>2,(C13/Page2!C13)>2),\"SPACE MONKEY cannot handle such a large change in funding.  The change will be capped at $2 per capita\",\"\"),\"\")","v":""}]

{"sheet":"Page4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Page5","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input","Default value","Your value \nLeave blank to use the default value"]
[null,"Number of Disease Intervention Specialists (DIS) employed ",{"$f":"calcs1!B63","v":0}]
[null,"Annual cost per DIS (salary plus fringe benefits)*",{"$f":"calcs1!B6","v":73600}]
[null,"Annual number of STD cases interviewed per DIS",{"$f":"calcs1!B7","v":400}]
[null,"Percentage of chlamydia cases interviewed",{"$f":"calcs1!B10","v":0.12}]
[null,"Percentage of gonorrhea cases interviewed",{"$f":"calcs1!B9","v":0.17}]
[null,"Percentage of syphilis cases interviewed\n(Primary, secondary, and early latent)",{"$f":"calcs1!B8","v":0.89}]

{"sheet":"Page6","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Results","index":6,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Year",{"$f":"IF(calcs1!C41<0,\"Percentage increase in STDs due to budget cut\",\"Percentage decrease in STDs due to budget increase\")","v":"Percentage decrease in STDs due to budget increase"},{"$f":"IF(calcs1!C41<0,\"Additonal number of syphilis infections\",\"Reduction in number of syphilis infections\")","v":"Reduction in number of syphilis infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of gonorrhea infections\",\"Reduction in number of gonorrhea infections\")","v":"Reduction in number of gonorrhea infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of chlamydia infections\",\"Reduction in number of chlamydia infections\")","v":"Reduction in number of chlamydia infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of STD-attributable HIV infections\",\"Reduction in number of STD-attributable HIV infections\")","v":"Reduction in number of STD-attributable HIV infections"},{"$f":"IF(calcs1!C41<0,\"Additonal STD costs\",\"Reduction in STD costs\")","v":"Reduction in STD costs"},{"$f":"IF(calcs1!C41<0,\"Additonal HIV costs\",\"Reduction in HIV costs\")","v":"Reduction in HIV costs"},{"$f":"IF(calcs1!C41<0,\"Total additonal costs (STD and HIV)\",\"Reduction in total costs (STD + HIV)\")","v":"Reduction in total costs (STD + HIV)"}]
[null,"Year 1",{"$f":"calcs1!S71","v":0},{"$f":"calcs1!U71","v":0},{"$f":"calcs1!V71","v":0},{"$f":"calcs1!W71","v":0},{"$f":"calcs1!X71","v":0},{"$f":"calcs1!Y71","v":0},{"$f":"calcs1!Z71","v":0},{"$f":"calcs1!AA71","v":0}]
[null,"Year 2",{"$f":"calcs1!S72","v":0},{"$f":"calcs1!U72","v":0},{"$f":"calcs1!V72","v":0},{"$f":"calcs1!W72","v":0},{"$f":"calcs1!X72","v":0},{"$f":"calcs1!Y72","v":0},{"$f":"calcs1!Z72","v":0},{"$f":"calcs1!AA72","v":0}]
[null,"Year 3",{"$f":"calcs1!S73","v":0},{"$f":"calcs1!U73","v":0},{"$f":"calcs1!V73","v":0},{"$f":"calcs1!W73","v":0},{"$f":"calcs1!X73","v":0},{"$f":"calcs1!Y73","v":0},{"$f":"calcs1!Z73","v":0},{"$f":"calcs1!AA73","v":0}]
[null,"Year 4",{"$f":"calcs1!S74","v":0},{"$f":"calcs1!U74","v":0},{"$f":"calcs1!V74","v":0},{"$f":"calcs1!W74","v":0},{"$f":"calcs1!X74","v":0},{"$f":"calcs1!Y74","v":0},{"$f":"calcs1!Z74","v":0},{"$f":"calcs1!AA74","v":0}]
[null,"Year 5",{"$f":"calcs1!S75","v":0},{"$f":"calcs1!U75","v":0},{"$f":"calcs1!V75","v":0},{"$f":"calcs1!W75","v":0},{"$f":"calcs1!X75","v":0},{"$f":"calcs1!Y75","v":0},{"$f":"calcs1!Z75","v":0},{"$f":"calcs1!AA75","v":0}]
[null,"Year 6",{"$f":"calcs1!S76","v":0},{"$f":"calcs1!U76","v":0},{"$f":"calcs1!V76","v":0},{"$f":"calcs1!W76","v":0},{"$f":"calcs1!X76","v":0},{"$f":"calcs1!Y76","v":0},{"$f":"calcs1!Z76","v":0},{"$f":"calcs1!AA76","v":0}]
[null,"Year 7",{"$f":"calcs1!S77","v":0},{"$f":"calcs1!U77","v":0},{"$f":"calcs1!V77","v":0},{"$f":"calcs1!W77","v":0},{"$f":"calcs1!X77","v":0},{"$f":"calcs1!Y77","v":0},{"$f":"calcs1!Z77","v":0},{"$f":"calcs1!AA77","v":0}]
[null,"Year 8",{"$f":"calcs1!S78","v":0},{"$f":"calcs1!U78","v":0},{"$f":"calcs1!V78","v":0},{"$f":"calcs1!W78","v":0},{"$f":"calcs1!X78","v":0},{"$f":"calcs1!Y78","v":0},{"$f":"calcs1!Z78","v":0},{"$f":"calcs1!AA78","v":0}]
[null,"Year 9",{"$f":"calcs1!S79","v":0},{"$f":"calcs1!U79","v":0},{"$f":"calcs1!V79","v":0},{"$f":"calcs1!W79","v":0},{"$f":"calcs1!X79","v":0},{"$f":"calcs1!Y79","v":0},{"$f":"calcs1!Z79","v":0},{"$f":"calcs1!AA79","v":0}]
[null,"Year 10",{"$f":"calcs1!S80","v":0},{"$f":"calcs1!U80","v":0},{"$f":"calcs1!V80","v":0},{"$f":"calcs1!W80","v":0},{"$f":"calcs1!X80","v":0},{"$f":"calcs1!Y80","v":0},{"$f":"calcs1!Z80","v":0},{"$f":"calcs1!AA80","v":0}]
[null,"10-year total",null,{"$f":"calcs1!U81","v":0},{"$f":"calcs1!V81","v":0},{"$f":"calcs1!W81","v":0},{"$f":"calcs1!X81","v":0},{"$f":"calcs1!Y81","v":0},{"$f":"calcs1!Z81","v":0},{"$f":"calcs1!AA81","v":0}]

{"sheet":"Page8","index":7,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F7,text_inserts!G7)","v":"Based on published evidence of the impact of STD prevention programs and the cost of STDs, a budget increase of $0 will result in:"}]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F8,text_inserts!G8)","v":"• In the first year alone, there will be an estimated decrease of 0 cases of syphilis (range: 0 to 0), 0 cases of gonorrhea (range: 0 to 0), 0 cases of chlamydia (range: 0 to 0), and 0.0 cases of STD-attributable HIV (range: 0.0 to 0.0)."}]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F9,text_inserts!G9)","v":"• Over 10 years, there will be an estimated cumulative decrease of 0 cases of syphilis (range: 0 to 0), 0 cases of gonorrhea (range: 0 to 0), 0 cases of chlamydia (range: 0 to 0), and 0.0 cases of STD-attributable HIV (range: 0 to 0)."}]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F10,text_inserts!G10)","v":"• Over 10 years, there will be an estimated cumulative decrease in direct medical costs of $0 (range: 0 to 0) due to decreases in STIs and STI-attributable HIV infections."}]
[]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F1,text_inserts!G1)","v":"With a budget increase of $0, positions for disease intervention specialists will be increased, resulting in:"}]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F2,text_inserts!G2)","v":"• Additional DIS interviews or effective behavioral counseling for an estimated 0 patients with STDs."}]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F3,text_inserts!G3)","v":"• DIS are public health professionals who work to find people diagnosed with syphilis and other STDs. DIS work to find new cases of the disease — and to prevent new ones from happening."}]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F4,text_inserts!G4)","v":"• In addition to STDs, DIS fight other disease outbreaks and epidemics, including Ebola, flu, anthrax, and SARS—with additional DIS, we will be better prepared for emergencies."}]
[null,{"$f":"IF(calcs1!$B$31<0,text_inserts!F5,text_inserts!G5)","v":"• Since an estimated 1 in 4 DIS interviews identifies a new STD case, an estimated 0 people with syphilis, gonorrhea, or chlamydia will become aware that they are infected, will be more likely to be treated, and will be less likely to spread STDs in their communities."}]

{"sheet":"Advanced_options_menu","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Advanced_options_1","index":9,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Which calculation approach do you want to use?","Use the average of the two approaches (default)"]

{"sheet":"Advanced_options_2","index":10,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Input","Default value","Your value (Leave blank to use the default value)"]
[null,"Percent change in  STDs relative to % change in number of STD cases interviewed",0.2]
[null,"Percent increase in STDs per $1 per capita decrease in STD prevention funding",0.16]
[null,"β parameter of residual impact, used to estimate new equilibrium STD incidence",0.7]
[null,"Annual number of syphilis infections, nationally ",55400]
[null,"Annual number of gonorrhea infections, nationally ",820000]
[null,"Annual number of chlamydia infections, nationally ",2860000]
[null,"Average lifetime cost per syphilis infection ",770]
[null,"Average lifetime cost per gonorrhea infection ",230]
[null,"Average lifetime cost per chlamydia infection ",210]
[null,"Average lifetime cost per HIV infection (both sexes)",351000]
[null,"Probability of STD-attributable HIV infection, per syphilis infection",1.0500000000000001E-2]
[null,"Probability of STD-attributable HIV infection, per gonorrhea infection",5.0000000000000001E-4]
[null,"Probability of STD-attributable HIV infection, per chlamydia infection",5.0000000000000001E-4]
[null,"Reported number of syphilis cases, nationally",{"$f":"23872+24173","v":48045}]
[null,"Reported number of gonorrhea cases, nationally",395216]
[null,"Reported number of chlamydia cases, nationally",1526658]
[null,"Discount rate",0.03]
[null,"Number of STD interviews required to yield 1 new case",4]

{"sheet":"Advanced_options_3","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"schematic","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"lower_bound_results","index":13,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Year",{"$f":"IF(calcs1!C41<0,\"Percentage increase in STDs due to budget cut\",\"Percentage decrease in STDs due to budget increase\")","v":"Percentage decrease in STDs due to budget increase"},{"$f":"IF(calcs1!C41<0,\"Additonal number of syphilis infections\",\"Reduction in number of syphilis infections\")","v":"Reduction in number of syphilis infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of gonorrhea infections\",\"Reduction in number of gonorrhea infections\")","v":"Reduction in number of gonorrhea infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of chlamydia infections\",\"Reduction in number of chlamydia infections\")","v":"Reduction in number of chlamydia infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of STD-attributable HIV infections\",\"Reduction in number of STD-attributable HIV infections\")","v":"Reduction in number of STD-attributable HIV infections"},{"$f":"IF(calcs1!C41<0,\"Additonal STD costs\",\"Reduction in STD costs\")","v":"Reduction in STD costs"},{"$f":"IF(calcs1!C41<0,\"Additonal HIV costs\",\"Reduction in HIV costs\")","v":"Reduction in HIV costs"},{"$f":"IF(calcs1!C41<0,\"Total additonal costs (STD and HIV)\",\"Reduction in total costs (STD + HIV)\")","v":"Reduction in total costs (STD + HIV)"}]
[null,"Year 1",{"$f":"bounds!B224","v":0},{"$f":"bounds!D224","v":0},{"$f":"bounds!E224","v":0},{"$f":"bounds!F224","v":0},{"$f":"bounds!G224","v":0},{"$f":"bounds!K224","v":0},{"$f":"bounds!L224","v":0},{"$f":"bounds!M224","v":0}]
[null,"Year 2",{"$f":"bounds!B225","v":0},{"$f":"bounds!D225","v":0},{"$f":"bounds!E225","v":0},{"$f":"bounds!F225","v":0},{"$f":"bounds!G225","v":0},{"$f":"bounds!K225","v":0},{"$f":"bounds!L225","v":0},{"$f":"bounds!M225","v":0}]
[null,"Year 3",{"$f":"bounds!B226","v":0},{"$f":"bounds!D226","v":0},{"$f":"bounds!E226","v":0},{"$f":"bounds!F226","v":0},{"$f":"bounds!G226","v":0},{"$f":"bounds!K226","v":0},{"$f":"bounds!L226","v":0},{"$f":"bounds!M226","v":0}]
[null,"Year 4",{"$f":"bounds!B227","v":0},{"$f":"bounds!D227","v":0},{"$f":"bounds!E227","v":0},{"$f":"bounds!F227","v":0},{"$f":"bounds!G227","v":0},{"$f":"bounds!K227","v":0},{"$f":"bounds!L227","v":0},{"$f":"bounds!M227","v":0}]
[null,"Year 5",{"$f":"bounds!B228","v":0},{"$f":"bounds!D228","v":0},{"$f":"bounds!E228","v":0},{"$f":"bounds!F228","v":0},{"$f":"bounds!G228","v":0},{"$f":"bounds!K228","v":0},{"$f":"bounds!L228","v":0},{"$f":"bounds!M228","v":0}]
[null,"Year 6",{"$f":"bounds!B229","v":0},{"$f":"bounds!D229","v":0},{"$f":"bounds!E229","v":0},{"$f":"bounds!F229","v":0},{"$f":"bounds!G229","v":0},{"$f":"bounds!K229","v":0},{"$f":"bounds!L229","v":0},{"$f":"bounds!M229","v":0}]
[null,"Year 7",{"$f":"bounds!B230","v":0},{"$f":"bounds!D230","v":0},{"$f":"bounds!E230","v":0},{"$f":"bounds!F230","v":0},{"$f":"bounds!G230","v":0},{"$f":"bounds!K230","v":0},{"$f":"bounds!L230","v":0},{"$f":"bounds!M230","v":0}]
[null,"Year 8",{"$f":"bounds!B231","v":0},{"$f":"bounds!D231","v":0},{"$f":"bounds!E231","v":0},{"$f":"bounds!F231","v":0},{"$f":"bounds!G231","v":0},{"$f":"bounds!K231","v":0},{"$f":"bounds!L231","v":0},{"$f":"bounds!M231","v":0}]
[null,"Year 9",{"$f":"bounds!B232","v":0},{"$f":"bounds!D232","v":0},{"$f":"bounds!E232","v":0},{"$f":"bounds!F232","v":0},{"$f":"bounds!G232","v":0},{"$f":"bounds!K232","v":0},{"$f":"bounds!L232","v":0},{"$f":"bounds!M232","v":0}]
[null,"Year 10",{"$f":"bounds!B233","v":0},{"$f":"bounds!D233","v":0},{"$f":"bounds!E233","v":0},{"$f":"bounds!F233","v":0},{"$f":"bounds!G233","v":0},{"$f":"bounds!K233","v":0},{"$f":"bounds!L233","v":0},{"$f":"bounds!M233","v":0}]
[null,"10-year total",null,{"$f":"bounds!D234","v":0},{"$f":"bounds!E234","v":0},{"$f":"bounds!F234","v":0},{"$f":"bounds!G234","v":0},{"$f":"bounds!K234","v":0},{"$f":"bounds!L234","v":0},{"$f":"bounds!M234","v":0}]

{"sheet":"upper_bound_results","index":14,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Year",{"$f":"IF(calcs1!C41<0,\"Percentage increase in STDs due to budget cut\",\"Percentage decrease in STDs due to budget increase\")","v":"Percentage decrease in STDs due to budget increase"},{"$f":"IF(calcs1!C41<0,\"Additonal number of syphilis infections\",\"Reduction in number of syphilis infections\")","v":"Reduction in number of syphilis infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of gonorrhea infections\",\"Reduction in number of gonorrhea infections\")","v":"Reduction in number of gonorrhea infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of chlamydia infections\",\"Reduction in number of chlamydia infections\")","v":"Reduction in number of chlamydia infections"},{"$f":"IF(calcs1!C41<0,\"Additonal number of STD-attributable HIV infections\",\"Reduction in number of STD-attributable HIV infections\")","v":"Reduction in number of STD-attributable HIV infections"},{"$f":"IF(calcs1!C41<0,\"Additonal STD costs\",\"Reduction in STD costs\")","v":"Reduction in STD costs"},{"$f":"IF(calcs1!C41<0,\"Additonal HIV costs\",\"Reduction in HIV costs\")","v":"Reduction in HIV costs"},{"$f":"IF(calcs1!C41<0,\"Total additonal costs (STD and HIV)\",\"Reduction in total costs (STD + HIV)\")","v":"Reduction in total costs (STD + HIV)"}]
[null,"Year 1",{"$f":"bounds!B241","v":0},{"$f":"bounds!D241","v":0},{"$f":"bounds!E241","v":0},{"$f":"bounds!F241","v":0},{"$f":"bounds!G241","v":0},{"$f":"bounds!K241","v":0},{"$f":"bounds!L241","v":0},{"$f":"bounds!M241","v":0}]
[null,"Year 2",{"$f":"bounds!B242","v":0},{"$f":"bounds!D242","v":0},{"$f":"bounds!E242","v":0},{"$f":"bounds!F242","v":0},{"$f":"bounds!G242","v":0},{"$f":"bounds!K242","v":0},{"$f":"bounds!L242","v":0},{"$f":"bounds!M242","v":0}]
[null,"Year 3",{"$f":"bounds!B243","v":0},{"$f":"bounds!D243","v":0},{"$f":"bounds!E243","v":0},{"$f":"bounds!F243","v":0},{"$f":"bounds!G243","v":0},{"$f":"bounds!K243","v":0},{"$f":"bounds!L243","v":0},{"$f":"bounds!M243","v":0}]
[null,"Year 4",{"$f":"bounds!B244","v":0},{"$f":"bounds!D244","v":0},{"$f":"bounds!E244","v":0},{"$f":"bounds!F244","v":0},{"$f":"bounds!G244","v":0},{"$f":"bounds!K244","v":0},{"$f":"bounds!L244","v":0},{"$f":"bounds!M244","v":0}]
[null,"Year 5",{"$f":"bounds!B245","v":0},{"$f":"bounds!D245","v":0},{"$f":"bounds!E245","v":0},{"$f":"bounds!F245","v":0},{"$f":"bounds!G245","v":0},{"$f":"bounds!K245","v":0},{"$f":"bounds!L245","v":0},{"$f":"bounds!M245","v":0}]
[null,"Year 6",{"$f":"bounds!B246","v":0},{"$f":"bounds!D246","v":0},{"$f":"bounds!E246","v":0},{"$f":"bounds!F246","v":0},{"$f":"bounds!G246","v":0},{"$f":"bounds!K246","v":0},{"$f":"bounds!L246","v":0},{"$f":"bounds!M246","v":0}]
[null,"Year 7",{"$f":"bounds!B247","v":0},{"$f":"bounds!D247","v":0},{"$f":"bounds!E247","v":0},{"$f":"bounds!F247","v":0},{"$f":"bounds!G247","v":0},{"$f":"bounds!K247","v":0},{"$f":"bounds!L247","v":0},{"$f":"bounds!M247","v":0}]
[null,"Year 8",{"$f":"bounds!B248","v":0},{"$f":"bounds!D248","v":0},{"$f":"bounds!E248","v":0},{"$f":"bounds!F248","v":0},{"$f":"bounds!G248","v":0},{"$f":"bounds!K248","v":0},{"$f":"bounds!L248","v":0},{"$f":"bounds!M248","v":0}]
[null,"Year 9",{"$f":"bounds!B249","v":0},{"$f":"bounds!D249","v":0},{"$f":"bounds!E249","v":0},{"$f":"bounds!F249","v":0},{"$f":"bounds!G249","v":0},{"$f":"bounds!K249","v":0},{"$f":"bounds!L249","v":0},{"$f":"bounds!M249","v":0}]
[null,"Year 10",{"$f":"bounds!B250","v":0},{"$f":"bounds!D250","v":0},{"$f":"bounds!E250","v":0},{"$f":"bounds!F250","v":0},{"$f":"bounds!G250","v":0},{"$f":"bounds!K250","v":0},{"$f":"bounds!L250","v":0},{"$f":"bounds!M250","v":0}]
[null,"10-year total",null,{"$f":"bounds!D251","v":0},{"$f":"bounds!E251","v":0},{"$f":"bounds!F251","v":0},{"$f":"bounds!G251","v":0},{"$f":"bounds!K251","v":0},{"$f":"bounds!L251","v":0},{"$f":"bounds!M251","v":0}]

{"sheet":"ranges","index":15,"n_rows":78,"n_cols":7,"rows_kept":78,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Percent change in STDs per $1 change in funding per capita (Β1 parameter)",0.16,0.09,0.23,{"$f":"C4*(D4/C4)","v":0.09},{"$f":"C4*(E4/C4)","v":0.23}]
[null,"Percent change in STDs per 10 percent change in Disease Intervention Specialist (DIS) activities ",0.02,5.0000000000000001E-3,0.05,{"$f":"C5*(D5/C5)","v":5.0000000000000001E-3},{"$f":"C5*(E5/C5)","v":0.05}]
[null,"Β0 parameter used to phase in the estimated changes in STD incidence (see text)",0.7,0.46,0.86,{"$f":"MIN(C6,D6)","v":0.46},{"$f":"MAX(C6,E6)","v":0.86}]
[null,"Average lifetime cost per syphilis infection ",770,385,1155,{"$f":"MIN(C7,D7)","v":385},{"$f":"MAX(C7,E7)","v":1155}]
[null,"Average lifetime cost per gonorrhea infection ",230,115,345,115,345]
[null,"Average lifetime cost per chlamydia infection ",210,105,315,105,315]
[null,"Average lifetime cost per HIV infection (both sexes)",351000,269000,427000,269000,427000]
[null,"Probability of STD-attributable HIV infection, per syphilis infection",1.0500000000000001E-2,1E-3,0.02,1E-3,0.02]
[null,"Probability of STD-attributable HIV infection, per gonorrhea infection",5.0000000000000001E-4,5.0000000000000002E-5,1E-3,5.0000000000000002E-5,1E-3]
[null,"Probability of STD-attributable HIV infection, per chlamydia infection",5.0000000000000001E-4,5.0000000000000002E-5,1E-3,5.0000000000000002E-5,1E-3]
[]
[]
[null,null,"base case","lower value","upper value"]
[null,"Size of population served by STD program (all ages)",{"$f":"calcs1!B2","v":0},{"$f":"$C17","v":0},{"$f":"$C17","v":0}]
[null,"Reported number of syphilis cases",{"$f":"calcs1!B3","v":0},{"$f":"$C18","v":0},0]
[null,"Reported number of gonorrhea cases",{"$f":"calcs1!B4","v":0},0,0]
[null,"Reported number of chlamydia cases",{"$f":"calcs1!B5","v":0},0,0]
[null,"Annual cost of Disease Intervention Specialist (DIS)",{"$f":"calcs1!B6","v":73600},73600,73600]
[null,"Annual number of STD cases interviewed per DIS",{"$f":"calcs1!B7","v":400},400,400]
[null,"Percentage of syphilis cases interviewed",{"$f":"calcs1!B8","v":0.89},0.89,0.89]
[null,"Percentage of gonorrhea cases interviewed",{"$f":"calcs1!B9","v":0.17},0.17,0.17]
[null,"Percentage of chlamydia cases interviewed",{"$f":"calcs1!B10","v":0.12},0.12,0.12]
[null,"number needed to interview to detect new case",{"$f":"calcs1!B11","v":4},4,4]
[null,"Percent change in  STDs relative to % change in number of STD cases interviewed",{"$f":"calcs1!B12","v":0.2},{"$f":"10*F5","v":0.05},{"$f":"10*G5","v":0.5}]
[null,"Percent increase in STDs per $1 per capita decrease in STD prevention funding",{"$f":"calcs1!B13","v":0.16},{"$f":"F4","v":0.09},{"$f":"G4","v":0.23}]
[null,"β parameter of residual impact, used to estimate new equilibrium STD incidence*",{"$f":"calcs1!B14","v":0.7},{"$f":"F6","v":0.46},{"$f":"G6","v":0.86}]
[null,"Annual number of syphilis infections, nationally ",{"$f":"calcs1!B15","v":55400},{"$f":"$C30","v":55400},{"$f":"$C30","v":55400}]
[null,"Annual number of gonorrhea infections, nationally ",{"$f":"calcs1!B16","v":820000},{"$f":"$C31","v":820000},820000]
[null,"Annual number of chlamydia infections, nationally ",{"$f":"calcs1!B17","v":2860000},2860000,2860000]
[null,"Average lifetime cost per syphilis infection ",{"$f":"calcs1!B18","v":770},{"$f":"F7","v":385},{"$f":"G7","v":1155}]
[null,"Average lifetime cost per gonorrhea infection ",{"$f":"calcs1!B19","v":230},{"$f":"F8","v":115},345]
[null,"Average lifetime cost per chlamydia infection ",{"$f":"calcs1!B20","v":210},105,315]
[null,"Average lifetime cost per HIV infection (both sexes)",{"$f":"calcs1!B21","v":351000},269000,427000]
[null,"Probability of STD-attributable HIV infection, per syphilis infection",{"$f":"calcs1!B22","v":1.0500000000000001E-2},{"$f":"F11","v":1E-3},{"$f":"G11","v":0.02}]
[null,"Probability of STD-attributable HIV infection, per gonorrhea infection",{"$f":"calcs1!B23","v":5.0000000000000001E-4},{"$f":"F12","v":5.0000000000000002E-5},1E-3]
[null,"Probability of STD-attributable HIV infection, per chlamydia infection",{"$f":"calcs1!B24","v":5.0000000000000001E-4},5.0000000000000002E-5,1E-3]
[null,"Reported number of syphilis cases, nationally",{"$f":"calcs1!B25","v":48045},{"$f":"$C40","v":48045},{"$f":"$C40","v":48045}]
[null,"Reported number of gonorrhea cases, nationally",{"$f":"calcs1!B26","v":395216},{"$f":"$C41","v":395216},395216]
[null,"Reported number of chlamydia cases, nationally",{"$f":"calcs1!B27","v":1526658},1526658,1526658]
[null,"Discount rate",{"$f":"calcs1!B28","v":0.03},0.03,0.03]
[null,"per cap change",{"$f":"calcs1!B29","v":0},{"$f":"IF(D46=0,0,D46/D17)","v":0},{"$f":"IF(E46=0,0,E46/E17)","v":0}]
[null,"per cap change, limited to $2 per capita",{"$f":"calcs1!B30","v":0},{"$f":"IF(D44<-2,-2,IF(D44>2,2,D44))","v":0},{"$f":"IF(E44<-2,-2,IF(E44>2,2,E44))","v":0}]
[null,"change in funding",{"$f":"calcs1!B31","v":0},{"$f":"$C46","v":0},{"$f":"$C46","v":0}]
[]
[null,"per capita funding change x coefficient",{"$f":"calcs1!B33","v":0},{"$f":"-D4*D45","v":0},{"$f":"-E4*E45","v":0}]
[null,"Annual number of syphilis infections, program",{"$f":"calcs1!B34","v":0},{"$f":"$C49","v":0},{"$f":"$C49","v":0}]
[null,"Annual number of gonorrhea infections, program",{"$f":"calcs1!B35","v":0},{"$f":"$C50","v":0},0]
[null,"Annual number of chlamydia infections, program",{"$f":"calcs1!B36","v":0},0,0]
[]
[]
[null,"Amount of budget decrease",{"$f":"calcs1!B39","v":0},{"$f":"$C54","v":0},{"$f":"$C54","v":0}]
[null,"Amount of budget increase",{"$f":"calcs1!B40","v":0},{"$f":"$C55","v":0},{"$f":"$C55","v":0}]
[]
[]
[]
[null,"Number of Disease Intervention Specialists (DIS) employed ",{"$f":"calcs1!D44","v":0}]
[null,"Annual cost per DIS (salary plus fringe benefits)*",{"$f":"calcs1!D45","v":73600}]
[null,"Annual number of STD cases interviewed per DIS",{"$f":"calcs1!D46","v":400}]
[null,"Percentage of chlamydia cases interviewed",{"$f":"calcs1!D47","v":0.12}]
[null,"Percentage of gonorrhea cases interviewed",{"$f":"calcs1!D48","v":0.17}]
[null,"Percentage of syphilis cases interviewed\n(Primary, secondary, and early latent)",{"$f":"calcs1!D49","v":0.89}]
[]
[]
[null,"Reported number of chlamydia cases",{"$f":"calcs1!B52","v":0}]
[null,"Reported number of gonorrhea cases",{"$f":"calcs1!B53","v":0}]
[null,"Reported number of syphilis cases\n(Primary, secondary, and early latent)",{"$f":"calcs1!B54","v":0}]
[]
[null,"interviewed CT cases",{"$f":"calcs1!B56","v":0}]
[null,"interviewed GC cases",{"$f":"calcs1!B57","v":0}]
[null,"interviewed PS/EL cases",{"$f":"calcs1!B58","v":0}]
[]
[null,"interviewed cases",{"$f":"calcs1!B60","v":0}]
[null,"interviews per DIS",{"$f":"calcs1!B61","v":400}]
[]
[null,"number of DIS (calculated)",{"$f":"calcs1!B63","v":0}]

{"sheet":"bounds","index":16,"n_rows":251,"n_cols":27,"rows_kept":251,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Percent change in STDs per $1 change in funding per capita (Β1 parameter)",0.16,0.09,0.23,{"$f":"C4*(D4/C4)","v":0.09},{"$f":"C4*(E4/C4)","v":0.23}]
[null,"Percent change in STDs per 10 percent change in Disease Intervention Specialist (DIS) activities ",0.02,5.0000000000000001E-3,0.05,{"$f":"C5*(D5/C5)","v":5.0000000000000001E-3},{"$f":"C5*(E5/C5)","v":0.05}]
[null,"Β0 parameter used to phase in the estimated changes in STD incidence (see text)",0.7,0.46,0.86,{"$f":"MIN(C6,D6)","v":0.46},{"$f":"MAX(C6,E6)","v":0.86}]
[null,"Average lifetime cost per syphilis infection ",770,385,1155,{"$f":"MIN(C7,D7)","v":385},{"$f":"MAX(C7,E7)","v":1155}]
[null,"Average lifetime cost per gonorrhea infection ",230,115,345,115,345,null,null,null,null,"DIS salary",{"$f":"calcs1!D45","v":73600}]
[null,"Average lifetime cost per chlamydia infection ",210,105,315,105,315,null,null,null,null,"Interviews per DIS",{"$f":"calcs1!D46","v":400},null,"reported cases",{"$f":"C47+C48+C49","v":0}]
[null,"Average lifetime cost per HIV infection (both sexes)",351000,269000,427000,269000,427000,null,null,null,null,"pct of Syphilis cases interviewed",{"$f":"calcs1!B49","v":0.89},null,"interviewed cases",{"$f":"M17","v":0}]
[null,"Probability of STD-attributable HIV infection, per syphilis infection",1.0500000000000001E-2,1E-3,0.02,1E-3,0.02,null,null,null,null,"pct of GC cases interviewed",{"$f":"calcs1!B48","v":0.17},null,"non-interviewed",{"$f":"P9-P10","v":0}]
[null,"Probability of STD-attributable HIV infection, per gonorrhea infection",5.0000000000000001E-4,5.0000000000000002E-5,1E-3,5.0000000000000002E-5,1E-3,null,null,null,null,"pct of CT cases interviewed",{"$f":"calcs1!B47","v":0.12},null,"max increase DIS",{"$f":"P11/M9","v":0}]
[null,"Probability of STD-attributable HIV infection, per chlamydia infection",5.0000000000000001E-4,5.0000000000000002E-5,1E-3,5.0000000000000002E-5,1E-3,null,null,null,null,null,null,null,"max pct increase in DIS",{"$f":"P12/M19","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Syphilis cases interviewed",{"$f":"C47*M10","v":0},null,"max pct increase interviews",{"$f":"P11/P10","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"GC cases interviewed",{"$f":"C48*M11","v":0}]
[null,"change in funding ",{"$f":"Page3!C13-Page3!C10","v":0},null,null,null,null,null,null,null,null,"CT cases interviewed",0]
[null,"population",{"$f":"Page2!C13","v":0},null,null,null,null,null,null,null,null,"total interviewed",{"$f":"M14+M15+M16","v":0},{"$f":"M17/400","v":0}]
[null,"change in funding per capita",{"$f":"IF(C16=0,0,C16/C17)","v":0}]
[null,"change in funding per capita, capped at -$2 or $2",{"$f":"IF(C18>2,2,IF(C18<-2,-2,C18))","v":0},null,null,null,null,null,null,null,null,"Number of DIS",{"$f":"calcs1!D44","v":0},null,"change in interviews",{"$f":"M20*M9","v":0}]
[null,"funding impact coefficient",{"$f":"C4","v":0.16},{"$f":"F4","v":0.09},{"$f":"G4","v":0.23},null,null,null,null,null,null,"change in DIS",{"$f":"C16/M8","v":0},null,"pct change in interviews",{"$f":"P19/M17","v":{"$error":"#DIV/0!"}}]
[null,"percent change in STIs",{"$f":"-C20*$C19","v":0},{"$f":"-D20*$C19","v":0},{"$f":"-E20*$C19","v":0},null,null,null,null,null,null,"pct change in DIS",{"$f":"IFERROR(MIN((M20/M19),P14),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"applied pct change in DIS",{"$f":"IF(M21<-1,-1,IF(M21>1,1,M21))","v":0},null,"Percent change in STDs per 10 percent change in Disease Intervention Specialist (DIS) activities "]
[null,1,{"$f":"POWER($C$6,$B23-1)","v":1},{"$f":"POWER($F$6,$B23-1)","v":1},{"$f":"POWER($G$6,$B23-1)","v":1},null,{"$f":"C23","v":1},{"$f":"D23","v":1},1,null,null,null,null,null,"base","low","high"]
[null,2,{"$f":"POWER($C$6,$B24-1)","v":0.7},{"$f":"POWER($F$6,$B24-1)","v":0.46},{"$f":"POWER($G$6,$B24-1)","v":0.86},null,{"$f":"G23+C24","v":1.7},{"$f":"H23+D24","v":1.46},1.8599999999999999,null,null,null,null,null,{"$f":"-C5","v":-0.02},{"$f":"-F5","v":-5.0000000000000001E-3},{"$f":"-G5","v":-0.05}]
[null,3,0.48999999999999994,0.21160000000000001,0.73959999999999992,null,{"$f":"G24+C25","v":2.19},{"$f":"H24+D25","v":1.6716},{"$f":"I24+E25","v":2.5995999999999997},null,null,null,null,null,{"$f":"O24*($M$22/0.1)","v":0},{"$f":"P24*($M$22/0.1)","v":0},0]
[null,4,0.34299999999999992,9.7336000000000006E-2,0.63605599999999995,null,2.5329999999999999,1.7689360000000001,3.2356559999999996]
[null,5,0.24009999999999992,4.4774560000000005E-2,0.54700815999999985,null,2.7730999999999999,1.8137105600000001,3.7826641599999995]
[null,6,0.16806999999999994,2.0596297600000004E-2,0.47042701759999989,null,2.9411699999999996,1.8343068576000001,4.2530911775999991]
[null,7,0.11764899999999995,9.4742968960000017E-3,0.40456723513599985,null,3.0588189999999997,1.8437811544960001,4.6576584127359988]
[null,8,8.235429999999995E-2,4.3581765721600009E-3,0.34792782221695989,null,3.1411732999999997,1.8481393310681602,5.0055862349529585]
[null,9,5.7648009999999965E-2,2.0047612231936006E-3,0.29921792710658546,null,3.1988213099999996,1.8501440922913539,5.3048041620595443]
[null,10,4.0353606999999972E-2,9.2219016266905632E-4,0.25732741731166348,null,3.2391749169999997,1.8510662824540229,5.5621315793712078]
[]
[null,"Discount rate",{"$f":"calcs1!B28","v":0.03},{"$f":"1/(1+C34)","v":0.970873786407767},null,null,null,null,null,null,null,null,null,"base","low","high","disc"]
[null,"Phased in impact","base","low","high","disc",null,null,null,null,null,null,1,{"$f":"(N$44*(G23/G$32))","v":0},{"$f":"(O$44*(H23/H$32))","v":0},{"$f":"(P$44*(I23/I$32))","v":0},{"$f":"F36","v":1}]
[null,1,{"$f":"MAX(C$21*G23,-1)","v":0},{"$f":"MAX(D$21*H23,-1)","v":0},{"$f":"MAX(E$21*I23,-1)","v":0},{"$f":"POWER($D$34,B36-1)","v":1},null,null,null,null,null,null,2,0,0,0,{"$f":"F37","v":0.970873786407767}]
[null,2,{"$f":"MAX(C$21*G24,-1)","v":0},{"$f":"MAX(D$21*H24,-1)","v":0},{"$f":"MAX(E$21*I24,-1)","v":0},{"$f":"POWER($D$34,B37-1)","v":0.970873786407767},null,null,null,null,null,null,3,0,0,0,0.94259590913375435]
[null,3,0,0,0,0.94259590913375435,null,null,null,null,null,null,4,0,0,0,0.91514165935315961]
[null,4,0,0,0,0.91514165935315961,null,null,null,null,null,null,5,0,0,0,0.88848704791568889]
[null,5,0,0,0,0.88848704791568889,null,null,null,null,null,null,6,0,0,0,0.862608784384164]
[null,6,0,0,0,0.862608784384164,null,null,null,null,null,null,7,0,0,0,0.83748425668365434]
[null,7,0,0,0,0.83748425668365434,null,null,null,null,null,null,8,0,0,0,0.81309151134335378]
[null,8,0,0,0,0.81309151134335378,null,null,null,null,null,null,9,{"$f":"(N$44*(G31/G$32))","v":0},{"$f":"(O$44*(H31/H$32))","v":0},0,0.78940923431393561]
[null,9,0,0,0,0.78940923431393561,"Cost","base","low","high",null,null,10,{"$f":"O25","v":0},{"$f":"P25","v":0},0,0.76641673234362684]
[null,10,0,0,0,0.76641673234362684,"PS",{"$f":"C7","v":770},{"$f":"F7","v":385},{"$f":"G7","v":1155}]
[null,null,"program","national",null,null,"GC",{"$f":"C8","v":230},{"$f":"F8","v":115},345]
[null,"reported syphilis cases",{"$f":"Page2!C17","v":0},{"$f":"calcs1!B25","v":48045},null,null,"CT",210,{"$f":"F9","v":105},315]
[null,"reported gc cases",{"$f":"Page2!C16","v":0},{"$f":"calcs1!B26","v":395216},null,null,"HIV",351000,{"$f":"F10","v":269000},427000]
[null,"reported ct cases",{"$f":"Page2!C15","v":0},{"$f":"calcs1!B27","v":1526658}]
[null,null,null,null,null,"HIV attrib","base","low","high"]
[null,"estimated syphilis incidence",{"$f":"(C47/D47)*D51","v":0},{"$f":"calcs1!B15","v":55400},null,"PS",{"$f":"C11","v":1.0500000000000001E-2},{"$f":"F11","v":1E-3},{"$f":"G11","v":0.02}]
[null,"estimated gc incidence",{"$f":"(C48/D48)*D52","v":0},{"$f":"calcs1!B16","v":820000},null,"GC",{"$f":"C12","v":5.0000000000000001E-4},{"$f":"F12","v":5.0000000000000002E-5},1E-3]
[null,"estimated ct incidence",0,{"$f":"calcs1!B17","v":2860000},null,"CT",5.0000000000000001E-4,{"$f":"F13","v":5.0000000000000002E-5},1E-3]
[]
[null,"Base case results: historic formula approach",null,{"$f":"H45","v":770},{"$f":"H46","v":230},{"$f":"H47","v":210},{"$f":"H48","v":351000},null,null,null,null,null,null,null,null,"Base case results: DIS approach",null,{"$f":"D55","v":770},{"$f":"E55","v":230},210,351000]
[null,null,null,{"$f":"G51","v":1.0500000000000001E-2},{"$f":"G52","v":5.0000000000000001E-4},{"$f":"G53","v":5.0000000000000001E-4},null,null,null,null,"DISCOUNTED",null,null,null,null,null,null,{"$f":"D56","v":1.0500000000000001E-2},5.0000000000000001E-4,5.0000000000000001E-4,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs",null,null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"ABS(C36)","v":0},"year 1",{"$f":"$C$51*$B58","v":0},{"$f":"$C$52*$B58","v":0},{"$f":"$C$53*$B58","v":0},{"$f":"(D58*D$56) + (E58*E$56)+(F58*F$56)","v":0},{"$f":"(D58*D$55)+(E58*E$55)+(F58*F$55)","v":0},{"$f":"G58*G$55","v":0},{"$f":"H58+I58","v":0},{"$f":"H58*$F36","v":0},{"$f":"I58*$F36","v":0},0,null,null,{"$f":"ABS(N35)","v":0},"year 1",{"$f":"$C$51*$P58","v":0},{"$f":"$C$52*$P58","v":0},{"$f":"$C$53*$P58","v":0},{"$f":"(R58*R$56) + (S58*S$56)+(T58*T$56)","v":0},{"$f":"(R58*R$55)+(S58*S$55)+(T58*T$55)","v":0},{"$f":"U58*U$55","v":0},{"$f":"V58+W58","v":0},{"$f":"V58*$F36","v":0},{"$f":"W58*$F36","v":0},{"$f":"X58*$F36","v":0}]
[null,{"$f":"ABS(C37)","v":0},"year 2",{"$f":"$C$51*$B59","v":0},{"$f":"$C$52*$B59","v":0},{"$f":"$C$53*$B59","v":0},{"$f":"(D59*D$56) + (E59*E$56)+(F59*F$56)","v":0},{"$f":"(D59*D$55)+(E59*E$55)+(F59*F$55)","v":0},{"$f":"G59*G$55","v":0},{"$f":"H59+I59","v":0},{"$f":"H59*$F37","v":0},{"$f":"I59*$F37","v":0},{"$f":"J59*$F37","v":0},null,null,{"$f":"ABS(N36)","v":0},"year 2",{"$f":"$C$51*$P59","v":0},{"$f":"$C$52*$P59","v":0},{"$f":"$C$53*$P59","v":0},{"$f":"(R59*R$56) + (S59*S$56)+(T59*T$56)","v":0},{"$f":"(R59*R$55)+(S59*S$55)+(T59*T$55)","v":0},{"$f":"U59*U$55","v":0},{"$f":"V59+W59","v":0},{"$f":"V59*$F37","v":0},0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,{"$f":"H67*$F45","v":0},{"$f":"I67*$F45","v":0},{"$f":"J67*$F45","v":0},null,null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",{"$f":"SUM(D58:D67)","v":0},{"$f":"SUM(E58:E67)","v":0},0,0,0,0,0,{"$f":"SUM(K58:K67)","v":0},{"$f":"SUM(L58:L67)","v":0},0,null,null,null,"TOTAL",{"$f":"SUM(R58:R67)","v":0},{"$f":"SUM(S58:S67)","v":0},{"$f":"SUM(T58:T67)","v":0},{"$f":"SUM(U58:U67)","v":0},{"$f":"SUM(V58:V67)","v":0},{"$f":"SUM(W58:W67)","v":0},{"$f":"SUM(X58:X67)","v":0},{"$f":"SUM(Y58:Y67)","v":0},{"$f":"SUM(Z58:Z67)","v":0},{"$f":"SUM(AA58:AA67)","v":0}]
[]
[]
[null,"Lower bound results: historic formula approach",null,{"$f":"I45","v":385},{"$f":"I46","v":115},{"$f":"I47","v":105},{"$f":"I48","v":269000},null,null,null,null,null,null,null,null,"Lower bound results: DIS approach",null,{"$f":"D71","v":385},{"$f":"E71","v":115},{"$f":"F71","v":105},{"$f":"G71","v":269000}]
[null,null,null,{"$f":"H51","v":1E-3},{"$f":"H52","v":5.0000000000000002E-5},{"$f":"H53","v":5.0000000000000002E-5},null,null,null,null,"DISCOUNTED",null,null,null,null,null,null,{"$f":"D72","v":1E-3},5.0000000000000002E-5,5.0000000000000002E-5,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs",null,null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"ABS(D36)","v":0},"year 1",{"$f":"$C$51*$B74","v":0},{"$f":"$C$52*$B74","v":0},{"$f":"$C$53*$B74","v":0},{"$f":"(D74*D$72) + (E74*E$72)+(F74*F$72)","v":0},{"$f":"(D74*D$71)+(E74*E$71)+(F74*F$71)","v":0},{"$f":"G74*G$71","v":0},{"$f":"H74+I74","v":0},{"$f":"H74*$F36","v":0},{"$f":"I74*$F36","v":0},0,null,null,{"$f":"ABS(O35)","v":0},"year 1",{"$f":"$C$51*$P74","v":0},{"$f":"$C$52*$P74","v":0},{"$f":"$C$53*$P74","v":0},{"$f":"(R74*R$72) + (S74*S$72)+(T74*T$72)","v":0},{"$f":"(R74*R$71)+(S74*S$71)+(T74*T$71)","v":0},{"$f":"U74*U$71","v":0},{"$f":"V74+W74","v":0},{"$f":"V74*$F36","v":0},{"$f":"W74*$F36","v":0},{"$f":"X74*$F36","v":0}]
[null,{"$f":"ABS(D37)","v":0},"year 2",{"$f":"$C$51*$B75","v":0},{"$f":"$C$52*$B75","v":0},{"$f":"$C$53*$B75","v":0},{"$f":"(D75*D$72) + (E75*E$72)+(F75*F$72)","v":0},{"$f":"(D75*D$55)+(E75*E$55)+(F75*F$55)","v":0},{"$f":"G75*G$55","v":0},{"$f":"H75+I75","v":0},{"$f":"H75*$F37","v":0},{"$f":"I75*$F37","v":0},{"$f":"J75*$F37","v":0},null,null,{"$f":"ABS(O36)","v":0},"year 2",{"$f":"$C$51*$P75","v":0},{"$f":"$C$52*$P75","v":0},{"$f":"$C$53*$P75","v":0},{"$f":"(R75*R$72) + (S75*S$72)+(T75*T$72)","v":0},{"$f":"(R75*R$55)+(S75*S$55)+(T75*T$55)","v":0},{"$f":"U75*U$55","v":0},{"$f":"V75+W75","v":0},{"$f":"V75*$F37","v":0},0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",{"$f":"SUM(D74:D83)","v":0},{"$f":"SUM(E74:E83)","v":0},{"$f":"SUM(F74:F83)","v":0},{"$f":"SUM(G74:G83)","v":0},{"$f":"SUM(H74:H83)","v":0},{"$f":"SUM(I74:I83)","v":0},{"$f":"SUM(J74:J83)","v":0},{"$f":"SUM(K74:K83)","v":0},{"$f":"SUM(L74:L83)","v":0},{"$f":"SUM(M74:M83)","v":0},null,null,null,"TOTAL",{"$f":"SUM(R74:R83)","v":0},{"$f":"SUM(S74:S83)","v":0},{"$f":"SUM(T74:T83)","v":0},{"$f":"SUM(U74:U83)","v":0},{"$f":"SUM(V74:V83)","v":0},{"$f":"SUM(W74:W83)","v":0},{"$f":"SUM(X74:X83)","v":0},{"$f":"SUM(Y74:Y83)","v":0},{"$f":"SUM(Z74:Z83)","v":0},{"$f":"SUM(AA74:AA83)","v":0}]
[]
[]
[]
[null,"Upper bound results: historic formula approach",null,{"$f":"J45","v":1155},{"$f":"J46","v":345},{"$f":"J47","v":315},{"$f":"J48","v":427000},null,null,null,null,null,null,null,null,"Upper bound results: DIS approach",null,{"$f":"D88","v":1155},{"$f":"E88","v":345},{"$f":"F88","v":315},{"$f":"G88","v":427000}]
[null,null,null,{"$f":"I51","v":0.02},{"$f":"I52","v":1E-3},{"$f":"I53","v":1E-3},null,null,null,null,"DISCOUNTED",null,null,null,null,null,null,{"$f":"D89","v":0.02},1E-3,1E-3,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs",null,null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"ABS(E36)","v":0},"year 1",{"$f":"$C$51*$B91","v":0},{"$f":"$C$52*$B91","v":0},{"$f":"$C$53*$B91","v":0},{"$f":"(D91*D$89) + (E91*E$89)+(F91*F$89)","v":0},{"$f":"(D91*D$71)+(E91*E$71)+(F91*F$71)","v":0},{"$f":"G91*G$71","v":0},{"$f":"H91+I91","v":0},{"$f":"H91*$F36","v":0},{"$f":"I91*$F36","v":0},0,null,null,{"$f":"ABS(P35)","v":0},"year 1",{"$f":"$C$51*$P91","v":0},{"$f":"$C$52*$P91","v":0},{"$f":"$C$53*$P91","v":0},{"$f":"(R91*R$89) + (S91*S$89)+(T91*T$89)","v":0},{"$f":"(R91*R$71)+(S91*S$71)+(T91*T$71)","v":0},{"$f":"U91*U$71","v":0},{"$f":"V91+W91","v":0},{"$f":"V91*$F36","v":0},{"$f":"W91*$F36","v":0},{"$f":"X91*$F36","v":0}]
[null,{"$f":"ABS(E37)","v":0},"year 2",{"$f":"$C$51*$B92","v":0},{"$f":"$C$52*$B92","v":0},{"$f":"$C$53*$B92","v":0},{"$f":"(D92*D$89) + (E92*E$89)+(F92*F$89)","v":0},{"$f":"(D92*D$55)+(E92*E$55)+(F92*F$55)","v":0},{"$f":"G92*G$55","v":0},{"$f":"H92+I92","v":0},{"$f":"H92*$F37","v":0},0,0,null,null,{"$f":"ABS(P36)","v":0},"year 2",{"$f":"$C$51*$P92","v":0},{"$f":"$C$52*$P92","v":0},{"$f":"$C$53*$P92","v":0},{"$f":"(R92*R$89) + (S92*S$89)+(T92*T$89)","v":0},{"$f":"(R92*R$55)+(S92*S$55)+(T92*T$55)","v":0},{"$f":"U92*U$55","v":0},{"$f":"V92+W92","v":0},{"$f":"V92*$F37","v":0},0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,0,0,0,null,null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",{"$f":"SUM(D91:D100)","v":0},{"$f":"SUM(E91:E100)","v":0},{"$f":"SUM(F91:F100)","v":0},{"$f":"SUM(G91:G100)","v":0},{"$f":"SUM(H91:H100)","v":0},{"$f":"SUM(I91:I100)","v":0},{"$f":"SUM(J91:J100)","v":0},{"$f":"SUM(K91:K100)","v":0},{"$f":"SUM(L91:L100)","v":0},{"$f":"SUM(M91:M100)","v":0},null,null,null,"TOTAL",{"$f":"SUM(R91:R100)","v":0},{"$f":"SUM(S91:S100)","v":0},{"$f":"SUM(T91:T100)","v":0},{"$f":"SUM(U91:U100)","v":0},{"$f":"SUM(V91:V100)","v":0},{"$f":"SUM(W91:W100)","v":0},{"$f":"SUM(X91:X100)","v":0},{"$f":"SUM(Y91:Y100)","v":0},{"$f":"SUM(Z91:Z100)","v":0},{"$f":"SUM(AA91:AA100)","v":0}]
[]
[]
[]
[]
[null,"Base case results: average"]
[null,null,null,null,null,null,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"AVERAGE(B58,P58)","v":0},"year 1",{"$f":"AVERAGE(D58,R58)","v":0},{"$f":"AVERAGE(E58,S58)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(L58,Z58)","v":0},{"$f":"AVERAGE(M58,AA58)","v":0}]
[null,{"$f":"AVERAGE(B59,P59)","v":0},"year 2",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Lower bound results: average",null,385,115,105,269000]
[null,null,null,1E-3,5.0000000000000002E-5,5.0000000000000002E-5,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"AVERAGE(B74,P74)","v":0},"year 1",{"$f":"AVERAGE(D74,R74)","v":0},{"$f":"AVERAGE(E74,S74)","v":0},{"$f":"AVERAGE(F74,T74)","v":0},{"$f":"AVERAGE(G74,U74)","v":0},{"$f":"AVERAGE(H74,V74)","v":0},{"$f":"AVERAGE(I74,W74)","v":0},{"$f":"AVERAGE(J74,X74)","v":0},{"$f":"AVERAGE(K74,Y74)","v":0},{"$f":"AVERAGE(L74,Z74)","v":0},{"$f":"AVERAGE(M74,AA74)","v":0}]
[null,{"$f":"AVERAGE(B75,P75)","v":0},"year 2",{"$f":"AVERAGE(D75,R75)","v":0},0,0,0,0,0,0,0,0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"Upper bound results: average",null,1155,345,315,427000]
[null,null,null,0.02,1E-3,1E-3,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"AVERAGE(B91,P91)","v":0},"year 1",{"$f":"AVERAGE(D91,R91)","v":0},{"$f":"AVERAGE(E91,S91)","v":0},{"$f":"AVERAGE(F91,T91)","v":0},{"$f":"AVERAGE(G91,U91)","v":0},{"$f":"AVERAGE(H91,V91)","v":0},{"$f":"AVERAGE(I91,W91)","v":0},{"$f":"AVERAGE(J91,X91)","v":0},{"$f":"AVERAGE(K91,Y91)","v":0},{"$f":"AVERAGE(L91,Z91)","v":0},{"$f":"AVERAGE(M91,AA91)","v":0}]
[null,{"$f":"AVERAGE(B92,P92)","v":0},"year 2",{"$f":"AVERAGE(D92,R92)","v":0},0,0,0,0,0,0,0,0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",0,0,0,0,0,0,0,0,0,0]
[null,"application code",{"$f":"calcs1!A75","v":1}]
[]
[null,"Base case results: applied"]
[null,null,null,null,null,null,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"IF($C$153=1,B109,IF($C$153=2,B58,IF($C$153=3,P58,\"error\")))","v":0},"year 1",{"$f":"IF($C$153=1,D109,IF($C$153=2,D58,IF($C$153=3,R58,\"error\")))","v":0},{"$f":"IF($C$153=1,E109,IF($C$153=2,E58,IF($C$153=3,S58,\"error\")))","v":0},0,0,0,0,0,0,0,0]
[null,{"$f":"IF($C$153=1,B110,IF($C$153=2,B59,IF($C$153=3,P59,\"error\")))","v":0},"year 2",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Lower bound results: applied",null,385,115,105,269000]
[null,null,null,1E-3,5.0000000000000002E-5,5.0000000000000002E-5,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"IF($C$153=1,B125,IF($C$153=2,B74,IF($C$153=3,P74,\"error\")))","v":0},"year 1",{"$f":"IF($C$153=1,D125,IF($C$153=2,D74,IF($C$153=3,R74,\"error\")))","v":0},{"$f":"IF($C$153=1,E125,IF($C$153=2,E74,IF($C$153=3,S74,\"error\")))","v":0},{"$f":"IF($C$153=1,F125,IF($C$153=2,F74,IF($C$153=3,T74,\"error\")))","v":0},{"$f":"IF($C$153=1,G125,IF($C$153=2,G74,IF($C$153=3,U74,\"error\")))","v":0},{"$f":"IF($C$153=1,H125,IF($C$153=2,H74,IF($C$153=3,V74,\"error\")))","v":0},{"$f":"IF($C$153=1,I125,IF($C$153=2,I74,IF($C$153=3,W74,\"error\")))","v":0},{"$f":"IF($C$153=1,J125,IF($C$153=2,J74,IF($C$153=3,X74,\"error\")))","v":0},{"$f":"IF($C$153=1,K125,IF($C$153=2,K74,IF($C$153=3,Y74,\"error\")))","v":0},{"$f":"IF($C$153=1,L125,IF($C$153=2,L74,IF($C$153=3,Z74,\"error\")))","v":0},{"$f":"IF($C$153=1,M125,IF($C$153=2,M74,IF($C$153=3,AA74,\"error\")))","v":0}]
[null,{"$f":"IF($C$153=1,B126,IF($C$153=2,B75,IF($C$153=3,P75,\"error\")))","v":0},"year 2",{"$f":"IF($C$153=1,D126,IF($C$153=2,D75,IF($C$153=3,R75,\"error\")))","v":0},0,0,0,0,0,0,0,0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"Upper bound results: applied",null,1155,345,315,427000]
[null,null,null,0.02,1E-3,1E-3,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"IF($C$153=1,B142,IF($C$153=2,B91,IF($C$153=3,P91,\"error\")))","v":0},"year 1",{"$f":"IF($C$153=1,D142,IF($C$153=2,D91,IF($C$153=3,R91,\"error\")))","v":0},{"$f":"IF($C$153=1,E142,IF($C$153=2,E91,IF($C$153=3,S91,\"error\")))","v":0},{"$f":"IF($C$153=1,F142,IF($C$153=2,F91,IF($C$153=3,T91,\"error\")))","v":0},{"$f":"IF($C$153=1,G142,IF($C$153=2,G91,IF($C$153=3,U91,\"error\")))","v":0},{"$f":"IF($C$153=1,H142,IF($C$153=2,H91,IF($C$153=3,V91,\"error\")))","v":0},{"$f":"IF($C$153=1,I142,IF($C$153=2,I91,IF($C$153=3,W91,\"error\")))","v":0},{"$f":"IF($C$153=1,J142,IF($C$153=2,J91,IF($C$153=3,X91,\"error\")))","v":0},{"$f":"IF($C$153=1,K142,IF($C$153=2,K91,IF($C$153=3,Y91,\"error\")))","v":0},{"$f":"IF($C$153=1,L142,IF($C$153=2,L91,IF($C$153=3,Z91,\"error\")))","v":0},{"$f":"IF($C$153=1,M142,IF($C$153=2,M91,IF($C$153=3,AA91,\"error\")))","v":0}]
[null,{"$f":"IF($C$153=1,B143,IF($C$153=2,B92,IF($C$153=3,P92,\"error\")))","v":0},"year 2",{"$f":"IF($C$153=1,D143,IF($C$153=2,D92,IF($C$153=3,R92,\"error\")))","v":0},0,0,0,0,0,0,0,0,0]
[null,0,"year 3",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 4",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 5",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 6",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 7",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 8",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 9",0,0,0,0,0,0,0,0,0,0]
[null,0,"year 10",0,0,0,0,0,0,0,0,0,0]
[null,null,"TOTAL",0,0,0,0,0,0,0,0,0,0]
[]
[null,"rounded results"]
[]
[null,"Base case results: applied"]
[null,null,null,null,null,null,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"ROUND(B158,4)","v":0},"year 1",{"$f":"ROUND(D158,0)","v":0},{"$f":"ROUND(E158,0)","v":0},0,{"$f":"ROUND(G158,1)","v":0},{"$f":"ROUND(H158,-3)","v":0},{"$f":"ROUND(I158,-3)","v":0},0,0,0,0]
[null,{"$f":"ROUND(B159,4)","v":0},"year 2",{"$f":"ROUND(D159,0)","v":0},0,0,{"$f":"ROUND(G159,1)","v":0},{"$f":"ROUND(H159,-3)","v":0},0,0,0,0,0]
[null,0,"year 3",0,0,0,0,{"$f":"ROUND(H160,-3)","v":0},0,0,0,0,0]
[null,0,"year 4",0,0,0,0,{"$f":"ROUND(H161,-3)","v":0},0,0,0,0,0]
[null,0,"year 5",0,0,0,0,{"$f":"ROUND(H162,-3)","v":0},0,0,0,0,0]
[null,0,"year 6",0,0,0,0,{"$f":"ROUND(H163,-3)","v":0},0,0,0,0,0]
[null,0,"year 7",0,0,0,0,{"$f":"ROUND(H164,-3)","v":0},0,0,0,0,0]
[null,0,"year 8",0,0,0,0,{"$f":"ROUND(H165,-3)","v":0},0,0,0,0,0]
[null,0,"year 9",0,0,0,0,{"$f":"ROUND(H166,-3)","v":0},0,0,0,0,0]
[null,0,"year 10",0,0,0,0,{"$f":"ROUND(H167,-3)","v":0},0,0,0,0,0]
[null,null,"TOTAL",0,0,0,0,{"$f":"ROUND(H168,-3)","v":0},0,0,0,0,0]
[]
[]
[null,"Lower bound results: applied",null,385,115,105,269000]
[null,null,null,1E-3,5.0000000000000002E-5,5.0000000000000002E-5,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"ROUND(B174,4)","v":0},"year 1",{"$f":"ROUND(D174,0)","v":0},{"$f":"ROUND(E174,0)","v":0},0,{"$f":"ROUND(G174,1)","v":0},{"$f":"ROUND(H174,-3)","v":0},{"$f":"ROUND(I174,-3)","v":0},0,0,0,0]
[null,{"$f":"ROUND(B175,4)","v":0},"year 2",{"$f":"ROUND(D175,0)","v":0},0,0,{"$f":"ROUND(G175,1)","v":0},{"$f":"ROUND(H175,-3)","v":0},0,0,0,0,0]
[null,0,"year 3",{"$f":"ROUND(D176,0)","v":0},0,0,0,{"$f":"ROUND(H176,-3)","v":0},0,0,0,0,0]
[null,0,"year 4",{"$f":"ROUND(D177,0)","v":0},0,0,0,{"$f":"ROUND(H177,-3)","v":0},0,0,0,0,0]
[null,0,"year 5",{"$f":"ROUND(D178,0)","v":0},0,0,0,{"$f":"ROUND(H178,-3)","v":0},0,0,0,0,0]
[null,0,"year 6",{"$f":"ROUND(D179,0)","v":0},0,0,0,{"$f":"ROUND(H179,-3)","v":0},0,0,0,0,0]
[null,0,"year 7",{"$f":"ROUND(D180,0)","v":0},0,0,0,{"$f":"ROUND(H180,-3)","v":0},0,0,0,0,0]
[null,0,"year 8",{"$f":"ROUND(D181,0)","v":0},0,0,0,{"$f":"ROUND(H181,-3)","v":0},0,0,0,0,0]
[null,0,"year 9",{"$f":"ROUND(D182,0)","v":0},0,0,0,{"$f":"ROUND(H182,-3)","v":0},0,0,0,0,0]
[null,0,"year 10",{"$f":"ROUND(D183,0)","v":0},0,0,0,{"$f":"ROUND(H183,-3)","v":0},0,0,0,0,0]
[null,null,"TOTAL",{"$f":"ROUND(D184,0)","v":0},0,0,0,{"$f":"ROUND(H184,-3)","v":0},0,0,0,0,0]
[]
[]
[]
[null,"Upper bound results: applied",null,1155,345,315,427000]
[null,null,null,0.02,1E-3,1E-3,null,null,null,null,"DISCOUNTED"]
[null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD costs","HIV","totcosts","STD costs","HIV costs","tot costs"]
[null,{"$f":"ROUND(B191,4)","v":0},"year 1",{"$f":"ROUND(D191,0)","v":0},{"$f":"ROUND(E191,0)","v":0},0,{"$f":"ROUND(G191,1)","v":0},{"$f":"ROUND(H191,-3)","v":0},{"$f":"ROUND(I191,-3)","v":0},0,0,0,0]
[null,{"$f":"ROUND(B192,4)","v":0},"year 2",{"$f":"ROUND(D192,0)","v":0},0,0,{"$f":"ROUND(G192,1)","v":0},{"$f":"ROUND(H192,-3)","v":0},0,0,0,0,0]
[null,0,"year 3",{"$f":"ROUND(D193,0)","v":0},0,0,0,{"$f":"ROUND(H193,-3)","v":0},0,0,0,0,0]
[null,0,"year 4",{"$f":"ROUND(D194,0)","v":0},0,0,0,{"$f":"ROUND(H194,-3)","v":0},0,0,0,0,0]
[null,0,"year 5",{"$f":"ROUND(D195,0)","v":0},0,0,0,{"$f":"ROUND(H195,-3)","v":0},0,0,0,0,0]
[null,0,"year 6",{"$f":"ROUND(D196,0)","v":0},0,0,0,{"$f":"ROUND(H196,-3)","v":0},0,0,0,0,0]
[null,0,"year 7",{"$f":"ROUND(D197,0)","v":0},0,0,0,{"$f":"ROUND(H197,-3)","v":0},0,0,0,0,0]
[null,0,"year 8",{"$f":"ROUND(D198,0)","v":0},0,0,0,{"$f":"ROUND(H198,-3)","v":0},0,0,0,0,0]
[null,0,"year 9",{"$f":"ROUND(D199,0)","v":0},0,0,0,{"$f":"ROUND(H199,-3)","v":0},0,0,0,0,0]
[null,0,"year 10",{"$f":"ROUND(D200,0)","v":0},0,0,0,{"$f":"ROUND(H200,-3)","v":0},0,0,0,0,0]
[null,null,"TOTAL",{"$f":"ROUND(D201,0)","v":0},0,0,0,{"$f":"ROUND(H201,-3)","v":0},0,0,0,0,0]

{"sheet":"calcs1","index":17,"n_rows":81,"n_cols":31,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
[]
["Size of population served by STD program (all ages)",{"$f":"Page2!C13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIS",{"$f":"D44","v":0},null,{"$f":"V2","v":0},"starting number of DIS"]
["Reported number of syphilis cases",{"$f":"Page2!C17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V12","v":0},"change in DIS"]
["Reported number of gonorrhea cases",{"$f":"Page2!C16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pct change in DIS",{"$f":"IF(V2=0,0,(V12/V2))","v":0},null,{"$f":"IF(X2+X3>0,X3,X2)","v":0},"change in DIS"]
["Reported number of chlamydia cases",{"$f":"Page2!C15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"applied pct change",{"$f":"IF(V4<-1,-1,IF(V4>1,1,V4))","v":0}]
["Annual cost of Disease Intervention Specialist (DIS)",73600]
["Annual number of STD cases interviewed per DIS",400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"change in interviews",null,null,"max decrease","max increase"]
["Percentage of syphilis cases interviewed",0.89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interviewed cases",{"$f":"V9+V10+V11","v":0},null,{"$f":"X4*D46","v":0},{"$f":"IF(V12<0,AA8,AB8)","v":0},null,{"$f":"MAX(-V8,X8)","v":0},{"$f":"MIN(X8,X13)","v":0}]
["Percentage of gonorrhea cases interviewed",0.17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A56","v":"interviewed CT cases"},{"$f":"B56","v":0},null,{"$f":"ROUND(ABS(Y8),0)","v":0}]
["Percentage of chlamydia cases interviewed",0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A57","v":"interviewed GC cases"},0]
["number needed to interview to detect new case",{"$f":"IF(Advanced_options_2!D25 = \"\",C11,D11)","v":4},{"$f":"Advanced_options_2!C25","v":4},{"$f":"Advanced_options_2!D25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"interviewed PS/EL cases",0]
["Percent change in  STDs relative to % change in number of STD cases interviewed",{"$f":"IF(Advanced_options_2!D8 = \"\",C12,D12)","v":0.2},{"$f":"Advanced_options_2!C8","v":0.2},{"$f":"Advanced_options_2!D8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"change in DIS",{"$f":"B31/D45","v":0},{"$f":"ROUND(ABS(V12),2)","v":0},"uninterviewed cases"]
["Percent increase in STDs per $1 per capita decrease in STD prevention funding",{"$f":"IF(Advanced_options_2!D9 = \"\",C13,D13)","v":0.16},{"$f":"Advanced_options_2!C9","v":0.16},{"$f":"Advanced_options_2!D9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"change in interviews",{"$f":"IF(B61*V12>X13,X13,IF(B61*V12<-V8,-V8,B61*V12))","v":0},{"$f":"ROUND(ABS(V13),0)","v":0},{"$f":"SUM(B3:B5)-SUM(V9:V11)","v":0}]
["β parameter of residual impact, used to estimate new equilibrium STD incidence*",{"$f":"IF(Advanced_options_2!D10 = \"\",C14,D14)","v":0.7},{"$f":"Advanced_options_2!C10","v":0.7},{"$f":"Advanced_options_2!D10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pct change",{"$f":"V13/V8","v":{"$error":"#DIV/0!"}}]
["Annual number of syphilis infections, nationally ",{"$f":"IF(Advanced_options_2!D11 = \"\",C15,D15)","v":55400},{"$f":"Advanced_options_2!C11","v":55400},{"$f":"Advanced_options_2!D11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"change in STDs",{"$f":"IF(W15<-1,-1,W15)","v":0},{"$f":"-(B12)*V5","v":0}]
["Annual number of gonorrhea infections, nationally ",{"$f":"IF(Advanced_options_2!D12 = \"\",C16,D16)","v":820000},{"$f":"Advanced_options_2!C12","v":820000},{"$f":"Advanced_options_2!D12","v":0}]
["Annual number of chlamydia infections, nationally ",{"$f":"IF(Advanced_options_2!D13 = \"\",C17,D17)","v":2860000},{"$f":"Advanced_options_2!C13","v":2860000},{"$f":"Advanced_options_2!D13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"change in interviews"]
["Average lifetime cost per syphilis infection ",{"$f":"IF(Advanced_options_2!D14 = \"\",C18,D18)","v":770},{"$f":"Advanced_options_2!C14","v":770},{"$f":"Advanced_options_2!D14","v":0},null,null,null,null,null,null,null,null,"Actual cases"]
["Average lifetime cost per gonorrhea infection ",{"$f":"IF(Advanced_options_2!D15 = \"\",C19,D19)","v":230},{"$f":"Advanced_options_2!C15","v":230},{"$f":"Advanced_options_2!D15","v":0},null,null,null,null,null,null,null,null,"syphilis","gonorrhea","chlamydia"]
["Average lifetime cost per chlamydia infection ",{"$f":"IF(Advanced_options_2!D16 = \"\",C20,D20)","v":210},{"$f":"Advanced_options_2!C16","v":210},{"$f":"Advanced_options_2!D16","v":0},null,null,null,null,null,null,null,null,{"$f":"B34","v":0},{"$f":"B35","v":0},{"$f":"B36","v":0},null,null,null,null,null,"DIS approach"]
["Average lifetime cost per HIV infection (both sexes)",{"$f":"IF(Advanced_options_2!D17 = \"\",C21,D21)","v":351000},{"$f":"Advanced_options_2!C17","v":351000},{"$f":"Advanced_options_2!D17","v":0},null,"DISCOUNTING",null,null,"funding formula approach"]
["Probability of STD-attributable HIV infection, per syphilis infection",{"$f":"IF(Advanced_options_2!D18 = \"\",C22,D22)","v":1.0500000000000001E-2},{"$f":"Advanced_options_2!C18","v":1.0500000000000001E-2},{"$f":"Advanced_options_2!D18","v":0},null,{"$f":"B28","v":0.03},null,null,null,{"$f":"B33","v":0}]
["Probability of STD-attributable HIV infection, per gonorrhea infection",{"$f":"IF(Advanced_options_2!D19 = \"\",C23,D23)","v":5.0000000000000001E-4},{"$f":"Advanced_options_2!C19","v":5.0000000000000001E-4},{"$f":"Advanced_options_2!D19","v":0},null,null,null,null,null,null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD cost","HIV cost","tot cost",null,null,null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD cost","HIV cost","tot cost"]
["Probability of STD-attributable HIV infection, per chlamydia infection",{"$f":"IF(Advanced_options_2!D20 = \"\",C24,D24)","v":5.0000000000000001E-4},{"$f":"Advanced_options_2!C20","v":5.0000000000000001E-4},{"$f":"Advanced_options_2!D20","v":0},null,{"$f":"POWER(1+$F$22,1-H24)","v":1},null,1,"year 1",1,{"$f":"SUM($J$24:J24)","v":1},{"$f":"MAX(K24*$J$22,-1)","v":0},{"$f":"$L24*M$20","v":0},{"$f":"$L24*N$20","v":0},0,{"$f":"(M24*$B$22)+(N24*$B$23)+(O24*$B$24)","v":0},{"$f":"(M24*$B$18 + N24*$B$19 + O24*$B$20)*F24","v":0},{"$f":"P24*$B$21*F24","v":0},{"$f":"Q24+R24","v":0},null,1,"year 1",{"$f":"K24/$K$33","v":0.30872059262738483},{"$f":"$V$15*W24","v":0},{"$f":"$X24*M$20","v":0},{"$f":"$X24*N$20","v":0},0,{"$f":"(Y24*$B$22)+(Z24*$B$23)+(AA24*$B$24)","v":0},{"$f":"(Y24*$B$18 + Z24*$B$19 + AA24*$B$20)*F24","v":0},{"$f":"AB24*$B$21*F24","v":0},{"$f":"AC24+AD24","v":0}]
["Reported number of syphilis cases, nationally",{"$f":"IF(Advanced_options_2!D21 = \"\",C25,D25)","v":48045},{"$f":"Advanced_options_2!C21","v":48045},{"$f":"Advanced_options_2!D21","v":0},null,{"$f":"POWER(1+$F$22,1-H25)","v":0.970873786407767},null,2,"year 2",{"$f":"POWER($B$14,H25-1)","v":0.7},{"$f":"SUM($J$24:J25)","v":1.7},{"$f":"MAX(K25*$J$22,-1)","v":0},{"$f":"$L25*M$20","v":0},0,0,{"$f":"(M25*$B$22)+(N25*$B$23)+(O25*$B$24)","v":0},{"$f":"(M25*$B$18 + N25*$B$19 + O25*$B$20)*F25","v":0},{"$f":"P25*$B$21*F25","v":0},{"$f":"Q25+R25","v":0},null,2,"year 2",{"$f":"K25/$K$33","v":0.52482500746655425},{"$f":"$V$15*W25","v":0},{"$f":"$X25*M$20","v":0},0,0,{"$f":"(Y25*$B$22)+(Z25*$B$23)+(AA25*$B$24)","v":0},{"$f":"(Y25*$B$18 + Z25*$B$19 + AA25*$B$20)*F25","v":0},{"$f":"AB25*$B$21*F25","v":0},{"$f":"AC25+AD25","v":0}]
["Reported number of gonorrhea cases, nationally",{"$f":"IF(Advanced_options_2!D22 = \"\",C26,D26)","v":395216},{"$f":"Advanced_options_2!C22","v":395216},{"$f":"Advanced_options_2!D22","v":0},null,0.94259590913375435,null,3,"year 3",0.48999999999999994,{"$f":"SUM($J$24:J26)","v":2.19},0,0,0,0,0,0,0,0,null,3,"year 3",0.67609809785397279,0,0,0,0,0,0,0,0]
["Reported number of chlamydia cases, nationally",{"$f":"IF(Advanced_options_2!D23 = \"\",C27,D27)","v":1526658},{"$f":"Advanced_options_2!C23","v":1526658},{"$f":"Advanced_options_2!D23","v":0},null,0.91514165935315961,null,4,"year 4",0.34299999999999992,{"$f":"SUM($J$24:J27)","v":2.5329999999999999},0,0,0,0,0,0,0,0,null,4,"year 4",0.78198926112516576,0,0,0,0,0,0,0,0]
["Discount rate",{"$f":"IF(Advanced_options_2!D24 = \"\",C28,D28)","v":0.03},{"$f":"Advanced_options_2!C24","v":0.03},{"$f":"Advanced_options_2!D24","v":0},null,0.888487047915689,null,5,"year 5",0.24009999999999992,{"$f":"SUM($J$24:J28)","v":2.7730999999999999},0,0,0,0,0,0,0,0,null,5,"year 5",0.85611307541500081,0,0,0,0,0,0,0,0]
["per cap change",{"$f":"IF(B31=0,0,B31/B2)","v":0},null,null,null,0.86260878438416411,null,6,"year 6",0.16806999999999994,{"$f":"SUM($J$24:J29)","v":2.9411699999999996},0,0,0,0,0,0,0,0,null,6,"year 6",0.90799974541788531,0,0,0,0,0,0,0,0]
["per cap change, limited to $2 per capita",{"$f":"IF(B29<-2,-2,IF(B29>2,2,B29))","v":0},null,null,null,0.83748425668365445,null,7,"year 7",0.11764899999999995,{"$f":"SUM($J$24:J30)","v":3.0588189999999997},0,0,0,0,0,0,0,0,null,7,"year 7",0.94432041441990455,0,0,0,0,0,0,0,0]
["change in funding",{"$f":"B40-B39","v":0},null,null,null,0.81309151134335378,null,8,"year 8",8.235429999999995E-2,{"$f":"SUM($J$24:J31)","v":3.1411732999999997},0,0,0,0,0,0,0,0,null,8,"year 8",0.96974488272131798,0,0,0,0,0,0,0,0]
["per capita funding change x coefficient",{"$f":"-(B30)*B13","v":0},null,null,null,0.78940923431393573,null,9,"year 9",5.7648009999999965E-2,{"$f":"SUM($J$24:J32)","v":3.1988213099999996},0,0,0,0,0,0,0,0,null,9,"year 9",0.98754201053230739,0,0,0,0,0,0,0,0]
["per capita funding change x coefficient",{"$f":"B32","v":0},null,null,null,0.76641673234362695,null,10,"year 10",4.0353606999999972E-2,{"$f":"SUM($J$24:J33)","v":3.2391749169999997},0,0,0,0,0,0,0,0,null,10,"year 10",1,0,0,0,0,0,0,0,0]
["Annual number of syphilis infections, program",{"$f":"(B3/B25)*B15","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M24:M33)","v":0},{"$f":"SUM(N24:N33)","v":0},0,0,0,0,0,null,null,null,null,null,{"$f":"SUM(Y24:Y33)","v":0},{"$f":"SUM(Z24:Z33)","v":0},0,0,0,0,{"$f":"SUM(AE24:AE33)","v":0}]
["Annual number of gonorrhea infections, program",{"$f":"(B4/B26)*B16","v":0}]
["Annual number of chlamydia infections, program",0]
[]
["increase",{"$f":"IF((B40-B39)*10>0,1,0)","v":0},null,null,null,null,null,null,null,"average approach","syphilis","gonorrhea","chlamydia","HIV","STD cost","HIV cost","tot cost"]
[{"$f":"Page3!B10","v":"Amount of budget decrease"},{"$f":"Page3!C10","v":0},{"$f":"ABS(B39)","v":0},null,null,null,null,null,{"$f":"AVERAGE(L24,X24)","v":0},"year 1",{"$f":"AVERAGE(M24,Y24)","v":0},{"$f":"AVERAGE(N24,Z24)","v":0},0,0,0,0,0]
[{"$f":"Page3!B13","v":"Amount of budget increase"},{"$f":"Page3!C13","v":0},{"$f":"ABS(B40)","v":0},null,null,null,null,null,{"$f":"AVERAGE(L25,X25)","v":0},"year 2",{"$f":"AVERAGE(M25,Y25)","v":0},0,0,0,0,0,0]
[null,null,{"$f":"C40-C39","v":0},null,null,null,null,null,0,"year 3",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 4",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 5",0,0,0,0,0,0,0]
["Number of Disease Intervention Specialists (DIS) employed ",{"$f":"Page5!C10","v":0},{"$f":"Page5!D10","v":0},{"$f":"IF(Page5!D10=\"\",B44,C44)","v":0},null,null,null,null,0,"year 6",0,0,0,0,0,0,0]
["Annual cost per DIS (salary plus fringe benefits)*",{"$f":"Page5!C11","v":73600},{"$f":"Page5!D11","v":0},{"$f":"IF(Page5!D11=\"\",B45,C45)","v":73600},null,null,null,null,0,"year 7",0,0,0,0,0,0,0]
["Annual number of STD cases interviewed per DIS",{"$f":"Page5!C12","v":400},{"$f":"Page5!D12","v":0},{"$f":"IF(Page5!D12=\"\",B46,C46)","v":400},null,null,null,null,0,"year 8",0,0,0,0,0,0,0]
["Percentage of chlamydia cases interviewed",{"$f":"Page5!C13","v":0.12},{"$f":"Page5!D13","v":0},{"$f":"IF(Page5!D13=\"\",B47,C47)","v":0.12},null,null,null,null,0,"year 9",0,0,0,0,0,0,0]
["Percentage of gonorrhea cases interviewed",{"$f":"Page5!C14","v":0.17},{"$f":"Page5!D14","v":0},{"$f":"IF(Page5!D14=\"\",B48,C48)","v":0.17},null,null,null,null,0,"year 10",0,0,0,0,0,0,0]
["Percentage of syphilis cases interviewed\n(Primary, secondary, and early latent)",{"$f":"Page5!C15","v":0.89},{"$f":"Page5!D15","v":0},{"$f":"IF(Page5!D15=\"\",B49,C49)","v":0.89},null,null,null,null,null,"TOTAL",0,0,0,0,0,0,0]
[]
[]
[{"$f":"Page2!B15","v":"Reported number of chlamydia cases"},{"$f":"Page2!C15","v":0}]
[{"$f":"Page2!B16","v":"Reported number of gonorrhea cases"},{"$f":"Page2!C16","v":0},null,null,null,null,null,null,null,"ABSOLUTE VALUES"]
[{"$f":"Page2!B17","v":"Reported number of syphilis cases\n(Primary, secondary, and early latent)"},{"$f":"Page2!C17","v":0}]
[null,null,null,null,null,null,null,null,null,"FUNDING FORMULA",null,null,null,null,null,null,null,null,"DIS"]
["interviewed CT cases",{"$f":"B52*D47","v":0},null,null,null,null,null,null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD cost","HIV cost","tot cost",null,null,"syphilis","gonorrhea","chlamydia","HIV","STD cost","HIV cost","tot cost"]
["interviewed GC cases",{"$f":"B53*D48","v":0},null,null,null,null,null,null,{"$f":"ABS(IFERROR(L24,0))","v":0},"year 1",{"$f":"ABS(IFERROR(M24,0))","v":0},{"$f":"ABS(IFERROR(N24,0))","v":0},0,0,0,0,0,{"$f":"ABS(IFERROR(X24,0))","v":0},"year 1",{"$f":"ABS(IFERROR(Y24,0))","v":0},{"$f":"ABS(IFERROR(Z24,0))","v":0},0,0,0,0,0]
["interviewed PS/EL cases",0,null,null,null,null,null,null,{"$f":"ABS(IFERROR(L25,0))","v":0},"year 2",{"$f":"ABS(IFERROR(M25,0))","v":0},0,0,0,0,0,0,{"$f":"ABS(IFERROR(X25,0))","v":0},"year 2",{"$f":"ABS(IFERROR(Y25,0))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 3",0,0,0,0,0,0,0,0,"year 3",0,0,0,0,0,0,0]
["interviewed cases",{"$f":"B56+B57+B58","v":0},null,null,null,null,null,null,0,"year 4",0,0,0,0,0,0,0,0,"year 4",0,0,0,0,0,0,0]
["interviews per DIS",{"$f":"D46","v":400},null,null,null,null,null,null,0,"year 5",0,0,0,0,0,0,0,0,"year 5",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 6",0,0,0,0,0,0,0,0,"year 6",0,0,0,0,0,0,0]
["number of DIS (calculated)",{"$f":"B60/B61","v":0},null,null,null,null,null,null,0,"year 7",0,0,0,0,0,0,0,0,"year 7",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 8",0,0,0,0,0,0,0,0,"year 8",0,0,0,0,0,0,0]
["Number needed to interview",null,null,null,null,null,null,null,0,"year 9",0,0,0,0,0,0,0,0,"year 9",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 10",0,0,0,0,0,0,0,0,"year 10",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"TOTAL",0,0,0,0,0,0,0,null,"TOTAL",0,0,0,0,{"$f":"SUM(X57:X66)","v":0},{"$f":"SUM(Y57:Y66)","v":0},0]
[]
[{"$f":"Advanced_options_1!C7","v":"Use the average of the two approaches (default)"},null,null,null,null,null,null,null,null,"Average",null,null,null,null,null,null,null,null,"Applied"]
[null,null,null,null,null,null,null,null,null,null,"syphilis","gonorrhea","chlamydia","HIV","STD cost","HIV cost","tot cost"]
[{"$f":"dropdown!B4","v":"Use the average of the two approaches (default)"},null,null,null,null,null,null,null,{"$f":"AVERAGE(I57,R57)","v":0},"year 1",{"$f":"AVERAGE(K57,T57)","v":0},{"$f":"AVERAGE(L57,U57)","v":0},0,0,0,0,0,null,{"$f":"IF($A$75=1,I71,IF($A$75=2,I57,IF($A$75=3,R57,I71)))","v":0},{"$f":"IF($A$75=1,J71,IF($A$75=2,J57,IF($A$75=3,S57,J71)))","v":"year 1"},{"$f":"IF($A$75=1,K71,IF($A$75=2,K57,IF($A$75=3,T57,K71)))","v":0},{"$f":"IF($A$75=1,L71,IF($A$75=2,L57,IF($A$75=3,U57,L71)))","v":0},{"$f":"IF($A$75=1,M71,IF($A$75=2,M57,IF($A$75=3,V57,M71)))","v":0},{"$f":"IF($A$75=1,N71,IF($A$75=2,N57,IF($A$75=3,W57,N71)))","v":0},{"$f":"IF($A$75=1,O71,IF($A$75=2,O57,IF($A$75=3,X57,O71)))","v":0},{"$f":"IF($A$75=1,P71,IF($A$75=2,P57,IF($A$75=3,Y57,P71)))","v":0},{"$f":"IF($A$75=1,Q71,IF($A$75=2,Q57,IF($A$75=3,Z57,Q71)))","v":0}]
[{"$f":"dropdown!B5","v":"Use the historical formula approach"},null,null,null,null,null,null,null,{"$f":"AVERAGE(I58,R58)","v":0},"year 2",{"$f":"AVERAGE(K58,T58)","v":0},0,0,0,0,0,0,null,0,"year 2",0,0,0,0,0,0,0]
[{"$f":"dropdown!B6","v":"Use the DIS approach"},null,null,null,null,null,null,null,0,"year 3",0,0,0,0,0,0,0,null,0,"year 3",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 4",0,0,0,0,0,0,0,null,0,"year 4",0,0,0,0,0,0,0]
[{"$f":"IF(A69=A71,1,IF(A69=A72,2,IF(A69=A73,3,1)))","v":1},null,null,null,null,null,null,null,0,"year 5",0,0,0,0,0,0,0,null,0,"year 5",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 6",0,0,0,0,0,0,0,null,0,"year 6",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 7",0,0,0,0,0,0,0,null,0,"year 7",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 8",0,0,0,0,0,0,0,null,0,"year 8",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 9",0,0,0,0,0,0,0,null,0,"year 9",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,"year 10",0,0,0,0,0,0,0,null,0,"year 10",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"TOTAL",0,0,0,0,0,0,0,null,{"$f":"S80","v":0},"TOTAL",0,0,0,0,0,0,0]

{"sheet":"dropdown","index":18,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Use the average of the two approaches (default)"]
[null,"Use the historical formula approach"]
[null,"Use the DIS approach"]

{"sheet":"text_inserts","index":19,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[{"$f":"TEXT(D1,\"0\")","v":"0"},{"$f":"TEXT(D1,\"0,000\")","v":"0,000"},null,{"$f":"ABS(calcs1!B31)","v":0},{"$f":"IF(D1>1000,B1,A1)","v":"0"},{"$f":"\"With a budget cut of $\"&E1&\", positions for disease intervention specialists will be eliminated, resulting in:\"","v":"With a budget cut of $0, positions for disease intervention specialists will be eliminated, resulting in:"},{"$f":"\"With a budget increase of $\"&E1&\", positions for disease intervention specialists will be increased, resulting in:\"","v":"With a budget increase of $0, positions for disease intervention specialists will be increased, resulting in:"}]
[null,null,null,null,null,{"$f":"\"• No DIS interviews or effective behavioral counseling for an estimated \"&E8&\" patients with STDs.\"","v":"• No DIS interviews or effective behavioral counseling for an estimated 0 patients with STDs."},{"$f":"\"• Additional DIS interviews or effective behavioral counseling for an estimated \"&E8&\" patients with STDs.\"","v":"• Additional DIS interviews or effective behavioral counseling for an estimated 0 patients with STDs."}]
[null,null,null,null,null,"• DIS are public health professionals who work to find people diagnosed with syphilis and other STDs. DIS work to find new cases of the disease — and to prevent new ones from happening.","• DIS are public health professionals who work to find people diagnosed with syphilis and other STDs. DIS work to find new cases of the disease — and to prevent new ones from happening."]
[null,null,null,null,null,"• In addition to STDs, DIS fight other disease outbreaks and epidemics, including Ebola, flu, anthrax, and SARS—without these DIS, we could be underprepared for emergencies.","• In addition to STDs, DIS fight other disease outbreaks and epidemics, including Ebola, flu, anthrax, and SARS—with additional DIS, we will be better prepared for emergencies."]
[null,null,null,null,null,{"$f":"\"• Since an estimated 1 in \"&TEXT(D10,\"0\")&\" DIS interviews identifies a new STD case, an estimated \"&E9&\" people with syphilis, gonorrhea, or chlamydia will not know they are infected, will not be treated, and will be more likely to spread STDs in their communities.\"","v":"• Since an estimated 1 in 4 DIS interviews identifies a new STD case, an estimated 0 people with syphilis, gonorrhea, or chlamydia will not know they are infected, will not be treated, and will be more likely to spread STDs in their communities."},{"$f":"\"• Since an estimated 1 in \"&TEXT(D10,\"0\")&\" DIS interviews identifies a new STD case, an estimated \"&E9&\" people with syphilis, gonorrhea, or chlamydia will become aware that they are infected, will be more likely to be treated, and will be less likely to spread STDs in their communities.\"","v":"• Since an estimated 1 in 4 DIS interviews identifies a new STD case, an estimated 0 people with syphilis, gonorrhea, or chlamydia will become aware that they are infected, will be more likely to be treated, and will be less likely to spread STDs in their communities."}]
[null,null,"budget cut"]
[{"$f":"TEXT(D7,\"0.00\")","v":"0.00"},{"$f":"TEXT(D7,\"0,000\")","v":"0,000"},"DIS reduction",{"$f":"calcs1!W12","v":0},{"$f":"IF(D7>1000,B7,A7)","v":"0.00"},{"$f":"\"Based on published evidence of the impact of STD prevention programs and the cost of STDs, a budget cut of $\"&E1&\" will result in:\"","v":"Based on published evidence of the impact of STD prevention programs and the cost of STDs, a budget cut of $0 will result in:"},{"$f":"\"Based on published evidence of the impact of STD prevention programs and the cost of STDs, a budget increase of $\"&E1&\" will result in:\"","v":"Based on published evidence of the impact of STD prevention programs and the cost of STDs, a budget increase of $0 will result in:"}]
[{"$f":"TEXT(D8,\"0\")","v":"0"},{"$f":"TEXT(D8,\"0,000\")","v":"0,000"},"STD reduction",{"$f":"calcs1!X9","v":0},{"$f":"IF(D8>1000,B8,A8)","v":"0"},{"$f":"\"• In the first year alone, there will be an estimated increase of \"&E12&\" cases of syphilis \"&C39&\", \"&E13&\" cases of gonorrhea \"&C40&\", \"&E14&\" cases of chlamydia \"&C41&\", and \"&E15&\" cases of STD-attributable HIV \"&C42&\".\"","v":"• In the first year alone, there will be an estimated increase of 0 cases of syphilis (range: 0 to 0), 0 cases of gonorrhea (range: 0 to 0), 0 cases of chlamydia (range: 0 to 0), and 0.0 cases of STD-attributable HIV (range: 0.0 to 0.0)."},{"$f":"\"• In the first year alone, there will be an estimated decrease of \"&E12&\" cases of syphilis \"&C39&\", \"&E13&\" cases of gonorrhea \"&C40&\", \"&E14&\" cases of chlamydia \"&C41&\", and \"&E15&\" cases of STD-attributable HIV \"&C42&\".\"","v":"• In the first year alone, there will be an estimated decrease of 0 cases of syphilis (range: 0 to 0), 0 cases of gonorrhea (range: 0 to 0), 0 cases of chlamydia (range: 0 to 0), and 0.0 cases of STD-attributable HIV (range: 0.0 to 0.0)."}]
["0","0,000","unaware",{"$f":"ROUND(D8/D10,0)","v":0},"0",{"$f":"\"• Over 10 years, there will be an estimated cumulative increase of \"&E18&\" cases of syphilis \"&C44&\", \"&E19&\" cases of gonorrhea \"&C45&\", \"&E20&\" cases of chlamydia \"&C46&\", and \"&E21&\" cases of STD-attributable HIV \"&C47&\".\"","v":"• Over 10 years, there will be an estimated cumulative increase of 0 cases of syphilis (range: 0 to 0), 0 cases of gonorrhea (range: 0 to 0), 0 cases of chlamydia (range: 0 to 0), and 0.0 cases of STD-attributable HIV (range: 0 to 0)."},{"$f":"\"• Over 10 years, there will be an estimated cumulative decrease of \"&E18&\" cases of syphilis \"&C44&\", \"&E19&\" cases of gonorrhea \"&C45&\", \"&E20&\" cases of chlamydia \"&C46&\", and \"&E21&\" cases of STD-attributable HIV \"&C47&\".\"","v":"• Over 10 years, there will be an estimated cumulative decrease of 0 cases of syphilis (range: 0 to 0), 0 cases of gonorrhea (range: 0 to 0), 0 cases of chlamydia (range: 0 to 0), and 0.0 cases of STD-attributable HIV (range: 0 to 0)."}]
[null,null,"number needed to interview",{"$f":"calcs1!B11","v":4},null,{"$f":"\"• Over 10 years, there will be an estimated cumulative increase in direct medical costs of $\"&E23&\" \"&C48&\" due to increases in STIs and STI-attributable HIV infections.\"","v":"• Over 10 years, there will be an estimated cumulative increase in direct medical costs of $0 (range: 0 to 0) due to increases in STIs and STI-attributable HIV infections."},{"$f":"\"• Over 10 years, there will be an estimated cumulative decrease in direct medical costs of $\"&E23&\" \"&C48&\" due to decreases in STIs and STI-attributable HIV infections.\"","v":"• Over 10 years, there will be an estimated cumulative decrease in direct medical costs of $0 (range: 0 to 0) due to decreases in STIs and STI-attributable HIV infections."}]
[null,null,"1 year"]
[{"$f":"TEXT(D12,\"0\")","v":"0"},{"$f":"TEXT(D12,\"0,000\")","v":"0,000"},"syphilis",{"$f":"ROUND(Results!D5,0)","v":0},{"$f":"IF(D12>1000,B12,A12)","v":"0"}]
[{"$f":"TEXT(D13,\"0\")","v":"0"},{"$f":"TEXT(D13,\"0,000\")","v":"0,000"},"gonorrhea",{"$f":"ROUND(Results!E5,0)","v":0},{"$f":"IF(D13>1000,B13,A13)","v":"0"}]
[{"$f":"TEXT(D14,\"0\")","v":"0"},"0,000","chlamydia",{"$f":"ROUND(Results!F5,0)","v":0},"0"]
[{"$f":"TEXT(D15,\"0.0\")","v":"0.0"},{"$f":"TEXT(D15,\"0\")","v":"0"},"STD-attributable HIV",{"$f":"ROUND(Results!G5,1)","v":0},{"$f":"IF(D15>100,B15,A15)","v":"0.0"}]
[]
[null,null,"10 year"]
[{"$f":"TEXT(D18,\"0\")","v":"0"},{"$f":"TEXT(D18,\"0,000\")","v":"0,000"},"syphilis",{"$f":"ROUND(Results!D15,0)","v":0},{"$f":"IF(D18>1000,B18,A18)","v":"0"}]
[{"$f":"TEXT(D19,\"0\")","v":"0"},{"$f":"TEXT(D19,\"0,000\")","v":"0,000"},"gonorrhea",{"$f":"ROUND(Results!E15,0)","v":0},{"$f":"IF(D19>1000,B19,A19)","v":"0"}]
[{"$f":"TEXT(D20,\"0\")","v":"0"},"0,000","chlamydia",{"$f":"ROUND(Results!F15,0)","v":0},"0"]
[{"$f":"TEXT(D21,\"0.0\")","v":"0.0"},{"$f":"TEXT(D21,\"0\")","v":"0"},"STD-attributable HIV",{"$f":"ROUND(Results!G15,1)","v":0},{"$f":"IF(D21>100,B21,A21)","v":"0.0"}]
[]
[{"$f":"TEXT(D23,\"0\")","v":"0"},{"$f":"TEXT(D23,\"0,000\")","v":"0,000"},"10 year cost",{"$f":"ROUND(Results!J15,-3)","v":0},{"$f":"IF(D23>1000,B23,A23)","v":"0"}]
[]
[]
[null,null,"syphilis",{"$f":"IFERROR(bounds!D224,0)","v":0},{"$f":"IFERROR(bounds!D241,0)","v":0},{"$f":"IF(D26>1000,2,IF(AND(D26<1000,E26>1000),3,1))","v":1}]
[null,null,"gonorrhea",{"$f":"IFERROR(bounds!E224,0)","v":0},{"$f":"bounds!E241","v":0},{"$f":"IF(D27>1000,2,IF(AND(D27<1000,E27>1000),3,1))","v":1}]
[null,null,"chlamydia",{"$f":"IFERROR(bounds!F224,0)","v":0},{"$f":"bounds!F241","v":0},1]
[null,null,"STD-attributable HIV",{"$f":"IFERROR(bounds!G224,0)","v":0},{"$f":"bounds!G241","v":0}]
[]
[null,null,"10 year"]
[null,null,"syphilis",{"$f":"bounds!D234","v":0},{"$f":"bounds!D251","v":0},{"$f":"IF(D32>1000,2,IF(AND(D32<1000,E32>1000),3,1))","v":1}]
[null,null,"gonorrhea",{"$f":"bounds!E234","v":0},{"$f":"bounds!E251","v":0},{"$f":"IF(D33>1000,2,IF(AND(D33<1000,E33>1000),3,1))","v":1}]
[null,null,"chlamydia",{"$f":"bounds!F234","v":0},{"$f":"bounds!F251","v":0},1]
[null,null,"STD-attributable HIV",{"$f":"bounds!G234","v":0},{"$f":"bounds!G251","v":0}]
[]
[null,null,"10 year cost",{"$f":"bounds!M234","v":0},{"$f":"bounds!M251","v":0},{"$f":"IF(D37>1000,2,IF(AND(D37<1000,E37>1000),3,1))","v":1}]
[]
[null,null,{"$f":"IF(F26=1,E39,IF(F26=2,D39,IF(F26=3,F39,D39)))","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D26,\"0,000\")&\" to \"&TEXT(E26,\"0,000\")&\")\"","v":"(range: 0,000 to 0,000)"},{"$f":"\"(range: \"&D26&\" to \"&E26&\")\"","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D26,\"0\")&\" to \"&TEXT(E26,\"0,000\"&\")\")","v":"(range: 0 to 0,000)"}]
[null,null,{"$f":"IF(F27=1,E40,IF(F27=2,D40,IF(F27=3,F40,D40)))","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D27,\"0,000\")&\" to \"&TEXT(E27,\"0,000\")&\")\"","v":"(range: 0,000 to 0,000)"},{"$f":"\"(range: \"&D27&\" to \"&E27&\")\"","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D27,\"0\")&\" to \"&TEXT(E27,\"0,000\"&\")\")","v":"(range: 0 to 0,000)"}]
[null,null,"(range: 0 to 0)",{"$f":"\"(range: \"&TEXT(D28,\"0,000\")&\" to \"&TEXT(E28,\"0,000\")&\")\"","v":"(range: 0,000 to 0,000)"},{"$f":"\"(range: \"&D28&\" to \"&E28&\")\"","v":"(range: 0 to 0)"},"(range: 0 to 0,000)"]
[null,null,{"$f":"D42","v":"(range: 0.0 to 0.0)"},{"$f":"\"(range: \"&TEXT(D29,\"0.0\")&\" to \"&TEXT(E29,\"0.0\")&\")\"","v":"(range: 0.0 to 0.0)"}]
[]
[null,null,{"$f":"IF(F32=1,E44,IF(F32=2,D44,IF(F32=3,F44,D44)))","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D32,\"0,000\")&\" to \"&TEXT(E32,\"0,000\"&\")\")","v":"(range: 0,000 to 0,000)"},{"$f":"\"(range: \"&D32&\" to \"&E32&\")\"","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D32,\"0\")&\" to \"&TEXT(E32,\"0,000\"&\")\")","v":"(range: 0 to 0,000)"}]
[null,null,{"$f":"IF(F33=1,E45,IF(F33=2,D45,IF(F33=3,F45,D45)))","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D33,\"0,000\")&\" to \"&TEXT(E33,\"0,000\"&\")\")","v":"(range: 0,000 to 0,000)"},{"$f":"\"(range: \"&D33&\" to \"&E33&\")\"","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D33,\"0\")&\" to \"&TEXT(E33,\"0,000\"&\")\")","v":"(range: 0 to 0,000)"}]
[null,null,"(range: 0 to 0)",{"$f":"\"(range: \"&TEXT(D34,\"0,000\")&\" to \"&TEXT(E34,\"0,000\"&\")\")","v":"(range: 0,000 to 0,000)"},{"$f":"\"(range: \"&D34&\" to \"&E34&\")\"","v":"(range: 0 to 0)"},"(range: 0 to 0,000)"]
[null,null,{"$f":"IF(D35>1000,D47,E47)","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D35,\"0,000\")&\" to \"&TEXT(E35,\"0,000\"&\")\")","v":"(range: 0,000 to 0,000)"},{"$f":"\"(range: \"&D35&\" to \"&E35&\")\"","v":"(range: 0 to 0)"},"(range: 0 to 0,000)"]
[null,null,{"$f":"IF(F37=1,E48,IF(F37=2,D48,IF(F37=3,F48,D48)))","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D37,\"0,000\")&\" to \"&TEXT(E37,\"0,000\"&\")\")","v":"(range: 0,000 to 0,000)"},{"$f":"\"(range: \"&D37&\" to \"&E37&\")\"","v":"(range: 0 to 0)"},{"$f":"\"(range: \"&TEXT(D37,\"0\")&\" to \"&TEXT(E37,\"0,000\"&\")\")","v":"(range: 0 to 0,000)"}]