Dear User:
Below is some information to help you in calculating the indicator which I think will help you get on track to matching the Malawi SPA report.

Questionnaire: Inventory Questionnaire
Indicator: Proportion of all facilities offering malaria diagnosis and/or treatment services
Numerator: Number facilities offering malaria diagnosis and/or treatment services
Interviewer observed RDT being conducted: Q1420(6)=1
OR
Providers in facility diagnose malaria: Q1702=1
OR
Providers in facility prescribe treatment for malaria: Q1710=1
OR
Facility had malaria microscopy capacity
(all components 1,2,and 3)
1. Light microscope used and functioning: Q840(1) B=1 AND Q840(1)C=1
AND
2. Glass slides and covers used: Q840(8)B=1
AND
3. Giemsa Stain, Field Stain, or Acridine Orange stain available: Q847(1)B=1 OR Q847(2)B=1 OR Q847(3)B=1
OR
Facility had RDT capacity
(components 1,2,or 3)
1. Observed RDT kit (malaria section): Q1706=1
OR
2. Observed RDT kit (parasitology section): Q843=1
OR
3. Observed malaria rapid diagnostic testing: Q1420(6)=1

Denominator: Total number of facilities
Total number of facilities interviewed Q006

If you combine this indicator with the measures of training and protocols as shown in the graphic below you should be able to reproduce the estimates from the report.

You can better visualize what is needed using the following graphic