Spreadsheet: 864680d1711765083-need-few-tweaks-and-beautify-my-excel-kpi-dashboard-excel-helper
Sheet: MAR-24

ABC.
KPI Summary    ( MARCH-2024 )
1ST FLOOR |  |  |  |  |  |  | 2ND FLOOR |  |  |  |  |  |  | Manager
[NAME] |  |  |  |  |  |  | BIDEN |  |  |  |  |  |  | TRUMP |  |  |  |  |  |  |  |  | 2024-03-29 00:00:00
 | Target |  | Achieve |  | [NAME] | KPI % |  | Target |  | Achieve |  | [NAME] | KPI % |  | Target |  | Achieve |  | [NAME] | KPI % | W/Hrs
Average |  |  |  |  |  |  | Average |  |  |  |  |  |  | Average
Month |  |  |  |  |  |  | Month |  |  |  |  |  |  | Month
Date | Day Target |  | Day Achieve |  | [NAME] | KPI % | Date | Day Target |  | Day Achieve |  | [NAME] | KPI % | Date | Day Target |  | Day Achieve |  | [NAME] | KPI % | W.Hrs
2024-03-01 00:00:00 | 13033 |  | 11211 |  |  |  |  | 13605 |  | 10738 |  |  |  |  |  |  |  |  |  |  | 8
2024-03-02 00:00:00 | 16364 |  | 15046 |  |  |  |  | 15654 |  | 13660 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-03 00:00:00 | 14343 |  | 15821 |  |  |  |  | 16808 |  | 14000 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-04 00:00:00 | 13470 |  | 15900 |  |  |  |  | 16325 |  | 14037 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-05 00:00:00 | 13958 |  | 15017 |  |  |  |  | 15425 |  | 14474 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-06 00:00:00 | 15220 |  | 14859 |  |  |  |  | 16011 |  | 13849 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-07 00:00:00 | 13645 |  | 16100 |  |  |  |  | 16856 |  | 13536 |  |  |  |  |  |  |  |  |  |  | 10
TOTAL
2024-03-09 00:00:00 | 16412 |  | 16000 |  |  |  |  | 16312 |  | 14006 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-10 00:00:00 | 15783 |  | 15469 |  |  |  |  | 14290 |  | 14591 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-11 00:00:00 | 16685 |  | 16020 |  |  |  |  | 16461 |  | 13597 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-12 00:00:00 | 15800 |  | 16044 |  |  |  |  | 17086 |  | 13027 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-13 00:00:00 | 16735 |  | 15903 |  |  |  |  | 14881 |  | 11026 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-14 00:00:00 | 15342 |  | 15049 |  |  |  |  | 13581 |  | 14045 |  |  |  |  |  |  |  |  |  |  | 10
TOTAL
2024-03-16 00:00:00 | 17508 |  | 15640 |  |  |  |  | 14075 |  | 14291 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-17 00:00:00 | 17770 |  | 16004 |  |  |  |  | 13517 |  | 14019 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-18 00:00:00 | 18049 |  | 16023 |  |  |  |  | 14418 |  | 14010 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-19 00:00:00 | 15170 |  | 16010 |  |  |  |  | 16232 |  | 13077 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-20 00:00:00 | 13022 |  | 15883 |  |  |  |  | 16494 |  | 14123 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-21 00:00:00 | 14877 |  | 15504 |  |  |  |  | 16001 |  | 14544 |  |  |  |  |  |  |  |  |  |  | 10
TOTAL |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
2024-03-22 00:00:00 | 12277 |  | 11931 |  |  |  |  | 12983 |  | 11317 |  |  |  |  |  |  |  |  |  |  | 8
2024-03-23 00:00:00 | 16109 |  | 15027 |  |  |  |  | 15442 |  | 15013 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-24 00:00:00 | 14944 |  | 15505 |  |  |  |  | 15478 |  | 14523 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-25 00:00:00 | 15598 |  | 15322 |  |  |  |  | 15747 |  | 14697 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-26 00:00:00
2024-03-27 00:00:00 | 15757 |  | 15168 |  |  |  |  | 14113 |  | 14616 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-28 00:00:00 | 15459 |  | 15103 |  |  |  |  | 15010 |  | 14097 |  |  |  |  |  |  |  |  |  |  | 10
TOTAL
2024-03-29 00:00:00 | 15254 |  | 14362 |  |  |  |  | 15082 |  | 13639 |  |  |  |  |  |  |  |  |  |  | 10
2024-03-30 00:00:00
2024-03-31 00:00:00
TOTAL
G.Total |  |  |  |  |  |  | G.Total |  |  |  |  |  |  | G.Total
Weekly  Status
1st Week |  | 3/1/2024 to 3/7/2024 |  | 2nd Week | 3/9/2024 to 3/14/2024 |  |  | 3rd Week |  | 3/16/2024 to 3/21/2024 |  |  | 4th Week |  | 3/22/2024 to 3/28/2024 |  |  | 5th Week |  | 3/29/24 to 3/31/24
 |  | From Fri To Thu |  |  | From Sat To Thu |  |  |  |  | From Sat To Thu |  |  |  |  | From Fri To Thu |  |  |  |  | From Fri To Sun |  |  | 0
WEEKLY TARGET |  |  |  | WEEKLY TGT |  |  |  | WEEKLY TARGET |  |  |  |  | WEEKLY TARGET |  |  |  |  | WEEKLY TARGET
WEEKLY ACV |  |  |  | WEEKLY ACV |  |  |  | WEEKLY TARGET |  |  |  |  | WEEKLY ACV |  |  |  |  | WEEKLY ACV
EXCESS/SHORT |  |  |  | EXCESS/SHORT |  |  |  | EXCESS/SHORT |  |  |  |  | EXCESS/SHORT |  |  |  |  | EXCESS/SHORT
Month Of MARCH-2024   Plan vs Achievements
[NAME] |  | Line 1-9
 |  | Plan | Actual | (+/-) | Per %
 | 1st Week
 | 2nd Week
 | 3rd Week
 | 4th Week
 | 5th Week
 | TTL
BIDEN |  | Line 10-18
 |  | Plan | Actual | (+/-) | Per %
 | 1st Week
 | 2nd Week
 | 3rd Week
 | 4th Week
 | 5th Week
 | TTL
Month Of MARCH-2024 Plan vs Achivements
TRUMP |  | Plan | Actual | (+/-) | Per %
 | 1st Week
 | 2nd Week
 | 3rd Week
 | 4th Week
 | 5th Week
 | TTL