Computing

Excel Comments – Macros

craigwhitetn Computing, Work

Excel Comments – Macros

Source: Excel Comments – Macros

‘Kudos: https://www.contextures.com/xlcomments03.html
Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub
Sub Comments_AutoSize()
‘posted by Dana DeLouis 2000-09-16

Dim MyComments As Comment
Dim lArea As Long
For Each MyComments In ActiveSheet.Comments
With MyComments
.Shape.TextFrame.AutoSize = True
If .Shape.Width > 300 Then
lArea = .Shape.Width * .Shape.Height
.Shape.Width = 200
‘ An adjustment factor of 1.1
‘ seems to work ok.
.Shape.Height = (lArea / 200) * 1.1
End If
End With
Next ‘ comment
End Sub

Advertisements

How to set (and change) an NTP time source in Windows Server 2008 R2 (SBS 2011 and Vanilla Server). – A Windows System Admin’s Blog

craigwhitetn Computing

To query the time service:

w32tm /query /status

To change time service:

w32tm /config /manualpeerlist:<IP Address or Host Name>

Tip: After changing service IP/Host, run another w32tm /query /status to confirm the settings show the new time service IP/Host.

Source: How to set (and change) an NTP time source in Windows Server 2008 R2 (SBS 2011 and Vanilla Server). – A Windows System Admin’s Blog

The difference between bandwidth and latency

craigwhitetn Computing

What’s the difference between bandwidth and latency? By reading the definition of both terms above you probably already spot the difference between the two, but I’ll give you an analogy to make it easier to understand it if you are still confused. Imagine a highway with 4 lanes where the speed limit is 60 mph. Now on the Internet, bandwidth is the highway, and latency is the 60 mph speed limit. Now if you want to increase the amount of cars that travels through the highway you can add more lanes, but because the highway has too many curves, and bumps, you can’t increase the speed limit so all cars have to travel at 60 mph still. It doesn’t matter how many lanes the highway has, the cars will get to their destination at the same time regardless of the size of the  highway!

Why increasing bandwidth increases download speed then you might ask, isn’t that speed? No, by increasing bandwidth you increase capacity not speed. Following the highway analogy, imagine that vehicles traveling through that highway were all trucks with house bricks for delivery. All trucks have to travel at 60 mph, but once they arrive at their destination instead of delivering 4 loads of bricks, 6 loads are delivered because 2 more lanes were added to the highway. The same thing happens when you add bandwidth to an Internet connection, the capacity is increased but the latency (speed ) stays the same.

Source: The difference between bandwidth and latency