MS Excel 2016: How to Change Column Headings from Numbers to Letters
Source: MS Excel 2016: How to Change Column Headings from Numbers to Letters
Advertisements
Excel Comments – Macros
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
Streisand on Michael Jackson Mollesting Little Boys
variety.com/2019/music/news/barbra-streisand-michael-jackson-accusers-thrilled-1203170747/
Streisand says that on the occasions she met Jackson, he was “very sweet, very childlike.” But despite the material being painful to watch, she seems to have some sympathy for the late pop star. “His sexual needs were his sexual needs, coming from whatever childhood he has or whatever DNA he has,” she told the Times.
ntpquery Utility
Bytefusion’s ntpquery seems to be incredibly old, but works. Sadly, it requires initial installation, but the application files will work fine when copied to another system.
Source: How can I query an NTP server under Windows? – Super User
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
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.
The difference between bandwidth and latency
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.
P&G to host first on-site career fair Jan. 31 | West Virginia | heraldmailmedia.com
MARTINSBURG, W.Va. — Procter & Gamble Co. announced Wednesday that it will hold its first on-site career fair Thursday, Jan. 31, to recruit employees for the company’s new Tabler Station
— Read on www.heraldmailmedia.com/content/tncms/live/
