STASTICAL FUNCTION

AVERAGE
78
90
87
65
80
AVERAGE A
78
90
87
65
A
B
53.3333333
AVERAGE IF
78
90
87
65
88.5
COUNT
7
89
78
90
A
4
COUNTA
7
89
78
90
A
5
COUNTBLANK
7
89

A
B
2
COUNTIF A
A
A
 B
A
B
A
V
5

MAX 78
90
87
65
90
MIN
78
90
56
45
45

MATH

ABS -2
2

CEILLING 35 10
40
FLOOR
35 10
30
PRODUCT
43 66
2838
SQRT
36
6
POWER
5 2 25
10 3 1000
EVEN 15 16
ODD 10 11

FACT 5 120

FACT DOUBLE 5 15
INT 3.598 3

ROUND 3.598 3.6

ROUNDUP 3.598 4

ROUND DOWN 3.598 3.5

LCM 10 10

GCD 10 10

PI 3.1415926535898

LOG 10 1

MOD 5 2 1

ROMAN 15 XV

SIGN 35 1

SQRTPI 89 16.7212962

SUMPRODUCT 34 6
45 9
33 8 873

SUMSQ
8 9 145

TEXT

CHAR 1�
2�
3�
4�
5�
TRIM
My name is gopal Swain
My name is gopal Swain

Exact
GOPAL SWAIN GOPAL SWAIN TRUE
 GOPAL SWAIN Gopal Swain FALSE

CONCATENATE
A E AE
B F BF
C G CG
D H DH

LOWER
GOPAL SWAIN gopal swain

UPPER
gopal swain GOPAL SWAIN

PROPER
gopal swain Gopal Swain

LEFT
I LOVE MY INDIA I LOV

RIGHT
I LOVE MY INDIA INDIA

MID
I LOVE MY INDIA IL

LEN
LORD 4
GOD 3
GOPAL 5

REPT
LORD LORDLORDLORDLORDLORDLORDLORDLORDLORDLORDLORDLORDLORDLORDLORD

FIND
LORD GOD IS LORD 8

SEARCH
GOD GOD IS LORD 1

DATE & TIME

DATE 11/21/2003

NOW
 3/30/2025 13:44

TODAY
3/30/2025

YEAR
11/21/2003 2003

MONTH
11/21/2003 11

DAY
11/21/2003 21

HOUR
8:32 8

MINUTE
8:33 33

SECOND
8:30:12 AM 12

E DATE
12/21/2003 38128

EO MONTH
1/3/2023 45138

DATE VALUE
21/11/2003 Err:502

WORK DAY
12/1/2022 15 12/7/2022
12/23/2022

NETWORKDAYS
12/1/2022 12/7/2022 12/23/2022 16

[Link]
12/1/2022 12/23/2022 12/7/2022 19

WEEKDAY
12/30/2022 7
WEEK NUM
12/30/2022 53

DAYS360
12/1/2022 12/23/2022 22

DAYS
11/21/2003 2/3/2023 7014
DLORDLORDLORDLORDLORDLORDLORDLORDLORDLORDLORD
NAME TEST 1 TEST 2 OR
Gopal Swain 22 50 TRUE selected
Soumya Das 20 20 FALSE Not selected
Raghu Jena 30 30 FALSE Not selected
Chiku Behera 67 87 TRUE selected

State Item Sale

Delhi Rice 20000
Punjab Dal 40000
Gujurat Ghee 8900
Hariyan Atta 4500
Delhi Rice 78000
Punjab Dal 5600
Gujurat Ghee 5600
Hariyan Atta 45000
Delhi Rice 32000
Punjab Dal 40000
Gujurat Ghee 21000
Hariyan Atta 35000

MARKIT
 Name Sub 1 Sub 2 Sub 3 Sub 4 Sub 5 Sub 6 Total Mark Per
Gopal Swain 22 99 69 69 65 44 368 61.33333
Jitu Behera 56 90 67 89 45 45 392 65.33333
Ananda Parida 22 45 67 89 67 21 311 51.83333
Rajendra Parida 23 34 56 78 44 32 267 44.5
Chiku Behera 20 23 33 45 32 67 220 36.66667
Rakesha Jena 55 89 33 22 11 89 299 49.83333
Debashis Behera 22 20 25 20 17 30 134 22.33333
Raghu Jena 23 56 44 33 22 78 256 42.66667
Bikash Jena 33 45 67 88 99 89 421 70.16667
Bikash Nayak 32 45 67 89 33 33 299 49.83333
Banty Behera 30 27 28 22 20 56 183 30.5

State Item Sale

Delhi Rice 20000
Punjab Dal 40000
Gujurat Ghee 8900
Hariyan Atta 4500
Delhi Rice 78000
Punjab Dal 5600
Gujurat Ghee 5600
Hariyan Atta 45000
Delhi Rice 32000
Punjab Dal 40000
Gujurat Ghee 21000
Hariyan Atta 35000
 Result Result Name Chiku Behera
