oci-rvtools 1.3.0

Convert RVTools Excel exports into an Oracle Cloud (OCI) monthly cost estimate workbook.

Turn VMware RVTools exports into an Oracle Cloud monthly cost estimate

This utility ingests one or more RVTools vInfo sheets, pulls the latest Oracle Cloud Infrastructure prices, and generates an Excel file with per-VM and aggregate monthly costs for all included resources.

Because OCI pricing scales linearly, costs are calculated by summing per-VM OCPU, RAM and disk values — each rounded up to whole units. The output includes a per-VM breakdown alongside aggregate monthly and yearly totals.

Note: VMware and Oracle approach CPU allocation differently. VMware's hypervisor present physical cores and hyperthreads as logical processors for vCPU allocation to guest VMs. Oracle allocates a full physical core (1 OCPU) and lets the guest OS handle both hyperthreads itself. So 1 OCPU equals 2 vCPUs from the guest's perspective. Same physical compute, different abstraction layers. oci-rvtools divides vCPU counts by 2 and rounds up to convert between the two.

---

🚀 Features

• Browser-based web app – no install required. Drop in your RVTools export on oci-rvtools.com and get the cost estimate instantly. Runs 100% browser-local via WebAssembly — nothing is uploaded, nothing leaves your device. Read Security & Privacy for more on this.
• Direct RVTools ingestion – reads raw RVTools_export_all.xlsx files and ignores housekeeping VMs (vCLS-*).
• Multi-file support – pass multiple files, a directory, or upload a .zip of exports in the web app to aggregate across sites.
• Datacenter and Cluster filtering – list all Datacenters and Clusters in the input, then scope the estimate to a specific subset of these.
• Configurable inclusion filters – toggle powered-off VMs for CPU/RAM and powered-off disks for storage calculations independently.
• Automatic unit handling – converts MiB totals to GiB, rounds quantities up to whole units, and maps 2 vCPUs to 1 OCPU.
• Live pricing lookup – fetches list prices for configurable OCI part numbers via the OCI pricing API.
• Console logging – prints aggregation totals, pricing inputs, and powered-on/off inclusion choices to the console.
• Polished Excel output – writes oci_cost_summary.xlsx with a Cost Summary sheet, a VM Details sheet with per-VM cost breakdown, and an OS Summary sheet. All quantities are Excel formulas — Cost Summary totals are driven directly by VM Details rows. Designed to look similar to the output from the official OCI Cost Estimator.

---

⚡ Quick start

Online (no install)

Visit oci-rvtools.com — drop in your RVTools .xlsx or a .zip of multiple exports, choose your options, and get the cost estimate. Everything runs in your browser via WebAssembly.

CLI

# Install from PyPI
pip install oci-rvtools

# Run the estimator
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --output oci_cost_summary.xlsx

The tool contacts the OCI pricing API at runtime. Ensure the machine has outbound internet access.

---

🏗️ Installation options

PyPI, pipx or uv

# pip — installs into your active environment
pip install oci-rvtools

# pipx — isolated install, command available system-wide
pipx install oci-rvtools

# uv — one-off run without a permanent install
uvx oci-rvtools --rvtools ./customer/RVTools_export_all.xlsx

Homebrew (macOS)

brew tap KimTholstorf/oci-rvtools-cost-estimator
brew install oci-rvtools

Docker

# CLI mode — mount your working directory to /data
docker run --rm \
  -v "$(pwd)":/data \
  ghcr.io/kimtholstorf/oci-rvtools-cost-estimator:latest \
  --rvtools /data/RVTools_export_all.xlsx \
  --output /data/oci_cost_summary.xlsx

# Web app mode — no arguments starts the local web UI on port 8080
docker run --rm -p 8080:8080 \
  ghcr.io/kimtholstorf/oci-rvtools-cost-estimator:latest
# then open http://localhost:8080

From source

git clone https://github.com/KimTholstorf/oci-rvtools-cost-estimator.git
cd oci-rvtools-cost-estimator
python3 -m venv .venv
source .venv/bin/activate
pip install .

# Run the CLI
oci-rvtools --rvtools ./customer/RVTools_export_all.xlsx

# Or serve the web UI locally
python3 -m http.server 8080 --directory docs/
# then open http://localhost:8080

---

📥 Input expectations

• RVTools workbook(s) in .xlsx format containing the vInfo sheet (default RVTools_export_all.xlsx).
• All calculations default to powered-on VMs, but powered-off VM CPU/RAM and disk capacity can be included via flags.

---

📤 Output workbook

The generated Excel file (oci_cost_summary.xlsx by default) contains three sheets:

1. Cost Summary – Aggregate monthly costs with two sections: Total Provisioned Disk and Total Used Disk. Includes a banner row, metadata block (source files, filters, hours, currency, VPU value, powered-on/off flags), pricing table with full Excel formulas, and advisory text. Part quantities are driven by SUM formulas referencing the VM Details sheet.

2. VM Details – One row per VM with OCPU, RAM and disk values alongside monthly and yearly cost formulas. Includes an OS Detected column (sourced from RVTools VMware Tools data) and an OCI Compatible column (yes / maybe / no) colour-coded via conditional formatting. Editing a value here automatically updates the Cost Summary totals.

