已关闭

Do some Excel Work

I am looking for a Microsoft Excel master to create what I am calling an “Active Skills Matrix”. Basically, the excel spread sheet should be designed to provide the following functionality:

Show a list of people vertically in column A

Show a list of skills / knowledge areas horizontally across the top that can be mapped to an individual person

Allow a person to rate their own proficiency (i.e. from 1 to 3 for example) for each individual skill / knowledge area using a drop down box i.e. 1(green fill), 2 (orange fill), 3 (red fill) etc which are assigned to a number

Show the rating criteria for both knowledge level and proficiency to assist them in understanding how to rate themselves correctly

Allow a manager to rate the supervision level required to be applied to an individual for each individual skill using a drop down box (i.e. from 1 to 3 for example)

Assign the individual skills to a discipline or multiple disciplines i.e. Security Design Services, Security Risk Services, Business Resilience, Crisis Management, Business Continuity, Project Management, Close Protection, Emergency Management etc

Assign the individual skills to project type i.e. CCTV design, Security Risk Assessment, Feasibility Study etc.

Assign the individual skills to a deliverable type i.e. TRA Report, Project Management Plan, Specification, etc

The spreadsheets objective (based on the inputs) is to rank people as follows:

Individual profile for each person (graph / pie chart etc) showing their proficiency / rating in each individual skill / knowledge area

Analyse and rank people best suited to a discipline

Analyse and rank people best suited to a project type

Analyse and rank people best suited to a deliverable type

Upon project award, I will provide the raw data that needs input into the spreadsheet.

技能: 数据输入, 数据处理, Excel

查看更多: work close, spreadsheet design services, skills matrix excel, risk assessment design, orange business services, objective of business plan, microsoft excel spread sheet, microsoft excel management, how to graph data, how to create graph, how to create a graph, how can i design graph, graph data type, excel spreadsheet services, excel specification, excel skills matrix, entry level project manager, drop down list in objective c, design crisis, data resilience, data entry skills assessment, data entry assessment, business in a box business plan, business excel services, best excel spreadsheets

About the Employer:
( 4 reviews ) Westlake, Australia

项目ID: #6851189

66名威客为此工作的平均竞标价是$130

Teloquence

Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to 更多

$50 USD 在0天内
(256条评论)
7.1
zExcel

A proposal has not yet been provided

$160 USD 在2天内
(131条评论)
6.7
pandey2008

Hello sir,I have 8 member team and good experience and we can start the work right now and also all communication and work will be high quality. all work will be on my office without any [url removed, login to view]

$105 USD 在3天内
(220条评论)
6.5
jaylancer43

Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n 更多

$101 USD 在2天内
(99条评论)
6.2
maverick44000

Hi. I am Usman and I have been working with Excel applications for a long time. I have designed a very similar application in Excel before and I shall be able to get it done for you exactly as you desire. Kindly discus 更多

$130 USD 在5天内
(45条评论)
6.0
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou 更多

$189USD 在1天里
(87条评论)
6.0
binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

$177 USD 在3天内
(84条评论)
5.9
shikhamehta

Hey, What you are looking for is something similar to stack ranking system. Right? I can create a spreadsheet template for you which will allow the users to input the ratings and also do project assignments as requi 更多

$244 USD 在7天内
(105条评论)
5.6
aarifakhtar

Hi: Will the spreadsheet have two separate pages: one for input and the other to view the summary? Summary could show the best 5 people in a discipline or a project type or a deliverable. Please note that I have 100% c 更多

$155 USD 在3天内
(44条评论)
5.5
Haque6568

hi i am very much interested to do such type work. i have long experience on any type of excel work, graph, calculation etc. i have a humble request to you. professionally i am lecturer. so please give me this pr 更多

$35 USD 在3天内
(33条评论)
5.4
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$155 USD 在3天内
(74条评论)
5.4
FirstChoiceWeb

Hello, Read and understood project details. We have a lot of experience of data scarping and data entry. We can do this job very well also we are ready to do sample entries. Hope to getting consider for this also pleas 更多

$34 USD 在3天内
(58条评论)
5.4
romanyfahmy0

Hello dear sir, I'm very interested in the job and ready to start immediately once you accept my bid, I'm a full time worker having all skills needed to complete your job perfect on time. kindly check my profile and s 更多

$157 USD 在5天内
(28条评论)
5.4
dragos1910d

Propunerea nu a fost încă furnizată

$150 USD 在3天内
(55条评论)
5.1
hdlong66

Hello, I am highly interested in your project and able to deliver quality work. Let's discuss about details. Best regards,

$100 USD 在7天内
(53条评论)
5.0
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have bee 更多

$150 USD 在3天内
(6条评论)
4.6
tomislav1975

I can do this, see my portfolio and contact me if you're interested. Thanks, TOm______________________________________________________________________

$160 USD 在5天内
(18条评论)
4.5
jiashahood

Hello I can do this project as I had done projects of excel, virtual assistance and data entry before as you can check my profile. I can provide you samples of my previous work. I hope you would like to work with me 更多

$100 USD 在3天内
(20条评论)
4.3
dank111

Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I am interested in creating this skill matrix that you have outlined as this will involved both analysis and logical thinking. I got a 更多

$150 USD 在5天内
(9条评论)
4.2
rousseauassoc

I would like to place a bid in relation to you project brief. I have recently built a similar model which enabled the user to - *Assign multiple skills to employees *Assign colleagues to specific tasks on specific 更多

$250 USD 在3天内
(6条评论)
4.1