fail compairment Sub 1 20
pass pass Sub 2 23
compairment compairment Sub 3 33
fail fail Sub 4 45
compairment compairment Sub 5 32
compairment compairment Sub 6 67
FALSE fail Total Mark 220
compairment compairment Percent 36.666666666667
pass pass PASS/FAIL Pass
pass pass
FALSE fail
Chiku Behera
[Link] Customer Products Qty Rate Amount
1 Gopal Swain Rice 14 40 560
2 Gopal Swain Atta 34 30 1020
3 Gopal Swain Biscuit 87 50 4350
Gopal Swain Total 0 5930
4 Kalandi Behera Oil 44 140 6160
5 Kalandi Behera Rice 56 40 2240
6 Kalandi Behera Biscuit 56 50 2800
Kalandi Behera Total 0 11200
7 Narendra Behera Ghee 15 90 1350
8 Narendra Behera Dal 90 100 9000
9 Narendra Behera Atta 14 30 420
Narendra Behera Total 0 10770
10 Soumya Jena Dal 30 100 3000
11 Soumya Jena Rice 56 40 2240
12 Soumya Jena Biscuit 23 50 1150
Soumya Jena Total 0 6390

Grand Total 0 34290

State Item Sale Name
Delhi Rice 40000 Gopal Swain
Delhi Rice 156000 Bikash Nayak
Delhi Rice 64000 Raghu Jena
Gujurat Ghee 17800 Chiku Behera
Gujurat Ghee 11200 Soumya Das
Gujurat Ghee 42000 Soumya Rout
Hariyan Atta 9000 Soumya Jena
Hariyan Atta 90000
Hariyan Atta 70000
Punjab Dal 80000
Punjab Dal 11200
Punjab Dal 80000
Name
Gopal Swain
Bikash Nayak
Raghu Jena
Chiku Behera
Soumya Das
Soumya Rout
Soumya Jena
Salary Bonous Total PAY
40000 3600 43600 0.09
50000 4500 54500
30000 2700 32700
20000 1800 21800
80000 7200 87200
45000 4050 49050
35000 3150 38150

Salary Bonous Total PAY 0.09

40000 3600 43600
50000 4500 54500
30000 2700 32700
20000 1800 21800
80000 7200 87200
45000 4050 49050
35000 3150 38150
 TABLE 1 TABLE 2
Milimeters 500 Centimeters
Feet 10 Inch
Kilometers 10 Miles
Liters 1 Millimeters
Kilograms 5 Grams
Hours 48 Days

TABLE 1 TABLE 2
Milimeters 500 Centimeters
Feet 10 Inch
Kilometers 10 Miles
Liters 1 Millimeters
Kilograms 5 Grams
Hours 48 Days
TABLE 2
50
120
6.21371192237334
1000
5000
2

TABLE 2
50
120
6.21371192237334
1000
5000
2
[Link] Customer Name Amount Recived or Not Status
1 Gopal Swain 6000 Recived
2 Rajendra Parida 7000 Recived
4 Jaga Jena 6500 Recived
7 Soumya Jena 3499 Recived
8 Raghu Jena 5000 Not Recived
9 Chiku Behera 3077 Recived
10 Ananda Parida 3400 Not Recived
14 Aswit Swain 299 Not Recived
15 Abhaya Mohanty 399 Not Recived
16 Ananda Parida 499 Recived
17 Babu Jena 599 Not Recived
18 Rakesha Jena 699 Not Recived
20 Aswit Swain 899 Recived
21 Abhaya Mohanty 999 Recived
[Link] Name Sale Amount
1 Rajendra Parida 2300
2 Bikash Jena 5000
3 Soumya Rout 4300
4 Soumya Jena 5600
5 Raghu Jena 555
6 Rakesha Jena 5680
7 Situ Swain 4500
8 Aswit Swain 4578
9 Abhaya Mohanty 6700
10 Ananda Parida 7680
11 Rajendra Parida 9640
12 Jaga Nayak 10620
13 Jaga Jena 11600
14 Bikash Jena 12580
15 Soumya Rout 13560
16 Soumya Jena 14540
17 Raghu Jena 15520
18 Ananda Parida 17480
19 Rakesha Jena 19440
20 Situ Swain 20420
21 Aswit Swain 21400
22 Abhaya Mohanty 22380
23 Ananda Parida 23360
259433
Bill NO. Date Party Name Item Name Qty Rate Amount
14 9/21/2022 GS Enterprises Keyboard 10 500 5000
16 10/22/2022 Bhola & CO Mouse 18 300 5400
18 11/22/2022 BKS Enterprises Ram 90 400 36000
20 12/23/2022 GS Enterprises Printer 67 3000 201000
22 1/23/2023 Bhola & CO Moniter 56 2000 112000
24 2/23/2023 BKS Enterprises Keyboard 32 500 16000
26 3/26/2023 GS Enterprises Moniter 90 2000 180000
28 4/26/2023 Bhola & CO Ram 87 400 34800
30 5/27/2023 BKS Enterprises Cpu 44 7000 308000
32 6/27/2023 GS Enterprises Moniter 55 2000 110000
Bill NO. Date Party Name Item Name Qty Rate Amount
33 8/21/2021 GS Enterprises Moniter 46 2000 92000
35 9/23/2021 Bhola & CO Keyboard 56 500 28000
37 10/26/2021 BKS Enterprises Ram 45 400 18000
39 11/28/2021 GS Enterprises Printer 34 3000 102000
41 12/31/2021 Bhola & CO Mouse 23 300 6900
43 2/2/2022 BKS Enterprises Cpu 56 7000 392000
45 3/7/2022 GS Enterprises Printer 78 3000 234000
47 4/9/2022 Bhola & CO Ram 65 400 26000
49 5/12/2022 BKS Enterprises Keyboard 43 500 21500
51 6/14/2022 GS Enterprises Mouse 78 300 23400
Bill NO. Date Party Name Item Name Qty Rate Amount
52 5/4/2022 BKS Enterprises Mouse 66 300 19800
54 6/3/2022 GS Enterprises Ram 56 400 22400
56 7/3/2022 Bhola & CO Moniter 45 2000 90000
58 8/2/2022 Bhola & CO Cpu 34 7000 238000
60 9/1/2022 BKS Enterprises Cpu 56 7000 392000
62 10/1/2022 GS Enterprises Ram 78 400 31200
64 10/31/2022 Bhola & CO Moniter 90 2000 180000
66 11/30/2022 BKS Enterprises Cpu 81 7000 567000
68 12/30/2022 GS Enterprises Printer 21 3000 63000
70 1/29/2023 Bhola & CO Mouse 56 300 16800
Bill NO. Date Party Name Item Name Qty Rate Amount
71 2/2/2022 BKS Enterprises Ram 77 400 30800
73 2/3/2022 GS Enterprises Moniter 45 2000 90000
75 2/4/2022 Bhola & CO Ram 44 400 17600
77 2/5/2022 Bhola & CO Keyboard 66 500 33000
79 2/6/2022 BKS Enterprises Printer 88 3000 264000
81 2/7/2022 GS Enterprises Mouse 99 300 29700
83 2/8/2022 Bhola & CO Keyboard 90 500 45000
85 2/9/2022 Bhola & CO Cpu 67 7000 469000
87 2/10/2022 BKS Enterprises Keyboard 54 500 27000
89 2/11/2022 GS Enterprises Ram 32 400 12800
Item Name Purchase Sales Purchase Return Sales Return Closing Stock
Keyboard 42 99 0 210 153
Mouse 18 101 122 99 -106
Ram 177 110 134 153 86
Printer 67 112 21 88 22
Moniter 201 46 135 45 65
Cpu 44 56 171 67 -116
 Principal Rate Time Interest
