R – Notes & future requirements
Steps that I need to be able to perform efficiently in R: Descriptive stats for each variable in a
Read MoreEverything is open for discussion…
Programming
Steps that I need to be able to perform efficiently in R: Descriptive stats for each variable in a
Read MoreAfter installing wordpress into home directory (ie public_html ) I realised it is not as clean as one would want
Read MoreCore principles to follow for web page layout: Appropriate break points for the most popular devices…phones, tablets/laptops & PCs are: Smart phone < 768px < Tablet < 1023px < Desktop Example: @media only screen and (max-width: 768px){ /* CSS rules to apply to smart phones goes here */ }
Read MoreWhile overhauling a site, I ended up with many obsolete rules in classes that are no longer applied. To help clean up the CSS stylesheet I wanted to list all class names so I could do a comparison. This answer from stackoverflow did 90% of what I needed
Read MoreWithout a correctly set .gitignore file during site development using wordpress, thousands of files are unnecessarily tracked. WordPress and wordpress
Read MoreGitKraken’s .gitignore wordpress template is a good basis to start with… [code lang=”powershell”] # ignore everything in the root except
Read MoreSimple steps to ensure the footer remains at the bottom of the page. These are: set body tag to min-height:100vh with padding-bottom to the height of the footer and set footer to position:absolute, bottom:0px
Read MoreCreates multiple folders in specified location for a list of specified years and inserts sub-folders for each month in each year folder.
Scenario: Maintaining dated documents such as photos or receipts. This script quickly creates a suitable folder structure for the years required.
Use: Function LastRowInt(InWS As Worksheet) As Integer LastRowInt = InWS.UsedRange.Find(What:=”*”, After:=InWS.Cells(1, 1), Lookat:=xlPart, _ LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, _ MatchCase:=False).Row End
Read MoreReading data directly from excel file rather than saving in csv file format.
Read More