Project

General

Profile

RedmineAttachedFiles » O1.htm

Ashamol E, 2018-02-13 10:22

 
1
<html xmlns:v="urn:schemas-microsoft-com:vml"
2
xmlns:o="urn:schemas-microsoft-com:office:office"
3
xmlns:x="urn:schemas-microsoft-com:office:excel"
4
xmlns="http://www.w3.org/TR/REC-html40">
5

    
6
<head>
7
<meta name="Excel Workbook Frameset">
8
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
9
<meta name=ProgId content=Excel.Sheet>
10
<meta name=Generator content="Microsoft Excel 15">
11
<link rel=File-List href="O1_files/filelist.xml">
12
<![if !supportTabStrip]>
13
<link id="shLink" href="O1_files/sheet001.htm">
14
<link id="shLink" href="O1_files/sheet002.htm">
15
<link id="shLink" href="O1_files/sheet003.htm">
16
<link id="shLink" href="O1_files/sheet004.htm">
17
<link id="shLink" href="O1_files/sheet005.htm">
18
<link id="shLink" href="O1_files/sheet006.htm">
19
<link id="shLink" href="O1_files/sheet007.htm">
20
<link id="shLink" href="O1_files/sheet008.htm">
21
<link id="shLink" href="O1_files/sheet009.htm">
22
<link id="shLink" href="O1_files/sheet010.htm">
23

    
24
<link id="shLink">
25

    
26
<script language="JavaScript">
27
<!--
28
 var c_lTabs=10;
29

    
30
 var c_rgszSh=new Array(c_lTabs);
31
 c_rgszSh[0] = "Summary";
32
 c_rgszSh[1] = "Dashboard-Purchase";
33
 c_rgszSh[2] = "Dashboard-Admin";
34
 c_rgszSh[3] = "Dashboard-IT";
35
 c_rgszSh[4] = "Dashboard-Top?management";
36
 c_rgszSh[5] = "Dashboard-PMO";
37
 c_rgszSh[6] = "Dashboard-People?Function";
38
 c_rgszSh[7] = "Organisational?summary";
39
 c_rgszSh[8] = "Department?wise?objective";
40
 c_rgszSh[9] = "?Consolidated?View";
41

    
42

    
43

    
44
 var c_rgszClr=new Array(8);
45
 c_rgszClr[0]="window";
46
 c_rgszClr[1]="buttonface";
47
 c_rgszClr[2]="windowframe";
48
 c_rgszClr[3]="windowtext";
49
 c_rgszClr[4]="threedlightshadow";
50
 c_rgszClr[5]="threedhighlight";
51
 c_rgszClr[6]="threeddarkshadow";
52
 c_rgszClr[7]="threedshadow";
53

    
54
 var g_iShCur;
55
 var g_rglTabX=new Array(c_lTabs);