6000 12.5 3 40000

PMT PAYMENT TERMS MONTHS IPMT

NAME GOPAL SWAIN 1 ₹ 333.33
RATE 8% 2 ₹ 320.48
LOAN AMOUNT 50000 3 ₹ 307.54
DURATION 24 4 ₹ 294.52
5 ₹ 281.40
PMT EMI ₹ 2,261.36 6 ₹ 268.20
AFTER MONTH TOTAL PAID ₹ 54,272.75 7 ₹ 254.92
TOTAL INTEREST ₹ 4,272.75 8 ₹ 241.54
9 ₹ 228.07
10 ₹ 214.52
PV 11 ₹ 200.87
RATE 12% 12 ₹ 187.14
EMI 20000 13 ₹ 173.31
DURATION 24 14 ₹ 159.39
15 ₹ 145.37
LOAN AMOUNT ₹ 424,867.75 16 ₹ 131.27
17 ₹ 117.07
18 ₹ 102.77
19 ₹ 88.38
20 ₹ 73.89
21 ₹ 59.31
22 ₹ 44.63
23 ₹ 29.85
24 ₹ 14.98
TOTAL MONTH ₹ 4,272.75
 ₹ 333.33
PPMT EMI
₹ 1,928.03 ₹ 2,261.36
₹ 1,940.88 ₹ 2,261.36
₹ 1,953.82 ₹ 2,261.36
₹ 1,966.85 ₹ 2,261.36
₹ 1,979.96 ₹ 2,261.36
₹ 1,993.16 ₹ 2,261.36
₹ 2,006.45 ₹ 2,261.36
₹ 2,019.83 ₹ 2,261.36
₹ 2,033.29 ₹ 2,261.36
₹ 2,046.85 ₹ 2,261.36
₹ 2,060.49 ₹ 2,261.36 FV
₹ 2,074.23 ₹ 2,261.36 RATE 12%
₹ 2,088.06 ₹ 2,261.36 EMI 20000
₹ 2,101.98 ₹ 2,261.36 DURATION 24
₹ 2,115.99 ₹ 2,261.36
₹ 2,130.10 ₹ 2,261.36 LOAN AMOUNT ₹ 539,469.30
₹ 2,144.30 ₹ 2,261.36
₹ 2,158.59 ₹ 2,261.36
₹ 2,172.98 ₹ 2,261.36
₹ 2,187.47 ₹ 2,261.36
₹ 2,202.05 ₹ 2,261.36
₹ 2,216.73 ₹ 2,261.36
₹ 2,231.51 ₹ 2,261.36
₹ 2,246.39 ₹ 2,261.36
₹ 50,000.00 ₹ 54,272.75
Emp ID Emp Name Age Unique Frequency
101AB2 Gopal Swain 18 18 7
101AB3 Raghu Jena 18 17 2
101AB4 Chiku Behera 18 22 1
101AB5 Ananda Parida 17 24 2
101AB6 Mikun Behera 22 23 1
101AB7 Ranjan Behera 24 20 1
101AB8 Pinu Pradhan 23 16 2
101AB9 Sipun Panigrahi 18 15 1
101AB10 Rakesha Jena 18 19 1
101AB11 Babu Swain 20 25 1
101AB12 Asit Swain 18
101AB13 Pintu Pradhan 24
101AB14 Kishore Jena 16
101AB15 Rajesh Nayak 16
101AB16 Jaga Nayak 17
101AB17 Bikash Nayak 18
101AB18 Jitu Nayak 15
101AB19 Aditya Nayak 19
101AB20 Ram Nayak 25
 LOAN AMOUNT 50000 RATE EMI
