This spreadsheet is for a self assessment by users. Rules and conditional formatting will produce automated scores and matrix chart.
See attached spreadsheet.
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.
Bu iş için 32 freelancer ortalamada £16 teklif veriyor
Can you send me the Excel spreadsheet please? I can start right away and finish in an hour. Thanks,
"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
Hi Sir I have rich experience in excel .I have checked the spreadsheet and will perform the functions as mentioned in your description Regards
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
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
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.
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
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
I am a pro excel user!! kindly provide me an opportunity to work on the project. Thanks Relevant Skills and Experience Excel
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.
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 Daha Fazla