56

    
57
function fnGetIEVer()
58
{
59
 var ua=window.navigator.userAgent
60
 var msie=ua.indexOf("MSIE")
61
 if (msie>0 && window.navigator.platform=="Win32")
62
  return parseInt(ua.substring(msie+5,ua.indexOf(".", msie)));
63
 else
64
  return 0;
65
}
66

    
67
function fnBuildFrameset()
68
{
69
 var szHTML="<frameset rows=\"*,18\" border=0 width=0 frameborder=no framespacing=0>"+
70
  "<frame src=\""+document.all.item("shLink")[0].href+"\" name=\"frSheet\" noresize>"+
71
  "<frameset cols=\"54,*\" border=0 width=0 frameborder=no framespacing=0>"+
72
  "<frame src=\"\" name=\"frScroll\" marginwidth=0 marginheight=0 scrolling=no>"+
73
  "<frame src=\"\" name=\"frTabs\" marginwidth=0 marginheight=0 scrolling=no>"+
74
  "</frameset></frameset><plaintext>";
75

    
76
 with (document) {
77
  open("text/html","replace");
78
  write(szHTML);
79
  close();
80
 }
81

    
82
 fnBuildTabStrip();
83
}
84

    
85
function fnBuildTabStrip()
86
{
87
 var szHTML=
88
  "<html><head><style>.clScroll {font:8pt Courier New;color:"+c_rgszClr[6]+";cursor:default;line-height:10pt;}"+
89
  ".clScroll2 {font:10pt Arial;color:"+c_rgszClr[6]+";cursor:default;line-height:11pt;}</style></head>"+
90
  "<body onclick=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" onselectstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+" topmargin=0 leftmargin=0><table cellpadding=0 cellspacing=0 width=100%>"+
91
  "<tr><td colspan=6 height=1 bgcolor="+c_rgszClr[2]+"></td></tr>"+
92
  "<tr><td style=\"font:1pt\">&nbsp;<td>"+
93
  "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(0);\" onmouseout=\"parent.fnMouseOutScroll(0);\"><a>&#171;</a></td>"+
94
  "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(0);\" ondblclick=\"parent.fnScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(1);\" onmouseout=\"parent.fnMouseOutScroll(1);\"><a>&lt</a></td>"+
95
  "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(1);\" ondblclick=\"parent.fnScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(2);\" onmouseout=\"parent.fnMouseOutScroll(2);\"><a>&gt</a></td>"+
96
  "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(3);\" onmouseout=\"parent.fnMouseOutScroll(3);\"><a>&#187;</a></td>"+
97
  "<td style=\"font:1pt\">&nbsp;<td></tr></table></body></html>";
98

    
99
 with (frames['frScroll'].document) {
100
  open("text/html","replace");
101
  write(szHTML);
102
  close();
103
 }
104

    
105
 szHTML =
106
  "<html><head>"+
107
  "<style>A:link,A:visited,A:active {text-decoration:none;"+"color:"+c_rgszClr[3]+";}"+
108
  ".clTab {cursor:hand;background:"+c_rgszClr[1]+";font:9pt Arial;padding-left:3px;padding-right:3px;text-align:center;}"+
109
  ".clBorder {background:"+c_rgszClr[2]+";font:1pt;}"+
110
  "</style></head><body onload=\"parent.fnInit();\" onselectstart=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+
111
  " topmargin=0 leftmargin=0><table id=tbTabs cellpadding=0 cellspacing=0>";
112

    
113
 var iCellCount=(c_lTabs+1)*2;
114

    
115
 var i;
116
 for (i=0;i<iCellCount;i+=2)
117
  szHTML+="<col width=1><col>";
118

    
119
 var iRow;
120
 for (iRow=0;iRow<6;iRow++) {
121

    
122
  szHTML+="<tr>";
123

    
124
  if (iRow==5)
125
   szHTML+="<td colspan="+iCellCount+"></td>";
126
  else {
127
   if (iRow==0) {
128
    for(i=0;i<iCellCount;i++)
129
     szHTML+="<td height=1 class=\"clBorder\"></td>";
130
   } else if (iRow==1) {
131
    for(i=0;i<c_lTabs;i++) {
132
     szHTML+="<td height=1 nowrap class=\"clBorder\">&nbsp;</td>";
133
     szHTML+=
134
      "<td id=tdTab height=1 nowrap class=\"clTab\" onmouseover=\"parent.fnMouseOverTab("+i+");\" onmouseout=\"parent.fnMouseOutTab("+i+");\">"+
135
      "<a href=\""+document.all.item("shLink")[i].href+"\" target=\"frSheet\" id=aTab>&nbsp;"+c_rgszSh[i]+"&nbsp;</a></td>";
136
    }
137
    szHTML+="<td id=tdTab height=1 nowrap class=\"clBorder\"><a id=aTab>&nbsp;</a></td><td width=100%></td>";
138
   } else if (iRow==2) {
139
    for (i=0;i<c_lTabs;i++)
140
     szHTML+="<td height=1></td><td height=1 class=\"clBorder\"></td>";
141
    szHTML+="<td height=1></td><td height=1></td>";
142
   } else if (iRow==3) {
143
    for (i=0;i<iCellCount;i++)
144
     szHTML+="<td height=1></td>";
145
   } else if (iRow==4) {
146
    for (i=0;i<c_lTabs;i++)
147
     szHTML+="<td height=1 width=1></td><td height=1></td>";
148
    szHTML+="<td height=1 width=1></td><td></td>";
149
   }
150
  }
151
  szHTML+="</tr>";
152
 }
153

    
154
 szHTML+="</table></body></html>";
155
 with (frames['frTabs'].document) {
156
  open("text/html","replace");
157
  charset=document.charset;
158
  write(szHTML);
159
  close();
160
 }
161
}
162

    
163
function fnInit()
164
{
165
 g_rglTabX[0]=0;
166
 var i;
167
 for (i=1;i<=c_lTabs;i++)
168
  with (frames['frTabs'].document.all.tbTabs.rows[1].cells[fnTabToCol(i-1)])
169
   g_rglTabX[i]=offsetLeft+offsetWidth-6;
170
}
171

    
172
function fnTabToCol(iTab)
173
{
174
 return 2*iTab+1;
175
}
176

    
177
function fnNextTab(fDir)
178
{
179
 var iNextTab=-1;
180
 var i;
181

    
182
 with (frames['frTabs'].document.body) {
183
  if (fDir==0) {
184
   if (scrollLeft>0) {
185
    for (i=0;i<c_lTabs&&g_rglTabX[i]<scrollLeft;i++);
186
    if (i<c_lTabs)
187
     iNextTab=i-1;
188
   }
189
  } else {
190
   if (g_rglTabX[c_lTabs]+6>offsetWidth+scrollLeft) {
191
    for (i=0;i<c_lTabs&&g_rglTabX[i]<=scrollLeft;i++);
192
    if (i<c_lTabs)
193
     iNextTab=i;
194
   }
195
  }
196
 }
197
 return iNextTab;
198
}
199

    
200
function fnScrollTabs(fDir)
201
{
202
 var iNextTab=fnNextTab(fDir);
203

    
204
 if (iNextTab>=0) {
205
  frames['frTabs'].scroll(g_rglTabX[iNextTab],0);
206
  return true;
207
 } else
208
  return false;
209
}
210

    
211
function fnFastScrollTabs(fDir)
212
{
213
 if (c_lTabs>16)
214
  frames['frTabs'].scroll(g_rglTabX[fDir?c_lTabs-1:0],0);
215
 else
216
  if (fnScrollTabs(fDir)>0) window.setTimeout("fnFastScrollTabs("+fDir+");",5);
217
}
218

    
219
function fnSetTabProps(iTab,fActive)
220
{
221
 var iCol=fnTabToCol(iTab);
222
 var i;
223

    
224
 if (iTab>=0) {
225
  with (frames['frTabs'].document.all) {
226
   with (tbTabs) {
227
    for (i=0;i<=4;i++) {
228
     with (rows[i]) {
229
      if (i==0)
230
       cells[iCol].style.background=c_rgszClr[fActive?0:2];
231
      else if (i>0 && i<4) {
232
       if (fActive) {
233
        cells[iCol-1].style.background=c_rgszClr[2];
234
        cells[iCol].style.background=c_rgszClr[0];
235
        cells[iCol+1].style.background=c_rgszClr[2];
236
       } else {
237
        if (i==1) {
238
         cells[iCol-1].style.background=c_rgszClr[2];
239
         cells[iCol].style.background=c_rgszClr[1];
240
         cells[iCol+1].style.background=c_rgszClr[2];
241
        } else {
242
         cells[iCol-1].style.background=c_rgszClr[4];
243
         cells[iCol].style.background=c_rgszClr[(i==2)?2:4];
244
         cells[iCol+1].style.background=c_rgszClr[4];
245
        }
246
       }
247
      } else
248
       cells[iCol].style.background=c_rgszClr[fActive?2:4];
249
     }
250
    }
251
   }
252
   with (aTab[iTab].style) {
253
    cursor=(fActive?"default":"hand");
254
    color=c_rgszClr[3];
255
   }
256
  }
257
 }
258
}
259

    
260
function fnMouseOverScroll(iCtl)
261
{
262
 frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[7];
263
}
264

    
265
function fnMouseOutScroll(iCtl)
266
{
267
 frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[6];
268
}
269

    
270
function fnMouseOverTab(iTab)
271
{
272
 if (iTab!=g_iShCur) {
273
  var iCol=fnTabToCol(iTab);
274
  with (frames['frTabs'].document.all) {
275
   tdTab[iTab].style.background=c_rgszClr[5];
276
  }
277
 }
278
}
279

    
280
function fnMouseOutTab(iTab)
281
{
282
 if (iTab>=0) {
283
  var elFrom=frames['frTabs'].event.srcElement;
284
  var elTo=frames['frTabs'].event.toElement;
285

    
286
  if ((!elTo) ||
287
   (elFrom.tagName==elTo.tagName) ||
288
   (elTo.tagName=="A" && elTo.parentElement!=elFrom) ||
289
   (elFrom.tagName=="A" && elFrom.parentElement!=elTo)) {
290

    
291
   if (iTab!=g_iShCur) {
292
    with (frames['frTabs'].document.all) {
293
     tdTab[iTab].style.background=c_rgszClr[1];
294
    }
295
   }
296
  }
297
 }
298
}
299

    
300
function fnSetActiveSheet(iSh)
301
{
302
 if (iSh!=g_iShCur) {
303
  fnSetTabProps(g_iShCur,false);
304
  fnSetTabProps(iSh,true);
305
  g_iShCur=iSh;
306
 }
307
}
308

    
309
 window.g_iIEVer=fnGetIEVer();