NO OF INSTALLMENT 24 15% ₹ 2,424.33
12% ₹ 2,353.67
10% ₹ 2,307.25
8% ₹ 2,261.36
5% ₹ 2,193.57
2% ₹ 2,127.01

LOAN AMOUNT 50000 RATE

NO OF INSTALLMENT 24 16%

EMI 12% 10% 8% 5%

₹ 2,448.16 ₹ 2,353.67 ₹ 2,307.25 ₹ 2,261.36 ₹ 2,193.57

AMOUNT 10000
BONOUS 10%
BONOUS
1000 5% 4% 3% 2% 1%
20000 1000 800 600 400 200
30000 1500 1200 900 600 300
40000 2000 1600 1200 800 400
50000 2500 2000 1500 1000 500
60000 3000 2400 1800 1200 600
70000 3500 2800 2100 1400 700
80000 4000 3200 2400 1600 800
 ₹ 2,424.33 ₹ 2,424.33
12% ₹ 2,353.67 12% ₹ 2,353.67
10% ₹ 2,307.25 10% ₹ 2,307.25
8% ₹ 2,261.36 8% ₹ 2,261.36
5% ₹ 2,193.57 5% ₹ 2,193.57
2% ₹ 2,127.01 2% ₹ 2,127.01

EMI 12% 10% 8%

₹ 2,448.16 ₹ 2,353.67 ₹ 2,307.25 ₹ 2,261.36
2%
₹ 2,127.01
 5% 2%
₹ 2,193.57 ₹ 2,127.01
 Student Name DOB MOB ROLL NO
Gopal Swain 210101092060 Gopal Swain 11/21/2003 7735614669 #FMT
Raghu Jena 210101092061 Raghu Jena 4/3/2004 8790675432 #FMT
Chiku Behera 210101092062 Chiku Behera 6/5/2001 7475579087 #FMT
Ananda Parida 210101092063 Ananda Parida 4/7/2004 7686908765 #FMT
Mikun Behera 210101092064 Mikun Behera 11/9/2005 8907654325 #FMT
Ranjan Behera 210101092065 Ranjan Behera 7/21/2003 5479087654 #FMT
Pinu Pradhan 210101092066 Pinu Pradhan 11/21/2003 8907654323 #FMT
Sipun Panigrahi 210101092067 Sipun Panigrahi 5/3/2004 9777980677 #FMT
Rakesha Jena 210101092068 Rakesha Jena 4/3/2003 9878908765 #FMT
Babu Swain 210101092069 Babu Swain 3/21/2005 9087666890 #FMT
Asit Swain 210101092070 Asit Swain 12/21/2006 4356789054 #FMT
Pintu Pradhan 210101092071 Pintu Pradhan 3/21/2005 7890654321 #FMT
Kishore Jena 210101092072 Kishore Jena 3/30/2003 7890654367 #FMT
Rajesh Nayak 210101092073 Rajesh Nayak 5/4/2006 9807654323 #FMT
Jaga Nayak 210101092074 Jaga Nayak 8/7/2006 9087654378 #FMT
Bikash Nayak 210101092075 Bikash Nayak 3/4/2003 9087654326 #FMT
Jitu Nayak 210101092076 Jitu Nayak 9/8/2003 8796069453 #FMT
Aditya Nayak 210101092077 Aditya Nayak 4/8/2002 8485853838 #FMT
Ram Nayak 210101092078 Ram Nayak 8/9/2002 8975988959 #FMT
Marks Obtained
454
345 Student Name ROLL NO Marks Obtained Pass/Fail
576 Gopal Swain #FMT 454 Pass
435
234 Pass
330
567
454
400
434
230
340
234
123
234
543
555
444
343
 TOTALWORKING
Name IN TIME OUT TIME HOURS
Gopal 10:00 AM 6:30 PM 08:30
Narendra 10:10 AM 5:30 PM 07:20
Kalandi 10:50 AM 4:30 PM 05:40
Jaga 10:30 AM 9:30 PM 11:00
Raghu 11:30 AM 10:00 PM 10:30
Soumya 11:00 AM 7:00 PM 08:00
GRAND TOTAL 51:00
 Batches & Time Table
Time / Teacher Asif Sir Vikranta Sir Rahul Sir Akshy Sir
7:00 AM Tally Excel Tally Excel INDEX & MATCH
8:00 AM Excel Tally Excel DTP SELECT Akshy Sir
9:00 AM Ms-office Ms-office DTP Ms-office 10:00 AM DTP
10:00 AM DTP Excel Ms-office DTP
11:00 AM Tally Tally Excel Excel
12:00 PM Excel Ms-office DTP DTP
1:00 AM Ms-office Excel DTP Tally
Customer Name Bill Amount Product Qty Bonous 5% Discount 10% Discount 20%

Gopal Swain 15000 8 750 1500 3000

Soumya Das 3000 7 0 300 0

