Skip to content

Instantly share code, notes, and snippets.

Windows Server 2022 Standard key:
HP9DJ-NK2X6-4QPCH-8HY8H-6X2XY
RRNMT-FP29D-CHKCH-GWQP2-DDDVB
44QN4-X3R72-9X3VK-3DWD6-HFWDM
CGGN9-DG8BW-PMBB4-Y79Y9-Y7X7B
PGQ8Y-WHN93-WY67T-FJXP7-QPHHB
Windows Server 2022 Datacenter Key
N7MMC-VGFH4-GVRDT-K9Q44-X2HJH
MNF6T-BTCTK-Q4HPP-KP2WG-VCHJH
@minnthuwinn
minnthuwinn / excel formulas.md
Created September 18, 2023 14:36 — forked from f-steff/excel formulas.md
Excel formulas to calculate IP values such as Netmask, IP range start, IP range end, Broadcast IP, Number of hosts.

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

Updated March 16. 2023

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.

VMware vSphere 6 Enterprise Plus
1C20K-4Z214-H84U1-T92EP-92838
1A2JU-DEH12-48460-CT956-AC84D
MC28R-4L006-484D1-VV8NK-C7R58
5C6TK-4C39J-48E00-PH0XH-828Q4
4A4X0-69HE3-M8548-6L1QK-1Y240
VMware vSphere with Operations Management 6 Enterprise
4Y2NU-4Z301-085C8-M18EP-2K8M8
1Y48R-0EJEK-084R0-GK9XM-23R52