Cloud Instance Recommender

• Filter presets — save the whole filter configuration under a name and re-apply it anytime from the bar above the Generate button; presets are per page and stay in your browser.
• Results Excel — download the results grid as a styled .xlsx (formatted header, autofilter, numeric columns) alongside the existing CSV.
• Nearest Miss column — no-match rows now name the closest qualifying instance and the filter(s) that excluded it, so you know exactly what to relax.
• Scenario comparison — pin two generation runs and diff them: match-rate change, newly matched/unmatched VMs, and old → new values for every changed recommendation.
• Install & offline — the tool is an installable app that keeps working offline after your first visit; updates apply automatically the next time you're online.

• App Portfolio & executive Excel — add an App Name column and group your estate by application: a per-app dashboard (Open App Portfolio after generating) and a styled multi-sheet .xlsx export.
• Excel upload — .xlsx workbooks are accepted alongside CSV; the first sheet is used.
• Column auto-mapping — headers like vCPUs, RAM, or Hostname map automatically to the expected columns; ambiguous cases open a mapping panel, and confirmed mappings are remembered for repeat uploads.
• Region Check panel — after upload, chips show each region as recognized (green), auto-resolved (amber, e.g. us-east-1a → us-east-1), or unknown (red — those rows would use built-in sample data).
• Faster loading — instance data loads per region on demand; pages open with a few KB of data instead of ~25 MB.
• Real progress, no freezing — generation runs in a background worker with a row-accurate progress bar and automatic fallback.
• Preview search — filter the results preview live across all visible columns.
• No-Match export — download only the rows that got no recommendation, with reasons, to fix and re-upload.
• Dark mode — 🌓 toggle on every page; follows your OS setting until you choose manually.
• Keyboard & screen-reader support — collapsible sections, table sorting, and status updates are fully accessible.

Welcome to the Cloud Instance Recommender, a comprehensive browser-based tool designed to help organisations optimise their cloud infrastructure across AWS, Azure, and Google Cloud Platform. All processing happens entirely in your browser — no data is ever uploaded to an external server.

The Rule Engine UI builds on the underlying rule engine with five capabilities: interactive Rule Engine UI dropdowns that set global defaults without CSV changes, a Minimum Generation filter to exclude EOL instance families (e.g., AWS m5/r5), conflict detection that highlights contradicting filter combinations in red, a split AWS Pricing Calculator Bulk Template that generates separate files for Like-to-Like and Optimized recommendations, and a Min Gen CSV column for per-row generation control.

🌐 Supported Cloud Providers

VM Name,App Name,CPU Count,Memory (GB),CPU Utilization,Memory Utilization,AWS Region,ENV,OS,Workload,Compliance,Min Gen
web-server-01,Storefront,4,16,45,60,us-east-1,Production,Linux,Web Server,,6
db-server-02,Billing,8,32,70,80,us-west-2,Production,Windows,Database,PCI,7
app-server-03,Billing,2,8,35,45,eu-west-1,Dev,Linux,General,,
cache-server-04,Storefront,4,16,25,30,us-east-1,Staging,Linux,Cache,,6
ml-server-05,Analytics,8,64,80,75,us-west-2,Production,Linux,ML/AI,HIPAA,7

The Rule Engine applies automatically when optional CSV columns are present. Rules narrow the candidate instance list before the cheapest-match selection runs — so every recommendation already satisfies your environment constraints.

🔢 Min Generation Rule (MG)

The Min Generation rule excludes instances older than a specified hardware generation. This is useful when older generations are approaching end-of-life (e.g., AWS m5/r5 EOL) or when you have a policy requiring modern silicon.

🎯 Workload Family Mappings

📋 Rules Reference Summary

Step 1 — Choose Your Cloud Provider

• Single provider: Navigate directly to the AWS, Azure, or GCP page for focused recommendations with provider-specific filtering options.
• Multi-cloud: Use the Multi-Cloud page to compare recommendations across all three providers in a single run from one CSV upload.

Step 2 — Download and Prepare the Template

1. Click Download Sample CSV on the provider page to get a template with the correct column headers.
2. Replace the sample rows with your actual VM inventory. Include the optional ENV, OS, Workload, and Compliance columns where applicable.
3. Save the file as UTF-8 CSV.

Step 3 — Upload Your CSV

1. Drag and drop your CSV onto the upload zone, or click it to browse.
2. The tool automatically validates the file, checks required columns, shows a data preview, and assigns a quality score (0–100 %).
3. Review any warnings before proceeding — common issues include missing region columns or non-numeric CPU/memory values.

Step 4 — Select Recommendation Type

Step 5 — Configure Optimization Settings

(Only relevant for Optimized or Both recommendation types)

Optimization Mode

