wowprompt

Electricity bill analysis for a shop, office or small factory

Reads twelve or more months of electricity bills and meter readings, separates fixed charges from usage, spots the months and hours that cost the most, and lists savings with a rough payback for each. Use it before negotiating a tariff change, buying solar panels or replacing old equipment.

A monthly table of units, demand and cost per unit, a chart outline of usage against temperature, and a ranked list of savings with payback months
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Site type and hours: [e.g. a garment workshop, 10 machines, open 9 am to 8 pm, six days a week]
  • Monthly bills: [paste rows: month, units consumed (kWh), maximum demand (kVA or kW), fixed or demand charge, energy charge, taxes and duties, total amount]
  • Sanctioned or contract load: [e.g. 25 kVA]
  • Time-of-day tariff, if any: [e.g. peak 6 pm to 10 pm at a higher rate, or none]
  • Main equipment: [paste rows: item, count, rated power, hours used per day]
  • Average outdoor temperature by month, if known: [paste, or skip]

Task

Find where the money goes on these bills and what would cut it, ranked by return.

Output format

  1. | Month | Units | Max demand | Fixed share of bill | Cost per unit | Change from last year |
  2. Effective cost per unit for the year, and how much of the bill is fixed whatever is used.
  3. Months where maximum demand went above the sanctioned load, with the likely penalty.
  4. Estimated usage by equipment from the list given, as a share of total units, checked against the billed units.
  5. Savings list: | Action | Units saved per month | Money saved per month | Rough cost | Payback in months |, covering load shifting out of peak hours, demand control, equipment replacement and power factor if it appears on the bill.
  6. A one-paragraph summary for the owner.

Rules

  • Use the tariff figures on the bills, not assumed national rates.
  • Mark every equipment estimate as an estimate and say how far it differs from the billed units.
  • Never recommend changing the sanctioned load without noting that the utility must approve it.
electricity bill analysisenergy cost reductionpower consumption analysisdemand chargescommercial electricity tariffenergy saving plan

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity