raw data to a consolidated given column table

[ravindra1962]

need a formula for this table

S.No

Name &Designation

From

to

days

Basic Pay

Due DA%-38.776

Drawn DA%-33.536

Differ

GPF (or) (10% PRAN)

90 % CPS

Cash

Reamrk

1​

K.NAGAKUMARI

01-07-2019

31-07-2019

31​

64670​

25076​

21688​

3388​

3388​

0​

0​

(306214) PSHM

01-08-2019

31-08-2019

31​

66330​

25720​

22244​

3476​

3476​

0​

0​

INC

NEED THIS

THIS

TABLE

COL.O

TO

COL.AE

CELL

FORMULAS

IN EXCEL

2007

CONSOLIDATION

ZPPF/PRAN:21337

01-09-2019

30-09-2019

30​

66330​

25720​

22244​

3476​

3476​

0​

0​

MPPS G.VEMAVARAM

01-10-2019

31-10-2019

31​

66330​

25720​

22244​

3476​

3476​

0​

0​

Sl. No

NO OF INSTALMEN T

SL/ INC/ AAS/ PRO

PERIOD

NO OF MONT HS

PAY

ELIGIBLE 38.776%

DRAWN 33.536%

DIFFEREN CE PER MONTH

CPS PER MONTH

TOTAL IN THIS PERIOD

P.F.

CPS

GRAND TOTAL

Total Deductio ns

Net Amount

01-11-2019

30-11-2019

30​

66330​

25720​

22244​

3476​

3476​

0​

0​

FROM

TO

01-12-2019

31-12-2019

31​

66330​

25720​

22244​

3476​

3476​

0​

0​

1

I

01.07.19

31.07.19

1

64670

25076

21688

3388

0

3388

3388

0

34672

34672

0

01-01-2020

31-01-2020

31​

66330​

25720​

22244​

3476​

3476​

0​

0​

1

I

INC

01.08.19

30.04.20

9

66330

25720

22244

3476

0

31284

31284

0

01-02-2020

29-02-2020

29​

66330​

25720​

22244​

3476​

3476​

0​

0​

1

I

01-03-2020

31-03-2020

31​

66330​

25720​

22244​

3476​

3476​

0​

0​

1

II

01.05.20

31.07.20

3

66330

25720

22244

3476

0

10428

10428

0

37051

37051

0

01-04-2020

30-04-2020

30​

66330​

25720​

22244​

3476​

3476​

0​

0​

1

II

INC

01.08.20

28.02.21

7

67990

26364

22801

3563

0

24941

24941

0

01-05-2020

31-05-2020

31​

66330​

25720​

22244​

3476​

3476​

0​

0​

1

II

SL

01.07.20

15.07.20

15/31

32095

12445

10763

1682

0

1682

1682

0

01-06-2020

30-06-2020

30​

66330​

25720​

22244​

3476​

3476​

0​

0​

1

01-07-2020

31-07-2020

31​

66330​

25720​

22244​

3476​

3476​

0​

0​

1

III

01.03.21

31.07.21

5

67990

26364

22801

3563

0

17815

17815

0

36090

36090

0

01-07-2020

15-07-2020

15​

33165​

12860​

11122​

1738​

1738​

0​

0​

SL

1

III

INC

01.08.21

31.12.21

5

69750

27046

23391

3655

0

18275

18275

0

01-08-2020

31-08-2020

31​

67990​

26364​

22801​

3563​

3563​

0​

0​

INC

1

III

01-09-2020

30-09-2020

30​

67990​

26364​

22801​

3563​

3563​

0​

0​

GRAND TOTAL

107813

107813

0

01-10-2020

31-10-2020

31​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-11-2020

30-11-2020

30​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-12-2020

31-12-2020

31​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-01-2021

31-01-2021

31​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-02-2021

28-02-2021

28​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-03-2021

31-03-2021

31​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-04-2021

30-04-2021

30​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-05-2021

31-05-2021

31​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-06-2021

30-06-2021

30​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-07-2021

31-07-2021

31​

67990​

26364​

22801​

3563​

3563​

0​

0​

01-08-2021

31-08-2021

31​

69750​

27046​

23391​

3655​

3655​

0​

0​

INC

01-09-2021

30-09-2021

30​

69750​

27046​

23391​

3655​

3655​

0​

0​

01-10-2021

31-10-2021

31​

69750​

27046​

23391​

3655​

3655​

0​

0​

01-11-2021

30-11-2021

30​

69750​

27046​

23391​

3655​

3655​

0​

0​

01-12-2021

31-12-2021

31​

69750​

27046​

23391​

3655​

3655​

0​

0​

TOTAL

930​

2058425​

798174​

690305​

107869​

107869​

0​

0​