← Back to branch summary

~mortenoh/+junk/dhis2-detailed-import-export

« back to all changes in this revision

Viewing changes to local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/MadhyaPradesh/mtb-c.jsp

  • Committer: larshelge at gmail
  • Date: 2009-03-03 16:46:36 UTC
  • Revision ID: larshelge@gmail.com-20090303164636-2sjlrquo7ib1gf7r
Initial check-in

Show diffs side-by-side

added added

removed removed

Lines of Context:
local/in/dhis-web-reports/src/main/webapp/dhis-web-reports/MadhyaPradesh/mtb-c.jsp
 
1
 
 
2
<%@ page import="java.sql.*" %>
 
3
<%@ page import="com.opensymphony.xwork.util.OgnlValueStack" %>
 
4
 
 
5
<%@ page session="true"%>
 
6
 
 
7
<%
 
8
    Connection con=null;
 
9
            
 
10
    // For finding organisationunit name of selected Orgunit based on Orgunit id
 
11
    Statement st1=null;
 
12
    ResultSet rs1=null;
 
13
      
 
14
    // For finding start date of selected period based on period id
 
15
    Statement st2=null;
 
16
    ResultSet rs2=null;
 
17
    
 
18
    //For finding monthly values
 
19
    Statement st3=null;
 
20
    ResultSet rs3=null;
 
21
    
 
22
    //For finding cumulative values
 
23
    Statement st4=null;
 
24
    ResultSet rs4=null;
 
25
       
 
26
    
 
27
    //For finding district name and id
 
28
    Statement st7=null;
 
29
    ResultSet rs7=null;
 
30
    
 
31
    //For finding state name and id
 
32
    Statement st8=null;
 
33
    ResultSet rs8=null;
 
34
    
 
35
    String userName = "dhis";      
 
36
    String password = "";           
 
37
    String urlForConnection = "jdbc:mysql://localhost/mp_dhis2";
 
38
          
 
39
 
 
40
        OgnlValueStack stack = (OgnlValueStack)request.getAttribute("webwork.valueStack");
 
41
 
 
42
        String selectedId = (String) stack.findValue( "orgUnitId" );
 
43
        int selectedOrgUnitID = Integer.parseInt( selectedId );
 
44
 
 
45
//      int selectedOrgUnitID = 240;
 
46
 
 
47
        
 
48
        String startingDate  = (String) stack.findValue( "startingPeriod" );
 
49
        String endingDate  = (String) stack.findValue( "endingPeriod" );
 
50
 
 
51
//      String startingDate  = "2006-10-01";
 
52
//      String endingDate  = "2006-10-01";
 
53
  
 
54
    
 
55
//      String monthlyPeriodId = (String) stack.findValue( "monthlyPeriodTypeId" );
 
56
//      int periodTypeID = Integer.parseInt( monthlyPeriodId );
 
57
 
 
58
      
 
59
        String selectedOrgUnitName = "";        
 
60
        String selectedDataPeriodStartDate = "";
 
