KPTree

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>mswindows windows setup tip notes personal license}}
======KPTree - MSWindows Setup======
=====Background=====
I have Windows on my main desk top machine, it is dual boot with Debian/XFCE.  I am using Debian almost exclusivly now.  The BIOS based dual boot works well, I have it defaulting to Debian.  I do not currently have a Windows VM setup on my main server.  My 3 sons also have computers with Windows on them. Lastly, I am required to used company Windows machines at work.  Hence I like to keep a list of my preferred Windows software reasonable up to date.

I have been using Microsoft products for quite some time, starting with MSDos then Windows 3.0, 3.1, 95, 98, XP, 7, 8, 8.1 and finally 10. (I managed to skip some of the duds, such as ME, 2000 and Vista, although I did occasionally use them on friends, family and work machines. Contrary to all the noise I never had any problems with version 8 & 8.1. I thought ME was bad and Vista too, but as noted basically managed to avoid them in the most part.)

++++tldr; Old build|
Recently my main home office machine failed. I build this computer myself. Basically originally an Intel i7 with the built-in graphics and a 2TB HD, 32GB RAM (16GB would have been enough) and of course a Seasonic 80plus gold power supply. I then quickly replaced with a 500GB SSD, by this time I had my Linux home server running and used this as a NAS for bulk storage and serving. When I set the machine up it was based upon Windows 7 (64bit of course). When Windows 8 came out I upgraded, then Windows 8.1 and finally Windows 10. A few years later I added a Nvidia 960 graphics card, to help breathe a bit of extra life into the machine (and play games better....) I have tried quite a large amount of software on this machine over the period and it was somewhat cluttered, albeit I did run the likes of CCleaner and SystemMechanic to help keep it usable. In any case I tried to load AutoCADLT 2017 on the machine (yes, a licensed version, my being a professional engineer) it worked on the first evening after loading, then the following day ACADLT stopped working. I tried to get it working to no avail and attempted a reinstall, also to no avail. The following day the machine would not run with the dreaded blue screen of death. Nothing I attempted would revive it. So I investigated a clean Windows 10 install. I downloaded a Windows 10 recovery / installation on to a USB. Turns out product code is no longer required, and my registration for this machine is tied to the hardware and my Microsoft account. After this reinstalling Windows 10 was a breeze. My original install was totally shot. Hopefully I did not have any important information left on the local documents directory. Unknown, unlikely, but possible. Helps to have the Linux NAS and Nextcloud working. It is also a reminder to do my NAS and Nextcloud backups. I got to keep on top of this, and need to try to do it every month.

My son got my old machine and I upgraded to a new Intel i9, with 1TB NVM SSD and 16GB RAM. Of course with a Seasonic 660W Titanium power supply. My first water cool CPU, which has been working a treat!. No graphics card yet, would like to get one in the next year or so.  My youngest son got this machine in early 2022. I got a new Intel i9 NUC, which I got with 32GB or RAM and 2TB NvME.  I am currently using the built-in Intel graphics, but the NUC will allow a lower tier full size graphics card to be installed (graphics cards is primarily limited by 2 bay size, 650W power supply). ++++

So below is a list of Windows software often use.

----

