Find Jobs
Hire Freelancers

SPREADSHEET WITH CONDITIONAL FORMATTING £10 Fixed Price

£10-20 GBP

Imefungwa
Imechapishwa almost 6 years ago

£10-20 GBP

Kulipwa wakati wa kufikishwa
This spreadsheet is for a self assessment by users. Rules and conditional formatting will produce automated scores and matrix chart. See attached spreadsheet. REQUIREMENTS: 1. Column H. The cells in Column H, must have a red/amber or green colour for each row item, based on the rules given in the sample matrix 2. Executive summary 5 x 5 matrix. Each row item short code needs to be plotted as shown in the sample 3. Executive summary total score calculation with red/amber or green colour coding. Risk Score as % of Total Possible Score (TPS) needs to be calculated, and then coloured as per the following rules: =/> 50% of TPS: RED (Top Priority, needs urgent attention), Between 25% and <50% of TPS: YELLOW, (Medium Priority, needs selective attention) <25% of TPS: GREEN: (No systemic risks identified) 4. OUTPUT: the speadsheet must not be editable, formulae need to be invisible, and users can only enter values to view the resulting scores, and print out.
Kitambulisho cha mradi: 16721090

Kuhusu mradi

32 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
32 wafanyakazi huru wana zabuni kwa wastani £16 GBP kwa kazi hii
Picha ya Mtumiaji
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
£10 GBP ndani ya siku 1
4.9 (253 hakiki)
7.0
7.0
Picha ya Mtumiaji
Hi Sir I have rich experience in excel .I have checked the spreadsheet and will perform the functions as mentioned in your description Regards
£20 GBP ndani ya siku 1
4.9 (377 hakiki)
6.5
6.5
Picha ya Mtumiaji
Can you send me the Excel spreadsheet please? I can start right away and finish in an hour. Thanks,
£10 GBP ndani ya siku 1
4.9 (206 hakiki)
6.7
6.7
Picha ya Mtumiaji
Hi, I went through your excel file and understand your requirements. Thanks for a nice project brief. I would like to work for you in this project. Please go through my reviews so that you can be confident about me. Hope to chat with you soon :) Thanks Sajid Khan
£10 GBP ndani ya siku 1
4.9 (67 hakiki)
5.7
5.7
Picha ya Mtumiaji
Hi, I have over five years experience in using Excel at an advanced level (formulas, array formulas, pivot table, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to improve my work quality and productivity and I made complex Excel sheets to automate my tasks. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
£15 GBP ndani ya siku 2
5.0 (22 hakiki)
5.3
5.3
Picha ya Mtumiaji
Hi, I am very much interested to deliver this Project exactly as per the listed job requirements with a quick turnaround time. With my expertise in excel conditional formatting and excel formulas, I would be able to update the spreadsheet to provide: 1. conditional formatting based on the specified rules. 2. Executive summary matrix. 3. calculation & color coding of the Executive summary total score. 4. protection of the worksheet contents (except the editable fields) 5. pre-formatted ready to print Output report. Please take a minute off to have a look at my profile. The "Quote comparison template" & "Revenue Analysis Report Recomn1" screenshots in the portfolio item "Excel based services", are two representative samples uploaded for your ready reference. Thank you for your time. BR, Devashish
£10 GBP ndani ya siku 1
5.0 (11 hakiki)
5.4
5.4
Picha ya Mtumiaji
Hello, I went thru the description, but I could not find any attachment Kindly send me the excel file, then I will look at that According to the description, this can be done You can see my previous projects and reviews I am looking forward to hearing from you thanks regards thushara
£15 GBP ndani ya siku 0
5.0 (29 hakiki)
4.4
4.4
Picha ya Mtumiaji
A proposal has not yet been provided
£10 GBP ndani ya siku 1
4.7 (12 hakiki)
4.2
4.2
Picha ya Mtumiaji
Hey, I have prior experience in data entry and excel. I hope you will consider my bid and give me a chance. thanks. Plus, I will work on min budget.
£11 GBP ndani ya siku 1
5.0 (2 hakiki)
2.7
2.7
Picha ya Mtumiaji
£66 GBP ndani ya siku 1
5.0 (2 hakiki)
1.8
1.8
Picha ya Mtumiaji
hey, i can do it well, as i know the excel work and i can assure you of the satisfactory work. i can start now and get done with it in as few hours, and you can take you time to check it out well. Thank You
£15 GBP ndani ya siku 1
4.8 (2 hakiki)
2.0
2.0
Picha ya Mtumiaji
Hi, I have gone through the GDRP Risk Assesment excel and have a good idea with your instruction.I'm doing full time freelancing and can be done a good job for you. Thank you
£10 GBP ndani ya siku 1
5.0 (2 hakiki)
1.3
1.3
Picha ya Mtumiaji
I will deliver a quality work and meet all the requirements at the quoted price within the 3 days Relevant Skills and Experience I will use my visual, excel skills combined eith other skills i have to deliver the promised quality
£23 GBP ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi, I 'm interested in your project and would like to start work immediately. Having good Microsoft Excel skills. If your okay with my profile, kindly provide me an opportunity to complete your project.
£18 GBP ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi, I can submit my task before its deadline with 100% accuracy. Just give me a chance and I'll prove it to you. Thank you.
£13 GBP ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
A proposal has not yet been provided
£23 GBP ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
£5 in 1 day Relevant Skills and Experience Data entry,excel.......
£18 GBP ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Excel Geek - no spreadsheet is too small. Professional and reliable service. Over twenty years of Excel experience.
£13 GBP ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
If you're looking for top-quality project delivery that will increase leads, make life easier and build on your brand identity, you've come to the right place.
£18 GBP ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
A proposal has not yet been provided
£10 GBP ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED KINGDOM
London, United Kingdom
5.0
3
Njia ya malipo imethibitishwa
Mwanachama tangu Jan 5, 2017

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.