Building Life Cycle Cost Dashboard

I have a 40 Year Building Life Cycle spreadsheet that I would like to add a dashboard capability to. I would like slicers , graphs etc. to present the data in a graphical way so clients can assess long term costs more simply. I'm open to design ideas.

I would like users to be able to filter costs by category, (as per the 11 categories on the attached excel file), and for other characteristics such as Essential, Life Cycle, Desirable etc. and to view these over time and for specific time periods.

The data is currently arranged per year (normally presented with columns hidden and only the 5 year grouped costs shown).

I would also like users to be able to adjust time frames for replacement based on their approach to risk - have the spreadsheet set up for 3 replacement strategies (Conservative, Moderate and Aggressive) which changes all the cells in the applicable column. I would like the user to be able to define item risks individually by using the "Varied" option but currently can't get this to work as it replaces the formula in the cell contents with text and it can't be set back.

I am also open to an Excel wizard making the formulas more elegant, or resistant to inadvertent errors or user inputs - I am a basic user at best.

Happy to discuss requirements in more detail.

Kemahiran: Excel, Reka Bentuk Grafik, Visual Basic

Lihat lagi: life cycle ipod, life cycle tcs socket, project report hospital management system development life cycle, activex life cycle mfc, full understanding full life cycle, product life cycle animation, desktop application life cycle, fmcg business life cycle, kinsey integrate business single project life cycle, dashboard development life cycle, life cycle cost analysis example, building construction life cycle, which phase of the software development life cycle is a requirements specification document created?, life cycle cost analysis tool, life cycle cost analysis pdf, life cycle cost analysis software, life cycle cost analysis template, life cycle cost analysis ppt

Tentang Majikan:
( 2 ulasan ) City Beach, Australia

ID Projek: #22282204

Dianugerahkan kepada:


Hi, I am an excel VBA expert and have read through your project. I just have a few questions more which I have messaged you. Please go through them and reply will help me in estimating the exact work hours required f Lagi

$350 AUD dalam 7 hari
(60 Ulasan)

22 pekerja bebas membida secara purata $410 untuk pekerjaan ini


Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Lagi

$380 AUD dalam 5 hari
(336 Ulasan)

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

$500 AUD dalam 5 hari
(335 Ulasan)

Hi I have read Your project description regarding GRAPHIC DESIGNS. I have made lots of GRAPHIC designs earlier. I am sure that you will like my work very much. I will deliver you project timely. I am here for long Lagi

$250 AUD dalam 3 hari
(432 Ulasan)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Let me help you create the Dashboard you need and improve Lagi

$380 AUD dalam 3 hari
(234 Ulasan)

Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can make a dashboard for you with the data you have. Let's discuss further. W Lagi

$400 AUD dalam 3 hari
(346 Ulasan)

Hello Sir/Madam!! I have read the description of your project and immediately available to start working. Also let me assure that I can design an attention-grabbing design. Please give me an opportunity to work on this Lagi

$500 AUD dalam 3 hari
(88 Ulasan)

Hey! I have read through your specifications and believe I would be a great fit for the project. I'm a freelance graphic designer based in Vancouver, Canada. I have 6+ experience in graphic designing. I will provide y Lagi

$418 AUD dalam 7 hari
(34 Ulasan)

Hello, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data Lagi

$500 AUD dalam 5 hari
(85 Ulasan)

Hi, I am an expert in Excel, Access, Powerpoint, VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interact Lagi

$500 AUD dalam 7 hari
(84 Ulasan)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lagi

$400 AUD dalam 3 hari
(129 Ulasan)

Sir,      I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from y Lagi

$444 AUD dalam 4 hari
(52 Ulasan)

I can develop an excel based dynamic dashboard with graphs & charts, let discuss this in detail in chat or over a call. Please find below a brief introduction of myself. I am postgraduate with more than 6 years of exp Lagi

$400 AUD dalam 5 hari
(36 Ulasan)

"Hi. i am an affiliate chartered accountant (CPA) and a professional finance expert since 2009. We have worked with our clients at national as well as international level. We have advanced knowledge in excel because of Lagi

$450 AUD dalam 5 hari
(56 Ulasan)

Hi, i had a look at the attached file. I can certainly give you results, on further discussions with you and interactions. I am well experienced to give you a comfortable dashboard.

$400 AUD dalam 10 hari
(9 Ulasan)

Hi There, I'm interested into your project, i have read all your descriptions, i'm excel expert with many experience, esspecially in this field, please kindly check my profile. Ready to disscuss over chat. thanks. Rega Lagi

$250 AUD dalam 5 hari
(14 Ulasan)

Hello, I have 10 years of experience in Mobile Application Development. I am a Web Professionals including Design, Programing, QA, SEO experts along with highly qualified and experienced skills. Android apps: https:// Lagi

$500 AUD dalam 7 hari
(3 Ulasan)

Hey there, I am Roland and I am keenly interested in the project. I can create visual displays and trends of the data. I can make a Pareto, pie chart and other forms of graphical display. I have something similar I di Lagi

$250 AUD dalam 5 hari
(3 Ulasan)

Hello, can I have a look at the Excel? This should be no problem as I have experience with your industry and a lot of Excel know how. Best regards Fuad

$250 AUD dalam 3 hari
(1 Ulasan)

Hello, Hope you are doing great! I have understood your stated information about the workflow, replacements etc. I am ready to start at the moment. Please PM. I have an experience of 7+ years of experience in desig Lagi

$500 AUD dalam 7 hari
(0 Ulasan)

Hello there,My name is Jessie,I am a construction cost estimator from China. I have read your [login to view URL] you need is a construction cost estimator If you give the project to a non-professional, they will only make th Lagi

$500 AUD dalam 7 hari
(0 Ulasan)