{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Input Data","Patients","Actions","Antibiotic","Lookups"],"not_rendered":{"charts":18,"images":1,"macros":0,"external_links":0,"defined_names":28,"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":"Instructions","index":0,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[[22,1,24,1],[25,1,29,1],[31,1,35,1],[36,1,44,1],[49,1,49,5],[14,1,14,2],[14,3,14,5],[15,1,15,19],[16,1,16,19],[14,7,14,12],[11,1,11,19],[10,1,10,19],[12,1,12,19],[13,1,13,19],[0,1,0,12],[0,16,0,19],[4,1,6,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.sapg.scot/"]
[]
[null,"Scottish Reduction in Antimicrobial Prescribing 2 (ScRAP 2) Acute Urinary Tract Infection Audit Tool"]
[]
[null,"Welcome to the national tool developed by the Scottish Antimicrobial Prescribing Group (SAPG) for the audit of primary care management of acute urinary tract infections.  The tool is intended to provide prescribers with qualitative information on their prescribing of antibiotics.  The results will facilitate reflective learning on the processes leading up to the decision to prescribe antibiotics in patients with an acute UTI.  The tool will allow prescribers to compare their prescribing decisions with local guidance and will support identification of areas for quality improvement.  "]
[]
[]
[]
[]
[null,"Guidance"]
[null,"Use a new workbook for each audit period."]
[null,"Identify patients who have been prescribed UTI antibiotics during the audit period (trimethoprim, nitrofurantoin, coamoxiclav, cefalexin, fosfomycin, pivmecillinam, ciprofloxacin, ofloxacin)."]
[null,"Restrospectively audit the management of those who have been treated for acute episodes of UTI."]
[null,"Suggested minimum audit period is 1 month (average practice) or 50 patients (NB the maximum number of patients that can be audited in any period is 1000)."]
[null,"Audit against the",null,"PHE Quick Reference Guide ",null,null,"or the ","SAPG Management of Suspected UTI in People over 65 years",null,null,null,null,null," "]
[null,"Where a patient was prescribed a UTI antibiotic more than once in the audit period, a separate row should be completed for each prescription."]
[null,"A paper based form can be downloaded from the SAPG website to allow consultation details to be recorded by hand for entry into this tool at a later date."]
[]
[]
[null,"Data Entry Instructions"]
[null,"Enter consultation data in the Input Data worksheet.  Enter data for every column (unless marked as optional below) in a separate row for each patient."]
[null,"Complete/select data according to the options below:"]
[null,"Audit details",1,"Practice ID",null,null,null,null,"Optional: give an ID that is relevant to you"]
[null,null,2,"Auditor ID",null,null,null,null,"Optional: give an ID that is relevant to you"]
[null,null,3,"Audit date range",null,null,null,null,"Optional: note the date or period when you did the audit"]
[null,"Patients",4,"Prescriber ID",null,null,null,null,"Optional: give an ID that is relevant to you"]
[null,null,5,"Patient ID",null,null,null,null,"Optional: give an ID that is relevant to you"]
[null,null,6,"Age range",null,null,null,null,"Select from age bands"]
[null,null,7,"Care home resident?",null,null,null,null,"Select Yes/No"]
[null,null,8,"Receiving antibiotic prophylaxis?",null,null,null,null,"Select Yes/No"]
[null,null,9,"UTI type",null,null,null,null,"Select the appropriate option"]
[null,"Actions",10,"Consultation type",null,null,null,null,"Select the appropriate option"]
[null,null,11,"Dipstick required/done",null,null,null,null,"Select the appropriate option"]
[null,null,12,"Reason dipstick not in line with guidance",null,null,null,null,"Options displayed are dependent on previous question.  Complete Q11 then Q12"]
[null,null,13,"Culture required/done",null,null,null,null,"Select the appropriate option"]
[null,null,14,"Reason culture not in line with guidance",null,null,null,null,"Options displayed are dependent on previous question.  Complete Q13 then 14"]
[null,"Antibiotic",15,"Was an antibiotic  required?",null,null,null,null,"Yes/No/Unknown"]
[null,null,16,"Reason why antibiotic not required",null,null,null,null,"Options displayed are dependent on previous question.  Complete Q15 then 16"]
[null,null,17,"Which antibiotic prescribed",null,null,null,null,"Select the appropriate option"]
[null,null,18,"Choice of antibiotic appropriate?",null,null,null,null,"Select Yes/No"]
[null,null,19,"Reason choice inappropriate ",null,null,null,null,"Options displayed are dependent on previous question.  Complete Q18 then 19"]
[null,null,20,"Dose appropriate?",null,null,null,null,"Select the appropriate option"]
[null,null,21,"Frequency appropriate?",null,null,null,null,"Select the appropriate option"]
[null,null,22,"Duration appropriate?",null,null,null,null,"Select the appropriate option"]
[null,null,23,"Delayed?",null,null,null,null,"Select the appropriate option"]
[null,"Comments",24,"Additional comments ",null,null,null,null,"Add any additional information e.g. drug name if not in list, or anything else relevant to you"]
[]
[]
[null,"Reports"]
[null,"Reports are automatically generated in the tabs:",null,null,null,null,"Patients","Actions","Antibiotic"]

