Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
home_server:mswindows_notes [2024-03-14 Thu wk11 05:31] – [friction factor calculation] baumkphome_server:mswindows_notes [2024-07-11 Thu wk28 15:31] (current) – [New Paperspace View port] baumkp
Line 237: Line 237:
 ====friction factor calculation==== ====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. 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 basic> +++++VSBasic code for Colebrook Equation| 
-'Public Re As Double 'Reynold number unitless 0<Re<10E9+<code basic>'Public Re As Double 'Reynold number unitless 0<Re<10E9
 'Public Rr As Double 'Relative Roughness unitless 'Public Rr As Double 'Relative Roughness unitless
 Public Ff As Double 'Friction Factor unitless Public Ff As Double 'Friction Factor unitless
Line 285: Line 285:
 'Static Function Log10(X) 'Static Function Log10(X)
 '    Log10 = Log(X) / Log(10#) '    Log10 = Log(X) / Log(10#)
-'End Function +'End Function</code>++++
-</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======
Line 319: Line 327:
 ======Autodesk====== ======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
  
 +======Accessibility Contract Checker======
 +Form versus function, unfortunately the moronic types seem to favour form over function.  Contrast of text is particularly im
 +  *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 -> <- home_server:web_server_setup|prev page ^ home_server:index|Start page ^ home_server:index|next page ->