Differences

This shows you the differences between two versions of the page.

--- home_server:mswindows_notes [2024-02-25 Sun wk08 12:08] – [friction factor calculation] baumkp
+++ home_server:mswindows_notes [2025-08-16 Sat wk33 16:50] (current) – baumkp
@@ Line 1: / Line 1: @@
-{{tag>mswindows windows setup tip notes personal license}}
+{{tag>mswindows windows setup tip notes personal license powertoys}}
 ======KPTree - MSWindows Setup======
 =====Background=====
@@ Line 19: / Line 19: @@
   *First up to make easier to load up system
      *Nextcloud Windows client - Cloud server client (**!L**)
-     *Keepass - Password and other secret info repository (**!L**)
+     *Keepass - Password and other secret info repository (L)
+     *KeepassXC - Password and other secret info repository, better than Keypass (**!L**)
      *I just use the built in Windows Defender for virus protection now
      *Xplorer2 - a multi-paned file explorer replacement - //I do not use any more. See notes below.//
@@ Line 28: / Line 29: @@
      *CCleaner - a Windows system maintenance program, clean junk files and registry and other - **Do not use anymore, looks like spam now**
      *FileZilla - and sFTP client program (**!**)
-     *Ghostscript - a PDF manipulator (**!L**)
+     *Ghostscript - a PDF manipulator (L)  I simply do not use much anymore
-     *iTunes - Apple iOS update control software - See Separate Section below (**!**)
+     *iTunes - Apple iOS update control software - See Separate Section below - I simply do not use much any more.
      *Setup printer / scanner - See separate notes below (**!**)
      *Vuescan - Is a paid scanner program. It is just for scanning and is simple and does the job __very__ well. (**!L**)
@@ Line 70: / Line 71: @@
   *YouTube Premium Family.  As much as I do not like supporting Google / Alphabeta I have been enjoying the use of YouTube Premium and they throw in YouTube Music too. The family like too.  Getting rid of the Ads has been wonderful!
   *Spotify - My son originally wanted this and I ended up going with family option.  Have move to YouTube option as it includes YouTube plus Music.