61
                        
 
62
        String monthlyDataElements[] = {
 
63
                                                                                        // Medications  - Category- 1
 
64
                                                                                        "TB_DE1","TB_DE2","TB_DE3",
 
65
 
 
66
                                                                                        // Medications  - Category- 2
 
67
                                                                                        "TB_DE4","TB_DE5","TB_DE6",
 
68
 
 
69
                                                                                        // Medications  - Category- 3                                                                                   
 
70
                                                                                        "TB_DE7","TB_DE8","TB_DE9",
 
71
                                                                                        
 
72
                                                                                        // Medications  - Pouches of Blister Strips
 
73
                                                                                        "TB_DE10","TB_DE11","TB_DE12","TB_DE13","TB_DE14",
 
74
                                                                                        
 
75
                                                                                        // Medications  - INH-300 mg
 
76
                                                                                        "TB_DE15","TB_DE16","TB_DE17","TB_DE18","TB_DE19",
 
77
                                                                                        
 
78
                                                                                        // Medications  - INH-100 mg
 
79
                                                                                        "TB_DE20","TB_DE21","TB_DE22","TB_DE23","TB_DE24",
 
80
                                                                                        
 
81
                                                                                        // Medications  - Streptomycin 0.75 g
 
82
                                                                                        "TB_DE25","TB_DE26","TB_DE27","TB_DE28","TB_DE29",
 
83
                                                                                        
 
84
                                                                                        // Medications  - Rifampicin 150 mg
 
85
                                                                                        "TB_DE30","TB_DE31","TB_DE32","TB_DE33","TB_DE34",
 
86
                                                                                        
 
87
                                                                                        // Medications  - Pyrazinamide
 
88
                                                                                        "TB_DE35","TB_DE36","TB_DE37","TB_DE38","TB_DE39",
 
89
                                                                                        
 
90
                                                                                        // Medications  - Ethambutol 800 mg     
 
91
                                                                                        "TB_DE40","TB_DE41","TB_DE42","TB_DE43","TB_DE44",
 
92
                                                                                        
 
93
                                                                                        // Staff Position and Training - Medical Officer
 
94
                                                                                        "TB_DE45","TB_DE46","TB_DE47",
 
95
                                                                                        
 
96
                                                                                        // Staff Position and Training - Laboratory Technician
 
97
                                                                                        "TB_DE48","TB_DE49","TB_DE50",
 
98
                                                                                        
 
99
                                                                                        // Staff Position and Training - Pharmacist
 
100
                                                                                        "TB_DE51","TB_DE52","TB_DE53",
 
101
                                                                                        
 
102
                                                                                        // Staff Position and Training - MPH Supervisors
 
103
                                                                                        "TB_DE54","TB_DE55","TB_DE56",
 
104
                                                                                        
 
105
                                                                                        // Staff Position and Training - Multipurpose Health Workers
 
106
                                                                                        "TB_DE57","TB_DE58","TB_DE59",
 
107
                                                                                        
 
108
                                                                                        // Staff Position and Training - TBHV
 
109
                                                                                        "TB_DE60","TB_DE61","TB_DE62",
 
110
                                                                                        
 
111
                                                                                        // Staff Position and Training - STLS
 
112
                                                                                        "TB_DE63","TB_DE64","TB_DE65",
 
113
                                                                                        
 
114
                                                                                        // Referral Activities
 
115
                                                                                        "TB_DE66","TB_DE67",
 
116
                                                                                        
 
117
                                                                                        // Microscopy Activities
 
118
                                                                                        "TB_DE68","TB_DE69","TB_DE70","TB_DE71", 
 
119
                                                                                        
 
120
                                                                                        // Treatment Initiation
 
121
                                                                                        "TB_DE72","TB_DE73","TB_DE74","TB_DE75",
 
122
                                                                                        
 
123
                                                                                        "TB_DE76","TB_DE77",
 
124
                                                                                        
 
125
                                                                                        // Consumables - Sputum Containers
 
126
                                                                                        "TB_DE78","TB_DE79","TB_DE80","TB_DE81","TB_DE82",
 
127
                                                                                        
 
128
                                                                                        // Consumables - Slides
 
129
                                                                                        "TB_DE83","TB_DE84","TB_DE85","TB_DE86","TB_DE87",
 
130
                                                                                        
 
131
                                                                                        // Consumables - Carbon Fuchsin
 
132
                                                                                        "TB_DE88","TB_DE89","TB_DE90","TB_DE91","TB_DE92",                                                                                      
 
133
                                                                                        
 
134
                                                                                        // Consumables - Methylene Blue
 
135
                                                                                        "TB_DE93","TB_DE94","TB_DE95","TB_DE96","TB_DE97",
 
136
                                                                                        
 
137
                                                                                        // Consumables - Sulphuric Acid
 
138
                                                                                        "TB_DE98","TB_DE99","TB_DE100","TB_DE101","TB_DE102",
 
139
                                                                                        
 
140
                                                                                        // Consumables - Phenol
 
141
                                                                                        "TB_DE103","TB_DE104","TB_DE105","TB_DE106","TB_DE107",
 
142
                                                                                        
 
143
                                                                                        // Consumables - Xylene
 
144
                                                                                        "TB_DE108","TB_DE109","TB_DE110","TB_DE111","TB_DE112",
 
145
                                                                                        
 
146
                                                                                        // Consumables - Immersion Oil
 
147
                                                                                        "TB_DE113","TB_DE114","TB_DE115","TB_DE116","TB_DE117",
 
148
                                                                                        
 
149
                                                                                        // Consumables - Methylated Spirit
 
150
                                                                                        "TB_DE118","TB_DE119","TB_DE120","TB_DE121","TB_DE122",
 
151
                                                                                        
 
152
                                                                                        // Equipment in Place - Monocular Microscopes
 
153
                                                                                        "TB_DE123","TB_DE124","TB_DE125",
 
154
                                                                                        
 
155
                                                                                        // Equipment in Place - Binocular Microscopes
 
156
                                                                                        "TB_DE126","TB_DE127","TB_DE128"
 
157
                                                                                        
 
158
                                                                                        
 
159
 
 
160
                                                                                        
 
161
                                                                                };
 
162
                                        
 
163
          int monthlyValues[] = new int[monthlyDataElements.length+5];          
 
164
         
 
165
          
 
166
          int CHCID=0;
 
167
          int TalukID=0;
 
168
          int DistrictID=0;
 
169
          int StateID=0;
 
170
          
 
171
          String CHCName="";
 
172
          String TalukName = "";
 
173
          String  DistrictName = "";
 
174
          String StateName = "";
 
175
 
 
176
          int j=1;       
 
