{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["CENTRAL MICRO ","KZN BLOOD CULTURE TENDER","FREESTATE","WESTERN-NORTHERN CAPE","GAUTENG","LIMPOPO-MPUMALANGA","EASTERN CAPE","NORTHWEST","KZN CHEM LARGE"],"not_rendered":{"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"CENTRAL MICRO ","index":0,"n_rows":31,"n_cols":12,"rows_kept":31,"hidden":true}
[null,"call","call"]
[null,"Kroonstad","Pelonomi","Welkom",{"$nulls":5},"Average","Low","High"]
["Micro"]
["Acinetobacter ba",13]
["Citrobacter freu",5]
["Enterobacter aer",1]
["Enterobacter agg",2]
["Enterobacter clo",7]
["Enterobacter spe",13]
["Escherichia coli",101]
["Klebsiella oxyto",15]
["Klebsiella speci",81]
["Proteus mirabili",46]
["Proteus vulgaris",13]
["Providencia rett",1]
["Pseudomonas aeru",41]
["Pseudomonas cepa",1]
["Serratia liquefa",1]
["Serratia marcesc",5]
["Serratia odorife",5]
["Shigella flexner",1]
["GN (Gram negative bacilli)",{"$f":"SUM(B4:B21)","v":352},-500,220]
["Staphylococcus a",127]
["Streptococcus pn",9]
["GP (Gram poitives cocci)",{"$f":"SUM(B23:B24)","v":136},-350,162]
[]
[]
[]
["No of analytes"]
[]
["Total",{"$f":"SUM(B3:B27)","v":976},-850,382,0,0,0,0,0,{"$f":"AVERAGE(B31:I31)","v":{"v":63.5,"d":"64"}},{"$f":"MIN(B31:I31)","v":-850},{"$f":"MAX(B31:I31)","v":976}]

{"sheet":"KZN BLOOD CULTURE TENDER","index":1,"n_rows":70,"n_cols":37,"rows_kept":70,"merged":[[0,2,0,31],[1,0,44,0]]}
[null,null,"KZN LABORATORIES"]
["Blood Culture tender","LAB NAME",null,"Monthly averageAverage","Total per Annum",{"$nulls":25},"Monthly averageAverage","Total per Annum"]
[null,"Hlabisa",1524,127,1524]
[null,"Vryheid",756,63,756]
[null,"Inkosi Albert Luthulli Central hospital",15444,1287,15444]
[null,"King edward Hospital Micro TB",900,75,900]
[null,"King edward Hospital Micro",14400,1200,14400]
[null,"Eshowe",6600,550,6600]
[null,"General Justice Gizenga Mpanza",11400,950,11400]
[null,"Queen Nandi Regional Hospital",6415,534,6415]
[null,"Ngwelezane",8400,700,8400]
[null,"Port Shepston",11686,989,11686]
[null,"Ladysmith",3180,265,3180]
[null,"Madadeni",288,24,288]
[null,"Northdale",25080,2090,25080]
[null,"King Dinizulu Hospital",1717,143,1717]
[null,"R.K. Khan Hospital",9576,798,9576]
[null,"MGHM",7056,588,7056]
[null,"Prince Mshiyeni",14436,1203,14436]
[null,"Addington ",7536,628,7536]
[null,"Dr. Pixley Ka Isaka Seme ",null,220,2640]
[null,"KZN TOTAL",null,{"$f":"SUM(D3:D21)","v":12434},{"$f":"SUM(E3:E21)","v":149034}]
{"$rows_empty":30}
[{"$nulls":26},260,null,null,260,{"$f":"AVERAGE(C53:AD53)","v":260}]
[{"$nulls":26},646,null,null,646,646]
[{"$nulls":26},306,null,null,306,306]
[{"$nulls":26},248,null,null,248,248]
[{"$nulls":26},45,null,null,45,45]
[{"$nulls":26},75,null,null,75,75]
[{"$nulls":23},1370,null,null,3000,null,null,3000,{"v":2456.6666666666665,"d":"2457"},{"$nulls":5},{"$f":"V69/30","v":8285.5}]
[{"$nulls":23},1209,null,null,2300,null,null,2300,{"v":1936.3333333333333,"d":"1936"}]
[{"$nulls":23},567,null,null,2000,null,null,2000,{"v":1522.3333333333333,"d":"1522"}]
[{"$nulls":23},29,null,null,55,null,null,55,{"v":46.333333333333336,"d":"46"}]
[{"$nulls":26},164,null,null,164,164]
[{"$nulls":26},155,null,null,155,155]
[{"$nulls":26},120,null,null,120,120]
[{"$nulls":26},94,null,null,94,94]
[{"$nulls":26},120,null,null,120,120]
[{"$nulls":22},5,53,null,null,46,null,null,46,{"v":37.5,"d":"38"}]
[null,null,28201,19607,19000,17077,17239,18558,47315,35620,18200,12724,22090,42728,13544,15047,19616,45037,55602,76517,80930,248565,88326,86147,227990,60295,73929,42263,71112,112089,{"v":57691.71428571428,"d":"57692"},{"$f":"MIN(C69:R69)","v":12724}]
[null,null,{"$f":"C69/30","v":940.0333333333333},{"$f":"D69/30","v":653.5666666666667},633.3333333333334,569.2333333333333,574.6333333333333,618.6,1577.1666666666667,1187.3333333333333,606.6666666666666,424.1333333333333,736.3333333333334,1424.2666666666667,451.46666666666664,501.56666666666666,653.8666666666667,{"$f":"R69/30","v":1501.2333333333333},{"$f":"S69/30","v":1853.4},{"$f":"T69/30","v":2550.5666666666666},2697.6666666666665,{"$f":"V69/30","v":8285.5},{"$f":"W69/30","v":2944.2},{"$f":"X69/30","v":2871.5666666666666},2040,2009.8333333333333,2464.3,1408.7666666666667,{"$f":"AC69/30","v":2370.4},3145,1923.0571428571427,424.1333333333333]

{"sheet":"FREESTATE","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"merged":[[0,0,43,0]]}
["Blood Culture tender","LAB NAME",null,"Monthly averageAverage","Total per Annum"]
[]
[null,"Pelonomi",9543,732,9543]
[null,"Welkom",3789,291,3789]
[null,"Kroonstad",4677,390,4677]
[null,"Bethlehem",1259,97,1259]
[null,"Manapo",1348,104,1348]
[null,"TOTAL",null,{"$f":"SUM(D2:D7)","v":1614},{"$f":"SUM(E3:E7)","v":20616}]

{"sheet":"WESTERN-NORTHERN CAPE","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"merged":[[0,0,43,0]]}
["Blood Culture tender","LAB NAME",null,"Monthly averageAverage","Total per Annum"]
[null,"GEORGE LABORATORY",null,900,10800]
[null,"GROOTE SCHUUR LABORATORY",null,4000,48000]
[null,"KIMBERLEY LABORATORY",null,610,7320]
[null,"TYGERBERG LABORATORY",null,4500,54000]
[null,"UPINGTON LABORATORY",null,160,1920]
[]
[null,"TOTAL",null,{"$f":"SUM(D2:D7)","v":10170},{"$f":"SUM(E3:E7)","v":111240}]

{"sheet":"GAUTENG","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"merged":[[0,0,43,0]]}
["Blood Culture tender","LAB NAME",null,"Monthly averageAverage","Total per Annum"]
[null,"Charlotte Maxeke ",36000,3000,36000]
[null,"Helen Joseph",33000,2750,33000]
[null,"Chris Hani Baragwanath",66209,5518,66209]
[null,"Dr George Mukhari",23063,1922,23063]
[null,"Tshwane Academic Division ",47088,3924,47088]
[null,"Tambo Memorial",28923,2410,28923]
[null,"Total",null,{"$f":"SUM(D2:D7)","v":19524},{"$f":"SUM(E2:E7)","v":234283}]
{"$rows_empty":9}
[null,"TOTAL",null,{"$f":"SUM(D2:D17)","v":39048},{"$f":"SUM(E3:E17)","v":432566}]

{"sheet":"LIMPOPO-MPUMALANGA","index":5,"n_rows":7,"n_cols":5,"rows_kept":7,"merged":[[0,0,43,0]]}
["Blood Culture tender","LAB NAME",null,"Monthly averageAverage","Total per Annum"]
[null,"ERMELO LABORATORY",null,280,3360]
[null,"POLOKWANE LABORATORY",null,1328,15936]
[null,"ROB FERREIRA LABORATORY",null,1312,15744]
[null,"WITBANK LABORATORY",null,526,6314]
[]
[null,"TOTAL",null,{"$f":"SUM(D2:D6)","v":3446},{"$f":"SUM(E3:E6)","v":37994}]

{"sheet":"EASTERN CAPE","index":6,"n_rows":6,"n_cols":5,"rows_kept":6,"merged":[[0,0,43,0]]}
["Blood Culture tender","LAB NAME",null,"Monthly averageAverage","Total per Annum"]
[null,"Port Elizabeth Micro",null,3000,36000]
[null,"East London Micro",null,850,10200]
[null,"Nelson mandela Academic Micro ",null,2100,25200]
[]
[null,"TOTAL",null,5950,35400]

{"sheet":"NORTHWEST","index":7,"n_rows":7,"n_cols":5,"rows_kept":7,"merged":[[0,0,43,0]]}
["Blood Culture tender","LAB NAME",null,"Monthly averageAverage","Total per Annum"]
[null,"Rustenburg ",null,720,8640]
[null,"Tshepong Culture Aerobic",null,989,11868]
[null,"Tshepong R/M Bld Cult Aerobic No Growth",null,968,11616]
[null,"Mafikeng ",null,167,2004]
[]
[null,"TOTAL",null,{"$f":"SUM(D2:D6)","v":2844},{"$f":"SUM(E3:E6)","v":25488}]

{"sheet":"KZN CHEM LARGE","index":8,"n_rows":60,"n_cols":7,"rows_kept":60,"hidden":true}
[null,24,24,24,24,24,24]
[null,"RKK","PMMH ","Addington ","Edendale ","MGMH","Ngwelezane "]
["UEC"]
["Sodium",10239,9483,9823,6631,6000,5200]
["Potassium",10239,9481,9820,6631,6000,5200]
["Chloride",10239,9750,9942,6631,6000,5200]
["Bicarbonate ",10239,9459,9810,6631,6000,5200]
["Urea",10239,null,null,6631,6000,5200]
["Creatinine",10239,10663,10491,6631,6000,5200]
["LFT"]
["T Prot",6700,6906,6352,3501,3200,4100]
["Alb",6700,6601,6146,4373,3200,4100]
["T Bil",6700,6593,6265,3718,3346,4100]
["D Bil",300,null,null,3496,520,173]
["ALP",6700,6460,6138,4826,3200,4100]
["AST",127]
["ALT",6700,8214,6470,3493,3500,4900]
["GGT",6700,6460,6137,3493,3200,4100]
["Misc"]
["Glucose",1330,1053,4155,299,750,220]
["CRP",{"$nulls":5},63]
["UA",800,550,787,377,250,140]
["Lactate",54,27,221,121,null,25]
["BhCG"]
["CSF/U Prot",185,null,null,68,250,240]
["Trop T",400,{"$nulls":3},370,75]
["D-Dimer"]
["CMP"]
["Calcium",1950,2882,723,2457,1300,1200]
["Magnesium",1950,2456,634,2466,1300,1200]
["Phos",1950,2444,701,2442,1300,1200]
["Lipids"]
["Chol",930,822,509,472,420,900]
["Trig",930,668,53,442,380,700]
["HDL",930,1057,321,null,370,2]
["Enzymes"]
["Amyl",null,342,443,294,500,500]
["LDH",null,1057,321,3497,90,340]
["CK",null,94,634,129,420,100]
["CK-MB",{"$nulls":4},120]
["Gas"]
["Gas"]
["Drugs"]
["Acetamino",50,{"$nulls":3},80]
["Cannabis"]
["Carbamaze",53]
["Phenobarb",12]
["Phenytoin",37,null,39]
["Theoph"]
["VPA",118]
["Tricylic AD"]
["Other"]
["HbA1C",400,{"$nulls":3},400]
["CO2 Content"]
["Cholinesterase"]
["Lipase"]
[]
["No of analytes"]
[]
["Total",{"$f":"SUM(B3:B56)","v":114140},{"$f":"SUM(C4:C59)","v":103522},{"$f":"SUM(D4:D59)","v":96935},{"$f":"SUM(E3:E56)","v":79750},{"$f":"SUM(F3:F56)","v":64466},{"$f":"SUM(G3:G56)","v":63678}]