310
 if (window.g_iIEVer>=4)
311
  fnBuildFrameset();
312
//-->
313
</script>
314
<![endif]><!--[if gte mso 9]><xml>
315
 <x:ExcelWorkbook>
316
  <x:ExcelWorksheets>
317
   <x:ExcelWorksheet>
318
    <x:Name>Summary</x:Name>
319
    <x:WorksheetSource HRef="O1_files/sheet001.htm"/>
320
   </x:ExcelWorksheet>
321
   <x:ExcelWorksheet>
322
    <x:Name>Dashboard-Purchase</x:Name>
323
    <x:WorksheetSource HRef="O1_files/sheet002.htm"/>
324
   </x:ExcelWorksheet>
325
   <x:ExcelWorksheet>
326
    <x:Name>Dashboard-Admin</x:Name>
327
    <x:WorksheetSource HRef="O1_files/sheet003.htm"/>
328
   </x:ExcelWorksheet>
329
   <x:ExcelWorksheet>
330
    <x:Name>Dashboard-IT</x:Name>
331
    <x:WorksheetSource HRef="O1_files/sheet004.htm"/>
332
   </x:ExcelWorksheet>
333
   <x:ExcelWorksheet>
334
    <x:Name>Dashboard-Top management</x:Name>
335
    <x:WorksheetSource HRef="O1_files/sheet005.htm"/>