177
          int i=1;       
 
178
          int k=0;       
 
179
          int endcount = 0;
 
180
          int p = 0;     
 
181
          int q = 0;
 
182
        
 
183
          String monthNames[] = { "", "January", "February", "March", "April", "May", "June", "July", "August", "September",
 
184
                                                                        "October", "November", "December" };    
 
185
%>
 
186
 
 
187
<%
 
188
 
 
189
     try
 
190
      {
 
191
                Class.forName ("com.mysql.jdbc.Driver").newInstance ();
 
192
                con = DriverManager.getConnection (urlForConnection, userName, password);
 
193
        
 
194
                st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
195
                st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
196
                st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
197
                st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);            
 
198
                st7=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
199
                st8=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);    
 
200
                
 
201
                //rs1 = st1.executeQuery("select shortname from organisationunit  where id = "+selectedOrgUnitID);
 
202
                rs1 = st1.executeQuery("select shortname from organisationunit  where organisationunitid = "+selectedOrgUnitID);        
 
203
                if(rs1.next())        {  selectedOrgUnitName = rs1.getString(1);      }
 
204
                
 
205
//              rs2 = st2.executeQuery("select startDate from period where id = "+selectedDataPeriodID);
 
206
//                      if(rs2.next())    {  selectedDataPeriodStartDate =  rs2.getDate(1).toString();  }                 
 
207
 
 
208
                        selectedDataPeriodStartDate = startingDate;
 
209
                                                
 
210
                        //rs7=st7.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+selectedOrgUnitID+")");
 
211
                        rs7=st7.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+selectedOrgUnitID+")");  
 
212
                        if(rs7.next())  { DistrictID = rs7.getInt(1);DistrictName = rs7.getString(2);  } 
 
213
                        else  {  DistrictID = 0; DistrictName = "";  } 
 
214
 
 
215
                        //rs8=st8.executeQuery("select organisationunit.id, organisationunit.shortname FROM organisationunit WHERE organisationunit.id in ( select organisationunit.parent from organisationunit where organisationunit.id = "+DistrictID+")");
 
216
                        rs8=st8.executeQuery("select organisationunit.organisationunitid, organisationunit.shortname FROM organisationunit WHERE organisationunit.organisationunitid in ( select organisationunit.parentid from organisationunit where organisationunit.organisationunitid = "+DistrictID+")"); 
 
217
                        if(rs8.next())  { StateID = rs8.getInt(1);StateName = rs8.getString(2);  } 
 
218
                        else  {  StateID = 0; StateName = "";  } 
 
219
 
 
220
      } //try block end
 
221
      catch(Exception e)  { out.println(e.getMessage());  }
 
222
      
 
223
     String partsOfDataPeriodStartDate[] = selectedDataPeriodStartDate.split("-");
 
224
     int lastYear = Integer.parseInt(partsOfDataPeriodStartDate[0]) - 1;
 
225
     int tempForMonth1 = Integer.parseInt(partsOfDataPeriodStartDate[1]);
 
226
     int tempForYear = 0;
 
227
     if(tempForMonth1 < 4){   tempForYear = lastYear;  }
 
228
     else  {   tempForYear = lastYear + 1;      }
 
229
     String curYearStart=tempForYear+"-04-01";
 
230
                
 
231
    try
 
232
     {     
 
233
        int count = monthlyDataElements.length;
 
234
        for(i=0;i<count;i++)      
 
235
                        {         
 
236
                                //rs3 = st3.executeQuery("SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataElement = dataelement.id WHERE datavalue.period  in (select id from period where startdate between '"+startingDate+"' and '"+startingDate+"')  AND datavalue.source ="+selectedOrgUnitID+" AND dataelement.code like '"+monthlyDataElements[i]+"'");
 
237
                                rs3 = st3.executeQuery("SELECT sum(datavalue.value) FROM datavalue INNER JOIN dataelement ON datavalue.dataelementid = dataelement.dataelementid WHERE datavalue.periodid  in (select periodid from period where startdate between '"+startingDate+"' and '"+startingDate+"')  AND datavalue.sourceid in (select organisationunitid from organisationunit where organisationunitid in ( select organisationunitid from organisationunit where parentid = "+selectedOrgUnitID+") or organisationunitid = "+selectedOrgUnitID+") AND dataelement.code like '"+monthlyDataElements[i]+"'");                                        
 
238
                        if(rs3.next())          {  monthlyValues[i] =  rs3.getInt(1);   }                                                                       
 
239
                        }
 
240
        } // try block end
 
241
    catch(Exception e)  { out.println(e.getMessage());  }
 
242
    finally
 
