Figure 3: Cell contents for traffic estimation worksheet

A:A1: {Page 1/2 Arial14 B}
'TRAFFIC ESTIMATION WORKSHEET
A:A3: {Page Arial14 B} 'Input:
A:A5: {Page} 'Home Page Size (bytes):
A:B7: 'Number of graphics:
A:D7: {Page} 2
A:B8: 'Average Graphic Storage
A:D8: {Page} 95000
A:B9: 'Text
A:D9: {Page} 800
A:A11: {Page} 'Tier One Level
A:B13: 'Avg Number of Graphics
A:D13: {Page} 1
A:B14: 'Average Graphics Storage
A:D14: {Page}75000
A:B15: 'Average text/page
A:D15: {Page} 1000
A:A17: {Page} 'Tier Two Level
A:B19: 'Avg Number of Graphics
A:D19: {Page} 0
A:B20: 'Average Graphics Storage
A:D20: {Page} 0
A:B21: 'Average text/page
A:D21: {Page} 1500
A:A23: {Page} 'Traffic Estimates:
A:B24: 'Busy hour hits:
A:D24: {Page} 750
A:B25: 'Page Access Distribution
A:B26: '   Home Page
A:D26: {Page} 60
A:B27: '   Tier One
A:D27: {Page} 25
A:B28: '   Tier Two
A:D28: {Page} 15
A:A30: {Page} 'LAN Constraints
A:B32: 'LAN operating rate
A:D32: {Page} 10000000
A:B33: 'Number of LAN stations
A:D33: {Page} 25
A:B34: 'LAN saturation percent
A:D34: {Page} 60
A:A36: {Page Arial14 B} 'Output
A:B38: 'Home Page
A:B40: ' Total Bytes home page
A:D40: {Page} +D7*D8+D9
A:B41: 'Avg Bytes per hit:
A:D41: {Page} +D40*D26/100
A:B43: 'Tier One
A:B44: ' Total Bytes tier 1 page
A:D44: {Page} +D13*D14+D15
A:B45: 'Avg Bytes per hit:
A:D45: {Page} +D44*D27/100
A:B47: 'Tier Two
A:B48: ' Total Bytes tier 2 page
A:D48: {Page} +D19*D20+D21
A:B49: 'Avg Bytes per hit:
A:D49: {Page} +D48*D28/100
A:B51: {Page} 'Total:
A:B52: 'Avg Bytes per hit:
A:D52: {Page} +D41+D45+D49
A:B54: 'WAN Line Operating Rate
A:B55: '   KBPS:
A:D55: {Page} (FO) (+D52*8*D24/3600)/100
A:B58: 'Avg LAN bandwidth for
A:B59: ' Web Server
A:B60: 'in KBPS:
A:D60: {Page} ((+D32/D33) *D34/100)/100