Extraction Data in 2 different Sheets & Sum Sales-problem

[loginid]

Dear Friends

I m using Excel 2013 and OS Windows 10

Sheet-1 is the data base. Sheet 2 (i.e. PV)

Formula Required: In Sheet 2 If The month is changed (from May-18 to June-18) then Planned Value (Column D) value should change (i.e. sales sum cumulative)
Also in sheet 2 Total Value (Column E) should change (respect to column M "Gross" of sheet 1) as per Invoice Schedule Revision (Column C of sheet 2) changes (respect to Column K of sheet 1)

Please explain a bit why that particular formula used.

Excel 2013 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]J[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]K[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]L[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]M[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]N[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]O[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]P[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Q[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]R[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]S[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]T[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]U[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]V[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]W[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]X[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Y[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Z[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AA[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AB[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AC[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AD[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AE[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AF[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AG[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AH[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AI[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AJ[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AK[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AL[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AM[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AN[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AO[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AP[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AQ[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AR[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AS[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AT[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AU[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AV[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]AW[/COLOR]​

[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​

[/TD]
[TD]

Project Name​

[/TD]
[TD="bgcolor: #FFFF99"]

Revised Contract Value​

[/TD]
[TD]

Date of LOI​

[/TD]
[TD]

Contractual Start Date​

[/TD]
[TD]

Contractual Completion Date​

[/TD]
[TD="bgcolor: #F8CBAD"]

Revised Completion Date​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD][/TD]
[TD]

Date of Rev​

[/TD]
[TD]

GROSS​

[/TD]
[TD]

Fy.17 / 18​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

Fy. 18 / 19​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

Fy. 19 / 20​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"]

Rs. In Lacs​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"]

As Actual​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

Apr-17​

[/TD]
[TD]

May-17​

[/TD]
[TD]

Jun-17​

[/TD]
[TD]

Jul-17​

[/TD]
[TD]

Aug-17​

[/TD]
[TD]

Sep-17​

[/TD]
[TD]

Oct-17​

[/TD]
[TD]

Nov-17​

[/TD]
[TD]

Dec-17​

[/TD]
[TD]

Jan-18​

[/TD]
[TD]

Feb-18​

[/TD]
[TD]

Mar-18​

[/TD]
[TD]

Apr-18​

[/TD]
[TD]

May-18​

[/TD]
[TD]

Jun-18​

[/TD]
[TD]

Jul-18​

[/TD]
[TD]

Aug-18​

[/TD]
[TD]

Sep-18​

[/TD]
[TD]

Oct-18​

[/TD]
[TD]

Nov-18​

[/TD]
[TD]

Dec-18​

[/TD]
[TD]

Jan-19​

[/TD]
[TD]

Feb-19​

[/TD]
[TD]

Mar-19​

[/TD]
[TD]

Apr-19​

[/TD]
[TD]

May-19​

[/TD]
[TD]

Jun-19​

[/TD]
[TD]

Jul-19​

[/TD]
[TD]

Aug-19​

[/TD]
[TD]

Sep-19​

[/TD]
[TD]

Oct-19​

[/TD]
[TD]

Nov-19​

[/TD]
[TD]

Dec-19​

[/TD]
[TD]

Jan-20​

[/TD]
[TD]

Feb-20​

[/TD]
[TD]

Mar-20​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​

[/TD]
[TD]

SUNRAY HOUSING​

[/TD]
[TD="bgcolor: #FFFF99"]

292 00​

[/TD]
[TD]

27-Nov-15​

[/TD]
[TD]

20-Jul-17​

[/TD]
[TD]

19-Jul-20​

[/TD]
[TD="bgcolor: #F8CBAD"]

19-Jul-20​

[/TD]
[TD="bgcolor: #FFC000"]

R0​

[/TD]
[TD="bgcolor: #FFC000"]

Init​

[/TD]
[TD]

29200​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

78​

[/TD]
[TD]

448​

[/TD]
[TD]

433​

[/TD]
[TD]

451​

[/TD]
[TD]

449​

[/TD]
[TD]

506​

[/TD]
[TD]

585​

[/TD]
[TD]

939​

[/TD]
[TD]

1257​

[/TD]
[TD]

1206​

[/TD]
[TD]

1372​

[/TD]
[TD]

1278​

[/TD]
[TD]

1296​

[/TD]
[TD]

1409​

[/TD]
[TD]

1498​

[/TD]
[TD]

1497​

[/TD]
[TD]

1393​

[/TD]
[TD]

1507​

[/TD]
[TD]

1510​

[/TD]
[TD]

1335​

[/TD]
[TD]

1170​

[/TD]
[TD]

1337​

[/TD]
[TD]

1207​

[/TD]
[TD]

1103​

[/TD]
[TD]

938.4​

[/TD]
[TD]

717.496​

[/TD]
[TD]

644.897​

[/TD]
[TD]

634.5​

[/TD]
[TD]

594.5​

[/TD]
[TD]

395.71​

[/TD]
[TD]

11.7314​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD="bgcolor: #FFC000"]

R1​

[/TD]
[TD="bgcolor: #FFC000"][/TD]
[TD]

0​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD="bgcolor: #FFC000"]

R2​

[/TD]
[TD="bgcolor: #FFC000"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD="bgcolor: #FFC000"]

R3​

[/TD]
[TD="bgcolor: #FFC000"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

ISBT-PATNA​

[/TD]
[TD="bgcolor: #FFFF99"]

279 51​

[/TD]
[TD="bgcolor: #E2EFDA"]

02-Dec-16​

[/TD]
[TD="bgcolor: #E2EFDA"]

22-May-17​

[/TD]
[TD="bgcolor: #E2EFDA"]

21-Aug-19​

[/TD]
[TD="bgcolor: #F8CBAD"]

31-Mar-20​

[/TD]
[TD]

R0​

[/TD]
[TD]

Init​

[/TD]
[TD]

28017​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

3​

[/TD]
[TD]

275​

[/TD]
[TD]

17​

[/TD]
[TD]

306​

[/TD]
[TD]

589​

[/TD]
[TD]

1109​

[/TD]
[TD]

951​

[/TD]
[TD]

1512​

[/TD]
[TD]

2017​

[/TD]
[TD]

1258​

[/TD]
[TD]

1477​

[/TD]
[TD]

1567​

[/TD]
[TD]

1650​

[/TD]
[TD]

1932​

[/TD]
[TD]

1859​

[/TD]
[TD]

1317​

[/TD]
[TD]

1577​

[/TD]
[TD]

1950​

[/TD]
[TD]

1911​

[/TD]
[TD]

1475​

[/TD]
[TD]

1420​

[/TD]
[TD]

921​

[/TD]
[TD]

578​

[/TD]
[TD]

319​

[/TD]
[TD]

25.49​

[/TD]
[TD]

0​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD]

R1​

[/TD]
[TD]

Base-line R1​

[/TD]
[TD]

29098​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

0​

[/TD]
[TD]

271​

[/TD]
[TD]

11​

[/TD]
[TD]

28​

[/TD]
[TD]

320​

[/TD]
[TD]

598​

[/TD]
[TD]

403​

[/TD]
[TD]

463​

[/TD]
[TD]

747​

[/TD]
[TD]

1753​

[/TD]
[TD]

442​

[/TD]
[TD]

451​

[/TD]
[TD]

609​

[/TD]
[TD]

709​

[/TD]
[TD]

751​

[/TD]
[TD]

601​

[/TD]
[TD]

591​

[/TD]
[TD]

890​

[/TD]
[TD]

996​

[/TD]
[TD]

1298​

[/TD]
[TD]

1379​

[/TD]
[TD]

1400​

[/TD]
[TD]

1620​

[/TD]
[TD]

1689​

[/TD]
[TD]

1589​

[/TD]
[TD]

1545​

[/TD]
[TD]

1413.3​

[/TD]
[TD]

1266.3​

[/TD]
[TD]

823​

[/TD]
[TD]

1021​

[/TD]
[TD]

1010.5​

[/TD]
[TD]

979.52​

[/TD]
[TD]

832.6656​

[/TD]
[TD]

597.8563​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD]

R2​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​

[/TD]
[TD]

DUMKA​

[/TD]
[TD="bgcolor: #FFFF99"]

172 53​

[/TD]
[TD]

27-Dec-16​

[/TD]
[TD]

10-Mar-17​

[/TD]
[TD]

5-Sep-19​

[/TD]
[TD="bgcolor: #F8CBAD"]

03-Sep-19​

[/TD]
[TD="bgcolor: #FFC000"]

R0​

[/TD]
[TD="bgcolor: #FFC000"]

Init​

[/TD]
[TD]

21596​

[/TD]
[TD]

31​

[/TD]
[TD]

258​

[/TD]
[TD]

603​

[/TD]
[TD]

747​

[/TD]
[TD]

569​

[/TD]
[TD]

440​

[/TD]
[TD]

486​

[/TD]
[TD]

495​

[/TD]
[TD]

596​

[/TD]
[TD]

848​

[/TD]
[TD]

929​

[/TD]
[TD]

1421​

[/TD]
[TD]

1162​

[/TD]
[TD]

1103​

[/TD]
[TD]

1049​

[/TD]
[TD]

992​

[/TD]
[TD]

1027​

[/TD]
[TD]

1046​

[/TD]
[TD]

694​

[/TD]
[TD]

702​

[/TD]
[TD]

609​

[/TD]
[TD]

889​

[/TD]
[TD]

1059​

[/TD]
[TD]

883​

[/TD]
[TD]

859​

[/TD]
[TD]

1041​

[/TD]
[TD]

1056​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD="bgcolor: #FFC000"]

R1​

[/TD]
[TD="bgcolor: #FFC000"]

Mar-18​

[/TD]
[TD]

17295​

[/TD]
[TD]

0​

[/TD]
[TD]

124​

[/TD]
[TD]

184​

[/TD]
[TD]

189​

[/TD]
[TD]

287​

[/TD]
[TD]

331​

[/TD]
[TD]

290​

[/TD]
[TD]

395​

[/TD]
[TD]

406​

[/TD]
[TD]

236​

[/TD]
[TD]

423​

[/TD]
[TD]

647​

[/TD]
[TD]

520​

[/TD]
[TD]

561​

[/TD]
[TD]

817​

[/TD]
[TD]

1149​

[/TD]
[TD]

1018​

[/TD]
[TD]

851​

[/TD]
[TD]

982​

[/TD]
[TD]

674​

[/TD]
[TD]

845​

[/TD]
[TD]

551​

[/TD]
[TD]

863​

[/TD]
[TD]

1103​

[/TD]
[TD]

483​

[/TD]
[TD]

415​

[/TD]
[TD]

601​

[/TD]
[TD]

1484​

[/TD]
[TD]

805.529​

[/TD]
[TD]

59.1179​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD="bgcolor: #FFC000"]

R2​

[/TD]
[TD="bgcolor: #FFC000"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"]

HAZARIBAGH​

[/TD]
[TD="bgcolor: #FFFF99"]

172 73​

[/TD]
[TD="bgcolor: #E2EFDA"]

27-Dec-16​

[/TD]
[TD="bgcolor: #E2EFDA"]

10-Mar-17​

[/TD]
[TD="bgcolor: #E2EFDA"]

9-Sep-19​

[/TD]
[TD="bgcolor: #F8CBAD"]

27-Jun-19​

[/TD]
[TD]

R0​

[/TD]
[TD]

Init​

[/TD]
[TD]

21596​

[/TD]
[TD]

31​

[/TD]
[TD]

258​

[/TD]
[TD]

603​

[/TD]
[TD]

747​

[/TD]
[TD]

569​

[/TD]
[TD]

440​

[/TD]
[TD]

486​

[/TD]
[TD]

495​

[/TD]
[TD]

596​

[/TD]
[TD]

848​

[/TD]
[TD]

929​

[/TD]
[TD]

1421​

[/TD]
[TD]

1162​

[/TD]
[TD]

1103​

[/TD]
[TD]

1049​

[/TD]
[TD]

992​

[/TD]
[TD]

1027​

[/TD]
[TD]

1046​

[/TD]
[TD]

694​

[/TD]
[TD]

702​

[/TD]
[TD]

609​

[/TD]
[TD]

889​

[/TD]
[TD]

1059​

[/TD]
[TD]

883​

[/TD]
[TD]

859​

[/TD]
[TD]

1041​

[/TD]
[TD]

1056​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD]

R1​

[/TD]
[TD]

Mar-18​

[/TD]
[TD]

17349​

[/TD]
[TD]

0​

[/TD]
[TD]

187​

[/TD]
[TD]

203​

[/TD]
[TD]

170​

[/TD]
[TD]

320​

[/TD]
[TD]

545​

[/TD]
[TD]

281​

[/TD]
[TD]

402​

[/TD]
[TD]

564​

[/TD]
[TD]

374​

[/TD]
[TD]

573​

[/TD]
[TD]

1294​

[/TD]
[TD]

580​

[/TD]
[TD]

659​

[/TD]
[TD]

872​

[/TD]
[TD]

906​

[/TD]
[TD]

791​

[/TD]
[TD]

767​

[/TD]
[TD]

882​

[/TD]
[TD]

814​

[/TD]
[TD]

548​

[/TD]
[TD]

532​

[/TD]
[TD]

656​

[/TD]
[TD]

1196​

[/TD]
[TD]

1504​

[/TD]
[TD]

1079​

[/TD]
[TD]

648​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​

[/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #E2EFDA"][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD]

R2​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]20[/COLOR]​

[/TD]
[TD]

PALAMU​

[/TD]
[TD="bgcolor: #FFFF99"]

170 82​

[/TD]
[TD]

27-Dec-16​

[/TD]
[TD]

10-Mar-17​

[/TD]
[TD]

5-Sep-19​

[/TD]
[TD="bgcolor: #F8CBAD"]

31-Jul-19​

[/TD]
[TD="bgcolor: #FFC000"]

R0​

[/TD]
[TD="bgcolor: #FFC000"]

Init​

[/TD]
[TD]

21596​

[/TD]
[TD]

31​

[/TD]
[TD]

258​

[/TD]
[TD]

603​

[/TD]
[TD]

747​

[/TD]
[TD]

569​

[/TD]
[TD]

440​

[/TD]
[TD]

486​

[/TD]
[TD]

495​

[/TD]
[TD]

596​

[/TD]
[TD]

848​

[/TD]
[TD]

929​

[/TD]
[TD]

1421​

[/TD]
[TD]

1162​

[/TD]
[TD]

1103​

[/TD]
[TD]

1049​

[/TD]
[TD]

992​

[/TD]
[TD]

1027​

[/TD]
[TD]

1046​

[/TD]
[TD]

694​

[/TD]
[TD]

702​

[/TD]
[TD]

609​

[/TD]
[TD]

889​

[/TD]
[TD]

1059​

[/TD]
[TD]

883​

[/TD]
[TD]

859​

[/TD]
[TD]

1041​

[/TD]
[TD]

1056​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]21[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD="bgcolor: #FFC000"]

R1​

[/TD]
[TD="bgcolor: #FFC000"]

Mar-18​

[/TD]
[TD]

16873​

[/TD]
[TD]

0​

[/TD]
[TD]

160​

[/TD]
[TD]

366​

[/TD]
[TD]

293​

[/TD]
[TD]

345​

[/TD]
[TD]

477​

[/TD]
[TD]

294​

[/TD]
[TD]

384​

[/TD]
[TD]

404​

[/TD]
[TD]

239​

[/TD]
[TD]

489​

[/TD]
[TD]

689​

[/TD]
[TD]

617​

[/TD]
[TD]

750​

[/TD]
[TD]

761​

[/TD]
[TD]

782​

[/TD]
[TD]

752​

[/TD]
[TD]

972​

[/TD]
[TD]

1048​

[/TD]
[TD]

734​

[/TD]
[TD]

596​

[/TD]
[TD]

419​

[/TD]
[TD]

714​

[/TD]
[TD]

852​

[/TD]
[TD]

1663​

[/TD]
[TD]

1229​

[/TD]
[TD]

385​

[/TD]
[TD]

460​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]22[/COLOR]​

[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF99"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F8CBAD"][/TD]
[TD="bgcolor: #FFC000"]

R2​

[/TD]
[TD="bgcolor: #FFC000"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet1[/TD]
[/TR]
</tbody>[/TABLE]

Excel 2013 32 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​

[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​

[/TD]
[TD][/TD]
[TD]

Month​

[/TD]
[TD]Extraction Data in 2 different Sheets & Sum Sales-problem[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​

[/TD]
[TD][/TD]
[TD]

May-18​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Value changes with month change[/TD]
[TD]Value changes with Invoice Schedule Revision change[/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​

[/TD]
[TD]S no.[/TD]
[TD]PROJECTS[/TD]
[TD]Invoice Schedule Revision[/TD]
[TD]Planned Value (Lacs)[/TD]
[TD]Total Value (Lacs)[/TD]
[TD]Planned %[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​

[/TD]
[TD]

1​

[/TD]
[TD]ISBT-PATNA[/TD]
[TD]=Sheet1!R[6]C[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!R[6]C[10]:R[6]C[23])​

[/TD]
[TD]

=Sheet1!R[6]C[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​

[/TD]
[TD]

2​

[/TD]
[TD]SUNRAY HOUSING[/TD]
[TD]=Sheet1!RC[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!RC[10]:RC[23])​

[/TD]
[TD]

=Sheet1!RC[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​

[/TD]
[TD]

3​

[/TD]
[TD]DUMKA[/TD]
[TD]=Sheet1!R[7]C[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!R[7]C[10]:R[7]C[23])​

[/TD]
[TD]

=Sheet1!R[7]C[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​

[/TD]
[TD]

4​

[/TD]
[TD]HAZARIBAGH[/TD]
[TD]=Sheet1!R[9]C[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!R[9]C[10]:R[9]C[23])​

[/TD]
[TD]

=Sheet1!R[9]C[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​

[/TD]
[TD]

5​

[/TD]
[TD]PALAMU[/TD]
[TD]=Sheet1!R[11]C[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!R[11]C[10]:R[11]C[23])​

[/TD]
[TD]

=Sheet1!R[11]C[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​

[/TD]
[TD]

6​

[/TD]
[TD]BELLEVUE-NC[/TD]
[TD]=Sheet1!R[13]C[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!R[13]C[10]:R[13]C[23])​

[/TD]
[TD]

=Sheet1!R[13]C[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​

[/TD]
[TD]

7​

[/TD]
[TD]CIVIC TOWER[/TD]
[TD]=Sheet1!R[14]C[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!R[14]C[10]:R[14]C[23])​

[/TD]
[TD]

=Sheet1!R[14]C[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​

[/TD]
[TD]

8​

[/TD]
[TD]GUWAHATI AIRPORT[/TD]
[TD]=Sheet1!R[16]C[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!R[16]C[10]:R[16]C[23])​

[/TD]
[TD]

=Sheet1!R[16]C[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​

[/TD]
[TD]

9​

[/TD]
[TD]SIVASAGAR HOSPITAL[/TD]
[TD]=Sheet1!R[18]C[8][/TD]
[TD="bgcolor: #FFFF00"]

=SUM(Sheet1!R[18]C[10]:R[18]C[23])​

[/TD]
[TD]

=Sheet1!R[18]C[8]​

[/TD]
[TD]

=RC[-2]/RC[-1]​

[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: PV[/TD]
[/TR]
</tbody>[/TABLE]

Thank u.