243
       {
 
244
                        try
 
245
                        {
 
246
                                if(rs1!=null)  rs1.close();             if(st1!=null)  st1.close();
 
247
                                if(rs2!=null)  rs2.close();             if(st2!=null)  st2.close();                             
 
248
                                if(rs3!=null)  rs3.close();             if(st3!=null)  st3.close();                             
 
249
                                if(rs4!=null)  rs4.close();             if(st4!=null)  st4.close();
 
250
                        
 
251
                                if(rs7!=null)  rs7.close();             if(st7!=null)  st7.close();
 
252
                                if(rs8!=null)  rs8.close();             if(st8!=null)  st8.close();
 
253
                                
 
254
                                if(con!=null)  con.close(); 
 
255
                        }
 
256
                        catch(Exception e)   {  out.println(e.getMessage());   }
 
257
       } // finally block end   
 
258
       
 
259
  %>
 
260
 
 
261
 
 
262
<html>
 
263
        <head>
 
264
                <title>REVISED NATIONAL TUBERCULOSIS CONTROL PROGRAMME</title>          
 
265
        </head>
 
266
        <body >
 
267
          <center> 
 
268
            <FONT face="Arial" size="3"><b><u>REVISED NATIONAL TUBERCULOSIS CONTROL PROGRAMME</u>
 
269
                <br>Monthly Report on Logistics and Microscopy
 
270
                <br><br>Peripheral Health Institution Level</b></font>
 
271
         </center>   
 
272
            <br><FONT face="Arial" size="2"><i>Note: All PHCs/CHCs/Referral Hospitals Major Hospitals/Specially Clinics/TB Hospitals/Medical Colleges to submit their monthly reports in this format.</i>
 
273
            <br><br>Name of Peripheral Health Institution :&nbsp;&nbsp;&nbsp;<%=selectedOrgUnitName%>
 
274
            
 
275
            <table cellpadding="0" cellspacing="0" bgcolor="ffffff" align="left" style="border-style:solid; border-width:0; border-collapse: collapse; padding: 0; position:relative; top:10" bordercolor="#ffffff" width="50%"  border="0">
 
276
                        <tr style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding: 0" bordercolor="#111111" width="100%">
 
277
                                <td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111"  height="23">
 
278
                                <font face="Arial" size="2">TU :&nbsp;&nbsp;</font>
 
279
                                </td>
 
280
                                <td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111"  height="23">
 
281
                                <font face="Arial" size="2">DISTRICT :&nbsp;&nbsp;<%=DistrictName%></font>
 
282
                                </td>   
 
283
                        </tr>
 
284
                        <tr>
 
285
                                <td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111" height="19">
 
286
                                <font face="Arial" size="2">Month : &nbsp;&nbsp;<%=monthNames[Integer.parseInt(partsOfDataPeriodStartDate[1])]%></font>
 
287
                                </td>
 
288
                                <td width="50%" style="border-collapse: collapse; border-left-style: solid; border-left-width: 0; border-right-style: solid; border-right-width: 0; padding-left:15; padding-right:0; padding-top:0; padding-bottom:0" bordercolor="#111111"  height="19">
 
289
                                <font face="Arial" size="2">Year : &nbsp;&nbsp;<%=partsOfDataPeriodStartDate[0]%></font>
 
290
                                </td>
 
291
                </tr>                           
 
292
                </table>  
 
293
            
 
294
                <br><br><br><br><br>
 
295
                <b>Medications</b></font><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
296
        <tr>
 
297
          <td width="20%" align="center"><FONT face="Arial" size="2"><b>Item</b></font></td>
 
298
          <td width="15%" align="center"><FONT face="Arial" size="2"><b>Unit of Measurement</b></font></td>
 
299
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on first day of month<br>(a)</b></font></td>
 
300
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock received during month<br>(b)</b></font></td>
 
301
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Patients initiated on treatment<br>(c)</b></font></td>
 
302
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on last day of month<br>(d) = a+b+c</b></font></td>
 
303
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Quantity Requested<p>(e) = (cx2)-d</b></font></td>
 
304
        </tr>
 
305
        <tr>
 
306
          <td width="20%"><FONT face="Arial" size="2">Category I</font></td>
 
307
          <td width="15%"><FONT face="Arial" size="2">Boxes</font></td>
 
308
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[0]%></font>&nbsp;</td>
 
309
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[1]%></font>&nbsp;</td>
 
310
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[2]%></font>&nbsp;</td>
 
311
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=(monthlyValues[0]+monthlyValues[1]-monthlyValues[2])%></font>&nbsp;</td>
 
312
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=((monthlyValues[2]*2)-(monthlyValues[0]+monthlyValues[1]-monthlyValues[2]))%></font>&nbsp;</td>
 
313
        </tr>
 
314
        <tr>
 
315
          <td width="20%"><FONT face="Arial" size="2">Category II</font></td>
 
316
          <td width="15%"><FONT face="Arial" size="2">Boxes</font></td>
 
317
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[3]%></font>&nbsp;</td>
 
318
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[4]%></font>&nbsp;</td>
 
