{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Calculator","Data","Report","Temp"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":false,"merged":[[33,1,33,14],[22,1,22,14],[37,1,37,14],[48,1,48,14],[51,1,51,14],[40,1,40,14],[34,1,36,14],[38,1,39,14],[43,1,43,14],[23,1,24,14],[32,1,32,14],[26,1,26,14],[27,1,27,14],[25,1,25,14],[28,1,30,14],[31,1,31,14],[3,1,3,14],[13,1,13,14],[14,1,14,14],[4,1,8,14],[9,1,9,14],[10,1,11,14],[12,1,12,14],[1,1,1,14],[2,1,2,14],[58,1,58,14],[59,1,59,14],[52,1,52,14],[53,1,53,14],[54,1,54,14],[55,1,55,14],[56,1,56,14],[57,1,57,14],[41,1,42,14],[44,1,47,14],[49,1,50,14],[15,1,17,14],[18,1,18,14],[19,1,21,14]]}
[]
[null,"Obare Method Calculator, Version 1.0"]
[]
[null,"Brief description and instructions:"]
[null,"The Obare Method calculator is a Microsoft Excel-based tool developed to facilitate adherence to the recommendations for internal quality control (IQC) defined in the recently released methods manual ‘Microscopy for the detection, identification and quantification of malaria parasites on stained thick and thin blood films in research settings’ (WHO 2015). It enables researchers to make systematic assessments of whether the results of two blood film reads are concordant or require a third read, calculate the mean parasite density of the reads on positive slides, and report consensus results. "]
[]
[]
[]
[]
[]
[null,"To use the Obare Method Calculator, the operator must enter a unique ID for each slide from which data is entered for assessment. The calculator allows the user to select:"]
[]
[]
[null,"- The film type (thick or thin) on which the malaria parasite density was assessed"]
[null,"- Parasite counts as total count (however all detected species must be reported), or separately for each species identified on the film"]
[null,"- Various methods for counting parasites: Thick film – parasites per microlitre, parasite and WBC counts, parasite and number of high power fields (along with field number of the ocular lens and magnification of the objective lens); thin film – parasites per microlitre, parasite and RBC counts"]
[]
[]
[]
[null,"The data entered by the user are recorded on a separate sheet of the excel file. Counts obtained from all reads of a given slide need not be entered at the same time, but the complete data from each read must be entered once it is begun. A list of the slides that require second or third reads can be obtained by clicking the [Generate Report] button."]
[]
[]
[]
[null,"Once at least two reads are entered for a slide, the calculator will display the consensus results if the slide results are concordant or will recommend a third read if it detects discordant results per the following criteria:"]
[]
[]
[null,"- Presence/absence of asexual forms of the parasite only"]
[null,"- Species of the parasites"]
[null,"- At least one of the first or second reads has a density for a particular species above 200 parasites/µL and there is a <10% chance of observing the two read densities if both were random samples from the theoretical probability distribution with mean equal to the average of the first and second read densities"]
[]
[]
[]
[null,"These parasite counts are reported according to the type of films (thick or thin)."]
[]
[null,"In cases where a third read is recommended by the Obare Method Calculator, consensus results are determined per the rules below. If there is species discordance even after three reads (i.e. if the three readers each report different species), the readers should confer with each other to determine the final reported species. "]
[]
[]
[]
[null,"- If one of the new read pairings (Reader 1 and Reader 3 OR Reader 2 and Reader 3) would not require an additional read, then those two reads are used"]
[]
[null,"- If the new pairings both require or both do not require a third read, then all three readings are used"]
[]
[]
[null,"Disclaimer:"]
[null,"Although reasonable care has been taken while developing this calculator, it is recommended that users should test the calculator to ensure that it performs as they expect it to. If any errors or inconsistencies are found, please contact mailto:qaqc@wwarn.org. The developers cannot accept any liability for any loss of data, misreporting, or errors arising as a result of any reliance placed on this calculator. The recommended system requirement is a PC running Windows 7, though earlier Windows operating systems may work if ActiveX controls are enabled."]
[]
[]
[]
[]
[null,"This calculator may be copied, distributed, and generally re-used for non-commercial purposes provided such use includes the appropriate citation/reference: \"Obare Method Calculator v1.0 (2015). Matthew Rosen, Mehul Dhorda, David Bell, Michelle Gatton. www.wwarn.org\""]
[]
[]
[null,"Compiled by:"]
[null,"Matthew Rosen, Intellectual Ventures Laboratory (mrosen@intven.com)"]
[null,"Dr. Michelle Gatton, Queensland University of Technology (m.gatton@qut.edu.au)"]
[null,"Technical support:"]
[null,"Mehul Dhorda, Worldwide Antimalarial Resistance Network (WWARN)"]
[null,"David Bell, Global Good /Intellectual Ventures Laboratory"]
[]
[null,"Concept by, and in memory of, the late Peter Obare of the Kenya Medical Research Institute (KEMRI)."]

