Fermé

SPREADSHEET WITH CONDITIONAL FORMATTING £10 Fixed Price

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.

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic

en voir plus : ill in a Spreadsheet with Data. See PDF attached and example Excel Sheet, data-entry/fill-spreadsheet-with-data-entry, google spreadsheet advanced conditional formatting, attached spreadsheet revenue, convert attached spreadsheet html table, link form attached spreadsheet, please complete attached spreadsheet, refer attached spreadsheet details, guide attached spreadsheet, find attached spreadsheet giving details inputs, attached spreadsheet, find attached spreadsheet, conditional formatting excel spreadsheet, conditional formatting spreadsheet, excel spreadsheet conditional formatting, conditional formatting formulas ratings, vb6 conditional formatting excel, virtuemart fixed price, excel 2003 conditional formatting, visual basic code conditional formatting, plan fixed price aspnet application, fixed price auction, swoopo reviewed fixed price, conditional formatting project dates, conditional formatting excel 2003 visual basic

Concernant l'employeur :
( 1 commentaire ) London, United Kingdom

Nº du projet : #16721090

34 freelance font une offre moyenne de £16 pour ce travail

zolayossa

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(182 Commentaires)
6.5
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(261 Commentaires)
6.1
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(128 Commentaires)
6.3
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(74 Commentaires)
5.3
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(40 Commentaires)
5.8
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(19 Commentaires)
4.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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 0 jours
(16 Commentaires)
4.0
humayoonsheikh4u

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(10 Commentaires)
4.1
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(5 Commentaires)
3.4
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(2 Commentaires)
2.8
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(8 Commentaires)
2.9
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(5 Commentaires)
1.3
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
rdharaniv

I am a pro excel user!! kindly provide me an opportunity to work on the project. Thanks Relevant Skills and Experience Excel

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
hamizah1711

My name is Hamizah Binti Abdul Hamid from Malaysia. I would like to bid this project because i have a few experience with this task

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
tonywong89

Ya, Im new comer on freelancer platform, but you can see my profesional working experiance at my Linkedin profile. [login to view URL] For Simple to Complex Needs.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(0 Commentaires)
0.0
girish100

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
varindsharma

Hi, thanks for the opportunity. Would you be able to share additional insights related to the project, template, project timelines/budget, etc. Thanks and happy to help. I have deep expertise working with in-hous Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(0 Commentaires)
0.0