319
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[5]%></font>&nbsp;</td>
 
320
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=(monthlyValues[3]+monthlyValues[4]-monthlyValues[5])%></font>&nbsp;</td>
 
321
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=((monthlyValues[5]*2)-(monthlyValues[3]+monthlyValues[4]-monthlyValues[5]))%></font>&nbsp;</td>
 
322
        </tr>
 
323
        <tr>
 
324
          <td width="20%"><FONT face="Arial" size="2">Category III</font></td>
 
325
          <td width="15%"><FONT face="Arial" size="2">Boxes</font></td>
 
326
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[6]%></font>&nbsp;</td>
 
327
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[7]%></font>&nbsp;</td>
 
328
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[8]%></font>&nbsp;</td>
 
329
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=(monthlyValues[6]+monthlyValues[7]-monthlyValues[8])%></font>&nbsp;</td>
 
330
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=((monthlyValues[8]*2)-(monthlyValues[6]+monthlyValues[7]-monthlyValues[8]))%></font>&nbsp;</td>
 
331
        </tr>
 
332
      </table>
 
333
      
 
334
      <br>
 
335
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
336
        <tr>
 
337
          <td width="20%" align="center"><FONT face="Arial" size="2"><b>Item</b></font></td>
 
338
          <td width="15%" align="center"><FONT face="Arial" size="2"><b>Unit of Measurement</b></font></td>
 
339
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on first day of month</b></font></td>
 
340
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock received during month</b></font></td>
 
341
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Consumption during month</b></font></td>
 
342
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on last day of month</b></font></td>
 
343
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Quantity Requested</b></font></td>
 
344
        </tr>
 
345
        <tr>
 
346
          <td width="20%"><FONT face="Arial" size="2">Pouches of blister strips for prolongation of intensive phase</font></td>
 
347
          <td width="15%"><FONT face="Arial" size="2">Pouches each with 12 blister strips</font></td>
 
348
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[9]%></font>&nbsp;</td>
 
349
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[10]%></font>&nbsp;</td>
 
350
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[11]%></font>&nbsp;</td>
 
351
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[12]%></font>&nbsp;</td>
 
352
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[13]%></font>&nbsp;</td>
 
353
        </tr>
 
354
        <tr>
 
355
          <td width="20%"><FONT face="Arial" size="2">INH 300 mg</font></td>
 
356
          <td width="15%"><FONT face="Arial" size="2">Tablets</font></td>
 
357
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[14]%></font>&nbsp;</td>
 
358
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[15]%></font>&nbsp;</td>
 
359
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[16]%></font>&nbsp;</td>
 
360
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[17]%></font>&nbsp;</td>
 
361
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[18]%></font>&nbsp;</td>
 
362
        </tr>
 
363
        <tr>
 
364
          <td width="20%"><FONT face="Arial" size="2">INH 100 mg</font></td>
 
365
          <td width="15%"><FONT face="Arial" size="2">Tablets</font></td>
 
366
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[19]%></font>&nbsp;</td>
 
367
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[20]%></font>&nbsp;</td>
 
368
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[21]%></font>&nbsp;</td>
 
369
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[22]%></font>&nbsp;</td>
 
370
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[23]%></font>&nbsp;</td>
 
371
        </tr>
 
372
        <tr>
 
373
          <td width="20%"><FONT face="Arial" size="2">Streptomycin 0.75g</font></td>
 
374
          <td width="15%"><FONT face="Arial" size="2">Vials</font></td>
 
375
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[24]%></font>&nbsp;</td>
 
376
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[25]%></font>&nbsp;</td>
 
377
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[26]%></font>&nbsp;</td>
 
378
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[27]%></font>&nbsp;</td>
 
379
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[28]%></font>&nbsp;</td>
 
380
        </tr>
 
381
        <tr>
 
382
          <td width="20%"><FONT face="Arial" size="2">Rifampicin 150 mg</font></td>
 
383
          <td width="15%"><FONT face="Arial" size="2">Capsules</font></td>
 
384
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[29]%></font>&nbsp;</td>
 
385
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[30]%></font>&nbsp;</td>
 
386
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[31]%></font>&nbsp;</td>
 
387
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[32]%></font>&nbsp;</td>
 
388
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[33]%></font>&nbsp;</td>
 
389
        </tr>
 
390
        <tr>
 
391
          <td width="20%"><FONT face="Arial" size="2">Pyrazinamide 500mg</font></td>
 
392
          <td width="15%"><FONT face="Arial" size="2">Tablets</font></td>
 
393
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[34]%></font>&nbsp;</td>
 
394
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[35]%></font>&nbsp;</td>
 
395
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[36]%></font>&nbsp;</td>
 
396
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[37]%></font>&nbsp;</td>
 
397
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[38]%></font>&nbsp;</td>
 
398
        </tr>
 