{"sheet":"Calculator","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[24,1,24,9],[11,1,19,9],[10,1,10,9],[4,1,6,9],[9,1,9,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[7,1,7,9],[8,1,8,9]]}
[]
[null,"Obare Method Calculator, v1.0"]
[]
[null,"Instructions: "]
[null,"Click the \"Obare Method Calculator\" button below and follow the prompts to enter data. Click the \"Generate Report\" button to create a list of Slide ID's for which additional reads are needed or to view previously entered results. The full data set can be viewed on the \"Data\" tab.",null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,"Note: "]
[null,"This program is intended for use with malaria blood film readings."]

{"sheet":"Data","index":2,"n_rows":4,"n_cols":204,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Obare Method Calculator, v1.0"]
["Data Storage Sheet",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,"Reading 1",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reading 2",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reading 3"]
[null,null,null,null,null,null,null,null,"Mean Reading",null,null,null,null,null,null,"Reading 1 (parasites/uL)",null,null,null,null,null,null,"Reading 2 (parasites/uL)",null,null,null,null,null,null,"Reading 3 (parasites/uL)",null,null,null,null,null,null,"P. falciparum ",null,null,null,null,null,null,null,"P. vivax",null,null,null,null,null,null,null,"P. ovale",null,null,null,null,null,null,null,"P. malariae",null,null,null,null,null,null,null,"P. knowlesi",null,null,null,null,null,null,null,"Uncertain Species",null,null,null,null,null,null,null,"Overall",null,null,null,null,null,null,null,"P. falciparum ",null,null,null,null,null,null,null,"P. vivax",null,null,null,null,null,null,null,"P. ovale",null,null,null,null,null,null,null,"P. malariae",null,null,null,null,null,null,null,"P. knowlesi",null,null,null,null,null,null,null,"Uncertain Species",null,null,null,null,null,null,null,"Overall",null,null,null,null,null,null,null,"P. falciparum ",null,null,null,null,null,null,null,"P. vivax",null,null,null,null,null,null,null,"P. ovale",null,null,null,null,null,null,null,"P. malariae",null,null,null,null,null,null,null,"P. knowlesi",null,null,null,null,null,null,null,"Uncertain Species",null,null,null,null,null,null,null,"Overall"]
["Timestamp","Slide ID","Film Type, Read 1","Film Type, Read 2","Film Type, Read 3","Third Read Needed?","Third Read Performed?","Readings Used","P. falciparum","P. vivax","P. ovale","P. malariae","P. knowlesi","Uncertain Species","Overall","P. falciparum","P. vivax","P. ovale","P. malariae","P. knowlesi","Uncertain Species","Overall","P. falciparum","P. vivax","P. ovale","P. malariae","P. knowlesi","Uncertain Species","Overall","P. falciparum","P. vivax","P. ovale","P. malariae","P. knowlesi","Uncertain Species","Overall","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification","# Parasites","# WBCs","WBC/uL","# RBCs","RBC/uL","HPFs","Field Number","Magnification"]

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

{"sheet":"Temp","index":4,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
["Find Slide ID (B1):","sdf",null,null,null,"warn1",0,null,"thirdArray12",null,null,"thirdArray13",null,null,"thirdArray23"]
[null,null,null,null,null,"warn2",0,null,0,0,null,0,0,null,0,0]
["Go Back Boolean (B3):",null,null,null,null,"warn3",0,null,1,0,null,1,0,null,1,0]
[null,null,null,null,null,"warn4",0,null,2,0,null,2,0,null,2,0]
["Find Entry Boolean (B5):",null,null,null,null,"warn5",0,null,3,0,null,3,0,null,3,0]
[null,null,null,null,null,"warn6",0,null,4,0,null,4,0,null,4,0]
["Confirm Boolean (B7):",null,null,null,null,"warn7",0,null,5,0,null,5,0,null,5,0]
[null,null,null,null,null,"warn8",0,null,6,0,null,6,0,null,6,0]
["Go Back Boolean (B9):",null,null,null,null,"warn9",0]
[null,null,null,null,null,"warn13",0]
["Species click for frm 2 type (B11)","P. ovale Reading",null,null,null,"warn23",0]
[null,null,null,null,null,"warnOut",1]
["Button click to determine species type",2,null,null,null,"warnType1_2",0]
[null,null,null,null,null,"warnType1_3",0]
["Read number (0, 1, 2 = 1st, 2nd, 3rd)",0,null,null,null,"warnType2_3",0]
[null,null,null,null,null,"warnType3",0]
["Multipage value",0,null,null,null,"warnType5",0]
[null,null,null,null,null,"warnType6",0]
["Report Find Boolean",0,null,null,null,"warnType7",0]
[null,null,null,null,null,"warnType8",0]
["Entry Method Type (1 = Species, 2 = Overall)",null,null,null,null,"warnType9",0]
[null,null,null,null,null,"warnType10",0]
[null,null,null,null,null,"warnType11",0]
[null,null,null,null,null,"warnType12",0]
[null,null,null,null,null,"warn2_ovr",0,null,"The 1st and 2nd reads have P <0.05"]
[null,null,null,null,null,"warn13_ovr",0,null,"The 1st and 3rd reads have P <0.05"]
[null,null,null,null,null,"warn23_ovr",0,null,"The 2nd and 3rd reads have P <0.05"]
[null,null,null,null,null,"warn10",0]
[null,null,null,null,null,"warn11",0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,"last clear",0]
[]
[]
[null,null,null,null,null,"warn1","warn1 = No species agreement between 1st and 2nd reads"]
[null,null,null,null,null,"warn2","warn2 = Some pairings in 1st and 2nd reads have P <0.05, call thirdArray(m) to determine which"]
[null,null,null,null,null,"warn3","warn3 = There is no species agreement between the 1st and 3rd or the 2nd and 3rd reads so all three reads are used."]
[null,null,null,null,null,"warn4","warn4 = There is no species agreement between the 1st and 3rd reads and the 2nd and 3rd read would not require another read"]
[null,null,null,null,null,"warn5","warn5 = There is no species agreement between the 2nd and 3rd reads and the 1st and 3rd reads would not require another read"]
[null,null,null,null,null,"warn6","warn6 = Both the 1st and 3rd read pairing and the 2nd and 3rd read pairing would require another read, so all readings are used to calculate mean."]
[null,null,null,null,null,"warn7","warn7 = Both the 1st and 3rd read pairing and the 2nd and 3rd read pairing would not require another read, so all readings are used to calculate mean."]
[null,null,null,null,null,"warn8","warn8 = The 2nd and 3rd read pairings do not require another read and are used to calculate the mean."]
[null,null,null,null,null,"warn9","warn9 =The 1st and 3rd read pairings do not require another read and are used to calculate the mean."]
[null,null,null,null,null,"warn13","warn13 = Some pairings in 1st and 3rd reads have P <0.05, call thirdArray13(m) to determine which"]
[null,null,null,null,null,"warn23","warn23 = Some pairings in 2nd and 3rd reads have P <0.05, call thirdArray23(m) to determine which"]
[null,null,null,null,null,"warnOut"]
[null,null,null,null,null,"warnType1_2","warnType1_2 = \"The 1st and 2nd reads are different read types.\""]
[null,null,null,null,null,"warnType1_3","warnType1_3 = \"The 1st and 3rd reads are different read types.\""]
[null,null,null,null,null,"warnType2_3","warnType2_3 = \"The 2nd and 3rd reads are different read types.\""]
[null,null,null,null,null,"warnType3"]
[null,null,null,null,null,"warnType5"]
[null,null,null,null,null,"warnType6"]
[null,null,null,null,null,"warnType7","warnType7 = There is no species agreement between the 2nd and 3rd read and the 1st read is a different read type, so all reads are used to calculate the mean. Users should confer to determine final readings."]
[null,null,null,null,null,"warnType8","warnType8 = The 2nd and 3rd reads would not require another read and the 1st read is of a different type, so the 2nd and 3rd are used."]
[null,null,null,null,null,"warnType9","warnType9 = The 2nd and 3rd reads would require another read and the 1st read is of a different type, so all reads are used to calculate the mean. Users should confer to determine final readings."]
[null,null,null,null,null,"warnType10","warnType10 = There is no species agreement between the 1st and 3rd read and the 2nd read is a different type so all reads are used to calculate the mean. Users should confer to determine final readings."]
[null,null,null,null,null,"warnType11","warnType11 = The 1st and 3rd reads would not require another read and the 2nd read is of a different type, so the 1st and 3rd are used."]
[null,null,null,null,null,"warnType12","warnType12 = The 1st and 3rd reads would require another read and the 2nd read is of a different type so all reads are used to calculate the mean. Users should confer to determine final readings."]
[]
[]
[]
[null,null,null,null,null,"warn2_ovr","warn2_ovr = \"The 1st and 2nd reads have P <0.05\""]
[null,null,null,null,null,"warn13_ovr","warn13_ovr = \"The 1st and 3rd reads have P <0.05\""]
[null,null,null,null,null,"warn23_ovr","warn23_ovr = \"The 2nd and 3rd reads have P <0.05\""]
[]
[]
[]
[null,null,null,null,null,null,null,null,"'warn23 = Some pairings in 2nd and 3rd reads have P <0.05, call thirdArray23(m) to determine which"]
[]
[null,null,null,null,null,"warn10 = All combinations of reads would require another read, so all are used to calculate the mean."]
[null,null,null,null,null,"warn11 = All combinations of reads would require another read, so all are used to calculate the mean."]