Annulleret

Creating a excel project budget dashboard

Hi

The assigment at hand is a school work that i need help with. I got an dataset of information, it concernes multiple projects in a goverment company. The task is to

take the informatin and turn it in to a general dashboard and one for the project managers. It has to be a "one-pager".

So the use of slicer should be implemented.

Now i tried to do it on my own and understood that i laked the necessary excel skills so im turning to you for help.

The KPIs i would like to have are: Planned value (PV), Earned value analysis (EVA) Cost Variance (CV), Overdu projects/crossed deadlines, Schedule Variance (SV) and precentage of projects completed on time.

Feel free to ask anything. The KPI:s are pretty simple.

Best regards,

Adis

This is the assigment :

The assigment ” One-pager”

This tab represents a "one-pager" whose purpose is to give a quick overview of the ongoing investments.

General information

This file is the controllers main tools. It contains all investments and is directly conected to the accounting system, which means that data is always fresh.

The role of an controllers includes determining the annual budget (business plan / VP) for all investment projects. Throughout the year every project is to be followed upp according to this budget. Partly to ensure that projects adheres to the budget but also to ensure that the projects planned in the budget really gets started.

Throughout the year, the investment economist also updates the project managers forecasts on their projects and the status of submission forecast shown in the "investment list".

(See the tab named forecasts)

There are several departments in the company that are interested in the data contained in this file, so the "one-pager" should not only aims to meet the controllers own monitoring needs.

It may be that individual project managers or department managers want to view the data based on their own perspective. By meeting also their need for follow-up and analysis you create a great added value to the company.

The companys investment portfolio is divided in three different budgetframes; "Within the framework", "Extended scope", and "PU". These must be monitored separately

The entire investment framework, in addition to being broken down by the different budget, is also divided into two categories. On the one hand, the companys own estates ( named FSK) and on the other hand, the sporting estates (named IDF). The two categories must not be mixed (ie, projects can not prioritized between these two), but they must be followed up separately. A project is thus combined with both a framework and a category, which gives a total of six possible combinations.

Explanation of ”the investment list"

The first columns that has a green main menu refers to the basic data for projects such as budgetfram, unit and department, division between the IDF and FSK etc.

Status of whether the forecast is filed or not shown in the column labeled "status of the forecast submission" (note that the data is initially only available in a separate tab)

The columns that are of the most interest in addition to the columns with green main menu is the outcome columns, forecast columns, VP columns (ie budget).

Get Started Tips

Be sure to do the one-pager foreseeable and mix graphs and tables. Useful formulas can for example be VLOOKUP, Index / fit, COUNTIFS, SUMIFS, year, today, displacement and much more.

Note that the column for the forecast submission is empty and that the data is in a separate file.

Be sure to do the one-pager "dynamic" so as to provide accurate data, not just for today but for every day of a year. The file's data refers to end of the month of November / December.

Also think about how you can meet several needs at once.

It is OK to remove or add lines and tabs, make your own assumptions etc. It is not corecctnes of the numbers that is important but the way they make possible the analysis and presentation that is in focus!

Good luck!

Færdigheder: Dataindførsel, Databehandling, Excel

Se mere: year budget project excel, project excel dashboard, master budget project excel, create project excel vba, etherpad lite excel, create project excel, project budget template excel, create budget report excel, budget video project excel, create simple project excel, create vba project excel, stock market project excel, christmas budget project, excel template service, customxml excel, creation excel file, excel keyword, office excel time management, macro excel cells, differences excel files, php excel pdf, excel vba xml

Om arbejdsgiveren:
( 6 bedømmelser ) Stockholm, Sweden

Projekt-ID: #12539858

Tildelt til:

Gathix444

I am currently an Excel Application Developer working in a civil engineering firm located in Taiwan. My job requires me to develop Excel Dictator Applications for project management purposes. I'm bilingual in English a Mere

$12 USD / time
(1 bedømmelse)
0.6

10 freelancere byder i gennemsnit $22/time for dette job

cgullapalli

Hi, I am good at Excel vba. I have seen the details. I would like to discuss the KPI and presentation part in the allocated 4 boxes and a slide bar. Looking forward to discuss in the chat.

$40 USD / time
(316 bedømmelser)
7.0
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.

$30 USD / time
(123 bedømmelser)
6.4
vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.

$15 USD / time
(86 bedømmelser)
5.3
suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Mere

$50 USD / time
(20 bedømmelser)
5.3
citijayamala

A proposal has not yet been provided

$24 USD / time
(29 bedømmelser)
4.6
sarcscoin

Hi, I have seen the description file and the excel. Plz explain me of KPI to formulate as required. Happy to support on the project completion.

$22 USD / time
(10 bedømmelser)
2.4
arielaleksander

Administrative Assistant who goes above and beyond basic administrative tasks and takes on multiple projects at once. Excellent work ethic and strength in boosting company morale. Good proficiency with excel spreadshee Mere

$8 USD / time
(0 bedømmelser)
0.0
$8 USD / time
(0 bedømmelser)
0.0
asifayt

Hi,I am a new honest and punctual freelancer with Strong Educational background. and will be giving my 100 % to give u best result. I read your project details and understood. We can move ahead for a reasonable bud Mere

$13 USD / time
(0 bedømmelser)
0.0