Bikash Nayak 4000 3 0 0 0

Raghu Jena 70000 6 3500 7000 14000

Chiku Behera 2000 5 0 0 0

Jitu Behera 5000 12 0 500 0

Rakesha Jena 10000 15 0 1000 0

Bikash Jena 9000 14 0 900 0

Grade (A,B,C)

C
[Link] NAME PAY DAYS BASIC DA TOTAL PAY PF ESI NET PAY
1 Gopal Swain 23 4500 450 4950 99 198 5247
2 Somu Jena 5 2000 200 2200 44 88 2332
3 Rajendra Parida 60 2000 200 2200 44 88 2332
4 Chiku Behera 89 3000 300 3300 66 132 3498
5 Rakesha Jena 67 6000 600 6600 132 264 6996
6 Raghu Jena 3 7000 700 7700 154 308 8162
7 Soumya Das 12 8000 800 8800 176 352 9328
8 Ananda Parida 56 6500 650 7150 143 286 7579
9 Ram Nayak 78 4500 450 4950 99 198 5247
10 Soumya Rout 3 3400 340 3740 74.8 149.6 3964.4
Lookup PAYDAYS
Soumya Rout 3

Rajendra Parida
ACCOUNT .NO AMOUNT ACCT TYPE BRANCH CUSTOMER ACCOUNT .NO
56001 50000 Saving Central Exisiting AMOUNT
56002 52000 Checking North Country New ACCT TYPE
56003 54000 CD Westside Exisiting BRANCH
56004 56000 Saving Central New CUSTOMER
56005 58000 Checking North Country New
56006 60000 CD Westside Exisiting
56007 62000 Saving Central New
56008 64000 Checking North Country New
56009 66000 CD Westside Exisiting
56010 68000 IRA Central Exisiting
 56009
66000 66000
CD
Westside
Exisiting
ACCOUNT .NO 56001 56002 56003 56004 56005
AMOUNT 50000 52000 54000 56000 58000
ACCT TYPE Saving Checking CD Saving Checking
BRANCH Central North Country Westside Central North Country
CUSTOMER Exisiting New Exisiting New New

ACCOUNT .NO AMOUNT ACCT TYPE BRANCH CUSTOMER

56002 52000 Checking North Country New
 56006 56007 56008 56009 56010
60000 62000 64000 66000 68000
CD Saving Checking CD IRA
Westside Central North Country Westside Central
Exisiting New New Exisiting Exisiting
 78
67
45 78 90 76 54 78 90 66
60
77
327
78 88 A B AB
89 67 C D CD
66 78 E F EF
56 44 G H GH
45 34
89 90
87 65
56 78
40002
78 65 675
Sales Name Sales Target
Gopal 55 89
Somu 45 89
Soumya 34 89
Rajendra 23 89
Ananda 46 89 100
Raghu 78 89
90
Chiku 60 89
80

70

60

50

40

30

20

10

0
Gopal Somu Soumya Ra
 Target
89

90

89 80

70

60

50

40

30

20

10

0
Somu Soumya Rajendra Ananda Raghu Chiku
 SEMINAR SEAT BOOKING
B B B
B
B B B
B B
B
B B B
B B B B
B
B B
B B B
B B
B B B
B B B
B
OOKING
PENDING 332
BOOKING SEAT 52
B B
B B
B
B B
B
B
B B
B B B B
B

B
B

B B
Employee Code Designation Salary MIS Executive 125000
TCS 1 MIS Executive 45000 Consulant 36000
TCS 2 Consulant 8000 Accounts Executive 67000
TCS 3 Accounts Executive 60000
TCS 4 MIS Executive 7000
TCS 5 Consulant 10000
TCS 6 MIS Executive 5000
TCS 7 Accounts Executive 7000
TCS 8 MIS Executive 8000
TCS 9 Consulant 9000
TCS 10 MIS Executive 50000
TCS 11 Consulant 9000
TCS 12 MIS Executive 10000

Employee Code
TCS 1 #REF!
MIS Executive
36000
 Date Transction Type Debit/Credit Amount Debit
2/11/2023 Online Debit 5000 Online 8500
2/12/2023 Cash Credit 2000 Cash 500
2/13/2023 Debit Card Debit 3000 Debit Card 9500
2/14/2023 Online Credit 7000
2/15/2023 Cash Credit 9000
2/16/2023 Debit Card Debit 6500
2/17/2023 Cash Credit 4500
2/18/2023 Online Debit 3500
2/19/2023 Debit Card Credit 2000
2/20/2023 Cash Debit 500
2/21/2023 Online Credit 1000

Date Transction Type Debit/Credit Amount Date Transction Type

2/14/2023 Online Credit 7000 2/15/2023 Cash
Credit
8000
15500
2000

Debit Credit
Online 8500 8000
Cash 500 15500
Debit Card 9500 2000

Debit/Credit Amount
Credit 9000
 Date Transction Type Debit/Credit Amount
2/11/2023 Online Debit 5000 Online 4 Online
2/12/2023 Cash Credit 2000 Cash 4 Cash
2/13/2023 Debit Card Debit 3000 Debit Card 3 Debit Card
2/14/2023 Online Credit 7000
2/15/2023 Cash Credit 9000
2/16/2023 Debit Card Debit 6500
2/17/2023 Cash Credit 4500
2/18/2023 Online Debit 3500
2/19/2023 Debit Card Credit 2000
2/20/2023 Cash Debit 500
2/21/2023 Online Credit 1000
4
4
3
 Date Transction Type Debit/Credit Amount Debit Credit