399
        <tr>
 
400
          <td width="20%"><FONT face="Arial" size="2">Ethambutol 800mg</font></td>
 
401
          <td width="15%"><FONT face="Arial" size="2">Tablets</font></td>
 
402
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[39]%></font>&nbsp;</td>
 
403
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[40]%></font>&nbsp;</td>
 
404
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[41]%></font>&nbsp;</td>
 
405
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[42]%></font>&nbsp;</td>
 
406
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[43]%></font>&nbsp;</td>
 
407
        </tr>
 
408
      </table>
 
409
      
 
410
      <br>
 
411
      <font face="Arial" size="2"><b>Staff Position and Training</b></font>
 
412
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
413
        <tr>
 
414
          <td width="25%" align="center"><FONT face="Arial" size="2"><b>Category of staff</b></font></td>
 
415
          <td width="25%" align="center"><FONT face="Arial" size="2"><b>Sanctioned</b></font></td>
 
416
          <td width="25%" align="center"><FONT face="Arial" size="2"><b>In Place</b></font></td>
 
417
          <td width="25%" align="center"><FONT face="Arial" size="2"><b>Trained in RNTCP</b></font></td>
 
418
        </tr>
 
419
        <tr>
 
420
          <td width="25%"><FONT face="Arial" size="2">Medical Officer</font></td>
 
421
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[44]%></font>&nbsp;</td>
 
422
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[45]%></font>&nbsp;</td>
 
423
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[46]%></font>&nbsp;</td>
 
424
        </tr>
 
425
        <tr>
 
426
          <td width="25%"><FONT face="Arial" size="2">Laboratory Techician</font></td>
 
427
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[47]%></font>&nbsp;</td>
 
428
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[48]%></font>&nbsp;</td>
 
429
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[49]%></font>&nbsp;</td>
 
430
        </tr>
 
431
        <tr>
 
432
          <td width="25%"><FONT face="Arial" size="2">Pharmacist</font></td>
 
433
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[50]%></font>&nbsp;</td>
 
434
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[51]%></font>&nbsp;</td>
 
435
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[52]%></font>&nbsp;</td>
 
436
        </tr>
 
437
        <tr>
 
438
          <td width="25%"><FONT face="Arial" size="2">MPH Supervisors</font></td>
 
439
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[53]%></font>&nbsp;</td>
 
440
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[54]%></font>&nbsp;</td>
 
441
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[55]%></font>&nbsp;</td>
 
442
        </tr>
 
443
        <tr>
 
444
          <td width="25%"><FONT face="Arial" size="2">Multipurpose Health Workers</font></td>
 
445
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[56]%></font>&nbsp;</td>
 
446
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[57]%></font>&nbsp;</td>
 
447
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[58]%></font>&nbsp;</td>
 
448
        </tr>
 
449
        <tr>
 
450
          <td width="25%"><FONT face="Arial" size="2">TBHV</font></td>
 
451
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[59]%></font>&nbsp;</td>
 
452
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[60]%></font>&nbsp;</td>
 
453
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[61]%></font>&nbsp;</td>
 
454
        </tr>
 
455
        <tr>
 
456
          <td width="25%"><FONT face="Arial" size="2">STLS*</font></td>
 
457
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[62]%></font>&nbsp;</td>
 
458
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[63]%></font>&nbsp;</td>
 
459
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[64]%></font>&nbsp;</td>
 
460
        </tr>
 
461
      </table>
 
462
      <FONT face="Arial" size="2">*STLS to be reported by medical colleges only</font>
 
463
      <br><br>
 
464
      <FONT face="Arial" size="2"><b>Referral Activities (To be filled in by all PHIs fom OPD Register)</b></font>
 
465
      
 
466
          <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
467
        <tr>
 
468
          <td width="80%"><FONT face="Arial" size="2">a. Number of new adult outpatient visits</font></td>
 
469
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[65]%></font>&nbsp;</td>
 
470
        </tr>
 
471
        <tr>
 
472
          <td width="80%"><FONT face="Arial" size="2">b. Out of (a), number of chest symptomatic patients referred for sputum examination</font></td>
 
473
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[66]%></font>&nbsp;</td>
 
474
        </tr>
 
475
      </table>
 
476
      <br><br><br>
 
477
      <FONT face="Arial" size="2"><b>Microscopy Activities (To be filled in by only PHIs which are a DMC from Laboratory Register)</b></font>            
 
478
          <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
479
        <tr>
 
480
          <td width="80%"><FONT face="Arial" size="2">c. Number of TB suspects whose sputum was examined for diagnosis</font></td>
 
481
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[67]%></font>&nbsp;</td>
 
482
        </tr>
 
483
        <tr>
 
484
          <td width="80%"><FONT face="Arial" size="2">d. Out of (c) number of smear positive patients diagnosed</font></td>
 
