Develop utility billing .xls for tenant billing
$250-750 USD
Paid on delivery
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.
Project ID: #20034585
About the project
18 freelancers are bidding on average $435 for this job
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More
Hello, I’m an Excel expert and I would like to help you with your project. Please tell me more about it so I can give you a more accurate quote. I am available to discuss on chat.
Hello I am an excel expert and have complete more than 100 projects in excel. I will send you a few samples of my past work for your kind perusal if required. I have read the job posting and understood the requiremen More
$ 250 ONLY !!!!! Sir, I understand your requirements very well. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you I will deliver your project within very short ti More
Combined twenty years of accounting, analytical and project management experience (as qualified accountant) Enthusiastic, proactive and accomplished successful roles within the financial services sector. Advanced exc More
Hello, How are you? I have more 8 years experience in development. Especially I have rich experience in Excel, VBA, Macro I am 100% sure I can satisfy your requirements and if you hire me, I will provide you good resu More
I have a strong knowledge of excel and am accurate and efficient Relevant Skills and Experience Advanced MSExcel skills
Proposals: It depends in details. Incompletes in requirements could result in dramatic increases of development. Different attitude on to quality, some times made big miss of dead lines.
Hello, I have a masters degree in engineering and currently work as an engineer for an oil and gas company. I create similar Excel workbooks on a daily basis and can promptly deliver your task. I will also provide you More
Hello, I have 15 years of working with Excel including advanced formulas, pivot tables, charts and macros.