| This sheet shows the cumulative capacity of the Tier-1 centre |
|
| |
| |
Step-3 |
Select an equipment phase-out model using
the pull-down list |
|
| |
(These are contained in the worksheet
called "PhaseOut") |
|
| |
|
|
|
|
| |
|
|
DISK |
CPU |
Tape |
|
| |
Hardware decommissioned after: |
3-years |
4-years |
5-years |
3-years |
4-years |
5-years |
3-years |
4-years |
5-years |
|
| |
|
AS |
|
0% |
10% |
100% |
0% |
5% |
100% |
0% |
0% |
100% |
|
| |
Table-1:
Hardware Phase-Out Profile |
|
| |
| |
Step-4 |
Select a status Month from the pull-down
list (day may be changed in cell E14). Select "Purchased" or
"Installed". |
|
| |
(The delay between "Purchase"
and "Install" is in the Assumptions Sheet.) |
|
| |
|
|
|
|
| |
Status Date |
|
2 |
2004 |
2005 |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
|
| |
Cumulative
Capacity |
Purchased |
|
2/9/04 |
2/9/05 |
2/9/06 |
2/9/07 |
2/9/08 |
2/9/09 |
2/9/10 |
2/9/11 |
2/9/12 |
|
| |
|
|
disk |
|
2/9/04 |
2/9/05 |
2/9/06 |
2/9/07 |
2/9/08 |
2/9/09 |
2/9/10 |
2/9/11 |
2/9/12 |
|
| |
|
|
Cpu |
|
2/9/04 |
2/9/05 |
2/9/06 |
2/9/07 |
2/9/08 |
2/9/09 |
2/9/10 |
2/9/11 |
2/9/12 |
|
| |
|
|
Tape |
|
2/9/04 |
2/9/05 |
2/9/06 |
2/9/07 |
2/9/08 |
2/9/09 |
2/9/10 |
2/9/11 |
2/9/12 |
|
| |
Actual Disk [TB] |
220 |
|
|
|
|
|
|
|
|
|
| |
Modeled Disk [TB} |
394 |
619 |
917 |
1700 |
2945 |
4628 |
4388 |
4001 |
3137 |
|
| |
Actual CPU [KSI2K] |
884 |
|
|
|
|
|
|
|
|
|
| |
Modeled CPU [KSI2K] |
1197 |
1989 |
2752 |
4536 |
7182 |
10079 |
9269 |
8258 |
6285 |
|
| |
Actual Tape [TB] |
187 |
|
|
|
|
|
|
|
|
|
| |
Modeled Tape [TB] |
347 |
347 |
1360 |
2740 |
3460 |
4020 |
4020 |
2940 |
1440 |
|
| |
Table-2:
Actual and Modeled Tier-1 Total Physical Capacity |
|
| |
| |
Step-5 |
Select the fraction of
Hardware that is available for allocation by adjusting sliders in Column-C |
|
| |
This scales the available "Installed" hardware, not the
"Purchased" hardware, regardless of the selection in Step-2 above. |
|
| |
|
|
|
|
| |
|
Available |
September 2 |
|
2004 |
2005 |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
|
| |
|
|
|
|
2/4/04 |
2/4/05 |
2/4/06 |
2/4/07 |
2/4/08 |
2/4/09 |
2/4/10 |
2/4/11 |
2/4/12 |
|
| |
|
|
|
|
2/6/04 |
2/6/05 |
2/6/06 |
2/6/07 |
2/6/08 |
2/6/09 |
2/6/10 |
2/6/11 |
2/6/12 |
|
| |
|
|
|
|
2/8/04 |
2/8/05 |
2/8/06 |
2/8/07 |
2/8/08 |
2/8/09 |
2/8/10 |
2/8/11 |
2/8/12 |
|
| |
|
|
|
|
220 |
619 |
917 |
1700 |
2945 |
4628 |
4388 |
4001 |
3137 |
|
| |
|
|
|
|
1197 |
1989 |
2752 |
4536 |
7182 |
10079 |
9269 |
8258 |
6285 |
|
| |
|
|
|
|
347 |
347 |
1360 |
2740 |
3460 |
4020 |
4020 |
2940 |
1440 |
|
| |
Disk |
 
|
90% |
TB |
198 |
557 |
826 |
1530 |
2650 |
4165 |
3949 |
3601 |
2823 |
|
| |
CPU |
90 |
90% |
KSI2K |
1078 |
1790 |
2477 |
4083 |
6464 |
9071 |
8342 |
7432 |
5656 |
|
| |
Tape |
100 |
100% |
TB |
347 |
347 |
1360 |
2740 |
3460 |
4020 |
4020 |
2940 |
1440 |
|
| |
Table-3: Available Capacity (Model) |
|
| |
| |
|
|
| |
| |
| |
|
|
| |
|
|
| |
January |
|
|
| |
February |
|
|
| |
March |
|
|
| |
April |
|
|
| |
May |
|
|
| |
June |
|
|
| |
July |
|
|
| |
August |
|
|
| |
September |
|
|
| |
October |
|
|
| |
November |
|
|
| |
December |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|