SPREADSHEET WITH CONDITIONAL FORMATTING £10 Fixed Price

Kapalı İlan edilme: 5 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

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.

Veri Girişi Veri İşleme Excel Visual Basic

Proje NO: #16721090

Proje hakkında

32 teklif Uzak proje Aktif 5 yıl önce

Bu iş için 32 freelancer ortalamada £16 teklif veriyor

Tanmoy236

"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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(253 Değerlendirme)
7.0
rohitagarberg

Hi Sir I have rich experience in excel .I have checked the spreadsheet and will perform the functions as mentioned in your description Regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(377 Değerlendirme)
6.5
zolayossa

Can you send me the Excel spreadsheet please? I can start right away and finish in an hour. Thanks,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(206 Değerlendirme)
6.7
sajidkhan45

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(67 Değerlendirme)
5.7
afenache

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 impro Daha Fazla

£15 GBP in 2 gün içinde
(22 Değerlendirme)
5.3
dfexcel

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(11 Değerlendirme)
5.4
nelumindralal

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 an Daha Fazla

£15 GBP in 0 gün içinde
(29 Değerlendirme)
4.4
humayoonsheikh4u

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(12 Değerlendirme)
4.2
maheen1995

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
2.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
1.8
farheenfazeel

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
2.0
Sagarika90

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
1.3
danielmutua

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 pr Daha Fazla

£23 GBP in 3 gün içinde
(0 Değerlendirme)
0.0
sangeethad1

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 in 3 gün içinde
(0 Değerlendirme)
0.0
pillasangelica

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
ravibohara035

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
ummaahmad305

£5 in 1 day Relevant Skills and Experience Data entry,excel.......

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
mattshort72

Excel Geek - no spreadsheet is too small. Professional and reliable service. Over twenty years of Excel experience.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
uday2405

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
MMalabaguio

A proposal has not yet been provided

£10 GBP in 2 gün içinde
(0 Değerlendirme)
0.0