2/11/2023 Online Debit 5000 Online 2 2
2/12/2023 Cash Credit 2000 Cash 1 3
2/13/2023 Debit Card Debit 3000 Debit Card 2 1
2/14/2023 Online Credit 7000
2/15/2023 Cash Credit 9000
2/16/2023 Debit Card Debit 6500
2/17/2023 Cash Credit 4500
2/18/2023 Online Debit 3500
2/19/2023 Debit Card Credit 2000
2/20/2023 Cash Debit 500
2/21/2023 Online Credit 1000
 Debit Credit
Online 2 2
Cash 1 3
Debit Card 2 1
Salesman ID Salesman Product Zone Sales
10051 Gopal Swain Computer West City 56
10052 Nanrendra Behera Mouse South City 65
10053 Rajendra Parida Moniter North City 89
10054 Ananda Parida CPU South City 90
10055 Raghu Jena Computer North City 45
10056 Chiku Behera CPU West City 34 Salesman ID
10057 Somu Jena Moniter West City 23 Salesman
10058 Soumya Das Keyboard North City 77 Product
10059 Rakesha Jena Headphone South City 70 Zone
Sales
Salesman ID Salesman Product Zone Sales
10053 Rajendra Parida Moniter North City 89

10055
Raghu Jena
Computer
North City
45
Salesman ID Salesman Product Zone Sales Performance Area Code
10051 Gopal Swain Computer West City 56 Average 754035
10052 Nanrendra Behera Mouse South City 65 Good 754030
10053 Rajendra Parida Moniter North City 89 Best 754050
10054 Ananda Parida CPU South City 90 Best 754030
10055 Raghu Jena Computer North City 45 Average 754050
10056 Chiku Behera CPU West City 34 Poor 754035
10057 Somu Jena Moniter West City 23 Poor 754035
10058 Soumya Das Keyboard North City 77 Good 754050
10059 Rakesha Jena Headphone South City 70 Good 754030
Target Performance
0 Poor
35 Average
60 Good
80 Best

Zone Area Code

West City 754035
South City 754030
North City 754050
Salesman ID Salesman Product Zone Sales Salesman ID
10051 Gopal Swain Computer West City 56 10051
10052 Nanrendra Behera Mouse South City 65
10053 Rajendra Parida Moniter North City 89
10054 Ananda Parida CPU South City 90
10055 Raghu Jena Computer North City 45
10056 Chiku Behera CPU West City 34
10057 Somu Jena Moniter West City 23
10058 Soumya Das Keyboard North City 77
10059 Rakesha Jena Headphone South City 70
 Salesman Product Zone Sales
Gopal Swain Computer West City 56
Salesman ID Product ID Product ID Salesman
100956 TCS1001 TCS1001 Gopal Swain
100957 TCS1002 TCS1002 Nanrendra Behera
100958 TCS1003 TCS1003 Rajendra Parida
100959 TCS1004 TCS1004 Ananda Parida
100960 TCS1005 TCS1005 Raghu Jena
100961 TCS1006 TCS1006 Chiku Behera
100962 TCS1007 TCS1007 Somu Jena
100963 TCS1008 TCS1008 Soumya Das
100964 TCS1009 TCS1009 Rakesha Jena

Salesman ID Salesman
100960 Raghu Jena

Salesman ID Salesman
100957 Nanrendra Behera

Salesman ID 100961
Salesman Chiku Behera
Product CPU
Zone West City
Sales 34
 Product Zone Sales
Computer West City 56
Mouse South City 65
Moniter North City 89
CPU South City 90
Computer North City 45
CPU West City 34
Moniter West City 23
Keyboard North City 77
Headphone South City 70

Product Zone Sales

Computer North City 45

Product Zone Sales

Mouse South City 65
 B B B B B B B B B B B

BOOKING STATUS B
B B
B
B
B
B
B B B B B

B B B B
B B B B B B B
TOTAL 450 B B B B B B B
B B B
BOOKING 268 B B B

REMAINING 182
B
B
B
B
B
B
B
B
B
B B
B
B
B
B
STAGE
B B B B
B B B B B B
B B B B B B
B B B B B
B B B B B
B B B B B B B B
B B B B B B B B
B B B B B
B B B B B
B B B B B B B B B B B
B B B B B B B B B B B
 B B B B B B B B B B B
B B B B B B B B B B B
B B B
B B B
B B B B B
B B B B B B B B B B B
B B B
B B B

STAGE B
B
B
B
B
B
B
B
B
B
B
B
B B B 227
B B B B B B B
B B B B B B B
B B B B
B B B
B B B B B
B B B B B B B B B B B
B B B B B
B B B
B B B B B B B B B B B
B B B B B B B B B B B
 Date Transction Type Debit/Credit Amount
