Build a spreadsheet
$30-250 AUD
Pagado a la entrega
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.
Nº del proyecto: #14109669
Sobre el proyecto
31 freelancers están ofertando un promedio de $145 por este trabajo
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 Más
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 Más
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.
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 Más
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 Más
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
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 Más
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 Más
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 Más
Hello, I graduated from Boston University USA, which is among top 50 Universities of the world. I have a lot of experience in data processing. I am very punctual and always deliver on time. My personal qualities Más
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. Más
Hello Sir, I have viewed your job posting and I'm very much interested on this kind of task because it had been my work in numerous projects in other freelancing sites successfully, and I'm quite comfortable doing the Más
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
Hi There, I’d like to be considered for your position. For years I’ve worked in Engineering and so I am accustomed to working with all sorts of products and services, and in a variety of industries. I have a deep Más
Greetings I am a CPA finalist and I provide a range of services majorly focusing on excel, bookkeeping, cost accounting and financial management. I have been working in the above mentioned fields for 5 years now and ha Más
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 Más