{"sheet":"Input Data","index":1,"n_rows":1003,"n_cols":25,"rows_kept":1003,"cut":false,"hidden":false,"merged":[[0,4,0,9],[0,10,0,14],[0,15,0,23],[0,1,0,3]]}
["Topic","Audit details",null,null,"Patient",null,null,null,null,null,"Actions",null,null,null,null,"Antibiotic prescription",null,null,null,null,null,null,null,null,"Comments"]
["Q",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Case","Practice ID","Auditor ID","Audit date range","Prescriber ID","Patient ID","Age range","Care home resident?","Receiving antibiotic prophylaxis?","UTI type","Consultation type","Dipstick required/done","Reason dipstick not in line with guidance","Culture required/done","Reason culture not in line with guidance","Was an antibiotic required?","Reason why antibiotic not required","Which antibiotic prescribed","Choice of antibiotic appropriate?","Reason choice inappropriate ","Dose appropriate?","Frequency appropriate?","Duration appropriate?","Delayed?","Additional comments "]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]

{"sheet":"Patients","index":2,"n_rows":14,"n_cols":40,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Patient details"]
[]
[]
["Q6","Age range","Count","% of cases",null,null,null,null,null,null,null,null,null,null,"Q7","Care home resident?","Count","% of cases",null,null,null,null,null,null,null,"Q8","Receiving antibiotic prophylaxis?","Count","% of cases",null,null,null,null,null,null,null,"Q9","UTI type","Count","% of cases"]
[null,"0 to 4 years",{"$f":"COUNTIF('Input Data'!$G$4:$G$1003,Patients!B5)","v":0},{"$f":"(C5/$C$12)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIF('Input Data'!$H$4:$H$1003,Patients!P5)","v":0},{"$f":"(Q5/$Q$7)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIF('Input Data'!$I$4:$I$1003,Patients!AA5)","v":0},{"$f":"(AB5/$AB$7)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Female uncomplicated \n(non-pregnant 14-65yrs) ",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL5)","v":0},{"$f":"(AM5/$AM$14)*100","v":{"$error":"#DIV/0!"}}]
[null,"05 to 13 years",{"$f":"COUNTIF('Input Data'!$G$4:$G$1003,Patients!B6)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIF('Input Data'!$H$4:$H$1003,Patients!P6)","v":0},{"$f":"(Q6/$Q$7)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIF('Input Data'!$I$4:$I$1003,Patients!AA6)","v":0},{"$f":"(AB6/$AB$7)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Older female (>65 years)",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL6)","v":0},{"$f":"(AM6/$AM$14)*100","v":{"$error":"#DIV/0!"}}]
[null,"14 to 29 years",{"$f":"COUNTIF('Input Data'!$G$4:$G$1003,Patients!B7)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q5:Q6)","v":0},{"$f":"SUM(R5:R6)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AB5:AB6)","v":0},{"$f":"SUM(AC5:AC6)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Catheter-associated",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL7)","v":0},{"$error":"#DIV/0!"}]
[null,"30 to 44 years",{"$f":"COUNTIF('Input Data'!$G$4:$G$1003,Patients!B8)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Child (<14 yrs)",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL8)","v":0},{"$error":"#DIV/0!"}]
[null,"45 to 64 years",{"$f":"COUNTIF('Input Data'!$G$4:$G$1003,Patients!B9)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Male ",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL9)","v":0},{"$error":"#DIV/0!"}]
[null,"65 to 79 years",{"$f":"COUNTIF('Input Data'!$G$4:$G$1003,Patients!B10)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pregnancy",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL10)","v":0},{"$error":"#DIV/0!"}]
[null,"80 plus years",{"$f":"COUNTIF('Input Data'!$G$4:$G$1003,Patients!B11)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recurrent (≥2/6mths \nor 3/12mths)",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL11)","v":0},{"$error":"#DIV/0!"}]
[null,"Total",{"$f":"SUM(C5:C11)","v":0},{"$f":"SUM(D5:D11)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper UTI",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL12)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",{"$f":"COUNTIF('Input Data'!$J$4:$J$1003,Patients!AL13)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AM5:AM13)","v":0},{"$f":"SUM(AN5:AN13)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Actions","index":3,"n_rows":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,3],[12,15,12,16],[12,30,12,31],[15,15,17,15],[14,30,17,30]]}
["Details of the action taken"]
[]
[]
["Q10","Consultation type","Count","% of cases",null,null,null,null,null,null,null,null,null,null,null,"Q11","Dipstick required/done","Count","% of cases",null,null,null,null,null,null,null,null,null,null,null,"Q13","Culture required/done","Count","% of cases"]
[null,"Face to face",{"$f":"COUNTIF('Input Data'!K$4:K$1003,Actions!B5)","v":0},{"$f":"(C5/$C$11)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Required and done",{"$f":"COUNTIF('Input Data'!L$4:L$1003,Actions!Q5)","v":0},{"$f":"(R5/$R$10)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Required and done",{"$f":"COUNTIF('Input Data'!N$4:N$1003,Actions!AF5)","v":0},{"$f":"(AG5/$AG$10)*100","v":{"$error":"#DIV/0!"}}]
[null,"Telephone",{"$f":"COUNTIF('Input Data'!K$4:K$1003,Actions!B6)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Not required and not done",{"$f":"COUNTIF('Input Data'!L$4:L$1003,Actions!Q6)","v":0},{"$f":"(R6/$R$10)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Not required and not done",{"$f":"COUNTIF('Input Data'!N$4:N$1003,Actions!AF6)","v":0},{"$f":"(AG6/$AG$10)*100","v":{"$error":"#DIV/0!"}}]
[null,"No contact - issued on \nrequest HCP/patient",{"$f":"COUNTIF('Input Data'!K$4:K$1003,Actions!B7)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Required but not done",{"$f":"COUNTIF('Input Data'!L$4:L$1003,Actions!Q7)","v":0},{"$f":"(R7/$R$10)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Required but not done",{"$f":"COUNTIF('Input Data'!N$4:N$1003,Actions!AF7)","v":0},{"$f":"(AG7/$AG$10)*100","v":{"$error":"#DIV/0!"}}]
[null,"No contact - issued on \nquestionnaire results",{"$f":"COUNTIF('Input Data'!K$4:K$1003,Actions!B8)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Not required but done",{"$f":"COUNTIF('Input Data'!L$4:L$1003,Actions!Q8)","v":0},{"$f":"(R8/$R$10)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Not required but done",{"$f":"COUNTIF('Input Data'!N$4:N$1003,Actions!AF8)","v":0},{"$f":"(AG8/$AG$10)*100","v":{"$error":"#DIV/0!"}}]
[null,"No contact - issued on \nurinalysis results",{"$f":"COUNTIF('Input Data'!K$4:K$1003,Actions!B9)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",{"$f":"COUNTIF('Input Data'!L$4:L$1003,Actions!Q9)","v":0},{"$f":"(R9/$R$10)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",{"$f":"COUNTIF('Input Data'!N$4:N$1003,Actions!AF9)","v":0},{"$f":"(AG9/$AG$10)*100","v":{"$error":"#DIV/0!"}}]
[null,"Unknown",{"$f":"COUNTIF('Input Data'!K$4:K$1003,Actions!B10)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R5:R9)","v":0},{"$f":"SUM(S5:S9)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AG5:AG9)","v":0},{"$f":"SUM(AH5:AH9)","v":{"$error":"#DIV/0!"}}]
[null,"Total",{"$f":"SUM(C5:C10)","v":0},{"$f":"SUM(D5:D10)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q12","Reason dipstick not in line with guidance",null,"Count","% of cases",null,null,null,null,null,null,null,null,null,null,"Q14","Reason culture not in line with guidance",null,"Count","% of cases"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In line","N/A",{"$f":"COUNTIF('Input Data'!M$4:M$1003,Actions!Q14)","v":0},{"$f":"(R14/$R$20)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"In line","N/A",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF14)","v":0},{"$f":"(AG14/$AG$24)*100","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required but not done","Needed to help diagnosis (e.g. \nlimited symptoms/cloudy urine)",{"$f":"COUNTIF('Input Data'!M$4:M$1003,Actions!Q15)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Required but not done","Equivocal dipstick and symptoms",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF15)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not required but done","UTI unlikely (no or mild or ≤2 \nsymptoms and clear urine)",{"$f":"COUNTIF('Input Data'!M$4:M$1003,Actions!Q16)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Persistent/recurrent symptoms",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF16)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Symptoms diagnostic \n(e.g. severe or ≥3 symptoms)",{"$f":"COUNTIF('Input Data'!M$4:M$1003,Actions!Q17)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"UTI type: older, male, catheter, \npregnancy, upper or child",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF17)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dipstick testing unrealiable ",{"$f":"COUNTIF('Input Data'!M$4:M$1003,Actions!Q18)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Risk factors e.g. renal/urinary tract \nabnormality, immunosuppression",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF18)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown","Insufficient information",{"$f":"COUNTIF('Input Data'!M$4:M$1003,Actions!Q19)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Not required but done","UTI unlikely (no or mild or ≤2 \nsymptoms and clear urine)",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF19)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R14:R19)","v":0},{"$f":"SUM(S14:S19)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Symptoms diagnostic \n(e.g. severe or ≥3 symptoms)",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF20)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dipstick testing sufficient",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF21)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown","Insufficient information",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF22)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dipstick required but not done",{"$f":"COUNTIF('Input Data'!O$4:O$1003,Actions!AF23)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AG14:AG23)","v":0},{"$f":"SUM(AH14:AH23)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Antibiotic","index":4,"n_rows":21,"n_cols":60,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,4],[10,1,10,2],[10,30,10,31],[12,30,18,30],[12,1,16,1]]}
["Details of the antibiotic prescription"]
[]
[]
[null,"Q15","Was an antibiotic required?","Count","% of cases",null,null,null,null,null,null,null,null,null,null,"Q17","Which antibiotic prescribed?","Count","% of cases",null,null,null,null,null,null,null,null,null,null,null,"Q18","Choice of antibiotic appropriate?","Count","% of cases",null,null,null,null,null,null,null,null,null,null,"Q20","Dose appropriate?","Count","% of cases",null,null,null,null,null,null,null,null,"Q22","Frequency appropriate?","Count","% of cases"]
[null,null,"Yes",{"$f":"COUNTIF('Input Data'!P$4:P$1003,C5)","v":0},{"$f":"(D5/$D$8)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"Cefalexin",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q5)","v":0},{"$f":"(R5/$R$14)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Yes ",{"$f":"COUNTIF('Input Data'!S$4:S$1003,AF5)","v":0},{"$f":"(AG5/$AG$8)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIF('Input Data'!U$4:U$1003,AT5)","v":0},{"$f":"(AU5/$AU$9)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIF('Input Data'!V$4:V$1003,BF5)","v":0},{"$f":"(BG5/$BG$9)*100","v":{"$error":"#DIV/0!"}}]
[null,null,"No",{"$f":"COUNTIF('Input Data'!P$4:P$1003,C6)","v":0},{"$f":"(D6/$D$8)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"Ciprofloxacin",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q6)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIF('Input Data'!S$4:S$1003,AF6)","v":0},{"$f":"(AG6/$AG$8)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"No: too high",{"$f":"COUNTIF('Input Data'!U$4:U$1003,AT6)","v":0},{"$f":"(AU6/$AU$9)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"No: too frequent",{"$f":"COUNTIF('Input Data'!V$4:V$1003,BF6)","v":0},{"$f":"(BG6/$BG$9)*100","v":{"$error":"#DIV/0!"}}]
[null,null,"Unknown",{"$f":"COUNTIF('Input Data'!P$4:P$1003,C7)","v":0},{"$f":"(D7/$D$8)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"Coamoxiclav",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q7)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",{"$f":"COUNTIF('Input Data'!S$4:S$1003,AF7)","v":0},{"$f":"(AG7/$AG$8)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"No: too low",{"$f":"COUNTIF('Input Data'!U$4:U$1003,AT7)","v":0},{"$f":"(AU7/$AU$9)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"No: too infrequent",{"$f":"COUNTIF('Input Data'!V$4:V$1003,BF7)","v":0},{"$f":"(BG7/$BG$9)*100","v":{"$error":"#DIV/0!"}}]
[null,null,"Total",{"$f":"SUM(D5:D7)","v":0},{"$f":"SUM(E5:E7)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"Fosfomycin",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q8)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AG5:AG7)","v":0},{"$f":"SUM(AH5:AH7)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"N/A",{"$f":"COUNTIF('Input Data'!U$4:U$1003,AT8)","v":0},{"$f":"(AU8/$AU$9)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"N/A",{"$f":"COUNTIF('Input Data'!V$4:V$1003,BF8)","v":0},{"$f":"(BG8/$BG$9)*100","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nitrofurantoin",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q9)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AU5:AU8)","v":0},{"$f":"SUM(AV5:AV8)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(BG5:BG8)","v":0},{"$f":"SUM(BH5:BH8)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ofloxacin",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q10)","v":0},{"$error":"#DIV/0!"}]
["Q16","Reason why antibiotic not required",null,"Count","% of cases",null,null,null,null,null,null,null,null,null,null,null,"Pivmecillinam",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q11)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,"Q19","Reason choice inappropriate ",null,"Count","% of cases"]
[null,"Yes","N/A",{"$f":"COUNTIF('Input Data'!Q$4:Q$1003,C12)","v":0},{"$f":"(D12/$D$19)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"Trimethoprim",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q12)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Yes","N/A",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF12)","v":0},{"$f":"(AG12/$AG$21)*100","v":{"$error":"#DIV/0!"}}]
[null,"No","Symptoms did not support UTI",{"$f":"COUNTIF('Input Data'!Q$4:Q$1003,C13)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Other (state in comments)",{"$f":"COUNTIF('Input Data'!R$4:R$1003,Q13)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"No","Empirical choice not \nin line with guidance",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF13)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,"Q21","Duration appropriate?","Count","% of cases",null,null,null,null,null,null,null,null,"Q23","Delayed?","Count","% of cases"]
[null,null,"Diagnostic tests did not support UTI",{"$f":"COUNTIF('Input Data'!Q$4:Q$1003,C14)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R5:R13)","v":0},{"$f":"SUM(S5:S13)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Choice not in line with available \nculture and sensitivity results ",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF14)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIF('Input Data'!W$4:W$1003,AT14)","v":0},{"$f":"(AU14/$AU$18)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Yes",{"$f":"COUNTIF('Input Data'!X$4:X$1003,BF14)","v":0},{"$f":"(BG14/$BG$17)*100","v":{"$error":"#DIV/0!"}}]
[null,null,"Symptoms and diagnostic \ntests did not support UTI",{"$f":"COUNTIF('Input Data'!Q$4:Q$1003,C15)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doesn't consider recent (12 months) \ntreatment, culture or sensitivities ",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF15)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"No: too long",{"$f":"COUNTIF('Input Data'!W$4:W$1003,AT15)","v":0},{"$f":"(AU15/$AU$18)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"No",{"$f":"COUNTIF('Input Data'!X$4:X$1003,BF15)","v":0},{"$f":"(BG15/$BG$17)*100","v":{"$error":"#DIV/0!"}}]
[null,null,"Insufficent or incorrect \nassessment/testing",{"$f":"COUNTIF('Input Data'!Q$4:Q$1003,C16)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contraindicated e.g. \nallergy/renal interactions",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF16)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"No: too short",{"$f":"COUNTIF('Input Data'!W$4:W$1003,AT16)","v":0},{"$f":"(AU16/$AU$18)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Unknown",{"$f":"COUNTIF('Input Data'!X$4:X$1003,BF16)","v":0},{"$f":"(BG16/$BG$17)*100","v":{"$error":"#DIV/0!"}}]
[null,null,"Alternative approaches could have \nbeen used (e.g. analgesia, delaying)",{"$f":"COUNTIF('Input Data'!Q$4:Q$1003,C17)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternative approaches could have \nbeen used (e.g. analgesia, delaying)",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF17)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"N/A",{"$f":"COUNTIF('Input Data'!W$4:W$1003,AT17)","v":0},{"$f":"(AU17/$AU$18)*100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(BG14:BG16)","v":0},{"$f":"SUM(BH14:BH16)","v":{"$error":"#DIV/0!"}}]
[null,"Unknown","Insufficent information",{"$f":"COUNTIF('Input Data'!Q$4:Q$1003,C18)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antibiotic wasn't required",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF18)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AU14:AU17)","v":0},{"$f":"SUM(AV14:AV17)","v":{"$error":"#DIV/0!"}}]
[null,null,"Total",{"$f":"SUM(D12:D18)","v":0},{"$f":"SUM(E12:E18)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF19)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown","Insufficient information",{"$f":"COUNTIF('Input Data'!T$4:T$1003,AF20)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AG12:AG20)","v":0},{"$f":"SUM(AH12:AH20)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Lookups","index":5,"n_rows":17,"n_cols":25,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,4,0,9],[0,10,0,14],[0,15,0,23],[0,1,0,3]]}
[null,"Audit details",null,null,"Patient",null,null,null,null,null,"Actions",null,null,null,null,"Antibiotic prescription",null,null,null,null,null,null,null,null,"Comments"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Case","Practice ID","Auditor ID","Audit date range","Prescriber ID","Patient ID","Age range","Care home resident?","Receiving antibiotic prophylaxis?","UTI type","Consultation type","Dipstick required/done","Reason dipstick not in line with guidance","Culture required/done","Reason culture not in line with guidance","Was an antibiotic required?","Reason why antibiotic not required","Which antibiotic prescribed","Choice of antibiotic appropriate?","Reason choice inappropriate ","Dose appropriate?","Frequency appropriate?","Duration appropriate?","Delayed?","Additional comments "]
[null,null,null,null,null,null,"0 to 4 years","Yes","Yes","Female uncomplicated \n(non-pregnant 14-65yrs) ","Face to face","Required and done","Required and done or not required and not done","Required and done","Required and done or not required and not done","Yes","Yes","Cefalexin","Yes ","Yes","Yes","Yes","Yes","Yes"]
[null,null,null,null,null,null,"05 to 13 years","No","No","Older female (>65 years)","Telephone","Not required and not done","N/A","Not required and not done","N/A","No","N/A","Ciprofloxacin","No","N/A","No: too high","No: too frequent","No: too long","No"]
[null,null,null,null,null,null,"14 to 29 years",null,null,"Catheter-associated","No contact - issued on \nrequest HCP/patient","Required but not done","Required but not done","Required but not done","Required but not done","Unknown","No","Coamoxiclav","Unknown","No","No: too low","No: too infrequent","No: too short","Unknown"]
[null,null,null,null,null,null,"30 to 44 years",null,null,"Child (<14 yrs)","No contact - issued on \nquestionnaire results","Not required but done","Needed to help diagnosis (e.g. \nlimited symptoms/cloudy urine)","Not required but done","Equivocal dipstick and symptoms",null,"Symptoms did not support UTI","Fosfomycin",null,"Empirical choice not \nin line with guidance","N/A","N/A","N/A"]
[null,null,null,null,null,null,"45 to 64 years",null,null,"Male ","No contact - issued on \nurinalysis results","Unknown","Not required but done","Unknown","Persistent/recurrent symptoms",null,"Diagnostic tests did not support UTI","Nitrofurantoin",null,"Choice not in line with available \nculture and sensitivity results "]
[null,null,null,null,null,null,"65 to 79 years",null,null,"Pregnancy","Unknown",null,"UTI unlikely (no or mild or ≤2 \nsymptoms and clear urine)",null,"UTI type: older, male, catheter, \npregnancy, upper or child",null,"Symptoms and diagnostic \ntests did not support UTI","Ofloxacin",null,"Doesn't consider recent (12 months) \ntreatment, culture or sensitivities "]
[null,null,null,null,null,null,"80 plus years",null,null,"Recurrent (≥2/6mths \nor 3/12mths)",null,null,"Symptoms diagnostic \n(e.g. severe or ≥3 symptoms)",null,"Risk factors e.g. renal/urinary tract \nabnormality, immunosuppression",null,"Insufficent or incorrect \nassessment/testing","Pivmecillinam",null,"Contraindicated e.g. \nallergy/renal interactions"]
[null,null,null,null,null,null,null,null,null,"Upper UTI",null,null,"Dipstick testing unrealiable ",null,"Not required but done",null,"Alternative approaches could have \nbeen used (e.g. analgesia, delaying)","Trimethoprim",null,"Alternative approaches could have \nbeen used (e.g. analgesia, delaying)"]
[null,null,null,null,null,null,null,null,null,"Unknown",null,null,"Unknown",null,"UTI unlikely (no or mild or ≤2 \nsymptoms and clear urine)",null,"Unknown","Other (state in comments)",null,"Antibiotic wasn't required"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Insufficient information",null,"Symptoms diagnostic \n(e.g. severe or ≥3 symptoms)",null,"Insufficent information",null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dipstick testing sufficient",null,null,null,null,"Unknown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",null,null,null,null,"Insufficient information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insufficient information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dipstick required but not done"]