2/11/2023 Online Debit 5000 4000
2/12/2023 Cash Credit 2000
2/13/2023 Debit Card Debit 3000
2/14/2023 Online Credit 7000
2/15/2023 Cash Credit 9000
2/16/2023 Debit Card Debit 6500
2/17/2023 Cash Credit 4500
2/18/2023 Online Debit 3500
2/19/2023 Debit Card Credit 2000
2/20/2023 Cash Debit 500
2/21/2023 Online Credit 1000
TOTAL Debit Credit
Online 4250 4000
Cash 500 5166.667
Debit Card 4750 2000
 DATE ITEM NAME QTY RATE
2/19/2003 CABINET 90 700
2/14/2003 CPU 40 8000
2/15/2003 HEAD PHONE 45 499
2/12/2003 KEYBOARD 25 500
2/17/2003 LCD 77 1500
2/16/2003 LED 66 3000
2/13/2003 MONITER 35 2000
2/11/2003 MOUSE 15 300
2/20/2003 PENDRIVE 66 250
2/18/2003 RAM 80 400
TOTAL 854455
3/30/2025
DATE EMP NAME DESG BASIC SALARY BONOUS
2/11/2023 Gopal Swain MANAGER 50000 5000
2/12/2023 Asit Swain SUPERVISOR 30000 2500
2/13/2023 Nanrendra Behera PEON 10000 1000
2/14/2023 Rajendra Parida CLERK 20000 500
2/15/2023 Ananda Parida MANAGER 50000 5000
2/16/2023 Raghu Jena CLERK 20000 500
2/17/2023 Chiku Behera PEON 10000 1000
2/18/2023 Somu Jena SUPERVISOR 30000 2500
2/19/2023 Soumya Das CLERK 20000 500
2/20/2023 Rakesha Jena CLERK 20000 500
MANAGER 5000
SUPERVISOR 2500
PEON 1000
CLERK 500
PRODUCT ID BILL NO SALES MAN PRODUCT ZONE SALES
1231 LM-001 Gopal Swain CABINET SOUTH CITY 56
1232 LM-002 Asit Swain CPU NORTH CITY 67
1233 LM-003 Nanrendra Behera HEAD PHONE WEST CITY 45
1234 LM-004 Rajendra Parida KEYBOARD SOUTH CITY 34
1235 LM-005 Ananda Parida LCD NORTH CITY 23
1236 LM-006 Raghu Jena LED WEST CITY 87
1237 LM-007 Chiku Behera MONITER WEST CITY 65
1238 LM-008 Somu Jena MOUSE NORTH CITY 90
1239 LM-009 Soumya Das PENDRIVE SOUTH CITY 67
1240 LM-010 Rakesha Jena RAM WEST CITY 77

PRODUCT ID PRODUCT ID
1231 1231
1232 1232
1233 1233
1234 1234
1235 1235
1236 1236
1237 1237
 PRODUCT ID PRODUCT ID
1238 1236

SALES MAN
SALES MAN Somu Jena PRODUCT
PRODUCT MOUSE ZONE
ZONE NORTH CITY SALES
SALES 90

1231
1232
1233
1234
1235
1236
1237
BILL NO PRODUCT QTY BILL NO PRODUCT QTY
1001 CABINET 20 1011 CABINET 35
1002 CPU 25 1012 CPU 45
1003 HEAD PHONE 30 1013 HEAD PHONE 55
1004 KEYBOARD 35 1014 KEYBOARD 65
1005 LCD 40 1015 LCD 75
1006 LED 45 1016 LED 85
1007 MONITER 50 1017 MONITER 95
1008 MOUSE 55 1018 MOUSE 105
1009 PENDRIVE 60 1019 PENDRIVE 115
1010 RAM 65 1020 RAM 125

BILL NO 1029
PRODUCT PENDRIVE
QTY 28
BILL NO PRODUCT QTY 1001
1021 CABINET 12 1002
1022 CPU 14 1003
1023 HEAD PHONE 16 1004
1024 KEYBOARD 18 1005
1025 LCD 20 1006
1026 LED 22 1007
1027 MONITER 24 1008
1028 MOUSE 26 1009
1029 PENDRIVE 28 1010
1030 RAM 30 1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
BILL NO PRODUCT QTY ZONE
1001 CABINET 20 SOUTH CITY
1002 CPU 25 NORTH CITY
1003 HEAD PHONE 30 WEST CITY
1004 KEYBOARD 35 SOUTH CITY
1005 LCD 40 NORTH CITY
1006 LED 45 WEST CITY
1007 MONITER 50 WEST CITY
1008 MOUSE 55 NORTH CITY
1009 PENDRIVE 60 SOUTH CITY
1010 RAM 65 WEST CITY
BILL NO PRODUCT
1001 CABINET
1002 CPU
1003 HEAD PHONE
1004 KEYBOARD
1005 LCD
1006 LED
1007 MONITER
1008 MOUSE
1009 PENDRIVE
1010 RAM
BILL NO QTY
1001 20
1002 25
1003 30
1004 35
1005 40
1006 45
1007 50
1008 55
1009 60
1010 65
BILL NO ZONE
1001 SOUTH CITY
1002 NORTH CITY
1003 WEST CITY
1004 SOUTH CITY
1005 NORTH CITY
1006 WEST CITY
1007 WEST CITY
1008 NORTH CITY
1009 SOUTH CITY
1010 WEST CITY
 Vlookup on Multiple Workbook