=====MSWindows 10 - Software Install List=====
//**I do not use Windows much at home anymore.**//  I have highlighted the software I still use with a (**!**), and software I use on my Linux desktop **L**\\
  *First up to make easier to load up system
     *Nextcloud Windows client - Cloud server client (**!L**)
     *Keepass - Password and other secret info repository (**!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.//
     *%%Notepad++%% - a good general text editor for Windows
  *Utilities
     *%%Notepad++%% - a good general text editor for Windows.  Seemed really good on Windows.  I use VIM on Linux now.
     *7Zip - a good general file compression program (**!**)
     *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**)
     *iTunes - Apple iOS update control software - See Separate Section below (**!**)
     *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**)
     *I no longer use Rsync on the Linux systems to do the back-ups, I basically do not store and main archive or working data on the local windows machines anymore. I try to copy anything important into the Nextcloud sync directory or work of the server.
  *Multimedia
     *Firefox web browser (I do not like using Microsoft and Google browser) (**!L**)
     *Calibre - an electronic book database and reader (**!L**)
     *VLC - seems to do a better job than mPlayer / Media player classic (**!L**)
     *PolyView - a picture / photo view (sadly would seem no longer supported) It is no longer supported and does not operate that well with Windows 10.  //I no longer use this software as it does not work will with Windows 10.  I use Faststone now//
     *Windows Media Player Classic - a video player -//I no longer use as prefer to use VLC now.//
     *Faststone Image View - A simple photo viewer that seems fast - Freeware (**!**)  I also use this at work.
     *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//
     *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.
     *Youtube / Youtube Music, is web based on desktop and has apps for iOS (**!L**)
  *Remote Control / Cloud
     *Nextcloud Windows client - Cloud server client (**!L**)
     *Putty - a SSH terminal program for Windows (**!**)
     *TigerVNC - remove video terminal program (**!L**)
  *Security
      *Keepass - Password and other secret info repository (**!L**)
      *iSpy - an IP camera viewer program - I have not been playing with the Security cameras lately.  I need to upgrade the system.
      *Tor - a more secure web browser (**!L**)
  *Productivity (Unless otherwise noted the software I use at work provided by work. I believe it to be appropriately licensed by work too.)
      *ACadLT2017 - CAD - got rid of this subscription, just too expensive for my occasional use.
      *ACAD 2022 - CAD software I use at work.
      *Navisworks - 3D productivity software, I started using the limited free, version at work, Freedom.  I now have the full version at work, Manage.
      *Foxit Pro - a PDF reader and writer (**!**) I use my private license at work.
      *Qoppa PDF Studio - I got this for my Linux desktop.  It is sadly the only **full** pdf suit I could find on Linux. I have not tried on Windows or for work.  It looks pretty good though.(**!L**)
      *Bluebeam Revu - a PDF reader and writer I use at work now, definitely has the best PDF technician editing functions I have seen.  I still find working on standard documents easier on Foxit or Qoppa.
      *LibreOffice - a office software suite -//I have not been using lately, and just using MSOffice, but will probably try again// (**!L**)
      *Microsoft Office 365 home subscription, allows use on 5 home computers and give 1TB One drive cloud access (**!**)

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 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 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 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.  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====
[[https://learn.microsoft.com/en-us/windows/powertoys/install|Install PowerToys]]
====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.  

I suppose the problem is the middle man, usually representing wealthy entitled people that use wealth and power to further their power and wealth.

I have the following 2 personal examples that highlight why I do not like paid licensed software.

A very big problem with paid licenses is the common absurd software licenses that go with them. They are a disgrace.  Generally they enormously limit the paying end users rights.  They are also so long who would bother reading them anyway.  Ultimately, if one has paid to use the software one should have the right to use, otherwise why pay.

===Autodesk License===
I had for many years a license for Autodesk AutoCAD Light.  This was not cheap software costing on average a few hundred dollar per year for the right to use.  My personal use was very limited, but I wanted access to this software.  I did use this software at work too, I could guarantee I was the only person using this license at any one time.  Autodesk charges different prices for their product in different countries, there are some valid reasons for this, but the main reason is to do with maximizing profit, in wealthier countries they can simply get away with charging more, in poor countries generally less.  Also there are marketing reasons in populous countries they may charge lower pricing to increase market penetration and make more sales, hence overall more profit. Sadly I come from a relatively wealthy country with a relatively small population, read higher pricing! The argument from the seller is that is cost more to sell in my country, however being English speaking I would be quite happy to use the USA version of the software at the USA price!  Basically many USA aspects are forced down our throat anyway, e.g. date format.\\ 
In any case I was assigned to work in China for about a year. About 3-4 months working in China I had a call from the company software department to ask if I was using AutoCAD Light software.  I said yes, but with paid for license.  Nevertheless they asked that I remove the software from the company computer, to which I immediately acquiesced.  Upon reading the license for the produce I found I only had the right to use the software in another country for 90 days after which I was expected to purchase a local version there!  Like I was expected to purchase a Chinese license of the software.  This was totally unacceptable and really is an example of gross license conditions failure.\\ 
I still use Autodesk products at Work using the license provided from work.  These are often corporate based network licenses that only work if connected to the network.  There is a method to fix a license to a machine, if required. 
 
===xplorer2===
xplorer2 is a nice Windows Explorer replacement with many extra features. I used for a number of years, but again the licensing requirement just became more than they were worth for me.\\  I purchased a copy for personal home use and another copy for work use.  The license is tied to a particular computer on to which the software is installed and authorised for use.  I have a number of computers at home, and generally only one at work. It was basically required that I have a license for every computer at home, I could not justify the expense and inconvenience associated with swapping active license on machines at home. I asked to install the license on more than one machine and the response was basically one license one machine!\\  Basically the built in version of Explorer in Windows meets 95+% of my daily needs.\\
An additional problem with using xplorer2 was that I got use to using it and when I went back to standard explorer it was uncomfortable to use.   As this software is basically on every Windows machine this happened often. So I have simply stopped using xplorer2 at work and at home, it is simply not worth the trouble, particularly with the restrictive license requirements.\\
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===
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."

====Software Bigotry==== 
Licensed software is often full of terms that are arguably bigoted, however this is usually simply a goal to maximize profit.  Sadly some GNU software providers seem to provide limits on their software use based upon their biases.

====iTunes - setup====

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.

I really now only use this software to backup and restore Apple devices.... The app functionality has been removed by Apple, which is good as I was wasting too much of my time..... Otherwise iTune is and always has been crap ware.....particularly on MSWindows machine.

  -Download from Apple and install the latest Windows 10 64bit version of iTunes.
  -Run iTunes and check the location of the "iTunes Media folder location" found in the menu item: Edit, Preferences, Advanced tab. e.g. "C:\Users\doej\Music\iTunes\iTunes Media"
  -Stop iTunes running
  -If moving an exiting iTunes data directory first time, copy ''C:\Users\doej\Music\iTunes'' to ''%%\\NASname\various_path\iTunes%%''
  -Rename ''%%C:\Users\doej\Music\iTunes%%'' to ''%%C:\Users\doej\Music\iTunes_old%%'', or simply delete.
  -Open Administrator Command Prompt(right click windows start and select so). Then run following command to create a simlink to NAS stored iTunes library: ''%%mklink /D 'C:\Users\doej\Music\iTunes'%%'' ''%%\\NASname\various_path\iTunes%%''. The command should state symbolic link created as given in original command.
  -The backup files are found at: ''%%C:\Users\baumk\AppData\Roaming\Apple Computer\MobileSync\Backup%%''.
  -Often the backup will not work or be seen. The solution is to move to another directory and then add back to the official directory until the correct backup directory is found or until adding one stops iTunes from working. More shoddy Apple software......

====iTunes - Not Recognising Devices====

iTunes is a pretty flakey program and Apple does play the propriety with the Lightning cable, so the problem could be any of the following:
  *Bad cable
  *Bad USB driver
  *Bad USB port
  *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=====
With the problems on the old printer noted below I decided to replace the printer scanner.  After 4 year of use it looks like I made the correct decision to go with the lower priced larger A3 printer with disposable ink cartridges.
  *Key point is I do very little printing at home.  If fact so little that some time I need to do a deep clean on the nozzles as they have blocked from infrequent use, usually after 1 - 2 months of non-use.  I need to try to remember to print a basic test page every month at minimum. 

++++I looked at 2 main options:|
  *An A3 multi function from Epson the WF-7725, this is the option I went with.
    *The printer cost is about 2x the large ink cartridge pack cost.  Which at 4 years I have only purchased 2 times.  I need to purchase a spare again soon.
    *The printer and scanner are full A3, including the ADF!
    *Everything has been working well after 4 years.  The ADF (Automatic document feeder) was nice to use, compared to the old manual single page scanner!  I do need to try to run the printer monthly to prevent the nozzles from blocking.
    *The A4 paper cassettes must be setup as portrait not landscape. But should not be problem for bubble jet printer. So a non-issue.
    *The machine is not exceptionally fast, but not a problem for a home office unit. More important is ease of use, long term reliability, and cost to run - read ink cost. I try to limit my printing and have not printed to any photo paper.  After about 7 months I had to replace the black ink cartridge.  The ink cost seem OK for low volume printing.  The scanner works great both platen and auto document feeder.  The auto document feeder is more sensitive that the pro office printers, but works well.
    *The Epson print and scan software worked well on MSWindows10. The ADF scanner scanned a pdf straight to the local computer document directory using the scanner program supplied.
  *An A4 multifunction from Canon or Epson with large refillable ink tanks
    *I looked at the various product review and in general print quality and functionality were commented on as substandard. Looks like these unit still need more polish before they become mainstream. This was the main show stopper for me. In any case after 2-3 year I can always upgrade the printer again, if necessary.
    *A colleague at work mention that the functionality of the Epson Ecotank multifunction A4 he purchased was poorer that his previous generation HP printer.
    *The up front cost is higher, however usually include 2 years of ink, so is competitive cost-wise in this consideration.
    *The A3 version of this printer was significantly more expensive (x5 the WF-7725 cost)
++++
====Old Printer====
++++tldr;| 
I finally stopped using the printer after over 8 years of use in 2019, it was a Canon MP990 multi-function. 

Canon seem to not be supplying an updated driver after Windows 8.1, that is, no Windows 10 drivers. I suspect there are 3 reasons for this; first, due to the age of the printer the vendor does not wish to spend the money to update the drivers, and second, the vendor hopes that users will simply purchase a new printer! Fortunately the default MSWindows 10 printer driver seems to work adequately with most required options. Unfortunately, the MSWindows scanner driver options are very limited. I attempted to load the OEM Windows 8.1 drivers, however they did not seem to recognise the printer. So I found a suitable free scanner driver that give the basic required scanner functionality, xxxNAPS2xxx, however the functionality proved to be too limited. I found and purchased a copy of Vuescan and now use this, it is very good and not tied to any particular printer supplier.

About the last 2 years of use I started to use cheaper compatible ink - this was a mistake. It is simply not cheaper! As the printer is less reliable as before just about each use needs to perform the deep nozzle clean. The deep nozzle clean uses so much ink that I run out of ink much faster so the cost saving is negligible. I suspect part of the problem is that I only use the printer every 1-2 months and the compatible ink has greater propensity to dry-up and plug nozzles more than original ink did.

I always felt the original Canon software was quite bloated.
++++
====Offsite Printing====

Printing photos at home is very expensive. The photo paper and original ink are just too expensive (rip off). It is cheaper to setup the photos and get their files printed at the likes of Kmart. These photo printing services even have on-line services or take a USB drive to the store terminal. The photos get mailed to you.
Old printer stuff


=====Windows Drive Link / Substitution=====

In windows both the link and drive substitution commands have their own nuances.....  The main problem with "subst" is that the reference is not canonical. The mklink seems to sometimes fall back to the full path.  

There are two main reasons to use:
  - To overcome the path/name length restriction of 260 characters
  - To simply the path name of regularly used references.

In Linux symlinks seem to be more robust (mind you just about everything seems more robust...)  Symlinks to files are used as a control mechanism.  Hard links are frequently used as a backup technique to minimise real backup space used.

====Windows Symlink equivalent command - mklink====

For some reason Windows 10 will not show my network drives in the Explorer Network directory. Even when it did work it was slow to show the network drives. I can simply type in the network drive into the path, e.g. "\\User1NetworkDrive", but this is a bit clumsy and is not always an option in some file modal windows. A symlink is the best overall solution.

Open up a Command Prompt (Admin) - right click the windows icon or type "Win + X". In Windows 10 you can also type in Command into the Cortina search area and right click on the Command Prompt item.

For files the command syntax is: "mklink Link Target".

I am only really interested in a directory link the syntax is: "mklink /D Link Target", example: "mklink /D C:\Users\User1\User1NetworkDrive \\User1NetworkDrive".

====Windows Drive Substitution - subst ====
This is the command syntax to associate a path with a drive letter:
<file>
SUBST [drive1: [drive2:]path]
SUBST drive1: /D
Parameters
drive1: – Specify a virtual drive to which to assign a path.
[drive2:]path – Specify a physical drive and path to assign to a virtual drive.
/D – Delete a substituted (virtual) drive.
Using the SUBST command with no parameters will display a list of current virtual drives.
</file>

**The GUI option in Windows is to right click the network icon in file explorer.  Then select the option map network drive.  A similar option to Disconnect network drive exists.**

There is an "opposite" to the "subst" command called "join" that makes hardward devices appear as directories.

=====Windows Keyboard Mapping Problems=====
All too often the keyboard mapping seems to get set to the United Kingdom, which messes up a few of the Keys when using a US keyboard. I suspect this is a problem with selecting Australian as the primary English langage that seems to sometime also select the UK keyboard. In any case in Windows 10 the solution is as follows.

The simple solution is to remove the UK language setting and if necessary add the US one. The Australian can remain. Further to this the keyboard layout can be independantly set. The language can be adjusted in the " region and language setting", use Cortana if necessary to find. Click on the language and add the US QWERTY if necessary. Delete the UK QWERTY keyboard layout.

=====Windows Off Screen Problems=====

I have had problems with windows appearing off the screen partially or fully many times over the years, particularly when using multiple monitors.

I found an article on CNet, but will not link to it, as CNet is a real garbage filled site. In any case the simple solutions are listed below:

  *Cascading windows

Right-click on the taskbar and click Cascade windows. This will reset all open window positions and cascade them from the top left screen point. Unfortunately, many media players will not reposition in this manner, and it forces ALL of your windows to reposition -- even the ones that were behaving themselves.

  *Manually moving

Right click on the task bar icon for the specific program and select move. Use the mouse or keyboard direction arrows to move the window selected.

  *Maximise the window

Right click on the task bar icon for the specific program and select Maximise. The window will maximise to the full screen area. When minimised its position will return to previous off screen.

For Windows 10 you need to move over the task bar program until the small program window appears, this also bring to foreground the main window too. Then right click on the small program window to get the move and maximise options.

======MSExcel Tips======

=====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

=====List Windows files and directories into MSExcel=====
The menu : Data : Get Data : From File : From Folder presents a dialogue to input a windows directory. Once the directory is shown the load button will place it into a new sheet

=====MSExcel List file path and name in cell=====
''=CELL("filename",A1)''\\
The cell function returns information about the cell contents.

=====List Directories to csv file=====
This is performed in MSWindows Powershell using command: ''dir -Recurse -Directory | Select FullName | Export-Csv "list.csv"''\\
 \\
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======
  *[[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======
Sometime a program seems to get stuck when starting.  This could be the add-in or other problems.  A possible solution is to start the program in safe mode.
  * Open up run (Windows + R)
  * Type name of program with /safe, e.g. outlook.exe /safe, word.exe /safe or excel.exe /safe
  * Sometime this is enough to allow a normal restart 
  * Check add-ins and stop start-up

Some other possible options to check:
  *Check task manager to see if a frozen process is the problem.\\
  *Restart the computer.

======Autodesk======

=====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.



<- home_server:web_server_setup|prev page ^ home_server:index|Start page ^ home_server:index|next page ->