• CPU-Based: Scale CPU according to utilisation thresholds
• Memory-Based: Scale memory according to utilisation thresholds
• Both can be enabled simultaneously

N/2, N, N+1 Thresholds (Industry-Standard Defaults)

Step 6 — Configure Rule Engine & Advanced Filtering (Optional)

Expand the Advanced Filtering section to access both the Rule Engine UI controls and provider-specific filters.

Rule Engine Defaults

Five dropdowns let you set rule defaults for the entire batch without modifying your CSV. Per-row CSV column values always take priority over these UI defaults.

Conflict Detection

When two selected options directly contradict each other, the conflicting dropdowns are highlighted in red with an explanatory warning. For example:

• OS = Windows + processor filter restricted to Graviton/ARM only
• ENV = Production + main families restricted to burstable types only (t/B/e2)
• Workload = ML/AI + processor filter restricted to Intel/AMD only (no GPU available)

Resolve conflicts before generating recommendations — rules will still run but may produce unexpected results if contradictions are left in place.

Step 7 — Generate and Download Results

1. Click 🔄 Generate Recommendations. A progress bar shows processing status for large files.
2. Once complete, the download section updates based on what was generated.
3. AWS page — both Like-to-Like and Optimized selected: three buttons appear:
   📥 Download Results CSV — all columns in one file
   🧾 Bulk Template (Like-to-Like) — AWS Pricing Calculator format, Like-to-Like instances only
   🧾 Bulk Template (Optimized) — AWS Pricing Calculator format, Optimized instances only
4. AWS page — single type selected: Results CSV + one Bulk Template button.
5. Azure / GCP pages: Results CSV only.

The downloaded CSV preserves all original input columns and appends recommendation columns for each selected provider.

Original Input Columns (preserved)

VM Name, CPU Count, Memory (GB), CPU Utilization, Memory Utilization, [Provider] Region, ENV, OS, Workload, Compliance — all returned unchanged.

Recommendation Columns (added per provider)

The same pattern applies for Azure and GCP (replacing "AWS" with the provider name).

Status values for recommendation columns

The Advanced Filtering section contains two types of controls: the Rule Engine UI (global defaults for ENV/OS/Workload/Compliance/Min Gen) and provider-specific filters that narrow the instance candidate pool. Provider filters are applied first; the Rule Engine then runs on the already-filtered set.

🔶 AWS-Specific Filters

🔷 Azure-Specific Filters

🔴 GCP-Specific Filters

The Multi-Cloud page processes a single CSV against all three providers simultaneously, producing side-by-side recommendations in one output file. This is useful for migration planning, vendor selection, and lock-in risk assessment.

CSV Format for Multi-Cloud

Include region columns for every provider you want to compare. Providers with a blank or missing region column are skipped for that row.

VM Name,App Name,CPU Count,Memory (GB),CPU Utilization,Memory Utilization,AWS Region,Azure Region,GCP Region,ENV,OS,Workload,Compliance,Min Gen
web-server-01,Storefront,4,16,45,60,us-east-1,East US,us-central1-a,Production,Linux,Web Server,,
db-server-02,Billing,8,32,70,80,us-west-2,West US 2,us-west1-b,Production,Windows,Database,PCI,

Regional Equivalents Reference

Interpreting Multi-Cloud Output

The output CSV contains recommendation columns for every selected provider in the same row, making it easy to filter in Excel or Google Sheets:

• Sort by VM Name to see all providers for each workload
• Use the "Rules Applied" columns to understand why providers differ
• Provider pricing calculators should be used to compare actual costs — do not compare instance types directly as the vCPU/memory ratio differs across providers

File Upload Problems

Recommendation Problems

Browser / Performance Problems

📊 Data Collection

• Collect at least 30 days of utilisation data; 90 days is ideal to capture seasonal variation
• Use the P95 or P99 percentile for CPU if your workload is spiky — average metrics underestimate peak demand
• Memory utilisation from the OS is more reliable than hypervisor-reported figures — use OS-level agents where possible
• Tag VMs with their ENV, OS, and Workload in your CMDB and export that metadata directly into the CSV

🚀 Recommendation Implementation

• Start with Dev/Test environments — fast to change and low risk if something is wrong
• For Production, use Like-to-Like first to establish a safe baseline, then consider Optimized for a second wave
• Always have a rollback plan: snapshot or image the VM before resizing
• Monitor for 48–72 hours after a resize before treating it as complete

💰 Cost Strategy

• Use this tool to identify the right instance type — then separately apply Reserved Instance or Savings Plan pricing in the provider's pricing calculator
• Re-run the tool quarterly for dynamic workloads; semi-annually for stable production systems
• After a cloud migration, re-run with actual utilisation data from the new environment — the right-sizing picture often changes after migration

🔒 Security & Compliance

