Problem solution

bwilly
Data.xlsx

HR Attrition Report

Monthly attrition Report - 2020
Sr. No. Month Opening Balance Employees Joined Employees Left Closing Balance Attrition %
1 January 37 3 1 39 2.56%
2 February 39 1 5 35 14.29%
3 March 35 4 2 37 5.41%
4 April 37 1 0 38 0.00%
5 May 38 0 6 32 18.75%
6 June 32 12 3 41 7.32%
7 July 41 1 2 40 5.00%
8 August 40 1 0 41 0.00%
9 September 41 1 2 40 5.00%
10 October 40 1 1 40 2.50%
11 November 40 1 1 40 2.50%
12 December 40 1 2 39 5.13%

Mothly Attrition report

Opening Balance January February March April May June July August September October November December 37 39 35 37 38 32 41 40 41 40 40 40 Employees Joined January February March April May June July August September October November December 3 1 4 1 0 12 1 1 1 1 1 1 Employees Left January February March April May June July August Septembe r October November December 1 5 2 0 6 3 2 0 2 1 1 2 Closing Balance January February March April May June July August September October November December 39 35 37 38 32 41 40 41 40 40 40 39 Attrition % January February March April May June July August September October November December 2.5641 02564102564E-2 0.14285714285714285 5.4054054054054057E-2 0 0.1875 7.3170731707317069E-2 0.05 0 0.05 2.5000000000000001E-2 2.5000000000000001E-2 5.128205128205128E-2