-====Microsoft PowerToys: Utilities to customize Windows====
+=====Microsoft PowerToys: Utilities to customize Windows=====
-[[https://learn.microsoft.com/en-us/windows/powertoys/install|Install PowerToys]]
+  *[[https://learn.microsoft.com/en-us/windows/powertoys/install|Install PowerToys]]
+  *[[https://github.com/microsoft/PowerToys|Github PowerToys]]
+  *[[https://learn.microsoft.com/en-us/windows/powertoys/fancyzones|Fancy Zones utility]]
+====Some key short cut keys====
+The Windows key is called the Super or Meta Key on Linux.  I will call the Meta key.
+So below is a list of special action keys.
+  *Shift (shift key, left or right)
+  *Alt (alt key, left of right)
+  *Ctrl (Control key, left or right)
+  *Meta (Meta, Super or Windows key, left or right)
+  *→ (Right arrow key)
+  *← (Left arrow key)
+  *↑  (Up arrow key)
+  *↓  (Down arrow key)
+  *PgUp (Page up Key)
+  *PgDn (Page Down Key)
+===Always on Top===
+  *Activate/Deactivate:  Meta + Ctrl + T
+===FancyZones====
+  *Activate/deactivate: Meta + Shift + `
+  *Apply saved Custom Layout: Meta + Ctrl + Alt + Number
 ====Software Licenses and Copyright====
 I am not overly pious about free versus purchased software.  I appreciate people should be rewarded for their efforts.  One has to have the upmost respect for those providing "free" software (true free, e.g. GNU free, **NOT** Facebook or Google free) .  Sadly in general paid software providers merit less respect.
@@ Line 91: / Line 118: @@
 Ultimately the software owner has the right to limit their software to 1 machine per license, however I have the similar right to decided this means the software it too expensive and inconvenient for me to justify to use. For this type of software I want a license that gives me unfettered home use on at least 2 machines and perhaps all home personal use machines, with a separate license for work use.
-===Foxit Pro===
+===Foxit Pro / Qoppa===
 Sadly there is no full featured GNU Licensed Linux PDF writer.  Further to this most paid versions, including Foxit Pro do not work on Linux. Interestingly the Free version of Foxit does have a Linux version.   Hence I purchase a copy of Qoppa Software's PDF Studio PRO that does run of Linux and Windows.  I may end up buying another license of Qoppa for my work machine in the future if happy with it, instead of Foxit Pro.\\  I was quite happy with Foxit Pro on Windows, but if they can not provide a Linux version...  Also Foxit originally allowed 2 installations per license and now seem to be going back to 1 machine one "Single-Use" license, which is a problem for me.  Qoppa states"...can be used on 2 machines of any OS."
@@ Line 98: / Line 125: @@
 ====iTunes - setup====
+++++I hardly ever use iTunes any more|
 iTunes is software I do not particularly like. First of all I do not use the Music feature having long ago rip my CD collection to MP3 and I simply do not like the way iTunes works. So the only real reason to use iTunes is for my iOS devices, backing up iOS devices etc. iTunes, in typical Apple fashion I find is not smart end user friendly as it has been designed for not smart users and attempts to hide the lower level file system. Further to this the configuration, backups and apps end up being very large amounts of files (multiple 1000s) and using huge amounts of disk space, in some cases well over 200GB!. So to help alleviate the excessive file system use on my primary Windows10 SSD I would like to move to my Linux NAS. The following are the steps to achieve this.
@@ Line 120: / Line 147: @@
   *iTunes playing up
 However one good trick is to simply run the install file "C:\Program Files\Common Files\Apple\Mobile Device Support\Drivers\usbaapl64.inf". The easiest way being to right click the file in exploer and select the install option.
+++++
 =====Printer Scanner Setup=====
@@ Line 217: / Line 245: @@
 ======MSExcel Tips======
+=====MS Excel Highlight Row or Column=====
+The basic built in way :
+  * ''shift+space'' to highlight the row
+  * ''ctrl+space'' to highlight the column
+Use conditional formating, but this requires hitting ''F9'' or a VB macro to actually highlight.
+Use a VB macro.  Main down side to this is that it slows down the MSExcel performance
+++++VB Code 1|
+<code>
+'from https://www.exceldemy.com/learn-excel/highlight/row/
+Private Sub Worksheet_SelectionChange(ByVal Target As Range)
+  If Target.Cells.Count > 1 Then Exit Sub
+  Application.ScreenUpdating = False
+  'Clear the color of all cells
+  Cells.Interior.ColorIndex = 0
+  With Target
+    'Highlight row and column of the selected cell
+    .EntireRow.Interior.ColorIndex = 38  'or use RGB(200,200,200) to pick a colour
+    .EntireColumn.Interior.ColorIndex = 24
+  End With
+  Application.ScreenUpdating = True
+End Sub</code>
+++++
+++++VB Code 2|
+<code>'from https://www.howtoexcel.org/highlight-current-row-column/
+Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
+Static xRow
+Static xColumn
+If xColumn <> "" Then
+    With Columns(xColumn).Interior
+        .ColorIndex = xlNone
+    End With
+    With Rows(xRow).Interior
+        .ColorIndex = xlNone
+    End With
+End If
+pRow = Selection.row
+pColumn = Selection.Column
+xRow = pRow
+xColumn = pColumn
+With Columns(pColumn).Interior
+    .ColorIndex = 6
+    .Pattern = xlSolid
+End With
+With Rows(pRow).Interior
+    .ColorIndex = 6
+    .Pattern = xlSolid
+End With
+End Sub</code>
+++++
 =====Text to Column=====
 When pasting text from other applications on occassions Excel places all the columns into one column. To adjust into multiple columns the following feature can be used. Menu: Data : Text to Columns
+=====Text Carriage Return / Line Feed=====
+  *Use char(10), e.g. ="Test text"&char(10)&"on new line"
+ON Mac/Linux this may be char(13) due to different ways these OS handle carriage return / end of line and line feed control charaters.
 =====List Windows files and directories into MSExcel=====
@@ Line 237: / Line 324: @@
 ====friction factor calculation====
 Earlier in my engineering career I used Lotus123 and MSExcel with iteration to calculate the friction factor of piping with Newtonian fluid according to the [[https://en.wikipedia.org/wiki/Darcy_friction_factor_formulae#Colebrook%E2%80%93White_equation|Darcy friction factor formulae]].  To remove the iteration from the spreadsheet I wrote a simple VB script that took care of this.  When I get the change I will copy the script here.
-<code>
+++++VSBasic code for Colebrook Equation|
-</code>
+<code basic>'Public Re As Double 'Reynold number unitless 0<Re<10E9
-As can be seen in the wiki page, [[https://en.wikipedia.org/wiki/Darcy_friction_factor_formulae#Colebrook%E2%80%93White_equation|Darcy friction factor formulae]],
+'Public Rr As Double 'Relative Roughness unitless
+Public Ff As Double 'Friction Factor unitless
+Public Fnew As Double
+Public error As Double
+Public i As Integer
+Public Function Pipefriction(Re, Rr)
+'
+' Calculated Moody Friction Factor for fluid flows
+'
+'https://en.wikipedia.org/wiki/Darcy_friction_factor_formulae
+'
+'The log function is understood to be base-10 (as is customary in engineering fields): if x = log(y), then y = 10x.
+'Hence, Loge(10)=2.30258509299405, 2/loge(10)=0.8685889638065
+'
+Ff = -1
+i = 0
+If Re > 0 And Re <= 2000 Then
+    Ff = 64 / Re
+ElseIf Re > 2000# And Re < 90000000000# And Rr > 0 And Rr < 0.01 Then
+    Ff = 0.015
+    Do
+        ' Fnew = 1 / (2 * Log10(Rr / 3.7 + 2.51 / (Re * Ff ^ 0.5))) ^ 2
+        Fnew = 1 / (0.8685889638065 * Log(Rr / 3.7 + 2.51 / (Re * Ff ^ 0.5))) ^ 2
+        error = Abs(Fnew - Ff) / Fnew
+        Ff = Fnew
+        i = i + 1
+    Loop Until error < 0.00001
+End If
+Pipefriction = Ff
+End Function
+'Static Function Log10(X)
+'    Log10 = Log(X) / Log(10#)
+'End Function</code>++++
+As can be seen in the wiki page, [[https://en.wikipedia.org/wiki/Darcy_friction_factor_formulae#Colebrook%E2%80%93White_equation|Darcy friction factor formulae]], there are reasonably accurate equations that approximate the Colebrook equation that are available that do not require iterations to solve.  I believe the VBscript is simpler and not an approximation.....
+====Excel Conditional Formatting Applies to Field Changing Unexpectedly====
+MSExcel unnecessarily and annoyingly changes conditional formatting ranges.
+The options menu, advanced options, Editing options, unselect Extend data range formats and formulas reputedly stops this behavior.  Unfortunately, it also stops the automatic copying of formula when inserting new rows or adding new lines to the bottom of an existing list.
+References:
+  *[[https://answers.microsoft.com/en-us/msoffice/forum/all/excel-conditional-formatting-applies-to-field/9fa1d051-0599-4763-9782-87dc118fbfa2|Excel Conditional Formatting Applies To Field Changing Unexpectedly]]
+  *[[https://support.microsoft.com/en-us/office/advanced-options-33244b32-fe79-4579-91a6-48b3be0377c4|MSExcel Advanced Options Description]]
 ======MS Word======
@@ Line 271: / Line 414: @@
 ======Autodesk======
-=====AutoCAD Hardware Acceleration=====
+=====AutoCAD=====
-The Intel built in graphics accelerator seems to have problems with proper full screen resolution on 4K monitors.  A solution to rectify this is to turn off the hardware acceleration within the AutoCAD product, see [[https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/How-to-enable-or-disable-hardware-acceleration-in-AutoCAD.html|How to enable or disable hardware acceleration in AutoCAD]].  The hardware configuration option can be found using the following commpands: '' graphicsconfig, 3Dconfig, options.
+====AutoCAD Hardware Acceleration====
+The Intel built in graphics accelerator seems to have problems with proper full screen resolution on 4K monitors.  A solution to rectify this is to turn off the hardware acceleration within the AutoCAD product, see [[https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/How-to-enable-or-disable-hardware-acceleration-in-AutoCAD.html|How to enable or disable hardware acceleration in AutoCAD]].  The hardware configuration option can be found using the following commands: ''graphicsconfig'', 3Dconfig, options.
+====Annotative block=====
+If inserting block does not seem to scale or show up check the annotative option on the block properties.  The option can only be changed in block edit.
+====Inserting a Picture====
+Attaching a picture effectively externally references the picture.  Unlike a drawing xref these ole object do not seem to be able to be bound (embedded) to the drawing. This is subject to links path breakage, particularly on multiuser system.  Where the image is in the same directory the path can be specified as "./image.file".
+Use the PASTESPEC command and paste in as a picture file.  This embeds into drawing file, not as a link.
+====New Paperspace View port====
+  *''viewport'' to create new viewport
+  *''grid'' ''off'' to turn off grid
+====STYLEMANAGER====
+The command ''STYLEMANGER'' opens up the directory where the plot styles are stored.  Different plot styles can be copied to and from this directory.
+======Accessibility Contract Checker======
+Form versus function, unfortunately the moronic types seem to favour form over function.  Contrast of text is particularly important to allow easier reading.
+  *WebAIM
+    *[[https://webaim.org/resources/contrastchecker/|Contrast Checker]]
+    *[[https://webaim.org/articles/contrast/|Contract and Color Accessibility]]
+    *[[https://webaim.org/articles/|Articles]]
+  *[[https://www.stylemanual.gov.au/|The standard for Australian Government writing and editing]]
+  *[[https://stylemanual.com.au/contents/writing/logical-structure/styles-and-templates|Sytle and templates]]
 <- home_server:web_server_setup|prev page ^ home_server:index|Start page ^ home_server:index|next page ->