进行中

Build a spreadsheet

We need to build a spreadsheet on Excel that will allow us to:

Quickly calculate the annual fees charged for several institutions (schools), and their forecast for the next 20 years. We have set a standard inflation rate per annum (5.18%). We also provide the annual fees charged for 3 institutions in 2017. The Excel document must meet the following specs:

- 5 sheets in total: 1 sheet containing the Annual Fees of all institutions for 2017. We provide information of 3 institutions. The document must enable us to add more institutions and fees along the way. If necessary, one sheet per institution can be considered. Whatever is easier for us to forecast fees.

- 4 sheets for possible customer's scenarios: 1. One child, 2. Two children, 3. Three children, 4. Four children (we provide an example of this one). As it is in the example, each of these sheets must contain:

* Table with fees per child and per year at a selected institution.

*Drop-down option in the table for us to select the institution, the level and the year per child. (Some comments in the example sheet have been inserted).

* The table must display the fee forecast given the year and school selected, based on the current fee (2017 fee) + an increase of 5.18% per year.

*A column chart displaying the annual cost per child and per year. An example is included as well.

- As part of the deliverable, we request a brief step by step explanation on how to add more institutions' fees along the way and how to replicate formulas or procedures.

技能: 数据输入, Excel

查看更多: Build a spreadsheet, build excel spreadsheet with forms, Build an excel spreadsheet from existing excel data, build list spreadsheet, build a price query website using an excel spreadsheet, build integration spreadsheet, build excel spreadsheet, visible drop select option magento, spring mvc view select option drop, select option drop list display details table php mysql, php mysql drop list values select option display details table, build widget excel spreadsheet, Build spreadsheet, build data entry spreadsheet, drop menu php mysql select option, scriptaculous drag drop select option, javascript drag drop select option, web design select option box replacement, php select image drop, select option menu php

关于此雇主:
( 2个评论 ) Hawthorn, Australia

项目ID: #14109669

33 威客就此工作平均出价 $143

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st 更多

$210 AUD 在3天内
(515条评论)
8.1
jkaranm

Hi Future Client, Our business is to make your business effective, profitable, & [login to view URL] are able to have a sound understanding of our Clients’ operations and their corporate goals, and we continually bring kno 更多

$250 AUD 在5天内
(28条评论)
7.7
vsolcorp

Hello, Sir I am from vSol CORP. We are 19 people team, worked on more than 500 completed projects. We provide round the clock service. Kindly interview us to review our competencies & hire us for best desired results. 更多

$200 AUD 在5天内
(247条评论)
7.6
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex 更多

$200 AUD 在3天内
(205条评论)
7.2
KulfiSoftwares

ZERO ERROR GUARANTEED!! Please read my 210+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfie 更多

$100 AUD 在3天内
(178条评论)
7.0
ponnarasiBabu

I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..I have completed sevaral smilar projects ..as you have said in the pro 更多

$200 AUD 在5天内
(358条评论)
7.2
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 AUD 在3天内
(205条评论)
6.8
cugamelover

I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scri 更多

$200 AUD 在3天内
(162条评论)
6.9
priyal1997

Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar dynamic excel te 更多

$90 AUD 在3天内
(165条评论)
6.6
asifdwan

Hi there! I’m an expert on any data entry jobs and I have a lot of experience on this type projects. I’m ready to start it right away. I look forward to hearing from you. Regards

$250 AUD 在3天内
(150条评论)
6.3
katilinas

Hello. I can provide you flexible annual fees calculator with 20 years forecast. I have already did similar 'schools' project. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do th 更多

$200 AUD 在3天内
(94条评论)
6.1
ksriniravi

Greetings! I have developed similar costs calculator / models before (Children Costs Calculator - similar to yours but not restricted to just education but based on publicly available information on Estimated averag 更多

$120AUD 在1天里
(119条评论)
6.2
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. 更多

$133 AUD 在3天内
(90条评论)
6.1
zebracaro

I can do it for you quickly and exactly .

$200 AUD 在3天内
(76条评论)
5.8
vineet370

Dear Employer, I have read the project and understand your requirement. I am a highly trained on Data Entry ,Data Analysis, Research, Web search, Web scraping, Product Add, Any Type Of Ecommerce Cart, Expert with g 更多

$100 AUD 在3天内
(57条评论)
5.2
asadkhan3533

7+ years of experience in Accounts & Finance makes me to offer my services to you on this project. I am able to do this project as listed in the post with 100% accuracy in a very reasonable time. My expertise includes 更多

$155 AUD 在2天内
(38条评论)
5.1
satishtl

- Can build the calculations for the annual charges for the [login to view URL] with 5 sheets and drop down options. - Will provide a separate instructions document once the project completed for usage. - Provide the 更多

$250 AUD 在5天内
(37条评论)
5.2
vibearning

hi, i can do this excel work for you. I have gone through the sheet and you just need to implement formulas to achieve this. Lets discuss in more details

$71 AUD 在2天内
(38条评论)
4.9
nineoneone

Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if y 更多

$80 AUD 在3天内
(20条评论)
4.7
BAVarun

With an experience of over a decade in excel and a dual degree in financial management (MBA - Finance and Chartered Accountant) I am a complete fit for your school fees forecasting template. I am with a decade lon 更多

$122 AUD 在3天内
(31条评论)
4.5