485
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[68]%></font>&nbsp;</td>
 
486
        </tr>
 
487
        <tr>
 
488
          <td width="80%"><FONT face="Arial" size="2">e. Number of TB suspects subjected to repeat sputum examination for diagnosis</font></td>
 
489
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[69]%></font>&nbsp;</td>
 
490
        </tr>
 
491
        <tr>
 
492
          <td width="80%"><FONT face="Arial" size="2">f. Out of (e), number of sputum smear positive patients diagnosed</font></td>
 
493
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[70]%></font>&nbsp;</td>
 
494
        </tr>
 
495
        <tr>
 
496
          <td width="80%"><FONT face="Arial" size="2">g. Total number of sputum smear positive patients diagnosed (d + f)</font></td>
 
497
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=(monthlyValues[68]+monthlyValues[70])%></font>&nbsp;</td>
 
498
        </tr>
 
499
      </table>
 
500
          
 
501
          <br>        
 
502
      <FONT face="Arial" size="2"><b>Treatment Initiation (To be filled in by only PHIs which are a DMC from Laboratory Register and Referral for Treatment</b></font>            
 
503
          <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
504
        <tr>
 
505
          <td width="80%"><FONT face="Arial" size="2">h. Of the smear-positive patients diagnosed (g), number put on DOTS</font></td>
 
506
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[71]%></font>&nbsp;</td>
 
507
        </tr>
 
508
        <tr>
 
509
          <td width="80%"><FONT face="Arial" size="2">i. Of the number of smear-positive patients diagnosed (g), number put on RNTCP Non-DOTS (ND1 and ND2)</font></td>
 
510
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[72]%></font>&nbsp;</td>
 
511
        </tr>
 
512
        <tr>
 
513
          <td width="80%"><FONT face="Arial" size="2">j. Of the smear-positive patients diagnosed (g), the number referred for treatment to other TUs within the district</font></td>
 
514
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[73]%></font>&nbsp;</td>
 
515
        </tr>
 
516
        <tr>
 
517
          <td width="80%"><FONT face="Arial" size="2">k. Of the smear-positive patients diagnosed (g), the number referred for treatment outside the district</font></td>
 
518
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[74]%></font>&nbsp;</td>
 
519
        </tr>
 
520
      </table>
 
521
      <br>
 
522
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
523
        <tr>
 
524
          <td width="80%"><FONT face="Arial" size="2">Number of smear negative patients residing within the district and put on treatment other than DOTS</font></td>
 
525
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[75]%></font>&nbsp;</td>
 
526
        </tr>
 
527
        <tr>
 
528
          <td width="80%"><FONT face="Arial" size="2">Number of extrapulmonary patients residing within the district and put on treatment other than DOTS</font></td>
 
529
          <td width="20%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[76]%></font>&nbsp;</td>
 
530
        </tr>
 
531
          </table>
 
532
          <br>
 
533
      <FONT face="Arial" size="2"><b>Consumables (To be filled in by only PHIs which are a DMC)</b></font>
 
534
      <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
535
        <tr>
 
536
          <td width="20%" align="center"><FONT face="Arial" size="2"><b>Item</b></font></td>
 
537
          <td width="15%" align="center"><FONT face="Arial" size="2"><b>Unit of Measurement</b></font></td>
 
538
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on first day of Month</b></font></td>
 
539
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock received during Month</b></font></td>
 
540
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Consumption during Month*</b></font></td>
 
541
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Stock on last day of Month</b></font></td>
 
542
          <td width="13%" align="center"><FONT face="Arial" size="2"><b>Quantity Requested</b></font></td>
 
543
        </tr>
 
544
        <tr>
 
545
          <td width="20%"><FONT face="Arial" size="2">Sputum containers</font></td>
 
546
          <td width="15%"><FONT face="Arial" size="2">Nos.</font></td>
 
547
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[77]%></font>&nbsp;</td>
 
548
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[78]%></font>&nbsp;</td>
 
549
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[79]%></font>&nbsp;</td>
 
550
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[80]%></font>&nbsp;</td>
 
551
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[81]%></font>&nbsp;</td>
 
552
        </tr>
 
553
        <tr>
 
554
          <td width="20%"><FONT face="Arial" size="2">Slides</font></td>
 
555
          <td width="15%"><FONT face="Arial" size="2">Nos.</font></td>
 
556
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[82]%></font>&nbsp;</td>
 
557
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[83]%></font>&nbsp;</td>
 
558
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[84]%></font>&nbsp;</td>
 
559
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[85]%></font>&nbsp;</td>
 
560
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[86]%></font>&nbsp;</td>
 
561
        </tr>
 
562
        <tr>
 
563
          <td width="20%"><FONT face="Arial" size="2">Carbon Fuchsin</font></td>
 
564
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
565
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[87]%></font>&nbsp;</td>
 
566
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[88]%></font>&nbsp;</td>
 
567
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[89]%></font>&nbsp;</td>
 
568
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[90]%></font>&nbsp;</td>
 
569
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[91]%></font>&nbsp;</td>
 
570
        </tr>
 
571
        <tr>
 
572
          <td width="20%"><FONT face="Arial" size="2">Methylene Blue</font></td>
 
573
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
574
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[92]%></font>&nbsp;</td>
 
575
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[93]%></font>&nbsp;</td>
 
576
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[94]%></font>&nbsp;</td>
 
577
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[95]%></font>&nbsp;</td>
 
578
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[96]%></font>&nbsp;</td>
 
579
        </tr>
 
580
        <tr>
 
581
          <td width="20%"><FONT face="Arial" size="2">Sulphuric Acid</font></td>
 
582
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
583
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[97]%></font>&nbsp;</td>
 
584
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[98]%></font>&nbsp;</td>
 
585
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[99]%></font>&nbsp;</td>
 
586
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[100]%></font>&nbsp;</td>
 
587
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[101]%></font>&nbsp;</td>
 
588
        </tr>
 
589
        <tr>
 
590
          <td width="20%"><FONT face="Arial" size="2">Phenol</font></td>
 
591
          <td width="15%"><FONT face="Arial" size="2">Grams</font></td>
 
592
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[102]%></font>&nbsp;</td>
 
593
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[103]%></font>&nbsp;</td>
 
594
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[104]%></font>&nbsp;</td>
 
595
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[105]%></font>&nbsp;</td>
 
596
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[106]%></font>&nbsp;</td>
 
597
        </tr>
 
598
        <tr>
 
599
          <td width="20%"><FONT face="Arial" size="2">Xylene</font></td>
 
600
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
601
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[107]%></font>&nbsp;</td>
 
602
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[108]%></font>&nbsp;</td>
 
603
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[109]%></font>&nbsp;</td>
 
604
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[110]%></font>&nbsp;</td>
 
605
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[111]%></font>&nbsp;</td>
 
606
        </tr>
 
607
        <tr>
 
608
          <td width="20%"><FONT face="Arial" size="2">Immersion Oil</font></td>
 
609
          <td width="15%"><FONT face="Arial" size="2">ml</font></td>
 
610
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[112]%></font>&nbsp;</td>
 
611
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[113]%></font>&nbsp;</td>
 
612
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[114]%></font>&nbsp;</td>
 
613
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[115]%></font>&nbsp;</td>
 
614
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[116]%></font>&nbsp;</td>
 
615
        </tr>
 
616
        <tr>
 
617
          <td width="20%"><FONT face="Arial" size="2">Methylated Spirit</font></td>
 
618
          <td width="15%"><FONT face="Arial" size="2">Litres</font></td>
 
619
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[117]%></font>&nbsp;</td>
 
620
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[118]%></font>&nbsp;</td>
 
621
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[119]%></font>&nbsp;</td>
 
622
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[120]%></font>&nbsp;</td>
 
623
          <td width="13%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[121]%></font>&nbsp;</td>
 
624
        </tr>
 
625
          </table>
 
626
          <br>
 
627
          <FONT face="Arial" size="2"><b>Equipment in place</b></font>
 
628
          <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
 
629
        <tr>
 
630
          <td width="25%" align="center"><b><font face="Arial" size="2">Item</font></b></td>
 
631
          <td width="25%" align="center"><b><font face="Arial" size="2">Number in place</font></b></td>
 
632
          <td width="25%" align="center"><b><font face="Arial" size="2">In working condition</font></b></td>
 
633
          <td width="25%" align="center"><b><font face="Arial" size="2">Not in working condition</font></b></td>
 
634
        </tr>
 
635
        <tr>
 
636
          <td width="25%"><font face="Arial" size="2">Monocular microscopes</font></td>
 
637
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[122]%></font>&nbsp;</td>
 
638
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[123]%></font>&nbsp;</td>
 
639
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[124]%></font>&nbsp;</td>
 
640
        </tr>
 
641
        <tr>
 
642
          <td width="25%"><font face="Arial" size="2">Binocular microscopes</font></td>
 
643
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[125]%></font>&nbsp;</td>
 
644
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[126]%></font>&nbsp;</td>
 
645
          <td width="25%" align="center"><FONT face="Arial" size="2"><%=monthlyValues[127]%></font>&nbsp;</td>
 
646
        </tr>
 
647
          </table>
 
648
          <FONT face="Arial" size="2">*PHIs that are not a DMC, but have been supplied with sputum ontainers, should complete this row.
 
649
          <br><br><br><b>Name of officer reporting (in Capital Letters):
 
650
          <br><br>Signature:
 
651
          <br><br>Date:
 
652
          </b></font>
 
653
        </body>
 
654
</html>
 
 
b'\\ No newline at end of file'