Bill No. Product Quantity
1001 Keyboard 45
1002 LCD 35
1003 Mouse 25
1004 Mouse 34
1005 Headphone 56
1006 Pendrive 78
1007 HDD 90
Company Name Location
Reliance Co. Mumbai
Tata Co. Delhi
Ganesh Pvt. LTD Pune
Raj Infotech Nagapur
Sachin Traders Chenai
Adani Group Pune
Sanghani Brothers Surat
Vishal Motors Delhi
 Salesman Product Zone Sales Product ID
Gopal Swain CABINET SOUTH CITY 56 LM-001 Product ID
Asit Swain CPU NORTH CITY 67 LM-002 Salesman
Nanrendra Behera HEAD PHONE WEST CITY 45 LM-003 Product
Rajendra Parida KEYBOARD SOUTH CITY 34 LM-004 Zone
Ananda Parida LCD NORTH CITY 23 LM-005 Sales
Raghu Jena LED WEST CITY 87 LM-006
Chiku Behera MONITER WEST CITY 65 LM-007
Somu Jena MOUSE NORTH CITY 90 LM-008
Soumya Das PENDRIVE SOUTH CITY 67 LM-009
Rakesha Jena RAM WEST CITY 77 LM-010
 INDEX & MATCH
LM-003
Nanrendra Behera
HEAD PHONE
WEST CITY
45
 Name Roll No DOB Blood [Link]
Gopal Swain BA21-115 11/21/2003 +B 9807564789
Asit Swain BA21-116 1/1/2003 +A 8907564785
Narendra Behera BA21-117 6/2/2003 -A 9087699549
Rajendra Parida BA21-118 5/9/2002 +O 8790654321
Ananda Parida BA21-119 3/15/2004 +B 7689054326
Raghu Jena BA21-120 3/16/2000 -A 7890654321
Chiku Behera BA21-121 7/4/2006 +B 7890654321
Somu Jena BA21-122 8/30/2005 +A 7896548905
Soumya Das BA21-123 8/9/2000 -A 8907658907
Rakesha Jena BA21-124 7/8/2000 +O 7789906664

Name Rajendra Parida

Roll No BA21-118
DOB 5/9/2002
Blood +O
[Link] 8790654321
MONTHS SALES TAX EXPENSE PROFIT
JAN 1500 1500 1400 1300
FEB 7000 6700 7000 5600 MONTHS SALES TAX
MAR 4300 50000 670 560 JAN 1500 1500
APR 450 800 4500 3400 FEB 7000 6700
MAY 2300 1300 1200 1500 MAR 4300 50000
JUN 3400 780 560 670 APR 450 800
MAY 2300 1300
JUN 3400 780
EXPENSE PROFIT
1400 1300
7000 5600
670 560
4500 3400
1200 1500
560 670
 MY LIVE SUPPORT(P) LTD
VOUCHER NO.1 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.2 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.3 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.4 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

 VOUCHER NO.5 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.6 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.7 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.8 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.9 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.10 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.11 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.12 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.13 Date:
DATE PARTICULAR DEBIT CREDIT
 TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.14 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain

MY LIVE SUPPORT(P) LTD

VOUCHER NO.15 Date:
DATE PARTICULAR DEBIT CREDIT

TOTAL(Rs)
Prepared By: Gopal Swain
AADHAAR No. AADHAAR No.
#FMT 4478 9076 5432
#FMT 4478 9076 5433
#FMT 4478 9076 5434
#FMT 4478 9076 5435
#FMT 4478 9076 5436
#FMT 4478 9076 5437
#FMT 4478 9076 5438
#FMT 4478 9076 5439
#FMT 4478 9076 5440
#FMT 4478 9076 5441
#FMT 4478 9076 5442
#FMT 4478 9076 5443
#FMT 4478 9076 5444
#FMT 4478 9076 5445
Month Targeted Sale Actual Sale
Apr-17 55757 Pending
May-17 435466 68868
Jun-17
Jul-17 4546664 657677
Aug-17
Sep-17 46654646
Oct-17 6556656
Nov-17 465654
Dec-17
Jan-18 46655464 66656
Feb-18
Mar-18 466666 656556
Apr-18 4665656
Name Sub 1 Sub 2 Sub 3 Sub 4 Sub 5 Sub 6 Average
Gopal Swain 22 99 69 69 65 44 61.33333
Jitu Behera 56 90 67 89 45 45 65.33333
Ananda Parida 22 45 67 89 67 21 51.83333
Rajendra Parida 23 34 56 78 44 32 44.5
Chiku Behera 20 23 33 45 32 67 36.66667
Rakesha Jena 55 89 33 22 11 89 49.83333
Debashis Behera 22 20 25 20 17 30 22.33333
Raghu Jena 23 56 44 33 22 78 42.66667
Bikash Jena 33 45 67 88 99 89 70.16667
Bikash Nayak 32 45 67 89 33 33 49.83333
Banty Behera 30 27 28 22 20 56 30.5
 Party Name Amount Gst Total Amount
1 Ambey Agency 9656906 68868 89868
Bgs Enterprises 7854745 675656 56565656
Rama Agency 45565 66 6676
Ambey Agency 655656 667 676767
Bgs Enterprises 565656 766676 667667
Rama Agency 676766 6676 6666
Ambey Agency 6666 66678 67887
Bgs Enterprises 5467676 56677878 898988
Rama Agency 67677676 8788989 898898
Total 92607312 67052154 59879073