Skip to content

Instantly share code, notes, and snippets.

@pauldwhitman
pauldwhitman / vCNStoNSX-step4-upgradevCD
Created May 30, 2021 19:26
vCNS to NSX Upgrade, Step 4. Upgrade vCloud Director.
VMware Product Before Step 4 After Step 4
-------------- ------------- ------------
vCloud Director 5.5.4 5.5.6
vCloud Networking and Security (vCNS) 5.5.4 (no change)
vCenter 6.0 U1 (ISO build 3040890, Windows build 3018524) (no change)
ESXi 6.0 U1b (ISO build 3380124) (no change)
Site Recovery Manager (SRM) 6.0.0.1 (build 2580226) (no change)
@pauldwhitman
pauldwhitman / vCNStoNSX-step3-upgradeESXiToVersion6
Created May 30, 2021 19:20
vCNS to NSX Upgrade, Step 3. Upgrade ESXi.
VMware Product Before Step 3 After Step 3
-------------- ------------- ------------
vCloud Director 5.5.4 (no change)
vCloud Networking and Security (vCNS) 5.5.4 (no change)
vCenter 6.0 U1 (ISO build 3040890, Windows build 3018524) (no change)
ESXi 5.5.0 Update 2 6.0 U1b (ISO build 3380124)
Site Recovery Manager (SRM) 6.0.0.1 (build 2580226) (no change)
@pauldwhitman
pauldwhitman / vCNStoNSX-step2B-upgradeSRM
Created May 30, 2021 19:15
vCNS to NSX Upgrade, Step 2B. Upgrade SRM.
VMware Product Before Step 2B After Step 2B
-------------- ------------- ------------
vCloud Director 5.5.4 (no change)
vCloud Networking and Security (vCNS) 5.5.4 (no change)
vCenter 6.0 U1 (ISO build 3040890, Windows build 3018524) (no change)
ESXi 5.5.0 Update 2 (no change)
Site Recovery Manager (SRM) 5.8.1.1 (build 4130000) 6.0.0.1 (build 2580226)
@pauldwhitman
pauldwhitman / vCNStoNSX-step2A-upgradevCenter
Last active May 30, 2021 15:27
vCNS to NSX Upgrade, Step 2A. Upgrade vCenter.
VMware Product Before Step 2A After Step 2A
-------------- ------------- ------------
vCloud Director 5.5.4 (no change)
vCloud Networking and Security (vCNS) 5.5.4 (no change)
vCenter 5.5.0 Update 2B 6.0 U1 (ISO build 3040890, Windows build 3018524)
ESXi 5.5.0 Update 2 (no change)
Site Recovery Manager (SRM) 5.8.1.1 (build 4130000) (no change)
@pauldwhitman
pauldwhitman / vCNStoNSX-step1-makeESXiVersionsConsistent
Last active May 30, 2021 19:13
vCNS to NSX Upgrade, Step 1. Upgrade ESXi versions across environment to get consistency.
VMware Product Before Step 1 After Step 1
-------------- ------------- ------------
vCloud Director 5.5.4 (no change)
vCloud Networking and Security (vCNS) 5.5.4 (no change)
vCenter 5.5.0 Update 2B (no change)
ESXi 5.5.0 Update 2 5.5.0 Update 2
ESXi 5.5.0 Patch 3 5.5.0 Update 2
ESXi 5.5.0 Patch 5 Re-release 5.5.0 Update 2
ESXi 5.5.0 Update 3a 5.5.0 Update 2
Site Recovery Manager (SRM) 5.8.1.1 (build 4130000) 6.5
@pauldwhitman
pauldwhitman / vCNStoNSX-step0-currentStateAndTargetState
Last active May 30, 2021 19:12
vCNS to NSX Upgrade, Step 0. Determine your Current State and Target State versions.
VMware Product Current State Target State
-------------- ------------- ------------
vCloud Director 5.5.4 8.20
vCloud Networking and Security (vCNS) 5.5.4 VMware NSX 6.3.1
vCenter 5.5.0 Update 2B 6.5.0
ESXi 5.5.0 Update 2 6.5.0
ESXi 5.5.0 Patch 3 6.5.0
ESXi 5.5.0 Patch 5 Re-release 6.5.0
ESXi 5.5.0 Update 3a 6.5.0
Site Recovery Manager (SRM) 5.8.1.1 (build 4130000) 6.5
@pauldwhitman
pauldwhitman / excelStampDutyACTCanberraAustralia-tableCurrent-reproduceOnlineCalculator
Created January 29, 2017 09:39
Microsoft Excel formula for calculating stamp duty in Australian Capital Territory (ACT, commonly referred to as "Canberra"), Australia.
=
IF(A1 >= 1455000, 0 + 0.0509 * A1,
IF(A1 >= 1000001, 42210 + 0.07 * (A1 - 1000001),
IF(A1 >= 750001, 25960 + 0.065 * (A1 - 750001),
IF(A1 >= 500001, 13460 + 0.05 * (A1 - 500001),
IF(A1 >= 300001, 5460 + 0.04 * (A1 - 300001),
IF(A1 >= 200001, 2960 + 0.025 * (A1 - 200001),
MAX(0.0148*A1,20)
))))))
=
IF(A1 > 725000, 28453 + 0.0515 * (A1 - 725000),
IF(A1 > 360000, 11115 + 0.0475 * (A1 - 360000),
IF(A1 > 150000, 3135 + 0.038 * (A1 - 150000),
IF(A1 > 120000, 2280 + 0.0285 * (A1 - 120000),
0.019 * A1)
)))
=
IF(A1 > 725000, 28453 + 0.0515 * (CEILING(A1,100) - 725000),
IF(A1 > 360000, 11115 + 0.0475 * (CEILING(A1,100) - 360000),
IF(A1 > 150000, 3135 + 0.038 * (CEILING(A1,100) - 150000),
IF(A1 > 120000, 2280 + 0.0285 * (CEILING(A1,100) - 120000),
0.019 * CEILING(A1,100))
)))
@pauldwhitman
pauldwhitman / excelStampDutyTasmaniaAustralia-reproduceOnlineCalculator
Created November 20, 2016 10:48
Microsoft Excel formula for calculating stamp duty in Tasmania (TAS), Australia. The output of this formula matches the official calculator (which rounds inputs to the nearest $100), but doesn't match the "letter of the law".
=
IF(A1 > 725000, 27810 + 0.045 * (CEILING(A1,100) - 725000),
IF(A1 > 375000, 12935 + 0.0425 * (CEILING(A1,100) - 375000),
IF(A1 > 200000, 5935 + 0.04 * (CEILING(A1,100) - 200000),
IF(A1 > 75000, 1560 + 0.035 * (CEILING(A1,100) - 75000),
IF(A1 > 25000, 435 + 0.0225 * (CEILING(A1,100) - 25000),
IF(A1 > 3000, 50 + 0.0175 * (CEILING(A1,100) - 3000),
50)
)))))