Charles_Mcgill_Module 4 - Server Logs
xlsx
keyboard_arrow_up
School
University of Alabama *
*We aren’t endorsed by this school
Course
200
Subject
Electrical Engineering
Date
Apr 3, 2024
Type
xlsx
Pages
11
Uploaded by MagistrateKoupreyPerson3084
Bandwidth Used (MB)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
8-10am
5
6
5
7
8
0
0
10-12pm
8
10
7
9
8
3
3
12pm-2pm
12
12
15
14
12
0
0
2pm-4pm
22
25
20
18
17
9
8
4pm-6pm
13
12
15
17
15
0
1
Total
60
65
62
65
60
12
12
Total Bandwidth (Line Graph)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
Bandwidth Used (MB)
0
10
20
30
40
50
60
70
Total_Bandwidth_By_Day
8-10am
10-12pm
12pm-2pm
2pm-4pm
4pm-6pm
Total
Module 4: Spreadsheet Application: Analyzing Server Traffic
Campus Travel has recently found that its internet connections between offices are becoming slow, especi
certain periods of the day. Since all the online traffic is maintained by another company, an increase in ban
requires a formal approval from the general manager. The IS manager has proposed to increase the bandw
the company’s network; in a few days, he must present the business case for this proposal at the weekly m
the department heads. You are asked to prepare graphs for the presentation to support the IS manager’s b
case. In this file, you will find information about the network traffic for a 1-week period. Update this spreadsheet tab to provide the following information:
1) Update the "Total" row (row 8) to include the total bandwidth used per day
2) Insert a line graph in the gray area starting in cell B15 that shows total bandwidth used each day. Name this line graph "Total_Bandwidth_By_Day" and format the graph professionallly.
Navigate to the "Total Bandwidth" tab. 3) Update the "Total" column (column I) to include the total bandwidth used per time period
4) Insert a line graph in the gray area starting in cell B15 that shows total bandwidth used each time period. Name this line graph "Total_Bandwidth_By_Time" and format the graph professionally.
Navigate to the "Average Bandwidth" tab. 5) Update the "Average" column (column I) to include the average bandwidth used per time period
6) Insert a line graph in the gray area starting in cell B15 that shows average bandwidth used each time period. Name this line graph "Average_Bandwidth_By_Time" and format the graph professionally.
ially during ndwidth width of meeting of business
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
97024
Bandwidth Used (MB)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022 Total
8-10am
5
6
5
7
8
0
0
31
10-12pm
8
10
7
9
8
3
3
48
12pm-2pm
12
12
15
14
12
0
0
65
2pm-4pm
22
25
20
18
17
9
8
119
4pm-6pm
13
12
15
17
15
0
1
73
Bandwidth per Period (Line Graph)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
Total
Bandwidth Used (MB)
0
20
40
60
80
100
120
140
Total_Bandwidth_By_Time
8-10am
10-12pm
12pm-2pm
2pm-4pm
4pm-6pm
97024
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Bandwidth Used (MB)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
Average
8-10am
5
6
5
7
8
0
0
4.43
10-12pm
8
10
7
9
8
3
3
6.86
12pm-2pm
12
12
15
14
12
0
0
9.29
2pm-4pm
22
25
20
18
17
9
8
17.00
4pm-6pm
13
12
15
17
15
0
1
10.43
Average Bandwidth per Period (Line Graph)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
Average
Bandwidth Used (MB)
0
5
10
15
20
25
30
Average_Bandwidth_By_Time
8-10am
10-12pm
12pm-2pm
2pm-4pm
4pm-6pm
97024
Questions
Score
Data in cell(s): B8:H8, in worksheet: Ch 4 ServerLogs
1
Data in cell(s): CHART EXISTS, in worksheet: Ch 4 ServerLogs
1
Data in cell(s): CHART PROPERTIES, in worksheet: Ch 4 ServerLogs
0
Data in cell(s): I3:I7, in worksheet: Total Bandwidth
1
Data in cell(s): CHART EXISTS, in worksheet: Total Bandwidth
1
Data in cell(s): CHART PROPERTIES, in worksheet: Total Bandwidth
0
Data in cell(s): I3:I7, in worksheet: Average Bandwidth
1
Data in cell(s): CHART EXISTS, in worksheet: Average Bandwidth
1
Data in cell(s): CHART PROPERTIES, in worksheet: Average Bandwidth
0
Total Score
6
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Max Points
1
1
1
1
1
1
1
1
1
9
Feedback
Great job adding the bandwidth for each day!
Nice work adding a chart that shows the total bandwidth per day!
Did you select the total bandwidth row as your data series for your line chart?
Great job finding the total bandwidth for each time period!
Excellent job creating a chart that shows the bandwidth used in each time period per day.
Did you select the bandwidth for each time period per day as your data series for your line chart (B3:H7)?
Great job finding the average bandwidth for each time period!
Awesome work finding the average bandwidth per time period.
Did you select the average bandwidth column as your data series for your line chart?
66.6667%
Related Documents
Related Questions
Can you please provide the MATLAB code needed to answer a, b and c? I am new to MATLAB and don't know where to start. Thank you!
arrow_forward
The oneline diagram of the system is shown in Fig.E5-1. The data for the components in
the system are given in per unit in Tables E6-1,2 and 3. The base values are Shase-100
MVA, Vbase-15 kV at bus 1. The ratings of the devices are:
Generator Gl:
Generator G2:
Transformer T1:
Transformer T2:
400 MVA, 15 kV
800 MVA, 15 kV
400 MVA, 15 A/345 Y kV
800 MVA, 345 Y/15 A kV
T2
Lengths of transmission lines: L1=200 mi, L2=100 mi, L3-50 mi.
Gl
T1
+
◎
L2
L3
Ll
나
口口
800 MW
280 Mvar
FIGURE E5-1
©
m
TABLE E5-1 Bus input data
ㅁ
80 MW
V
δ
Po
QG
PL
QL
QCmax
QCimin
Bus
Туре
p.u
degrees
p.u.
p.u.
p.u.
p.u.
p.u.
p.u.
1
Swing
1.0
0
-
-
0
0
-
2
Load
-
-
0
0
8.0
2.8
Voltage-
3
1.05
-
5.2
0.8
0.4
4.0
-2.4
controlled
4
Load
0
0
0
0
0
5
Load
0
0
0
0
0
arrow_forward
5. From the state diagram below, design a counter that displays the frequency shown rising/falling.
arrow_forward
Identify which measurement this oscilloscope time difference reading is useful for.
Oscilloscope-XSC1
Time
250.000 us
1.261 ms
Channel_A
169.064 V
168.513 V
-550. 584 mV
Channel_B
89. 282 V
95.005 V
5.722 V
Reverse
T2-T1
1.011 ms
Save
Ext. trigger
Timebase
Scale: 200 us/Div : Scale: 100 V/Div
X pos. (Div): 0
Channel A
Channel B
Scale: 100 V/Div
Y pos. (Div): 0
Trigger
Edge: F
Level: 0
A B Ext
Y pos. (Div): 0
V
Y/T Add B/A
A/B
AC
DC
AC
DC
Single Normal
O period
O none of the above
O phase shift
arrow_forward
For which measurement is this oscilloscope time difference reading useful?
Oscilloscope-XSC1
Time
Channel_A
Channel B
89.282 V
-91.176 V
250.000 us
169.064 V
Reverse
-168.880 V
-337.944 V
753.788 us
T2-T1
503. 788 us
-180.458 V
Save
Ext. trigger
Timebase
Channel A
Channel B
Trigger
Scale: 200 us/Div Scale: 100 V/Div
X pos. (Div): 0
Y/T Add B/A A/B
100 V/Div
Edge: F2 AB Ext
Scale:
Y pos. (Div): 0
Y pos. (Div): 0
Level:
AC
DC
AC 0
DC
O Single Normal Auto None
SER RI ME
arrow_forward
For which measurement is this oscilloscope time difference reading useful?
Ociloscope-XSC1
Time
250.000 us
Channel_A
Channel B
89.282 V
-91.176 V
Reverse
169.064 V
-168.880 V
753.788 us
503. 788 us
T2-T1
-337.944 V
-180.458 V
Save
Ext. trigger
Timebase
Scale: ko0 us/Div : Scale: 100 V/Div
Channel A
Channel B
Trigger
100 v/Dv
Y pos. (Div): 0
Scale:
Edge: F2 AB
X pos. (Div): 0
Y pos. (Div): 0
Level:
Y/T Add B/A A/B
AC O DC
AC0 DC
O Single Normal Auto None
O phase shift
O period
O none of the above
SE R RI NI E BII E
arrow_forward
Identify which measurement this oscilloscope time difference reading is useful for.
Ociloscope-XSC1
Channel_A
169.064 V
168.513 V
Channel_B
89.282 V
95.005 V
Time
Reverse
250.000 us
1.261 ms
1.011 ms
T2
T2-T1
-550. 584 mV
5.722 V
Save
Ext. trigger
Channel A
Timebase
Scale: ko0 us/Div
X pos. (Div): 0
Y/T Add B/A A/B
Channel B
Trigger
Scale: 100 V/Div
Y pos. (Div): 0
AC0 DC
100 V/Div
f 2 AB Ext
Scale:
Edge:
| Y pos.(Div): 0
AC 0 DC
Level:
V
Single Normal Auto None
arrow_forward
please help me with this question, thanks
arrow_forward
Isolator
MCB
MCCB
RCD
BIE
Noark
D 20A
480Y/277V
50/60Hz
5000A E355391
CAUS
us
D-OFF
C
D-OFF
The shown protection device is
arrow_forward
A clipper is a device that removes either the positive half (top half) or negative half (bottom half), or both positive and negative halves of the input AC signal. In other words, a clipper is a device that limits the positive amplitude or negative amplitude or both positive and negative amplitudes of the input AC signal. In some cases, a clipper removes a small portion of the positive half cycle or negative half cycle or both positive and negative half cycles. In the below circuit diagram, the positive half cycles are removed by using the series positive clipper.
QUESTION:
In your own opinion. Why do we need to clip a certain amount of voltage in positive or negative or on both sides? What is the benefit of that in our devices or circuits in doing such thing?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Power System Analysis and Design (MindTap Course ...
Electrical Engineering
ISBN:9781305632134
Author:J. Duncan Glover, Thomas Overbye, Mulukutla S. Sarma
Publisher:Cengage Learning
Related Questions
- Can you please provide the MATLAB code needed to answer a, b and c? I am new to MATLAB and don't know where to start. Thank you!arrow_forwardThe oneline diagram of the system is shown in Fig.E5-1. The data for the components in the system are given in per unit in Tables E6-1,2 and 3. The base values are Shase-100 MVA, Vbase-15 kV at bus 1. The ratings of the devices are: Generator Gl: Generator G2: Transformer T1: Transformer T2: 400 MVA, 15 kV 800 MVA, 15 kV 400 MVA, 15 A/345 Y kV 800 MVA, 345 Y/15 A kV T2 Lengths of transmission lines: L1=200 mi, L2=100 mi, L3-50 mi. Gl T1 + ◎ L2 L3 Ll 나 口口 800 MW 280 Mvar FIGURE E5-1 © m TABLE E5-1 Bus input data ㅁ 80 MW V δ Po QG PL QL QCmax QCimin Bus Туре p.u degrees p.u. p.u. p.u. p.u. p.u. p.u. 1 Swing 1.0 0 - - 0 0 - 2 Load - - 0 0 8.0 2.8 Voltage- 3 1.05 - 5.2 0.8 0.4 4.0 -2.4 controlled 4 Load 0 0 0 0 0 5 Load 0 0 0 0 0arrow_forward5. From the state diagram below, design a counter that displays the frequency shown rising/falling.arrow_forward
- Identify which measurement this oscilloscope time difference reading is useful for. Oscilloscope-XSC1 Time 250.000 us 1.261 ms Channel_A 169.064 V 168.513 V -550. 584 mV Channel_B 89. 282 V 95.005 V 5.722 V Reverse T2-T1 1.011 ms Save Ext. trigger Timebase Scale: 200 us/Div : Scale: 100 V/Div X pos. (Div): 0 Channel A Channel B Scale: 100 V/Div Y pos. (Div): 0 Trigger Edge: F Level: 0 A B Ext Y pos. (Div): 0 V Y/T Add B/A A/B AC DC AC DC Single Normal O period O none of the above O phase shiftarrow_forwardFor which measurement is this oscilloscope time difference reading useful? Oscilloscope-XSC1 Time Channel_A Channel B 89.282 V -91.176 V 250.000 us 169.064 V Reverse -168.880 V -337.944 V 753.788 us T2-T1 503. 788 us -180.458 V Save Ext. trigger Timebase Channel A Channel B Trigger Scale: 200 us/Div Scale: 100 V/Div X pos. (Div): 0 Y/T Add B/A A/B 100 V/Div Edge: F2 AB Ext Scale: Y pos. (Div): 0 Y pos. (Div): 0 Level: AC DC AC 0 DC O Single Normal Auto None SER RI MEarrow_forwardFor which measurement is this oscilloscope time difference reading useful? Ociloscope-XSC1 Time 250.000 us Channel_A Channel B 89.282 V -91.176 V Reverse 169.064 V -168.880 V 753.788 us 503. 788 us T2-T1 -337.944 V -180.458 V Save Ext. trigger Timebase Scale: ko0 us/Div : Scale: 100 V/Div Channel A Channel B Trigger 100 v/Dv Y pos. (Div): 0 Scale: Edge: F2 AB X pos. (Div): 0 Y pos. (Div): 0 Level: Y/T Add B/A A/B AC O DC AC0 DC O Single Normal Auto None O phase shift O period O none of the above SE R RI NI E BII Earrow_forward
- Identify which measurement this oscilloscope time difference reading is useful for. Ociloscope-XSC1 Channel_A 169.064 V 168.513 V Channel_B 89.282 V 95.005 V Time Reverse 250.000 us 1.261 ms 1.011 ms T2 T2-T1 -550. 584 mV 5.722 V Save Ext. trigger Channel A Timebase Scale: ko0 us/Div X pos. (Div): 0 Y/T Add B/A A/B Channel B Trigger Scale: 100 V/Div Y pos. (Div): 0 AC0 DC 100 V/Div f 2 AB Ext Scale: Edge: | Y pos.(Div): 0 AC 0 DC Level: V Single Normal Auto Nonearrow_forwardplease help me with this question, thanksarrow_forwardIsolator MCB MCCB RCD BIE Noark D 20A 480Y/277V 50/60Hz 5000A E355391 CAUS us D-OFF C D-OFF The shown protection device isarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Power System Analysis and Design (MindTap Course ...Electrical EngineeringISBN:9781305632134Author:J. Duncan Glover, Thomas Overbye, Mulukutla S. SarmaPublisher:Cengage Learning

Power System Analysis and Design (MindTap Course ...
Electrical Engineering
ISBN:9781305632134
Author:J. Duncan Glover, Thomas Overbye, Mulukutla S. Sarma
Publisher:Cengage Learning