Develop utility billing .xls for tenant billing

Create a blended-rate utility bill for commercial real estate tenants where electrical consumption will be calculated by electrical meters (each tenant as a percentage of total building usage) and utility cost will be calculated by allocating tenant usage as a function of percentage of total building usage. For example: Total building usage - 100kwh with cost of $100 Tenant 1 usage - 25 kwh with cost of $25 Tenant 2 usage - 25 kwh with cost of $25 Tenant 3 usage -50 kwh with cost of $25 Required: -Fields for manual data entry of 17 utility meters (two fields each; beginning kwh and ending kwh) -Field for manual entry of monthly utility bill total; one field -Field for billing dates (two fields; from-to) -Fields for (3) unique tenant names and identifier (6 fields total) -Simple algorithms (add/subtract) to calculate total energy consumption for 3 tenants (aggregate some meter totals together, disaggregate others based on square footage) -Create 3 unique tabs which will export consumption (kwh) and cost total in $USD for report of tenant energy consumption. Report to include tenant name, one field for unique identifier, reporting dates (from-to), energy consumed (kwh) and total dollar amount.