336
   </x:ExcelWorksheet>
337
   <x:ExcelWorksheet>
338
    <x:Name>Dashboard-PMO</x:Name>
339
    <x:WorksheetSource HRef="O1_files/sheet006.htm"/>
340
   </x:ExcelWorksheet>
341
   <x:ExcelWorksheet>
342
    <x:Name>Dashboard-People Function</x:Name>
343
    <x:WorksheetSource HRef="O1_files/sheet007.htm"/>
344
   </x:ExcelWorksheet>
345
   <x:ExcelWorksheet>
346
    <x:Name>Organisational summary</x:Name>
347
    <x:WorksheetSource HRef="O1_files/sheet008.htm"/>
348
   </x:ExcelWorksheet>
349
   <x:ExcelWorksheet>
350
    <x:Name>Department wise objective</x:Name>
351
    <x:WorksheetSource HRef="O1_files/sheet009.htm"/>
352
   </x:ExcelWorksheet>
353
   <x:ExcelWorksheet>
354
    <x:Name> Consolidated View</x:Name>
355
    <x:WorksheetSource HRef="O1_files/sheet010.htm"/>
356
   </x:ExcelWorksheet>
357
  </x:ExcelWorksheets>
358
  <x:Stylesheet HRef="O1_files/stylesheet.css"/>
359
  <x:WindowHeight>4635</x:WindowHeight>
360
  <x:WindowWidth>5760</x:WindowWidth>
361
  <x:WindowTopX>0</x:WindowTopX>
362
  <x:WindowTopY>0</x:WindowTopY>
363
  <x:ProtectStructure>False</x:ProtectStructure>
364
  <x:ProtectWindows>False</x:ProtectWindows>
365
 </x:ExcelWorkbook>
366
</xml><![endif]-->
367
</head>
368

    
369
<frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0>
370
 <frame src="O1_files/sheet001.htm" name="frSheet">
371
 <frame src="O1_files/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
372
 <noframes>
373
  <body>
374
   <p>This page uses frames, but your browser doesn't support them.</p>
375
  </body>
376
 </noframes>
377
</frameset>
378
</html>
(4-4/4)