3. OS Summary – Aggregates detected operating systems and their OCI compatibility classification. VM counts and percentages are driven by COUNTIF formulas referencing VM Details, so the summary stays in sync as values change.

Per-VM quantities are rounded up to whole units. Block Volume Performance Units (VPU) scale with disk capacity (VPU per GB × GB).

---

🛠️ CLI reference

Argument	Description
--version	Print the script version and exit.
--rvtools PATH [PATH ...]	One or more RVTools .xlsx files or directories to scan. Required.
--output FILE	Destination workbook path. Defaults to oci_cost_summary.xlsx.
--hours HOURS	Hours per month to bill. Defaults to 730.
--currency CODE	Pricing currency (passed to OCI pricing API). Defaults to USD.
--ocpu-part PART	OCI part number for OCPU per hour (default B97384, i.e. VM.Standard.E5.Flex).
--memory-part PART	OCI part number for memory GB per hour (default B97385, i.e. VM.Standard.E5.Flex).
--storage-part PART	OCI part number for block storage capacity per month (default B91961).
--vpu-part PART	OCI part number for block volume performance units (default B91962).
--vpu VALUE	VPUs per GB (range 1–120, default 10, i.e Balanced performance level).
--include-poweredoff-vms	Include powered-off VMs when summing vCPU and RAM.
--include-poweredoff-disks	Include powered-off VMs when summing disk usage (default).
--exclude-poweredoff-disks	Ignore powered-off VMs when summing disk usage.
--list	Print all Datacenter and Cluster names found in the input file(s) and exit.
--datacenter NAME [NAME ...]	Only include VMs in the given Datacenter(s). Quote names with spaces e.g. "DC East".
--cluster NAME [NAME ...]	Only include VMs in the given Cluster(s). Quote names with spaces e.g. "Production-01".
--anonymize	Write an anonymized copy of each input and exit (no pricing). Keeps only vInfo+vCPU, stripped to the sizing/OS columns, with DNS and VM-name domains removed. VM/cluster/datacenter names are kept real.
--anonymize-full	Everything --anonymize does, plus replace VM, hostname, cluster and datacenter names with tokens and emit a <name>_anonymized_key.csv mapping back to the originals. Mutually exclusive with --anonymize.

Paths can point to folders and the script recursively picks up .xlsx files.

When both --datacenter and --cluster are specified, a VM must match both conditions (AND logic). Multiple values within each flag are matched with OR logic.

---

📈 Examples

# Baseline run (powered-on VMs only, powered-off disks included)
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx

# List Datacenter and Clusters in input file
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --list
  
# Use Datecenter and Cluster filtering
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --datacenter DC-NAME --cluster CLUSTER-NAME
  
# Aggregate multiple exports and change output name
oci-rvtools \
  --rvtools ./customer/site-a.xlsx ./customer/site-b.xlsx \
  --output reports/oci_cost_summary.xlsx

# Include powered-off VM CPU/RAM
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --include-poweredoff-vms \

# Override pricing part numbers (VM.Standard.E6.Flex) and hours per month
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --hours 744 \
  --ocpu-part B111129 \
  --memory-part B111130

# Use VM.Standard.E6.Ax.Flex shape
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --ocpu-part B112530 \
  --memory-part B112531

# Ultra High Performance for Storage
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --vpu 30   # Ultra High Performance is VPU 30-120.

# Anonymize an export before sharing (keeps real names, strips everything else)
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --anonymize

# Fully anonymize (tokenise VM/host/cluster/datacenter names + write a key file)
oci-rvtools \
  --rvtools ./customer/RVTools_export_all.xlsx \
  --anonymize-full

---

🕵️ Anonymizing exports before sharing

If a customer is reluctant to share a full RVTools export, --anonymize / --anonymize-full produce a slimmed-down copy (<name>_anonymized.xlsx) that still calculates to the exact same cost, but contains only what the tool needs:

• Only the vInfo and vCPU sheets are kept; every other sheet is dropped.
• vInfo is reduced to the VM sizing + OS-detection columns (plus VM, Cluster, Datacenter and a domain-stripped DNS Name); vCPU is reduced to VM + the OS columns. IP addresses, UUIDs, folder paths, annotations, network details, etc. are removed.
• DNS names and any domain embedded in VM names are reduced to their short hostname (server.corp.local → server).

--anonymize-full additionally replaces VM, hostname, cluster and datacenter names with tokens (VM0001, host0001, cluster01, dc01) and writes a <name>_anonymized_key.csv mapping the tokens back to the originals, so the anonymized results can be translated back later. Housekeeping vCLS VMs keep their prefix so cost totals stay identical to the original file.

---

🍿 Demo

CLI

Web-UI

---

⚠️ Notes

• The CLI relies on real-time pricing data, so expect run failures if the Oracle pricing API is unreachable or if your machine is not connected to the internet.
• Generated Excel workbooks contain formulas and formatting. Excel recalculates automatically when opened.

---

Happy estimating! Contributions and pull requests are welcome.

---

MIT License — © 2026 Kim Tholstorf