Excel - Risk / Request & Project Management Tracker Excel
- or -
Post a project like this58
£150(approx. $188)
- Posted:
- Proposals: 12
- Remote
- #4157860
- OPPORTUNITY
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Excel Macro/VBA Automation, PDF Conversions, Fillable PDF Forms, Data Scrapping, Data Entry
Bhaktapur
Pro Motion Designer |PPT Designer|Shopify Expert|Google Analytics Setup|Pdf editing
Rawalpindi
Graphic Designer |Experienced Web Designer | Video/Audio Editor | PowerPoint/Keynote | Content Writer |
San Jose
Expert in Video editing | Animation | CV Update | illustrations | Photoshop | CGI and AutoCAD expert | Web developer & designer | Expert in Data scrapping
Karachi
Talented Individual with Expertise in WordPress, Graphic Design, and Microsoft Excel
Bhakkar
140641669457622911342325100271740827947343431416925461110224124105784401093283310964718
Description
Experience Level: Expert
I am looking for an excel document that we can use on projects to track issues and responses. The way this would be done in hard copy would be a register page and then an individual page for each request / issue / risk.
Each tab can be categorised as either a RFI (Request For Information), PMI (Project Manager Instruction) or a RR (Risk Register).
Each tab would have a project name, area of work, date raised, raised by, raised to, cost associated, time associated and a description. The people involved in the project can be limited to around 15 so this could be from a drop down table. The area of work would be the same, approx 15 areas.
On the summary page I would like to see all of the tabs listed in order of date requested with brief details displayed and whether they are a RFI, PMI or RR.
I would also like to lock the cells where user input is not required so that we don't have other parties manipulating the data and I can then share it in excel format without fear of being edited. Plus add company logo, also attached.
I have attached my very poor version I have been working on and I know there are far better ways of doing it by people better at excel than me. Can you make suggestions?
Thanks!
Each tab can be categorised as either a RFI (Request For Information), PMI (Project Manager Instruction) or a RR (Risk Register).
Each tab would have a project name, area of work, date raised, raised by, raised to, cost associated, time associated and a description. The people involved in the project can be limited to around 15 so this could be from a drop down table. The area of work would be the same, approx 15 areas.
On the summary page I would like to see all of the tabs listed in order of date requested with brief details displayed and whether they are a RFI, PMI or RR.
I would also like to lock the cells where user input is not required so that we don't have other parties manipulating the data and I can then share it in excel format without fear of being edited. Plus add company logo, also attached.
I have attached my very poor version I have been working on and I know there are far better ways of doing it by people better at excel than me. Can you make suggestions?
Thanks!
Andrew M.
98% (12)Projects Completed
18
Freelancers worked with
19
Projects awarded
25%
Last project
7 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
1) Does this document hold all the issues / risks and requests that you have? Or do you have one document per project? Or something else?
2) Do you manage RFI's as issues? Or are Project Manager Requests managed as issues? In the past I have called impacted risks, issues and RFI were part of a sales process so something different, so I would need to quickly understand your terminology.
1087421
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies