Spreadsheet: 872772d1719220989-audit-calculation-audit
Sheet: Sheet1

Date | Location | Parameter1 | Parameter1 | Parameter1 | Parameter2 | Parameter2 | Parameter2 | Parameter3 | Parameter3 | Parameter3 | Parameter4 | Parameter4
2024-06-01 00:00:00 | A-3 | Yes | Yes | Yes | Yes | Yes |  | Yes | No | Yes | Yes | Yes |  |  | A-3 | Select Location |  |  |  |  |  |  |  |  | Location
2024-06-01 00:00:00 | A-3 | Yes | Yes | Yes | Yes | Yes |  | Yes | No | Yes | Yes | Yes |  |  | Parameter1 | 2024-06-01 00:00:00 | 2024-06-03 00:00:00 | 2024-06-04 00:00:00 | 2024-06-05 00:00:00 | 2024-06-06 00:00:00 |  |  |  |  | A-3
2024-06-01 00:00:00 | A-3 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes |  |  | Parameter1 |  |  |  |  |  |  |  |  |  | A-GF
2024-06-01 00:00:00 | A-3 | Yes | Yes | Yes | Yes | Yes | No | Yes | No | Yes | Yes | Yes |  |  | Parameter1 |  |  |  |  |  |  |  |  |  | A-8
2024-06-01 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes |  |  | Parameter2 |  |  |  |  |  |  |  |  |  | A-7
2024-06-01 00:00:00 | A-8 | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes |  |  | Parameter2 |  |  |  |  |  |  |  |  |  | [NAME]
2024-06-01 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes |  |  | Parameter2 |  |  |  |  |  |  |  |  |  | A-4
2024-06-01 00:00:00 | A-GF | Yes | No | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes |  |  | Parameter3
2024-06-01 00:00:00 | A-GF | Yes | No | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes |  |  | Parameter3
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes |  |  | Parameter3
2024-06-01 00:00:00 | A-8 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |  |  | Parameter4
2024-06-01 00:00:00 | A-8 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |  |  | Parameter4
2024-06-01 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |  |  | Hi I wanted to calculate the % of Audits of various parameter & Date wise  mentionedi the "Column P" and rowP3:U3 based on the data from "Colmuns A to Columns N" and also floor wise filter selection in "Cell P3"  Audit % Calculation = Count of Yes / (Count. of Yes + Count. of NO)
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-01 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-4 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-7 | Yes | No | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-7 | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-04 00:00:00 | A-8 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-04 00:00:00 | A-8 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | A-3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Yes
2024-06-05 00:00:00 | A-4 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-05 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-03 00:00:00 | A-3 | Yes | Yes | No | Yes | Yes |  | Yes | No | Yes | Yes | Yes
2024-06-06 00:00:00 | A-3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-GF | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | A-7 | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No
2024-06-06 00:00:00 | A-7 | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
2024-06-06 00:00:00 | [NAME] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes