Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision |
home_server:mswindows_notes [2023-10-05 Thu wk40 12:39] – [Frozen Program Safe Start] baumkp | home_server:mswindows_notes [2024-04-05 Fri wk14 05:36] – [friction factor calculation] baumkp |
---|
*SystemMechanic - a Windows system maintenance program - paid software -**I am no longer using this, looks like spam now** | *SystemMechanic - a Windows system maintenance program - paid software -**I am no longer using this, looks like spam now** |
*AIMP - Music player (reminds me of the old lost classic Winamp) -//I am no longer using this// | *AIMP - Music player (reminds me of the old lost classic Winamp) -//I am no longer using this// |
*Clementine - Music player, looks like a modern take on Winamp. I am using on Linux via Flatpak and also have installed on Windows 11 desktop. (**!L**) | *Clementine - Music player, looks like a modern take on Winamp. I am using on Linux via Flatpak and also have installed on Windows 11 desktop. (!L) |
| *Strawberry is a fork of Clementine and looks to be better maintained. (**!L**) |
*Spotify (**!L**) (I have family license as my sons have demanded.....) I am now family subscribed to YouTube which automatically gives YouTube Music. I will probably move away from Spotify for this reason. | *Spotify (**!L**) (I have family license as my sons have demanded.....) I am now family subscribed to YouTube which automatically gives YouTube Music. I will probably move away from Spotify for this reason. |
*Youtube / Youtube Music, is web based on desktop and has apps for iOS (**!L**) | *Youtube / Youtube Music, is web based on desktop and has apps for iOS (**!L**) |
| |
Notes on licensed software: | Notes on licensed software: |
*Xplorer2 :- I am going back to using plan Windows Explorer. The licensing requirements were a pain in the arse. I appreciate that the author fairly and reasonably wants to make money from the product he has worked on, however I was primarily use this product at home on a few machines and on on work machine. The author required that I have licenses on every machine. This couples with learning the interface that is not identical to vanilla Explorer made me give up on the software. Also at home I now primarily use Linux desktop for which Xplorer2 does not function. I believe I had 2 for life licenses. I suspect the author may have modified the "for life | *Xplorer2 :- I am going back to using plan Windows Explorer. The licensing requirements were a pain in the arse. I appreciate that the author fairly and reasonably wants to make money from the product he has worked on, however I was primarily using this product at home on a few machines and on a work machine. The author required that I have licenses on every machine. This coupled with learning the interface that is not identical to vanilla Explorer made me give up on the software. Also, at home I now primarily use Linux desktop for which Xplorer2 does not function. I believe I had 2 for life licenses, although this was for 2 different versions of the application. I suspect the author may have modified the "for life license"? As of 2024 I have not used this product for circa 7 years. |
*Polyview :- Went the way of the Dodo..... I had a license. I do not regret purchasing this license once off. I got many year of use. It worked really well at the time. I remember sending a query to the author concerning font comparability, circa 2008. He said the program was ANSI font only not compatible with the expanded font set, I forget what it is called now. | *Polyview :- Went the way of the Dodo..... I had a license. I do not regret purchasing this license once off. I got many years of use. It worked really well at the time. I remember sending a query to the author concerning font comparability, circa 2008. He said the program was ANSI font only not compatible with the expanded font set, I forget what it is called now. |
*Vuescan :- simply the best scanner program around, consistently an well supported. Multi platformed, Windows, Linux, perhaps Mac. | *VueScan :- simply the best scanner program around, consistently well supported. Multi platformed, Windows, Linux, perhaps Mac. |
*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. | *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 original wanted and I ended up going with family option. Will probably move to Youtube option as it included Youtube plus Music. | *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]] |
\\ | \\ |
After this I want to list the level of the directory, to do this I count the number of "\" in cell B3: ''=LEN(B3)-LEN(SUBSTITUTE(B3,"\",""))'' | After this I want to list the level of the directory, to do this I count the number of "\" in cell B3: ''=LEN(B3)-LEN(SUBSTITUTE(B3,"\",""))'' |
| |
| =====MSExcel Visual Basic===== |
| |
| ====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. |
| ++++VSBasic code for Colebrook Equation| |
| <code basic>'Public Re As Double 'Reynold number unitless 0<Re<10E9 |
| '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. |
| |
| 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====== |
| *[[https://www.bettersolutions.com/word/fields/toc-field.htm|TOC [switches]]] |
| *''{ TOC \o "1-2" \h \z \f }'' |
| *The TOC \f switch will include identified TC fields |
| *[[https://www.bettersolutions.com/word/fields/tc-field.htm|TC "text" [switches]]] |
| *''{ TC "Appendix A - Content/Name" \l 1 \n }'' |
| |
| =====MS Word and Excel Keyboard Shortcuts===== |
| Replace File menu commands: |
| *%%Ctrl-p for print dialogue%% |
| *%%Ctrl-S or Shift-F12 for save%% |
| *%%F12 for save-as%% |
| *%Ctrl-w to close the current document%% |
| *%Ctrl-n or Ctrl-Alt-F2 to create new document%% |
| |
| *[[https://www.computerhope.com/shortcut/word.htm#:~:text=Microsoft%20Word%20keyboard%20shortcuts%20%20%20%20Shortcut,the%20r%20...%20%2040%20more%20rows%20|Microsoft Word keyboard shortcuts]] |
| |
======Frozen Program Safe Start====== | ======Frozen Program Safe Start====== |
======Autodesk====== | ======Autodesk====== |
| |
======AutoCAD Hardware Acceleration===== | =====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 commpands: '' graphicsconfig, 3Dconfig, options. | 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. |
| |