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
-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.
I would really love opportunity to work with you to develop a user friendly utility billing system. Based upon your project description I am proposing the following solution. Milestone 1 Creation of a user friendl Daha Fazla
Bu iş için 22 freelancer ortalamada $403 teklif veriyor
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 there. I have good experience in using Excel and Excel VBA. Although you have offered 250dollars, this work can be done for much less maybe 100 or so, based on it's complexity. Thanks.
$ 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 Daha Fazla
Hi, I can create a desktop excel file or an online excel file that you can access anywhere. I can turn the excel file into a small application for your phone too. I would charge $270 for making the excel file and trai Daha Fazla
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.