Loading...
Toggle navigation
Site
About This Wiki
Using JoiWiki
Languages
CSharp
VB.Net
SQL
VBA
Windows Scripting
Linux Scripting
Article Type
Code
Documentation
Theory
How To
Code Repo
Log in
Username :
Password:
CapsLock is on.
Remember me (for 1 week)
Log in
I forgot my password
Stay in SSL mode:
?
Structures
Developer
JoiWiki
»
Excel Fomulae
Excel Fomulae
Excel Fomulae
Table of contents:
Developer
Dev Resources
.Net
.Net Theory
CSharp Event Patterns
VB.Net Event Patterns
App.Config
User Defined Conversions
Lambda Shortcuts
.Net Snippets
CSharp Loop Through Command Line Arguments
CSharp Test for Table in Access DB Through OleDb
Serialise Object to XML
CSharp Append to txt File
CSharp Dynamic ContextMenu
Reflection to fill Class properties from an Array of Values
Quick and Dirty Log File
Collection Manipulation Shotcuts
CSharp Get Classes that Implement an Interface
Databases
SQL Language
SQL Transactions
MySQL Command Line
Common Table Expressions
Testing for Nothing Parameters
SQL Scripts
SQL Transaction Scripts
SQL Find Columns Named
SQL List Columns on Table
SQL Show Unique Tables Between Databases
SSMS Search Stored Procedure Content
SSMS Stored Procedure - Create Audit Table and Trigger
SSMS Test Index Fragmentation
SQL Find Stored Proc Info
Copy One Database to Another
MS Office
Excel Tips and Tricks
Excel Named Range Tricks
Excel Calling Subs with Parameters from a Worksheet
Excel Unprotect WorkSheets
Disable VBA IDE Error Popup
VBA Passing Parameters to Methods from Worksheet Buttons
Bulk Add Apostrophes to Cells
Excel Fomulae
Multiple List Values from Criteria
Quick Random Numbers
VLookup, Offset Match and Index Match for Single Values
Get Last Filled Value in Row or Column
VBA Theory
VBA Error Handling
VBA Event Patterns
VBA Inheritance or Lack of
VBA Excel xlam Addins
Excel xlam Adding a Custom Ribbon
Excel xlam Adding Buttons to the Ribbon
VBA Snippets
VBA Excel ShowHide Columns
VBA Open Word Doc
VBA Custom Command Line Arguments
VBA Common Methods
VBA Testing Dynamic Array Initialisation
VBA Date Functions
Programming Concepts
Core Concepts
Procedural Programming
Object Oriented Programming
Classes and their Features
Applications
Git
Git Concepts and Setup
Git Basics
Setting up a New Repo
The .gitignore File
Changing Home for Git
Submodules in Git
Git Commands
Reverting Changes
Common Lifecycle Commands
Tortoise Git
TiddlyWiki
Adding Plugins to your TiddlyWiki
Adding a Favourites to the Menu Bar
Adding an Expandable Contents
SSMS
SSMS Refresh Intellisense
Websites
TikiWiki
Replacing TikiWiki Favicons
TikiWiki Setup
Adding a New Structure
WordPress
Web Hosting
Adding SSL Support to a Website
Website DNS Settings
Using Windows
Windows Keyboard Shortcuts
Windows Tips and Tricks
Assigning Application Hotkeys in Windows
Managing Resources
Setting Up a Shared Folder on Your Network
Windows Scripting
HTA Applications
Windows Script Snippets
Moving files with VBScript
Making Folders with Batch Script
Finding Folders with VBScript
Re-Registering a .dll with Batch
Delete Locked File in Windows with Powershell
Using Linux
Bash and its Uses
XML Based Tech
XSLT XPath Variable use
Dev Random How To
Find ODBC Entry Values in Regedit
Maker
Arduino
Arduino Software
3D Printing
3D Printing How To
Setting the Z Offset
The "Cold Pull" Technique for Hot End Cleaning
Add an LED Strip to Your Printer
3D Printing Troubleshooting
Ender 5
Ender 5 Upgrades
Extruder Gear and Bowden Tubing Upgrade
Ender 5 Board upgrade
Silent Board Upgrade
Ender 5 Cura Profile Tweaks
Anet A6
Anet A6 Upgrades
Useful GCode
Cocktails
How to Mix a Cocktail
Cocktail Recipes
Corpse Reviver #2
Metal Working
The Complete DIY Kiln
3D Modelling
OpenSCAD
Blender
Musician
Music Theory
Music Notation Software
The Fundamentals
Guitar
Guitar Exercises
Learning the Fretboard
Developing Technique
Recording
VST Plugins
Conditioning Your PC
Current Setup
Miscellany
Games
Elden Ring Cheat Sheet
Stuff to Remember
Watching and To Watch
;){kind=link}
;){kind=link}
;){kind=link}
;){kind=link}