| Both sides previous revision Previous revision Next revision | Previous revision |
| home_server:mswindows_notes [2024-01-17 Wed wk03 06:38] – [MSWindows 10 - Software Install List] baumkp | home_server:mswindows_notes [2024-04-05 Fri wk14 05:38] (current) – [Excel Conditional Formatting Applies to Field Changing Unexpectedly] baumkp |
|---|
| |
| 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. 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====== | ======MS Word====== |
| |
| =====MS Word and Excel Keyboard Shortcuts===== | =====MS Word and Excel Keyboard Shortcuts===== |
| ^p for print | Replace File menu commands: |
| ^S for save | *%%Ctrl-p for print dialogue%% |
| F12 for save-as | *%%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====== |