Tamamlanmış

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.

Beceriler: Excel, Visual Basic

Daha fazlasını gör: medical billing service data mining, billing transcription data entry medical, billing software data payment gateway, california landlord tenant law water bill, tenant not paying water bill, ratio utility billing system, do tenants pay sewer bills, ratio utility billing calculator, who pays water bill landlord or tenant california, is landlord responsible for tenant water bill, tenant utility responsibility, data collection process method petrol bulk required project, hourly rate dollar data entry operator, xls products services catalogue data crm, asterisk multi tenant billing, dollar data entry, tenant billing software, daily data add monthly excel, develop a custom logo corporate identity tetra pak product 2, do some purely data entry work with no sales required

İşveren Hakkında:
( 0 değerlendirme ) Brentwood, United States

Proje NO: #20034585

Seçilen:

GUSTX1

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

%selectedBids___i_period_sub_7% gün içinde 288%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
0.0

Bu iş için 22 freelancer ortalamada $403 teklif veriyor

schoudhary1553

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 Daha Fazla

$500 USD in 7 gün içinde
(317 Değerlendirme)
7.9
asin1987

Dear Employer, I understand you want to have following points implemented: -Fields for manual data entry of 17 utility meters (two fields each; beginning kwh and ending kwh) -Field for manual entry of monthly ut Daha Fazla

$300 USD in 10 gün içinde
(164 Değerlendirme)
7.4
P0L

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.

$300 USD in 3 gün içinde
(299 Değerlendirme)
7.2
zekovicm

Hi there,I am Excel VBA/Macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within Daha Fazla

$520 USD in 5 gün içinde
(105 Değerlendirme)
7.1
wsh2

Question: Should we include invoice printing and/or emailing as part of this? If yes, can you please provide some details on your current process. Question: Will you need to feed this data into another application? If Daha Fazla

$500 USD in 7 gün içinde
(49 Değerlendirme)
6.3
rohitpithisaria

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 Daha Fazla

$500 USD in 2 gün içinde
(110 Değerlendirme)
6.5
mtdevil369

Hello, I have a lot of experience in Excel (including formulas, macros, VBA). If you wish, I can do the job satisfactorily. If you want more information, please visit my profile or contact me.i am ready for your work B Daha Fazla

$250 USD in 0 gün içinde
(119 Değerlendirme)
5.9
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Excel and macro/VBA development, I can write Daha Fazla

$500 USD in 10 gün içinde
(82 Değerlendirme)
5.8
afenache

Hi, I can create the excel utility billing tool that you need with all features that you described in your project post. I am a chemical engineer and I have over five years experience in using Excel at an advanced le Daha Fazla

$350 USD in 4 gün içinde
(19 Değerlendirme)
5.2
valor312

VERY EASY FOR ME Hi, Nice to meet you. Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Need-HELP-this-excel-form/?w=f [login to view URL] Daha Fazla

$250 USD in 10 gün içinde
(32 Değerlendirme)
5.3
parthog47

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 USD in 5 gün içinde
(4 Değerlendirme)
3.3
stewartjlogan1

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 Daha Fazla

$444 USD in 10 gün içinde
(3 Değerlendirme)
3.3
AnowarRatul

$ 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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
2.0
EimaB

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
staub

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.

$555 USD in 10 gün içinde
(0 Değerlendirme)
0.0
vikrantlakhanpal

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 Daha Fazla

$388 USD in 4 gün içinde
(0 Değerlendirme)
0.0
ephastie

I have a strong knowledge of excel and am accurate and efficient Relevant Skills and Experience Advanced MSExcel skills

$555 USD in 10 gün içinde
(0 Değerlendirme)
0.0
DevStar925

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 Daha Fazla

$500 USD in 7 gün içinde
(0 Değerlendirme)
2.0
GKEvans

Hello, I have 15 years of working with Excel including advanced formulas, pivot tables, charts and macros.

$500 USD in 7 gün içinde
(0 Değerlendirme)
0.0
MLJ88

Hello, As an Australian fully qualified CPA accountant I have many years' experience with Excel modelling. The model you seek, I can put together for you as I am very familiar with analysing electricity bills to ident Daha Fazla

$500 USD in 10 gün içinde
(0 Değerlendirme)
0.0