f-steff

Excel formulas to calculate IP values - Works in Excel and Google Sheet.

Updated 2023-12-11: Hosts calculation updated to support CIDR or 31 and 32.

Prerequisites:

• A1 contains an IP address, such as 10.0.0.2
• B1 contains the number of bits in the netmask (CIDR) such as 24

The below formulas then go into C1, D1 etc. to perform the various calculations. Some calculations depends on other calculations.

jdhitsolutions

#requires -version 5.0

# https://gist.github.com/jdhitsolutions/7217ed9293f18e8d454e3f88ecb38b67

Function Compare-Module {
    <#
.Synopsis
Compare module versions.
.Description
Use this command to compare module versions between what is installed against an online repository like the PSGallery. Results will be automatically sorted by module name.

xcud

<#
.Synopsis
        Gets a list of the assemblies loaded into memory in the current AppDomain.
.Example
        PS> Get-Assemblies power -NameOnly

	Name
	----
	Microsoft.PowerShell.ConsoleHost.dll
	Microsoft.PowerShell.Security.dll