This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision |
home_server:mswindows_notes [2024-03-14 Thu wk11 05:39] – [friction factor calculation] baumkp | home_server:mswindows_notes [2024-04-05 Fri wk14 05:38] – [Excel Conditional Formatting Applies to Field Changing Unexpectedly] baumkp |
---|
'End Function</code>++++ | '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..... | 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====== |