• Set Compliance = PCI or Compliance = HIPAA in the CSV for regulated workloads to ensure Nitro-capable (AWS) and current-gen-only instances are recommended
• For FIPS-boundary requirements, manually verify that recommended regions are within your geographic compliance boundary
• No inventory data ever leaves your browser — the tool is fully client-side

🌟 General

Q: Is my data secure?
A: Yes. All processing happens in your browser — your VM inventory never leaves your machine. The tool loads a static instance catalogue at start-up; there is no backend server receiving your data.

Q: Why doesn't the output include pricing?
A: Cloud pricing is not static — it changes with region, OS, discounts, Savings Plans, Reserved Instances, and enterprise agreements. Showing a price in the output would be misleading within weeks. This tool identifies the right instance type; use your provider's pricing calculator for accurate cost figures. The AWS Pricing Calculator Bulk Template export makes this workflow seamless for AWS.

Q: Can I use this tool offline?
A: Yes — after your first visit. A service worker caches the pages and any region data you've used, so those keep working without connectivity, and you can optionally install the site as an app from your browser. Regions you've never loaded still need one online visit. Updates are picked up automatically the next time you're online.

Q: Which file formats are supported?
A: CSV (UTF-8) and Excel .xlsx workbooks — the first sheet is used. Common header variants like vCPUs, RAM, or Hostname are mapped to the expected columns automatically.

Q: Can I save my filter configuration for next time?
A: Yes — use the ⭐ Filter presets bar above the Generate button to save the current configuration under a name and re-apply it later. Presets are per page and stored in your browser, and can be exported as a JSON file to move them to another browser or machine (see Section 9).

⚙ Technical

Q: Why does the tool recommend a different instance than our cloud provider's own advisor?
A: Provider advisors (AWS Trusted Advisor, Azure Advisor) typically look at longer time horizons (14–90 days) and use conservative thresholds. This tool applies your chosen utilisation window and thresholds. The recommendations can legitimately differ — treat both as data points rather than absolute answers.

Q: Why are the downsize thresholds set to 40 % instead of 50 %?
A: The 40 %/80 % thresholds align with the approach used by AWS Cost Optimisation, Azure Advisor, and GCP Recommender. At 40 %, there is still comfortable headroom for traffic spikes and OS/monitoring overhead. The old 50 % default was too aggressive for most production workloads. You can adjust both thresholds in the UI if your environment requires different values.

Q: I set ENV = Production but got a t3.large recommendation. Why?
A: Check the Rules Applied column — the rule engine reports exactly what happened. If "1a: Burstable excluded" is not listed, verify that the ENV column value is exactly Production (no extra spaces or different capitalisation).

Q: Can I use a mix of ENVs in the same CSV?
A: Yes — rules are applied per row. You can have Production, Staging, and Dev rows in the same file; each gets its own rule evaluation.

Q: What happens if no instance survives after all rules are applied?
A: The tool notes the failure in the Rules Applied column with a ⚠ warning and falls back to the best available instance from the pre-rules candidate set. This is a signal to either relax filters or review whether the requirements are achievable in that region.

💼 Business

Q: What typical savings can I expect?
A: Organisations commonly see 15–40 % reduction in compute spend from right-sizing alone, before applying Reserved Instances or Savings Plans. The actual figure depends heavily on how over-provisioned the original fleet is.

Q: How often should I re-run the tool?
A: Monthly for dynamic/seasonal workloads; quarterly for stable production workloads; immediately after any significant architectural change or traffic pattern shift.

Q: Can I share results with stakeholders who don't have access to the tool?
A: Yes — the downloaded CSV can be opened in Excel or Google Sheets. The "Rules Applied" column provides plain-English audit notes explaining every recommendation, making it straightforward to present to non-technical stakeholders.

Q: Is the AWS Pricing Calculator Bulk Template ready to import immediately?
A: It populates all required columns with On-Demand, Always On, Shared Instances defaults. You will need to manually add storage details (EBS volume type, size, IOPS) in the calculator after import if required for your estimate.

The Cloud Instance Recommender gives you a fast, privacy-first starting point for cloud rightsizing at any scale — from a handful of VMs to thousands. By combining flexible like-to-like and optimised recommendation modes with a configurable rule engine, it produces recommendations that are not just cheap, but appropriate for the environment, OS, workload type, and compliance posture of each individual VM.

Key things to remember:

• Add ENV, OS, Workload, and Compliance columns to get environment-aware recommendations with a full audit trail
• Use the 40 %/80 % thresholds as a starting point — adjust them based on whether your utilisation data is averages or percentiles
• Pricing is intentionally excluded from output — use the AWS Pricing Calculator Bulk Template export for cost estimation
• Treat recommendations as an informed starting point, not a final answer — validate in a non-production environment first
• Re-run quarterly to keep pace with changing workloads and the cloud providers' expanding instance catalogues