Please would you be able to advise for the following?
The work I do produces a document that asks customers questions about the design of buildings so that I can report to an client and let them know that the building will be safe.
I have been working on creating a Burndown Chart which is based on a this document. This document has a number of iterations, and tracks a list of questions we send to customers and whether they are answered to our satisfaction. The Burndown chart will track how many queries are answered for each time we review the questions, which is not on a fixed schedule but every 3-4 weeks as a guide.
The number of questions changes from project to project, but the aim is that after 15 reviews by us, the client will answered and completed 95% of the queries.
Due to my company ban of VBA or code in general due to safety breaches, data on how many questions were answered satisfactorily has to be entered manually.
I need to create a chart which - looks good visually for the client - has a hidden user interface which makes it easy for someone with very basic excel skills to manually enter: 1. The total number of queries or "conditions" as we call them, 2. Be automatically provided with the target number of questions to be answered per review (N/15) 3. Forecast whether based on the current customer rate of answering queries they will meet the target of answering 95% of queries in 15 reviews. 4. Show in an overlaid bar chart on the burndown chart how many conditions were responded to and how many were accepted.
Ideally a separate chart, like a heat map would be also created. It would show from our query list to customers which sections are not being answered and which were. If you could price for this seperately that would be great.
I have a document which shows my attempt but I was hoping you could bring it to the next level in terms of making it easier to use and failsafe for people with very limited excel knowledge or skills.
You can download it here: https://labcwarranty.sharefile.com/d-s600265d251d34176a8a4972f0d00ce59
I appreciate your time and hope to discuss with you soon.