{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Front page","Intro","data dictionary","data entry","calculations","output against PN standards","lists"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":10,"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":"Front page","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,1,12,11],[26,0,26,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Audit tool to measure Partner Notification (PN) rates "]
[null,"National Chlamydia Screening Programme"]
[]
[]
[null,"September 2015"]

{"sheet":"Intro","index":1,"n_rows":40,"n_cols":1,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,0,12,12],[13,0,13,12],[15,0,15,12],[18,0,18,12],[20,0,20,12],[37,0,37,12],[33,0,33,12],[28,0,28,8],[29,0,29,8],[30,0,30,8],[31,0,31,8],[32,0,32,8],[36,0,36,8],[35,0,35,8],[26,0,26,8],[23,0,23,8],[24,0,24,8],[16,0,16,12],[22,0,22,12],[25,0,25,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["National Chlamydia Screening Programme"]
["Partner Notification monitoring tool"]
[]
["Rationale"]
["Partner notification (PN) is a key element in the identification, management and control of chlamydia. All HCWs providing PN should have documented competency, corresponding to the Society of Sexual Health Advisers National Sexual Health Advisers Competencies – Competency Record Book (SSHA Manual).\nSome individuals require active intervention by HCWs to complete PN (provider notification). Each area should have clear referral pathways for this activity.\nThe NSCP follows the BASHH Standards for the Management of STIs (January 2014). At least one discussion (which may be a face-to-face or telephone discussion) should be offered to people found to have chlamdyia to begin the PN process. This discussion should be provided by a HCW with the appropriate documented competency. If the offer of discussion of PN is declined, the reason for this should be documented."]
[]
["Local pathways should be in place to clarify roles and responsibilities for all aspects of PN, including interviews, provider referral, follow-up, verification and data reporting. Up to date protocols should be in place at each PN venue, which are acceptable to young people and partners. Close working relationships between all services offering PN and treatment are important to maximise effectiveness."]
[]
[" At a national level, the NCSP uses the GUMCAD V2 dataset to estimate PN rates by local area. At a local level sexual health commissioners and service providers should continue to monitor data on chlamydia treatment and PN rates. This tool offers a method to monitor PN rates."]
[]
["Auditable Outcome Measures:\nThe NCSP follows the BASHH Standards for the management of STIs 2014 on PN for chlamydia:\n• Measure: The percentage of all contacts of index cases of chlamydia who attend a service commissioned to manage STIs within four weeks of the date of first PN discussion.\n• Standard: 0.6 contacts per index case\n* This is the first discussion between the index case and a HCW (including telephone) for the purpose of PN, with the appropriate documented competency."]
["> 0.6 contacts/index case with contact attendance reported by index or HCW within 4 weeks of PN discussion"]
["Calculation"]
["number of contacts with attendance (@ L1/2/3 clinic) documented as reported by index case or by a HCW within 4 weeks of PN discussion "]
["total number of index cases managed by service during the same interval "]
[]
["> 0.4 contacts/index case with contact attendance verified by HCW within 4 weeks of PN discussion"]
["Calculation"]
["number of contacts with attendance (@ L1/2/3 clinic) documented as verified by a HCW within 4 weeks of PN discussion "]
["total number of index cases managed by service during the same interval "]
[]
["Following BASHH guidance we include as meeting the standard, those contacts whose attendances are within 4 working weeks (20 working days) after the index PN discussion date with the index patient. "]
[]
["The BASHH guidance on the management of STIs, including PN, can be found here:"]
["http://www.bashh.org/documents/Standards%20for%20the%20management%20of%20STIs%202014%20FINAL%20WEB.pdf"]
["Please use the data relating to 40 consecutive patients found to be positive from a specific date, going back in time until 40 records have been found."]
[]
["If you have any questions, please contact erna.buitendam@phe.gov.uk"]

{"sheet":"data dictionary","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,0,21,0],[15,2,21,2]]}
["Data item","Explanatory notes"]
["Name of commissioning authority","Please enter name of the main commissioning local authority. If you have more than one commissioning authority, you may wish to complete an audit tool for each one as part of potential contract requirements to undertake audits. This will only need to be completed once, not for every patient. Please use data for 40 patients found to be positive from a specific date, going back in time until 40 records have been found.","return to data entry"]
["Name of service provider","Please enter name of the clinic or organisation that provides the services. This will only need to be entered once, not for every patient","return to data entry"]
["Type of service provider","Please select from drop down list.","return to data entry"]
["Period","Can be any period and probably depends on the size of the service, usually best to choose from one month, one week or a quarter. Data entry tab can also be used to keep adding throughout the year for example.","return to data entry"]
["index patient","Please enter a number, no commas or full stops for positive patients only. This should not be the same as any id numbers used in your service. You may keep the 'key' locally if you wish to keep an audit trail.","return to data entry"]
["date of test","Date of test taken, format/length: an10  dd/mm/ccyy, if no date available or known, please leave blank","return to data entry"]
["gender","This can be male, female or unknown (this includes when it is not recorded)","return to data entry"]
["age","Please provide age at time of the test, not date of birth, for NCSP only age 15-24 to be included","return to data entry"]
["type of test site","This can be one of the following: GUM clinic, SRH/CASH clinic, GP, Community Pharmacy, remote testing, CSO, outreach & education, 'other' (incl prison/YOI, military, ToP, gynae, A&E/MIU, antenatal etc.)","return to data entry"]
["date of result notification","Date when result was notified to patient, if no date available, please leave blank. Please use the following format: dd/mm/yyyy","return to data entry"]
["date of treatment","Date of the day the treatment is provided to the young person, if no date available or known, please leave blank. Please use the following format: dd/mm/yyyy","return to data entry"]
["type of treatment site","This can be one of the following: GUM clinic, SRH/CASH clinic, GP, Community Pharmacy, Postal treatment, CSO, outreach & education, 'other' (incl prison/YOI, military, ToP, gynae, A&E/MIU, antenatal etc.)","return to data entry"]
["offered PN?","This can be 'Yes', 'No', 'Unknown' (which includes when this has not been recorded)","return to data entry"]
["date of PN discussion","This is the date of the first PN discussion, which is the first discussion (including a telephone discussion) for the purpose of PN between the index case and a HCW with the appropriate documented competency. If not available, please leave blank. Please use the following format: dd/mm/yyyy","return to data entry"]
["if no PN offered, why not?","Please answer this question if 'no' or 'unknown' has been selected in the question: 'offered PN?'. Answer can be one of the following:","return to data entry"]
[null,"no documented evidence of PN"]
[null,"patient routinely seen for SH care elsewhere"]
[null,"patient transferred care"]
[null,"documented that PN performed elsewhere"]
[null,"lost to follow up before PN initiated"]
[null,"other"]
["Total number of contacts","Please enter a number, include both contactable and non-contactable partners, between a minimum of 1 and a maximum of 5. If index patient is partner of a positive patient, and no further partners need to be notified, please select '1' in this cell. Please select 'unknown' if no PN was offered, or not recorded.","return to data entry"]
["Total number of contactable contacts","Please enter the number of contacts for which sufficient baseline contact information has been recorded to enable PN to take place","return to data entry"]
["date of index patient or HCW reported attendance for testing and treating contact 1 etc","Date of contact attending a sexual health service for testing and or treatment as reported by the index patient or a healthcare worker. If not available, please leave blank. Please use the following format: dd/mm/yyyy. For pragmatic reasons, please limit data entry to 5 contacts.","return to data entry"]
["date of healthcare worker verified attendance for testing and treating contact 1 etc","Date of contact attending a sexual health service for testing and or treatment as verified by a healthcare worker.Verified means confirming contact attendance by checking records in your own service, or by contacting other services where contacts may have attended. If not available, please leave blank. Please use the following format: dd/mm/yyyy. For pragmatic reasons, please limit data entry to 5 contacts.","return to data entry"]
["PN outcome","Please select for each for up to 5 contacts from drop down list, one of the following options:\ncontact already known to have chlamydia infection\ncontact had a negative test in your service\ncontact had a negative in another service\ncontact had a positive test in your service\ncontact had a positive test in another service\ncontact had a chlamydia test, but result not known\nrecord made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\ncontact not known to have been informed of risk of chlamydia infection\nother","return to data entry"]

{"sheet":"data entry","index":3,"n_rows":45,"n_cols":31,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Commissioning local authority","Name of service provider","Type of service provider","positive patient number (index)","date of test","gender","age","testing service type","date of result notification","date of treatment","treatment service type","offered PN?","date of PN discussion","if no PN offered, reason?","total no of contacts","total  number of contactable contacts","date of patient/HCW reported attendance for testing and treating contact 1","date of patient/HCW reported attendance for testing and treating contact 2","date of patient/HCW reported attendance for testing and treating contact 3","date of patient/HCW reported attendance for testing and treating contact 4","date of patient/HCW reported attendance for testing and treating contact 5","date of healthcare worker verified attendance for testing and treating contact 1","date of healthcare worker verified attendance for testing and treating contact 2","date of healthcare worker verified attendance for testing and treating contact 3","date of healthcare worker verified attendance for testing and treating contact 4","date of healthcare worker verified attendance for testing and treating contact 5","PN outcome for contact no 1","PN outcome for contact no 2","PN outcome for contact no 3","PN outcome for contact no 4","PN outcome for contact no 5"]
[null,null,null,1]
[{"$f":"$A$2","v":0},{"$f":"$B$2","v":0},{"$f":"$C$2","v":0},2]
[{"$f":"$A$2","v":0},{"$f":"$B$2","v":0},{"$f":"$C$2","v":0},3]
[0,0,{"$f":"$C$2","v":0},4]
[0,0,0,5]
[0,0,0,6]
[0,0,0,7]
[0,0,0,8]
[0,0,0,9]
[0,0,0,10]
[0,0,0,11]
[0,0,0,12]
[0,0,0,13]
[0,0,0,14]
[0,0,0,15]
[0,0,0,16]
[0,0,0,17]
[0,0,0,18]
[0,0,0,19]
[0,0,0,20]
[0,0,0,21]
[0,0,0,22]
[0,0,0,23]
[0,0,0,24]
[0,0,0,25]
[0,0,0,26]
[0,0,0,27]
[0,0,0,28]
[0,0,0,29]
[0,0,0,30]
[0,0,0,31]
[0,0,0,32]
[0,0,0,33]
[0,0,0,34]
[0,0,0,35]
[0,0,0,36]
[0,0,0,37]
[0,0,0,38]
[0,0,0,39]
[0,0,0,40]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]

{"sheet":"calculations","index":4,"n_rows":50,"n_cols":50,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["positive patient (index)","If PN offered, 1, otherwise 'not offered' or 'not completed'","Date of test of index patient","Date of PN discussion","date of patient reported attendance for testing and treating contact 1","date of patient reported attendance for testing and treating contact 2","date of patient reported attendance for testing and treating contact 3","date of patient reported attendance for testing and treating contact 4","date of patient reported attendance for testing and treating contact 5","days between PN discussion and date of patient reported attendance contact 1","days between PN discussion and date of patient reported attendance contact 2","days between PN discussion and date of patient reported attendance contact 3","days between PN discussion and date of patient reported attendance contact 4","days between PN discussion and date of patient reported attendance contact 5","meeting standard (between 0 and 21 working days - four working weeks after date of PN discussion) contact 1","meeting standard (between 0 and 21 working days - four working weeks after date of PN discussion) contact 2","meeting standard (between 0 and 21 working days - four working weeks after date of PN discussion) contact 3","meeting standard (between 0 and 21 working days - four working weeks after date of PN discussion) contact 4","meeting standard (between 0 and 21 working days - four working weeks after date of PN discussion) contact 5","number where patient/\nhcw reported standard has been met","Number of contacts with an attendance date ","total number of contacts",null,"date of healthcare worker verified attendance for testing and treating contact 1","date of healthcare worker verified attendance for testing and treating contact 2","date of healthcare worker verified attendance for testing and treating contact 3","date of healthcare worker verified attendance for testing and treating contact 4","date of healthcare worker verified attendance for testing and treating contact 5",null,"days between PN discussion and date of healthcare worker verified attendance contact 2","days between PN discussion and date of healthcare worker verified attendance contact 3","days between PN discussion and date of healthcare worker verified attendance contact 4","days between PN discussion and date of healthcare worker verified attendance contact 5","meeting standard within four weeks contact 1","meeting standard within four weeks contact 2","meeting standard within four weeks contact 3","meeting standard within four weeks contact 4","meeting standard within four weeks contact 5","number where healthcare worker verified standard has been met","Number of contacts with an attendance date ","total number of contacts","PN outcome: contact already known to have chlamydia infection","PN outcome: contact had a negative test in your service","PN outcome: contact had a negative test in another service","PN outcome: contact had a positive test in your service","PN outcome: contact had a positive test in another service","PN outcome: contact had a chlamydia test, but result not known","PN outcome: record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test","PN outcome: contact not known to have been informed of risk of chlamydia infection","Other"]
[{"$f":"'data entry'!D2","v":1},{"$f":"IF('data entry'!M2=0,\"not completed\",IF('data entry'!M2=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E2>0,'data entry'!$E2, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M2>0,'data entry'!M2,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q2>0,$B2=1),'data entry'!Q2,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R2>0,$B2=1),'data entry'!R2,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S2>0,$B2=1),'data entry'!S2,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T2>0,$B2=1),'data entry'!T2,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U2>0,$B2=1),'data entry'!U2,\"NA\")","v":"NA"},{"$f":"IF(E2=\"na\",\"NA\",NETWORKDAYS(D2,E2))","v":"NA"},{"$f":"IF(F2=\"NA\",\"NA\",NETWORKDAYS(D2,F2))","v":"NA"},{"$f":"IF($G2=\"NA\",\"NA\",NETWORKDAYS(D2,G2))","v":"NA"},{"$f":"IF($H2=\"NA\",\"NA\",NETWORKDAYS(D2,H2))","v":"NA"},{"$f":"IF($I2=\"NA\",\"NA\",NETWORKDAYS(D2,I2))","v":"NA"},{"$f":"IF(AND($J2<21,$J2>=0),1,0)","v":0},{"$f":"IF(AND($K2<21,$K2>=0),1,0)","v":0},{"$f":"IF(AND($L2<21,$L2>=0),1,0)","v":0},{"$f":"IF(AND($M2<21,$M2>=0),1,0)","v":0},{"$f":"IF(AND($N2<21,$N2>=0),1,0)","v":0},{"$f":"SUM(O2:S2)","v":0},{"$f":"COUNT(E2:I2)","v":0},{"$f":"'data entry'!O2","v":0},null,{"$f":"IF(AND('data entry'!V2>0,$B2=1),'data entry'!V2,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W2>0,$B2=1),'data entry'!W2,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X2>0,$B2=1),'data entry'!X2,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y2>0,$B2=1),'data entry'!Y2,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z2>0,$B2=1),'data entry'!Z2,\"NA\")","v":"NA"},{"$f":"IF(X2=\"na\",\"NA\",NETWORKDAYS(D2,X2))","v":"NA"},{"$f":"IF(Y2=\"NA\",\"NA\",NETWORKDAYS(D2,Y2))","v":"NA"},{"$f":"IF($Z2=\"NA\",\"NA\",NETWORKDAYS(D2,Z2))","v":"NA"},{"$f":"IF($AA2=\"NA\",\"NA\",NETWORKDAYS(D2,AA2))","v":"NA"},{"$f":"IF($AB2=\"NA\",\"NA\",NETWORKDAYS(D2,AB2))","v":"NA"},{"$f":"IF(AND($AC2<21,$AC2>=0),1,0)","v":0},{"$f":"IF(AND($AD2<21,$AD2>=0),1,0)","v":0},{"$f":"IF(AND($AE2<21,$AE2>=0),1,0)","v":0},{"$f":"IF(AND($AF2<21,$AF2>=0),1,0)","v":0},{"$f":"IF(AND($AG2<21,$AG2>=0),1,0)","v":0},{"$f":"SUM(AH2:AL2)","v":0},{"$f":"COUNT(X2:AB2)","v":0},{"$f":"'data entry'!$O2","v":0},{"$f":"COUNTIF('data entry'!$AA$2:$AE$2,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA2:$AE2,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA2:$AE2,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA2:$AE2,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA2:$AE2,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA2:$AE2,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA2:$AE2,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA2:$AE2,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA2:$AE2,\"other\")","v":0}]
[{"$f":"'data entry'!D3","v":2},{"$f":"IF('data entry'!M3=0,\"not completed\",IF('data entry'!M3=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E3>0,'data entry'!$E3, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M3>0,'data entry'!M3,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q3>0,$B3=1),'data entry'!Q3,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R3>0,$B3=1),'data entry'!R3,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S3>0,$B3=1),'data entry'!S3,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T3>0,$B3=1),'data entry'!T3,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U3>0,$B3=1),'data entry'!U3,\"NA\")","v":"NA"},{"$f":"IF(E3=\"na\",\"NA\",NETWORKDAYS(D3,E3))","v":"NA"},{"$f":"IF(F3=\"NA\",\"NA\",NETWORKDAYS(D3,F3))","v":"NA"},{"$f":"IF($G3=\"NA\",\"NA\",NETWORKDAYS(D3,G3))","v":"NA"},{"$f":"IF($H3=\"NA\",\"NA\",NETWORKDAYS(D3,H3))","v":"NA"},{"$f":"IF($I3=\"NA\",\"NA\",NETWORKDAYS(D3,I3))","v":"NA"},{"$f":"IF(AND($J3<21,$J3>=0),1,0)","v":0},{"$f":"IF(AND($K3<21,$K3>=0),1,0)","v":0},{"$f":"IF(AND($L3<21,$L3>=0),1,0)","v":0},{"$f":"IF(AND($M3<21,$M3>=0),1,0)","v":0},{"$f":"IF(AND($N3<21,$N3>=0),1,0)","v":0},{"$f":"SUM(O3:S3)","v":0},0,{"$f":"'data entry'!O3","v":0},null,{"$f":"IF(AND('data entry'!V3>0,$B3=1),'data entry'!V3,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W3>0,$B3=1),'data entry'!W3,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X3>0,$B3=1),'data entry'!X3,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y3>0,$B3=1),'data entry'!Y3,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z3>0,$B3=1),'data entry'!Z3,\"NA\")","v":"NA"},{"$f":"IF(X3=\"na\",\"NA\",NETWORKDAYS(D3,X3))","v":"NA"},{"$f":"IF(Y3=\"NA\",\"NA\",NETWORKDAYS(D3,Y3))","v":"NA"},{"$f":"IF($Z3=\"NA\",\"NA\",NETWORKDAYS(D3,Z3))","v":"NA"},{"$f":"IF($AA3=\"NA\",\"NA\",NETWORKDAYS(D3,AA3))","v":"NA"},{"$f":"IF($AB3=\"NA\",\"NA\",NETWORKDAYS(D3,AB3))","v":"NA"},{"$f":"IF(AND($AC3<21,$AC3>=0),1,0)","v":0},{"$f":"IF(AND($AD3<21,$AD3>=0),1,0)","v":0},{"$f":"IF(AND($AE3<21,$AE3>=0),1,0)","v":0},{"$f":"IF(AND($AF3<21,$AF3>=0),1,0)","v":0},{"$f":"IF(AND($AG3<21,$AG3>=0),1,0)","v":0},{"$f":"SUM(AH3:AL3)","v":0},0,{"$f":"'data entry'!$O3","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA3:$AE3,\"other\")","v":0}]
[{"$f":"'data entry'!D4","v":3},{"$f":"IF('data entry'!M4=0,\"not completed\",IF('data entry'!M4=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E4>0,'data entry'!$E4, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M4>0,'data entry'!M4,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q4>0,$B4=1),'data entry'!Q4,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R4>0,$B4=1),'data entry'!R4,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S4>0,$B4=1),'data entry'!S4,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T4>0,$B4=1),'data entry'!T4,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U4>0,$B4=1),'data entry'!U4,\"NA\")","v":"NA"},{"$f":"IF(E4=\"na\",\"NA\",NETWORKDAYS(D4,E4))","v":"NA"},{"$f":"IF(F4=\"NA\",\"NA\",NETWORKDAYS(D4,F4))","v":"NA"},{"$f":"IF($G4=\"NA\",\"NA\",NETWORKDAYS(D4,G4))","v":"NA"},{"$f":"IF($H4=\"NA\",\"NA\",NETWORKDAYS(D4,H4))","v":"NA"},{"$f":"IF($I4=\"NA\",\"NA\",NETWORKDAYS(D4,I4))","v":"NA"},0,0,0,0,0,0,0,{"$f":"'data entry'!O4","v":0},null,{"$f":"IF(AND('data entry'!V4>0,$B4=1),'data entry'!V4,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W4>0,$B4=1),'data entry'!W4,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X4>0,$B4=1),'data entry'!X4,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y4>0,$B4=1),'data entry'!Y4,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z4>0,$B4=1),'data entry'!Z4,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O4","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA4:$AE4,\"other\")","v":0}]
[{"$f":"'data entry'!D5","v":4},{"$f":"IF('data entry'!M5=0,\"not completed\",IF('data entry'!M5=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E5>0,'data entry'!$E5, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M5>0,'data entry'!M5,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q5>0,$B5=1),'data entry'!Q5,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R5>0,$B5=1),'data entry'!R5,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S5>0,$B5=1),'data entry'!S5,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T5>0,$B5=1),'data entry'!T5,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U5>0,$B5=1),'data entry'!U5,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O5","v":0},null,{"$f":"IF(AND('data entry'!V5>0,$B5=1),'data entry'!V5,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W5>0,$B5=1),'data entry'!W5,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X5>0,$B5=1),'data entry'!X5,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y5>0,$B5=1),'data entry'!Y5,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z5>0,$B5=1),'data entry'!Z5,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O5","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA5:$AE5,\"other\")","v":0}]
[{"$f":"'data entry'!D6","v":5},{"$f":"IF('data entry'!M6=0,\"not completed\",IF('data entry'!M6=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E6>0,'data entry'!$E6, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M6>0,'data entry'!M6,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q6>0,$B6=1),'data entry'!Q6,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R6>0,$B6=1),'data entry'!R6,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S6>0,$B6=1),'data entry'!S6,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T6>0,$B6=1),'data entry'!T6,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U6>0,$B6=1),'data entry'!U6,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O6","v":0},null,{"$f":"IF(AND('data entry'!V6>0,$B6=1),'data entry'!V6,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W6>0,$B6=1),'data entry'!W6,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X6>0,$B6=1),'data entry'!X6,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y6>0,$B6=1),'data entry'!Y6,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z6>0,$B6=1),'data entry'!Z6,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O6","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA6:$AE6,\"other\")","v":0}]
[{"$f":"'data entry'!D7","v":6},{"$f":"IF('data entry'!M7=0,\"not completed\",IF('data entry'!M7=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E7>0,'data entry'!$E7, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M7>0,'data entry'!M7,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q7>0,$B7=1),'data entry'!Q7,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R7>0,$B7=1),'data entry'!R7,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S7>0,$B7=1),'data entry'!S7,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T7>0,$B7=1),'data entry'!T7,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U7>0,$B7=1),'data entry'!U7,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O7","v":0},null,{"$f":"IF(AND('data entry'!V7>0,$B7=1),'data entry'!V7,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W7>0,$B7=1),'data entry'!W7,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X7>0,$B7=1),'data entry'!X7,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y7>0,$B7=1),'data entry'!Y7,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z7>0,$B7=1),'data entry'!Z7,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O7","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA7:$AE7,\"other\")","v":0}]
[{"$f":"'data entry'!D8","v":7},{"$f":"IF('data entry'!M8=0,\"not completed\",IF('data entry'!M8=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E8>0,'data entry'!$E8, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M8>0,'data entry'!M8,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q8>0,$B8=1),'data entry'!Q8,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R8>0,$B8=1),'data entry'!R8,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S8>0,$B8=1),'data entry'!S8,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T8>0,$B8=1),'data entry'!T8,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U8>0,$B8=1),'data entry'!U8,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O8","v":0},null,{"$f":"IF(AND('data entry'!V8>0,$B8=1),'data entry'!V8,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W8>0,$B8=1),'data entry'!W8,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X8>0,$B8=1),'data entry'!X8,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y8>0,$B8=1),'data entry'!Y8,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z8>0,$B8=1),'data entry'!Z8,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O8","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA8:$AE8,\"other\")","v":0}]
[{"$f":"'data entry'!D9","v":8},{"$f":"IF('data entry'!M9=0,\"not completed\",IF('data entry'!M9=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E9>0,'data entry'!$E9, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M9>0,'data entry'!M9,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q9>0,$B9=1),'data entry'!Q9,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R9>0,$B9=1),'data entry'!R9,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S9>0,$B9=1),'data entry'!S9,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T9>0,$B9=1),'data entry'!T9,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U9>0,$B9=1),'data entry'!U9,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O9","v":0},null,{"$f":"IF(AND('data entry'!V9>0,$B9=1),'data entry'!V9,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W9>0,$B9=1),'data entry'!W9,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X9>0,$B9=1),'data entry'!X9,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y9>0,$B9=1),'data entry'!Y9,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z9>0,$B9=1),'data entry'!Z9,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O9","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA9:$AE9,\"other\")","v":0}]
[{"$f":"'data entry'!D10","v":9},{"$f":"IF('data entry'!M10=0,\"not completed\",IF('data entry'!M10=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E10>0,'data entry'!$E10, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M10>0,'data entry'!M10,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q10>0,$B10=1),'data entry'!Q10,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R10>0,$B10=1),'data entry'!R10,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S10>0,$B10=1),'data entry'!S10,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T10>0,$B10=1),'data entry'!T10,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U10>0,$B10=1),'data entry'!U10,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O10","v":0},null,{"$f":"IF(AND('data entry'!V10>0,$B10=1),'data entry'!V10,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W10>0,$B10=1),'data entry'!W10,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X10>0,$B10=1),'data entry'!X10,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y10>0,$B10=1),'data entry'!Y10,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z10>0,$B10=1),'data entry'!Z10,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O10","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA10:$AE10,\"other\")","v":0}]
[{"$f":"'data entry'!D11","v":10},{"$f":"IF('data entry'!M11=0,\"not completed\",IF('data entry'!M11=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E11>0,'data entry'!$E11, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M11>0,'data entry'!M11,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q11>0,$B11=1),'data entry'!Q11,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R11>0,$B11=1),'data entry'!R11,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S11>0,$B11=1),'data entry'!S11,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T11>0,$B11=1),'data entry'!T11,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U11>0,$B11=1),'data entry'!U11,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O11","v":0},null,{"$f":"IF(AND('data entry'!V11>0,$B11=1),'data entry'!V11,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W11>0,$B11=1),'data entry'!W11,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X11>0,$B11=1),'data entry'!X11,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y11>0,$B11=1),'data entry'!Y11,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z11>0,$B11=1),'data entry'!Z11,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O11","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA11:$AE11,\"other\")","v":0}]
[{"$f":"'data entry'!D12","v":11},{"$f":"IF('data entry'!M12=0,\"not completed\",IF('data entry'!M12=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E12>0,'data entry'!$E12, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M12>0,'data entry'!M12,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q12>0,$B12=1),'data entry'!Q12,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R12>0,$B12=1),'data entry'!R12,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S12>0,$B12=1),'data entry'!S12,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T12>0,$B12=1),'data entry'!T12,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U12>0,$B12=1),'data entry'!U12,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O12","v":0},null,{"$f":"IF(AND('data entry'!V12>0,$B12=1),'data entry'!V12,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W12>0,$B12=1),'data entry'!W12,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X12>0,$B12=1),'data entry'!X12,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y12>0,$B12=1),'data entry'!Y12,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z12>0,$B12=1),'data entry'!Z12,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O12","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA12:$AE12,\"other\")","v":0}]
[{"$f":"'data entry'!D13","v":12},{"$f":"IF('data entry'!M13=0,\"not completed\",IF('data entry'!M13=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E13>0,'data entry'!$E13, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M13>0,'data entry'!M13,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q13>0,$B13=1),'data entry'!Q13,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R13>0,$B13=1),'data entry'!R13,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S13>0,$B13=1),'data entry'!S13,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T13>0,$B13=1),'data entry'!T13,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U13>0,$B13=1),'data entry'!U13,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O13","v":0},null,{"$f":"IF(AND('data entry'!V13>0,$B13=1),'data entry'!V13,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W13>0,$B13=1),'data entry'!W13,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X13>0,$B13=1),'data entry'!X13,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y13>0,$B13=1),'data entry'!Y13,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z13>0,$B13=1),'data entry'!Z13,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O13","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA13:$AE13,\"other\")","v":0}]
[{"$f":"'data entry'!D14","v":13},{"$f":"IF('data entry'!M14=0,\"not completed\",IF('data entry'!M14=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E14>0,'data entry'!$E14, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M14>0,'data entry'!M14,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q14>0,$B14=1),'data entry'!Q14,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R14>0,$B14=1),'data entry'!R14,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S14>0,$B14=1),'data entry'!S14,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T14>0,$B14=1),'data entry'!T14,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U14>0,$B14=1),'data entry'!U14,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O14","v":0},null,{"$f":"IF(AND('data entry'!V14>0,$B14=1),'data entry'!V14,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W14>0,$B14=1),'data entry'!W14,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X14>0,$B14=1),'data entry'!X14,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y14>0,$B14=1),'data entry'!Y14,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z14>0,$B14=1),'data entry'!Z14,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O14","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA14:$AE14,\"other\")","v":0}]
[{"$f":"'data entry'!D15","v":14},{"$f":"IF('data entry'!M15=0,\"not completed\",IF('data entry'!M15=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E15>0,'data entry'!$E15, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M15>0,'data entry'!M15,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q15>0,$B15=1),'data entry'!Q15,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R15>0,$B15=1),'data entry'!R15,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S15>0,$B15=1),'data entry'!S15,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T15>0,$B15=1),'data entry'!T15,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U15>0,$B15=1),'data entry'!U15,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O15","v":0},null,{"$f":"IF(AND('data entry'!V15>0,$B15=1),'data entry'!V15,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W15>0,$B15=1),'data entry'!W15,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X15>0,$B15=1),'data entry'!X15,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y15>0,$B15=1),'data entry'!Y15,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z15>0,$B15=1),'data entry'!Z15,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O15","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA15:$AE15,\"other\")","v":0}]
[{"$f":"'data entry'!D16","v":15},{"$f":"IF('data entry'!M16=0,\"not completed\",IF('data entry'!M16=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E16>0,'data entry'!$E16, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M16>0,'data entry'!M16,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q16>0,$B16=1),'data entry'!Q16,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R16>0,$B16=1),'data entry'!R16,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S16>0,$B16=1),'data entry'!S16,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T16>0,$B16=1),'data entry'!T16,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U16>0,$B16=1),'data entry'!U16,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O16","v":0},null,{"$f":"IF(AND('data entry'!V16>0,$B16=1),'data entry'!V16,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W16>0,$B16=1),'data entry'!W16,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X16>0,$B16=1),'data entry'!X16,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y16>0,$B16=1),'data entry'!Y16,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z16>0,$B16=1),'data entry'!Z16,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O16","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA16:$AE16,\"other\")","v":0}]
[{"$f":"'data entry'!D17","v":16},{"$f":"IF('data entry'!M17=0,\"not completed\",IF('data entry'!M17=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E17>0,'data entry'!$E17, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M17>0,'data entry'!M17,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q17>0,$B17=1),'data entry'!Q17,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R17>0,$B17=1),'data entry'!R17,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S17>0,$B17=1),'data entry'!S17,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T17>0,$B17=1),'data entry'!T17,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U17>0,$B17=1),'data entry'!U17,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O17","v":0},null,{"$f":"IF(AND('data entry'!V17>0,$B17=1),'data entry'!V17,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W17>0,$B17=1),'data entry'!W17,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X17>0,$B17=1),'data entry'!X17,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y17>0,$B17=1),'data entry'!Y17,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z17>0,$B17=1),'data entry'!Z17,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O17","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA17:$AE17,\"other\")","v":0}]
[{"$f":"'data entry'!D18","v":17},{"$f":"IF('data entry'!M18=0,\"not completed\",IF('data entry'!M18=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E18>0,'data entry'!$E18, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M18>0,'data entry'!M18,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q18>0,$B18=1),'data entry'!Q18,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R18>0,$B18=1),'data entry'!R18,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S18>0,$B18=1),'data entry'!S18,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T18>0,$B18=1),'data entry'!T18,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U18>0,$B18=1),'data entry'!U18,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O18","v":0},null,{"$f":"IF(AND('data entry'!V18>0,$B18=1),'data entry'!V18,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W18>0,$B18=1),'data entry'!W18,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X18>0,$B18=1),'data entry'!X18,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y18>0,$B18=1),'data entry'!Y18,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z18>0,$B18=1),'data entry'!Z18,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O18","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA18:$AE18,\"other\")","v":0}]
[{"$f":"'data entry'!D19","v":18},{"$f":"IF('data entry'!M19=0,\"not completed\",IF('data entry'!M19=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E19>0,'data entry'!$E19, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M19>0,'data entry'!M19,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q19>0,$B19=1),'data entry'!Q19,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R19>0,$B19=1),'data entry'!R19,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S19>0,$B19=1),'data entry'!S19,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T19>0,$B19=1),'data entry'!T19,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U19>0,$B19=1),'data entry'!U19,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O19","v":0},null,{"$f":"IF(AND('data entry'!V19>0,$B19=1),'data entry'!V19,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W19>0,$B19=1),'data entry'!W19,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X19>0,$B19=1),'data entry'!X19,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y19>0,$B19=1),'data entry'!Y19,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z19>0,$B19=1),'data entry'!Z19,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O19","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA19:$AE19,\"other\")","v":0}]
[{"$f":"'data entry'!D20","v":19},{"$f":"IF('data entry'!M20=0,\"not completed\",IF('data entry'!M20=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E20>0,'data entry'!$E20, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M20>0,'data entry'!M20,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q20>0,$B20=1),'data entry'!Q20,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R20>0,$B20=1),'data entry'!R20,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S20>0,$B20=1),'data entry'!S20,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T20>0,$B20=1),'data entry'!T20,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U20>0,$B20=1),'data entry'!U20,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O20","v":0},null,{"$f":"IF(AND('data entry'!V20>0,$B20=1),'data entry'!V20,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W20>0,$B20=1),'data entry'!W20,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X20>0,$B20=1),'data entry'!X20,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y20>0,$B20=1),'data entry'!Y20,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z20>0,$B20=1),'data entry'!Z20,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O20","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA20:$AE20,\"other\")","v":0}]
[{"$f":"'data entry'!D21","v":20},{"$f":"IF('data entry'!M21=0,\"not completed\",IF('data entry'!M21=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E21>0,'data entry'!$E21, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M21>0,'data entry'!M21,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q21>0,$B21=1),'data entry'!Q21,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R21>0,$B21=1),'data entry'!R21,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S21>0,$B21=1),'data entry'!S21,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T21>0,$B21=1),'data entry'!T21,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U21>0,$B21=1),'data entry'!U21,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O21","v":0},null,{"$f":"IF(AND('data entry'!V21>0,$B21=1),'data entry'!V21,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W21>0,$B21=1),'data entry'!W21,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X21>0,$B21=1),'data entry'!X21,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y21>0,$B21=1),'data entry'!Y21,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z21>0,$B21=1),'data entry'!Z21,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O21","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA21:$AE21,\"other\")","v":0}]
[{"$f":"'data entry'!D22","v":21},{"$f":"IF('data entry'!M22=0,\"not completed\",IF('data entry'!M22=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E22>0,'data entry'!$E22, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M22>0,'data entry'!M22,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q22>0,$B22=1),'data entry'!Q22,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R22>0,$B22=1),'data entry'!R22,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S22>0,$B22=1),'data entry'!S22,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T22>0,$B22=1),'data entry'!T22,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U22>0,$B22=1),'data entry'!U22,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O22","v":0},null,{"$f":"IF(AND('data entry'!V22>0,$B22=1),'data entry'!V22,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W22>0,$B22=1),'data entry'!W22,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X22>0,$B22=1),'data entry'!X22,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y22>0,$B22=1),'data entry'!Y22,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z22>0,$B22=1),'data entry'!Z22,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O22","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA22:$AE22,\"other\")","v":0}]
[{"$f":"'data entry'!D23","v":22},{"$f":"IF('data entry'!M23=0,\"not completed\",IF('data entry'!M23=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E23>0,'data entry'!$E23, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M23>0,'data entry'!M23,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q23>0,$B23=1),'data entry'!Q23,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R23>0,$B23=1),'data entry'!R23,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S23>0,$B23=1),'data entry'!S23,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T23>0,$B23=1),'data entry'!T23,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U23>0,$B23=1),'data entry'!U23,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O23","v":0},null,{"$f":"IF(AND('data entry'!V23>0,$B23=1),'data entry'!V23,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W23>0,$B23=1),'data entry'!W23,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X23>0,$B23=1),'data entry'!X23,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y23>0,$B23=1),'data entry'!Y23,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z23>0,$B23=1),'data entry'!Z23,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O23","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA23:$AE23,\"other\")","v":0}]
[{"$f":"'data entry'!D24","v":23},{"$f":"IF('data entry'!M24=0,\"not completed\",IF('data entry'!M24=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E24>0,'data entry'!$E24, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M24>0,'data entry'!M24,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q24>0,$B24=1),'data entry'!Q24,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R24>0,$B24=1),'data entry'!R24,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S24>0,$B24=1),'data entry'!S24,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T24>0,$B24=1),'data entry'!T24,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U24>0,$B24=1),'data entry'!U24,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O24","v":0},null,{"$f":"IF(AND('data entry'!V24>0,$B24=1),'data entry'!V24,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W24>0,$B24=1),'data entry'!W24,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X24>0,$B24=1),'data entry'!X24,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y24>0,$B24=1),'data entry'!Y24,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z24>0,$B24=1),'data entry'!Z24,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O24","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA24:$AE24,\"other\")","v":0}]
[{"$f":"'data entry'!D25","v":24},{"$f":"IF('data entry'!M25=0,\"not completed\",IF('data entry'!M25=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E25>0,'data entry'!$E25, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M25>0,'data entry'!M25,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q25>0,$B25=1),'data entry'!Q25,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R25>0,$B25=1),'data entry'!R25,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S25>0,$B25=1),'data entry'!S25,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T25>0,$B25=1),'data entry'!T25,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U25>0,$B25=1),'data entry'!U25,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O25","v":0},null,{"$f":"IF(AND('data entry'!V25>0,$B25=1),'data entry'!V25,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W25>0,$B25=1),'data entry'!W25,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X25>0,$B25=1),'data entry'!X25,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y25>0,$B25=1),'data entry'!Y25,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z25>0,$B25=1),'data entry'!Z25,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O25","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA25:$AE25,\"other\")","v":0}]
[{"$f":"'data entry'!D26","v":25},{"$f":"IF('data entry'!M26=0,\"not completed\",IF('data entry'!M26=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E26>0,'data entry'!$E26, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M26>0,'data entry'!M26,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q26>0,$B26=1),'data entry'!Q26,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R26>0,$B26=1),'data entry'!R26,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S26>0,$B26=1),'data entry'!S26,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T26>0,$B26=1),'data entry'!T26,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U26>0,$B26=1),'data entry'!U26,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O26","v":0},null,{"$f":"IF(AND('data entry'!V26>0,$B26=1),'data entry'!V26,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W26>0,$B26=1),'data entry'!W26,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X26>0,$B26=1),'data entry'!X26,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y26>0,$B26=1),'data entry'!Y26,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z26>0,$B26=1),'data entry'!Z26,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O26","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA26:$AE26,\"other\")","v":0}]
[{"$f":"'data entry'!D27","v":26},{"$f":"IF('data entry'!M27=0,\"not completed\",IF('data entry'!M27=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E27>0,'data entry'!$E27, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M27>0,'data entry'!M27,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q27>0,$B27=1),'data entry'!Q27,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R27>0,$B27=1),'data entry'!R27,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S27>0,$B27=1),'data entry'!S27,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T27>0,$B27=1),'data entry'!T27,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U27>0,$B27=1),'data entry'!U27,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O27","v":0},null,{"$f":"IF(AND('data entry'!V27>0,$B27=1),'data entry'!V27,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W27>0,$B27=1),'data entry'!W27,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X27>0,$B27=1),'data entry'!X27,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y27>0,$B27=1),'data entry'!Y27,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z27>0,$B27=1),'data entry'!Z27,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O27","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA27:$AE27,\"other\")","v":0}]
[{"$f":"'data entry'!D28","v":27},{"$f":"IF('data entry'!M28=0,\"not completed\",IF('data entry'!M28=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E28>0,'data entry'!$E28, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M28>0,'data entry'!M28,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q28>0,$B28=1),'data entry'!Q28,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R28>0,$B28=1),'data entry'!R28,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S28>0,$B28=1),'data entry'!S28,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T28>0,$B28=1),'data entry'!T28,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U28>0,$B28=1),'data entry'!U28,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O28","v":0},null,{"$f":"IF(AND('data entry'!V28>0,$B28=1),'data entry'!V28,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W28>0,$B28=1),'data entry'!W28,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X28>0,$B28=1),'data entry'!X28,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y28>0,$B28=1),'data entry'!Y28,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z28>0,$B28=1),'data entry'!Z28,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O28","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA28:$AE28,\"other\")","v":0}]
[{"$f":"'data entry'!D29","v":28},{"$f":"IF('data entry'!M29=0,\"not completed\",IF('data entry'!M29=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E29>0,'data entry'!$E29, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M29>0,'data entry'!M29,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q29>0,$B29=1),'data entry'!Q29,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R29>0,$B29=1),'data entry'!R29,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S29>0,$B29=1),'data entry'!S29,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T29>0,$B29=1),'data entry'!T29,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U29>0,$B29=1),'data entry'!U29,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O29","v":0},null,{"$f":"IF(AND('data entry'!V29>0,$B29=1),'data entry'!V29,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W29>0,$B29=1),'data entry'!W29,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X29>0,$B29=1),'data entry'!X29,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y29>0,$B29=1),'data entry'!Y29,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z29>0,$B29=1),'data entry'!Z29,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O29","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA29:$AE29,\"other\")","v":0}]
[{"$f":"'data entry'!D30","v":29},{"$f":"IF('data entry'!M30=0,\"not completed\",IF('data entry'!M30=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E30>0,'data entry'!$E30, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M30>0,'data entry'!M30,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q30>0,$B30=1),'data entry'!Q30,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R30>0,$B30=1),'data entry'!R30,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S30>0,$B30=1),'data entry'!S30,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T30>0,$B30=1),'data entry'!T30,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U30>0,$B30=1),'data entry'!U30,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O30","v":0},null,{"$f":"IF(AND('data entry'!V30>0,$B30=1),'data entry'!V30,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W30>0,$B30=1),'data entry'!W30,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X30>0,$B30=1),'data entry'!X30,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y30>0,$B30=1),'data entry'!Y30,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z30>0,$B30=1),'data entry'!Z30,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O30","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA30:$AE30,\"other\")","v":0}]
[{"$f":"'data entry'!D31","v":30},{"$f":"IF('data entry'!M31=0,\"not completed\",IF('data entry'!M31=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E31>0,'data entry'!$E31, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M31>0,'data entry'!M31,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q31>0,$B31=1),'data entry'!Q31,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R31>0,$B31=1),'data entry'!R31,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S31>0,$B31=1),'data entry'!S31,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T31>0,$B31=1),'data entry'!T31,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U31>0,$B31=1),'data entry'!U31,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O31","v":0},null,{"$f":"IF(AND('data entry'!V31>0,$B31=1),'data entry'!V31,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W31>0,$B31=1),'data entry'!W31,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X31>0,$B31=1),'data entry'!X31,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y31>0,$B31=1),'data entry'!Y31,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z31>0,$B31=1),'data entry'!Z31,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O31","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA31:$AE31,\"other\")","v":0}]
[{"$f":"'data entry'!D32","v":31},{"$f":"IF('data entry'!M32=0,\"not completed\",IF('data entry'!M32=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E32>0,'data entry'!$E32, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M32>0,'data entry'!M32,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q32>0,$B32=1),'data entry'!Q32,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R32>0,$B32=1),'data entry'!R32,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S32>0,$B32=1),'data entry'!S32,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T32>0,$B32=1),'data entry'!T32,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U32>0,$B32=1),'data entry'!U32,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O32","v":0},null,{"$f":"IF(AND('data entry'!V32>0,$B32=1),'data entry'!V32,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W32>0,$B32=1),'data entry'!W32,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X32>0,$B32=1),'data entry'!X32,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y32>0,$B32=1),'data entry'!Y32,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z32>0,$B32=1),'data entry'!Z32,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O32","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA32:$AE32,\"other\")","v":0}]
[{"$f":"'data entry'!D33","v":32},{"$f":"IF('data entry'!M33=0,\"not completed\",IF('data entry'!M33=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E33>0,'data entry'!$E33, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M33>0,'data entry'!M33,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q33>0,$B33=1),'data entry'!Q33,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R33>0,$B33=1),'data entry'!R33,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S33>0,$B33=1),'data entry'!S33,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T33>0,$B33=1),'data entry'!T33,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U33>0,$B33=1),'data entry'!U33,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O33","v":0},null,{"$f":"IF(AND('data entry'!V33>0,$B33=1),'data entry'!V33,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W33>0,$B33=1),'data entry'!W33,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X33>0,$B33=1),'data entry'!X33,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y33>0,$B33=1),'data entry'!Y33,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z33>0,$B33=1),'data entry'!Z33,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O33","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA33:$AE33,\"other\")","v":0}]
[{"$f":"'data entry'!D34","v":33},{"$f":"IF('data entry'!M34=0,\"not completed\",IF('data entry'!M34=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E34>0,'data entry'!$E34, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M34>0,'data entry'!M34,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q34>0,$B34=1),'data entry'!Q34,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R34>0,$B34=1),'data entry'!R34,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S34>0,$B34=1),'data entry'!S34,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T34>0,$B34=1),'data entry'!T34,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U34>0,$B34=1),'data entry'!U34,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O34","v":0},null,{"$f":"IF(AND('data entry'!V34>0,$B34=1),'data entry'!V34,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W34>0,$B34=1),'data entry'!W34,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X34>0,$B34=1),'data entry'!X34,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y34>0,$B34=1),'data entry'!Y34,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z34>0,$B34=1),'data entry'!Z34,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O34","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA34:$AE34,\"other\")","v":0}]
[{"$f":"'data entry'!D35","v":34},{"$f":"IF('data entry'!M35=0,\"not completed\",IF('data entry'!M35=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E35>0,'data entry'!$E35, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M35>0,'data entry'!M35,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q35>0,$B35=1),'data entry'!Q35,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R35>0,$B35=1),'data entry'!R35,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S35>0,$B35=1),'data entry'!S35,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T35>0,$B35=1),'data entry'!T35,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U35>0,$B35=1),'data entry'!U35,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O35","v":0},null,{"$f":"IF(AND('data entry'!V35>0,$B35=1),'data entry'!V35,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W35>0,$B35=1),'data entry'!W35,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X35>0,$B35=1),'data entry'!X35,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y35>0,$B35=1),'data entry'!Y35,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z35>0,$B35=1),'data entry'!Z35,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O35","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA35:$AE35,\"other\")","v":0}]
[{"$f":"'data entry'!D36","v":35},{"$f":"IF('data entry'!M36=0,\"not completed\",IF('data entry'!M36=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E36>0,'data entry'!$E36, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M36>0,'data entry'!M36,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q36>0,$B36=1),'data entry'!Q36,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R36>0,$B36=1),'data entry'!R36,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S36>0,$B36=1),'data entry'!S36,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T36>0,$B36=1),'data entry'!T36,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U36>0,$B36=1),'data entry'!U36,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O36","v":0},null,{"$f":"IF(AND('data entry'!V36>0,$B36=1),'data entry'!V36,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W36>0,$B36=1),'data entry'!W36,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X36>0,$B36=1),'data entry'!X36,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y36>0,$B36=1),'data entry'!Y36,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z36>0,$B36=1),'data entry'!Z36,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O36","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA36:$AE36,\"other\")","v":0}]
[{"$f":"'data entry'!D37","v":36},{"$f":"IF('data entry'!M37=0,\"not completed\",IF('data entry'!M37=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E37>0,'data entry'!$E37, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M37>0,'data entry'!M37,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q37>0,$B37=1),'data entry'!Q37,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R37>0,$B37=1),'data entry'!R37,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S37>0,$B37=1),'data entry'!S37,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T37>0,$B37=1),'data entry'!T37,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U37>0,$B37=1),'data entry'!U37,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O37","v":0},null,{"$f":"IF(AND('data entry'!V37>0,$B37=1),'data entry'!V37,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W37>0,$B37=1),'data entry'!W37,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X37>0,$B37=1),'data entry'!X37,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y37>0,$B37=1),'data entry'!Y37,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z37>0,$B37=1),'data entry'!Z37,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O37","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA37:$AE37,\"other\")","v":0}]
[{"$f":"'data entry'!D38","v":37},{"$f":"IF('data entry'!M38=0,\"not completed\",IF('data entry'!M38=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E38>0,'data entry'!$E38, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M38>0,'data entry'!M38,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q38>0,$B38=1),'data entry'!Q38,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R38>0,$B38=1),'data entry'!R38,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S38>0,$B38=1),'data entry'!S38,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T38>0,$B38=1),'data entry'!T38,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U38>0,$B38=1),'data entry'!U38,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O38","v":0},null,{"$f":"IF(AND('data entry'!V38>0,$B38=1),'data entry'!V38,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W38>0,$B38=1),'data entry'!W38,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X38>0,$B38=1),'data entry'!X38,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y38>0,$B38=1),'data entry'!Y38,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z38>0,$B38=1),'data entry'!Z38,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O38","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA38:$AE38,\"other\")","v":0}]
[{"$f":"'data entry'!D39","v":38},{"$f":"IF('data entry'!M39=0,\"not completed\",IF('data entry'!M39=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E39>0,'data entry'!$E39, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M39>0,'data entry'!M39,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q39>0,$B39=1),'data entry'!Q39,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R39>0,$B39=1),'data entry'!R39,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S39>0,$B39=1),'data entry'!S39,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T39>0,$B39=1),'data entry'!T39,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U39>0,$B39=1),'data entry'!U39,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O39","v":0},null,{"$f":"IF(AND('data entry'!V39>0,$B39=1),'data entry'!V39,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W39>0,$B39=1),'data entry'!W39,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X39>0,$B39=1),'data entry'!X39,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y39>0,$B39=1),'data entry'!Y39,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z39>0,$B39=1),'data entry'!Z39,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O39","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA39:$AE39,\"other\")","v":0}]
[{"$f":"'data entry'!D40","v":39},{"$f":"IF('data entry'!M40=0,\"not completed\",IF('data entry'!M40=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E40>0,'data entry'!$E40, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M40>0,'data entry'!M40,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q40>0,$B40=1),'data entry'!Q40,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R40>0,$B40=1),'data entry'!R40,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S40>0,$B40=1),'data entry'!S40,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T40>0,$B40=1),'data entry'!T40,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U40>0,$B40=1),'data entry'!U40,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O40","v":0},null,{"$f":"IF(AND('data entry'!V40>0,$B40=1),'data entry'!V40,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W40>0,$B40=1),'data entry'!W40,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X40>0,$B40=1),'data entry'!X40,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y40>0,$B40=1),'data entry'!Y40,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z40>0,$B40=1),'data entry'!Z40,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O40","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA40:$AE40,\"other\")","v":0}]
[{"$f":"'data entry'!D41","v":40},{"$f":"IF('data entry'!M41=0,\"not completed\",IF('data entry'!M41=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E41>0,'data entry'!$E41, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M41>0,'data entry'!M41,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q41>0,$B41=1),'data entry'!Q41,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R41>0,$B41=1),'data entry'!R41,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S41>0,$B41=1),'data entry'!S41,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T41>0,$B41=1),'data entry'!T41,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U41>0,$B41=1),'data entry'!U41,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O41","v":0},null,{"$f":"IF(AND('data entry'!V41>0,$B41=1),'data entry'!V41,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W41>0,$B41=1),'data entry'!W41,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X41>0,$B41=1),'data entry'!X41,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y41>0,$B41=1),'data entry'!Y41,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z41>0,$B41=1),'data entry'!Z41,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O41","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA41:$AE41,\"other\")","v":0}]
[{"$f":"'data entry'!D42","v":0},{"$f":"IF('data entry'!M42=0,\"not completed\",IF('data entry'!M42=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E42>0,'data entry'!$E42, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M42>0,'data entry'!M42,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q42>0,$B42=1),'data entry'!Q42,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R42>0,$B42=1),'data entry'!R42,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S42>0,$B42=1),'data entry'!S42,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T42>0,$B42=1),'data entry'!T42,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U42>0,$B42=1),'data entry'!U42,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O42","v":0},null,{"$f":"IF(AND('data entry'!V42>0,$B42=1),'data entry'!V42,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W42>0,$B42=1),'data entry'!W42,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X42>0,$B42=1),'data entry'!X42,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y42>0,$B42=1),'data entry'!Y42,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z42>0,$B42=1),'data entry'!Z42,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O42","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA42:$AE42,\"other\")","v":0}]
[{"$f":"'data entry'!D43","v":0},{"$f":"IF('data entry'!M43=0,\"not completed\",IF('data entry'!M43=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E43>0,'data entry'!$E43, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M43>0,'data entry'!M43,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q43>0,$B43=1),'data entry'!Q43,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R43>0,$B43=1),'data entry'!R43,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S43>0,$B43=1),'data entry'!S43,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T43>0,$B43=1),'data entry'!T43,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U43>0,$B43=1),'data entry'!U43,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O43","v":0},null,{"$f":"IF(AND('data entry'!V43>0,$B43=1),'data entry'!V43,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W43>0,$B43=1),'data entry'!W43,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X43>0,$B43=1),'data entry'!X43,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y43>0,$B43=1),'data entry'!Y43,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z43>0,$B43=1),'data entry'!Z43,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O43","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA43:$AE43,\"other\")","v":0}]
[{"$f":"'data entry'!D44","v":0},{"$f":"IF('data entry'!M44=0,\"not completed\",IF('data entry'!M44=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E44>0,'data entry'!$E44, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M44>0,'data entry'!M44,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q44>0,$B44=1),'data entry'!Q44,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R44>0,$B44=1),'data entry'!R44,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S44>0,$B44=1),'data entry'!S44,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T44>0,$B44=1),'data entry'!T44,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U44>0,$B44=1),'data entry'!U44,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O44","v":0},null,{"$f":"IF(AND('data entry'!V44>0,$B44=1),'data entry'!V44,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W44>0,$B44=1),'data entry'!W44,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X44>0,$B44=1),'data entry'!X44,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y44>0,$B44=1),'data entry'!Y44,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z44>0,$B44=1),'data entry'!Z44,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O44","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA44:$AE44,\"other\")","v":0}]
[{"$f":"'data entry'!D45","v":0},{"$f":"IF('data entry'!M45=0,\"not completed\",IF('data entry'!M45=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E45>0,'data entry'!$E45, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M45>0,'data entry'!M45,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q45>0,$B45=1),'data entry'!Q45,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R45>0,$B45=1),'data entry'!R45,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S45>0,$B45=1),'data entry'!S45,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T45>0,$B45=1),'data entry'!T45,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U45>0,$B45=1),'data entry'!U45,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O45","v":0},null,{"$f":"IF(AND('data entry'!V45>0,$B45=1),'data entry'!V45,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W45>0,$B45=1),'data entry'!W45,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X45>0,$B45=1),'data entry'!X45,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y45>0,$B45=1),'data entry'!Y45,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z45>0,$B45=1),'data entry'!Z45,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O45","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA45:$AE45,\"other\")","v":0}]
[{"$f":"'data entry'!D46","v":0},{"$f":"IF('data entry'!M46=0,\"not completed\",IF('data entry'!M46=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E46>0,'data entry'!$E46, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M46>0,'data entry'!M46,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q46>0,$B46=1),'data entry'!Q46,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R46>0,$B46=1),'data entry'!R46,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S46>0,$B46=1),'data entry'!S46,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T46>0,$B46=1),'data entry'!T46,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U46>0,$B46=1),'data entry'!U46,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O46","v":0},null,{"$f":"IF(AND('data entry'!V46>0,$B46=1),'data entry'!V46,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W46>0,$B46=1),'data entry'!W46,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X46>0,$B46=1),'data entry'!X46,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y46>0,$B46=1),'data entry'!Y46,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z46>0,$B46=1),'data entry'!Z46,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O46","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA46:$AE46,\"other\")","v":0}]
[{"$f":"'data entry'!D47","v":0},{"$f":"IF('data entry'!M47=0,\"not completed\",IF('data entry'!M47=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E47>0,'data entry'!$E47, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M47>0,'data entry'!M47,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q47>0,$B47=1),'data entry'!Q47,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R47>0,$B47=1),'data entry'!R47,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S47>0,$B47=1),'data entry'!S47,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T47>0,$B47=1),'data entry'!T47,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U47>0,$B47=1),'data entry'!U47,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O47","v":0},null,{"$f":"IF(AND('data entry'!V47>0,$B47=1),'data entry'!V47,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W47>0,$B47=1),'data entry'!W47,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X47>0,$B47=1),'data entry'!X47,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y47>0,$B47=1),'data entry'!Y47,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z47>0,$B47=1),'data entry'!Z47,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O47","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA47:$AE47,\"other\")","v":0}]
[{"$f":"'data entry'!D48","v":0},{"$f":"IF('data entry'!M48=0,\"not completed\",IF('data entry'!M48=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E48>0,'data entry'!$E48, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M48>0,'data entry'!M48,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q48>0,$B48=1),'data entry'!Q48,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R48>0,$B48=1),'data entry'!R48,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S48>0,$B48=1),'data entry'!S48,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T48>0,$B48=1),'data entry'!T48,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U48>0,$B48=1),'data entry'!U48,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O48","v":0},null,{"$f":"IF(AND('data entry'!V48>0,$B48=1),'data entry'!V48,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W48>0,$B48=1),'data entry'!W48,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X48>0,$B48=1),'data entry'!X48,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y48>0,$B48=1),'data entry'!Y48,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z48>0,$B48=1),'data entry'!Z48,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O48","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA48:$AE48,\"other\")","v":0}]
[{"$f":"'data entry'!D49","v":0},{"$f":"IF('data entry'!M49=0,\"not completed\",IF('data entry'!M49=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E49>0,'data entry'!$E49, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M49>0,'data entry'!M49,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q49>0,$B49=1),'data entry'!Q49,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R49>0,$B49=1),'data entry'!R49,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S49>0,$B49=1),'data entry'!S49,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T49>0,$B49=1),'data entry'!T49,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U49>0,$B49=1),'data entry'!U49,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O49","v":0},null,{"$f":"IF(AND('data entry'!V49>0,$B49=1),'data entry'!V49,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W49>0,$B49=1),'data entry'!W49,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X49>0,$B49=1),'data entry'!X49,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y49>0,$B49=1),'data entry'!Y49,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z49>0,$B49=1),'data entry'!Z49,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O49","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA49:$AE49,\"other\")","v":0}]
[{"$f":"'data entry'!D50","v":0},{"$f":"IF('data entry'!M50=0,\"not completed\",IF('data entry'!M50=0,\"not offered\",1))","v":"not completed"},{"$f":"IF('data entry'!$E50>0,'data entry'!$E50, \"not completed\")","v":"not completed"},{"$f":"IF('data entry'!M50>0,'data entry'!M50,\"0\")","v":"0"},{"$f":"IF(AND('data entry'!Q50>0,$B50=1),'data entry'!Q50,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!R50>0,$B50=1),'data entry'!R50,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!S50>0,$B50=1),'data entry'!S50,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!T50>0,$B50=1),'data entry'!T50,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!U50>0,$B50=1),'data entry'!U50,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!O50","v":0},null,{"$f":"IF(AND('data entry'!V50>0,$B50=1),'data entry'!V50,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!W50>0,$B50=1),'data entry'!W50,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!X50>0,$B50=1),'data entry'!X50,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Y50>0,$B50=1),'data entry'!Y50,\"NA\")","v":"NA"},{"$f":"IF(AND('data entry'!Z50>0,$B50=1),'data entry'!Z50,\"NA\")","v":"NA"},"NA","NA","NA","NA","NA",0,0,0,0,0,0,0,{"$f":"'data entry'!$O50","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"contact already known to have chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"contact had a negative test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"contact had a negative test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"contact had a positive test in your service\")","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"contact had a positive test in another service\")","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"contact had a chlamydia test, but result not known\")","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test\")","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"contact not known to have been informed of risk of chlamydia infection\")","v":0},{"$f":"COUNTIF('data entry'!$AA50:$AE50,\"other\")","v":0}]

{"sheet":"output against PN standards","index":5,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[[12,0,12,4],[1,0,1,4],[4,0,4,4],[5,0,5,4],[7,0,7,4],[10,0,10,4],[2,0,2,4],[11,0,11,4]]}
["Period covered: 40 consecutive patients found to be positive from  <enter date>",null,null,null,null,"Patient/HCW reported","Healthcare worker verified"]
["Number of contacts where standard has been achieved of contact's attendance 28 days (20 working days) after date of PN discussion with index patient(a)",null,null,null,null,{"$f":"SUMIF(calculations!$T$2:'calculations'!$T$2001,\">0\")","v":0},{"$f":"SUMIF(calculations!AM2:'calculations'!AM2001,\">0\")","v":0}]
["Number of contacts where attendance has not met the standard of attending a service within 28 days (20 working days) after date of PN discussion with index patient (b)",null,null,null,null,{"$f":"SUM(calculations!U2:U2001)-SUM(calculations!T2:T2001)","v":0},{"$f":"SUM(calculations!AN2:AN2001)-SUM(calculations!AM2:AM2001)","v":0}]
["Number of index cases not offered PN",null,null,null,null,{"$f":"COUNTIF(calculations!$B$2:$B$2001,\"not offered\")","v":0},{"$f":"COUNTIF(calculations!$B$2:$B$2001,\"not offered\")","v":0}]
["Total number of index cases (c)",null,null,null,null,{"$f":"B19","v":0},{"$f":"B19","v":0}]
["Proportion of contacts of index cases that met the standard (contacts that meet the standard/index cases: =a/c)",null,null,null,null,{"$f":"F2/F5","v":{"$error":"#DIV/0!"}},{"$f":"G2/G5","v":{"$error":"#DIV/0!"}}]
["Standard",null,null,null,null,0.6,0.4]
["Difference from standard",null,null,null,null,{"$f":"F6-F7","v":{"$error":"#DIV/0!"}},{"$f":"G6-G7","v":{"$error":"#DIV/0!"}}]
["Total number of contacts (d)",null,null,null,null,{"$f":"SUM('data entry'!$O$2:$O$1997)","v":0},{"$f":"SUM('data entry'!$O$2:$O$1997)","v":0}]
["Total number of contactable contacts (e)",null,null,null,null,{"$f":"SUM('data entry'!$P$2:$P$1997)","v":0},{"$f":"SUM('data entry'!$P$2:$P$1997)","v":0}]
["Proportion of contacts that attended a service (those within and outside the standard of 28 days =(a+b)/d)",null,null,null,null,{"$f":"SUM(calculations!U2:'calculations'!U2001)/SUM(calculations!V2:'calculations'!V2001)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(calculations!AN2:'calculations'!AN2001)/SUM(calculations!AO2:'calculations'!AO2001)","v":{"$error":"#DIV/0!"}}]
["Proportion of contactable contacts that attended a service (those within and outside the standard of 28 days = (a+b)/e)",null,null,null,null,{"$f":"(F2+F3)/F10","v":{"$error":"#DIV/0!"}},{"$f":"(G2+G3)/G10","v":{"$error":"#DIV/0!"}}]
["Average number of days between date of first PN discussion and date of attendance of all contacts with an attendance date (both inside and outside the standard)",null,null,null,null,{"$f":"AVERAGE(calculations!J2:N2001)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(calculations!AC2:AG2001)","v":{"$error":"#DIV/0!"}}," "]
[]
["Positive patients and offer of PN by gender","No of positive patients","No of patients offered PN","% of patients offered PN","No of patients not offered PN","% of patients not offered PN"]
["female",{"$f":"COUNTIF('data entry'!$F$2:'data entry'!$F$1997,\"Female\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$F$2:'data entry'!$F$1997,\"Female\")","v":0},{"$f":"IF(B16=0,0,C16/B16)","v":0},{"$f":"B16-C16","v":0},{"$f":"IF(B16=0,0,E16/B16)","v":0}]
["male",{"$f":"COUNTIF('data entry'!$F$2:'data entry'!$F$1997,\"Male\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$F$2:'data entry'!$F$1997,\"Male\")","v":0},{"$f":"IF(B17=0,0,C17/B17)","v":0},{"$f":"B17-C17","v":0},{"$f":"IF(B17=0,0,E17/B17)","v":0}]
["unknown",{"$f":"COUNTIF('data entry'!$F$2:'data entry'!$F$1997,\"Unknown\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$F$2:'data entry'!$F$1997,\"Unknown\")","v":0},0,0,0]
["total",{"$f":"SUM(B16:B18)","v":0},{"$f":"SUM(C16:C18)","v":0},0,0,0]
[]
[]
["Positive patients and offer of PN by age","No of positive patients","No of patients offered PN","% of patients offered PN","No of patients not offered PN","% of patients not offered PN"]
["<15",{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"<15\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"<15\")","v":0},{"$f":"IF(B23=0,0,C23/B23)","v":0},{"$f":"B23-C23","v":0},{"$f":"IF(B23=0,0,E23/B23)","v":0}]
[15,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"15\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"15\")","v":0},{"$f":"IF(B24=0,0,C24/B24)","v":0},{"$f":"B24-C24","v":0},{"$f":"IF(B24=0,0,E24/B24)","v":0}]
[16,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"16\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"16\")","v":0},{"$f":"IF(B25=0,0,C25/B25)","v":0},0,0]
[17,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"17\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"17\")","v":0},0,0,0]
[18,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"18\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"18\")","v":0},0,{"$f":"B27-C27","v":0},0]
[19,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"19\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"19\")","v":0},0,0,0]
[20,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"20\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"20\")","v":0},0,0,0]
[21,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"21\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"21\")","v":0},0,0,0]
[22,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"22\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"22\")","v":0},0,0,0]
[23,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"23\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"23\")","v":0},0,0,0]
[24,{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\"24\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\"24\")","v":0},0,0,0]
[">24",{"$f":"COUNTIF('data entry'!$G$2:'data entry'!$G$1997,\">24\")","v":0},{"$f":"COUNTIFS('data entry'!$L$2:'data entry'!$L$1997,\"Yes\",'data entry'!$G$2:'data entry'!$G$1997,\">24\")","v":0},0,0,0]
["total",{"$f":"SUM(B23:B34)","v":0},{"$f":"SUM(C23:C34)","v":0},0,{"$f":"B35-C35","v":0},0]
[]
[]
["Reasons for PN not being offered","Number","Proportion (of those not offered PN)"]
["no documented evidence of PN",{"$f":"COUNTIF('data entry'!$N$2:$N$1997,\"no documented evidence of PN\")","v":0},{"$f":"B39/$B$45","v":{"$error":"#DIV/0!"}}]
["patient routinely seen for SH care elsewhere",{"$f":"COUNTIF('data entry'!$N$2:$N$1997,\"patient routinely seen for SH care elsewhere\")","v":0},{"$f":"B40/$B$45","v":{"$error":"#DIV/0!"}}]
["patient transferred care",{"$f":"COUNTIF('data entry'!$N$2:$N$1997,\"patient transferred care\")","v":0},{"$error":"#DIV/0!"}]
["documented that PN performed elsewhere",{"$f":"COUNTIF('data entry'!$N$2:$N$1997,\"documented that PN performed elsewhere\")","v":0},{"$error":"#DIV/0!"}]
["lost to follow up before PN initiated",{"$f":"COUNTIF('data entry'!$N$2:$N$1997,\"lost to follow up before PN initiated\")","v":0},{"$error":"#DIV/0!"}]
["other",{"$f":"COUNTIF('data entry'!$N$2:$N$1997,\"other\")","v":0},{"$error":"#DIV/0!"}]
["total",{"$f":"SUM(B39:B44)","v":0},{"$f":"SUM(C39:C44)","v":{"$error":"#DIV/0!"}}]
[null,"NB this total needs to be the same as cells E17 and E33"]
[]
[]
["PN outcomes","Number","Proportion"]
["contact already known to have chlamydia infection (a)",{"$f":"SUM(calculations!AP2:AP50)","v":0},{"$f":"B50/$B$59","v":{"$error":"#DIV/0!"}}]
["contact had a negative test in your service (b)",{"$f":"SUM(calculations!AQ2:AQ50)","v":0},{"$error":"#DIV/0!"}]
["contact had a negative test in another service ( c )",{"$f":"SUM(calculations!AR2:AR50)","v":0},{"$error":"#DIV/0!"}]
["contact had a positive test in your service (d)",{"$f":"SUM(calculations!AS2:AS50)","v":0},{"$error":"#DIV/0!"}]
["contact had a positive test in another service ( e )",{"$f":"SUM(calculations!AT2:AT50)","v":0},{"$error":"#DIV/0!"}]
["contact had a chlamydia test, but result not known (f)",{"$f":"SUM(calculations!AU2:AU50)","v":0},{"$error":"#DIV/0!"}]
["record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test",{"$f":"SUM(calculations!AV2:AV50)","v":0},{"$error":"#DIV/0!"}]
["contact not known to have been informed of risk of chlamydia infection",{"$f":"SUM(calculations!AW2:AW50)","v":0},{"$error":"#DIV/0!"}]
["other",{"$f":"SUM(calculations!AX2:AX50)","v":0},{"$error":"#DIV/0!"}]
["Total",{"$f":"SUM(B50:B58)","v":0},{"$error":"#DIV/0!"}]
[null,"This total should be the same as in cell F9"]
["total number of new positive contacts (=d+e)",{"$f":"B53+B54","v":0}]
["total number of contacts having had a test (=b+c+d+e+f)",{"$f":"SUM(B51:B55)","v":0}]
["positivity in contacts following PN (incl those with unknown result)",{"$f":"B61/B62","v":{"$error":"#DIV/0!"}}]

{"sheet":"lists","index":6,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Testing service type","Gender","PN offer","No PN reasons","number of partners","number of contactable partners","PN outcome"]
["GUM clinic","Male","Yes","no documented evidence of PN",1,0,"contact already known to have chlamydia infection"]
["SRH/CASH clinic","Female","No","patient routinely seen for SH care elsewhere",2,1,"contact had a negative test in your service"]
["GP","Unknown","Unknown","patient transferred care",3,2,"contact had a negative test in another service"]
["Community Pharmacy",null,null,"documented that PN performed elsewhere",4,3,"contact had a positive test in your service"]
["Remote testing",null,null,"lost to follow up before PN initiated",5,4,"contact had a positive test in another service"]
["CSO",null,null,"other","unknown",5,"contact had a chlamydia test, but result not known"]
["Outreach & education",null,null,null,null,"unknown","record made that contact informed of risk of chlamydia infection, but not known to have had a chlamydia test"]
["Integrated Sexual Health Service",null,null,null,null,null,"contact not known to have been informed of risk of chlamydia infection"]
["Other, incl prison/YOI, military, ToP, gynae, A&E/MIU, antenatal etc",null,null,null,null,null,"other"]