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\"> <td>"+
|
93
|
"<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(0);\" onmouseout=\"parent.fnMouseOutScroll(0);\"><a>«</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><</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>></a></td>"+
|
96
|
"<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(3);\" onmouseout=\"parent.fnMouseOutScroll(3);\"><a>»</a></td>"+
|
97
|
"<td style=\"font:1pt\"> <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\"> </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> "+c_rgszSh[i]+" </a></td>";
|
136
|
}
|
137
|
szHTML+="<td id=tdTab height=1 nowrap class=\"clBorder\"><a id=aTab> </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>
|