Sheet Index

Sr. No. Sheet Name

1 Student Data
2 Horizontal Entry
3 Pivot
4 Sales Detail
5 Formula
6 Forcasting
7 What if analysis
8 Hlookup
9 Vlookup
10 And & OR
11 Sparklines
12 Salary Slip
13 Dynamic Chats
14 Day Wise Wages Calculation
15 Sheet 2
 Student Data File
Name Father's Name Date Contact Number Address
Alisha Kumar Dr Ajay Kumar 5/7/2024 +91 4321098765 567, HIJ Road, Hyderabad
Diya Kumar Dr Amit Kumar ### +91 4321098765 567, HIJ Road, Hyderabad
Diya Verma Dr Amit Verma 7/2/2024 +91 2109876543 345, UVW Colony, Jaipur
Priya Gupta Dr Anand Gupta ### +91 8765432109 456, XYZ Road, Mumbai
Lata Patel Dr Anand Patel 7/8/2024 +91 5432109876 234, EFG Lane, Bangalore
Aman Singh Dr Anil Singh 5/8/2024 +91 3210987654 890, STU Street, Pune
Ankit Singh Dr Anil Singh ### +91 7654321098 789, PQR Colony, Kolkata
Isha Yadav Dr Anil Yadav ### +91 1098765432 678, WXY Avenue, Lucknow
Tanvi Verma Dr Anoop Verma ### +91 6543210987 987, LMN Avenue, Chennai
Devansh Sharma Dr Anuj Sharma 7/1/2024 +91 3210987654 890, STU Street, Pune
Devansh Verma Dr Anuj Verma ### +91 5432109876 234, EFG Lane, Bangalore
Rohan Kumar Dr Ashish Kumar 6/2/2024 +91 5432109876 234, EFG Lane, Bangalore
Vivaan Patel Dr Ashok Patel ### +91 3210987654 890, STU Street, Pune
Amrita Sharma Dr Ashok Sharma 5/9/2024 +91 2109876543 345, UVW Colony, Jaipur
Bhavya Singh Dr Deepak Singh ### +91 7654321098 789, PQR Colony, Kolkata
Bhavya Verma Dr Deepak Verma ### +91 5432109876 234, EFG Lane, Bangalore
Pranav Patel Dr Dinesh Patel ### +91 9876543210 123, ABC Street, Delhi
Pranav Singh Dr Dinesh Singh ### +91 7654321098 789, PQR Colony, Kolkata
Rohan Patel Dr Gopal Patel ### +91 3210987654 890, STU Street, Pune
Aarav Singh Dr Gopal Singh ### +91 7654321098 789, PQR Colony, Kolkata
Udit Sharma Dr Jatin Sharma ### +91 5432109876 234, EFG Lane, Bangalore
Harshita Sharma Dr Kamal Sharma ### +91 2109876543 345, UVW Colony, Jaipur
Kavya Singh Dr Kamal Singh 7/7/2024 +91 6543210987 987, LMN Avenue, Chennai
Shreya Singh Dr Mahendra Singh 6/6/2024 +91 1098765432 678, WXY Avenue, Lucknow
Chetna Patel Dr Mahesh Patel ### +91 6543210987 987, LMN Avenue, Chennai
Chetna Singh Dr Mahesh Singh ### +91 4321098765 567, HIJ Road, Hyderabad
Zoya Singh Dr Manish Singh ### +91 1098765432 678, WXY Avenue, Lucknow
Arnav Gupta Dr Manoj Gupta ### +91 8765432109 456, XYZ Road, Mumbai
Minal Patel Dr Mukesh Patel ### +91 5432109876 234, EFG Lane, Bangalore
Priya Patel Dr Mukesh Patel ### +91 6543210987 987, LMN Avenue, Chennai
Rahul Singh Dr Mukesh Singh ### +91 7654321098 789, PQR Colony, Kolkata
Amrita Singh Dr Mukesh Singh ### +91 9876543210 123, ABC Street, Delhi
Lata Singh Dr Naresh Singh ### +91 7654321098 789, PQR Colony, Kolkata
Harshita Singh Dr Naresh Singh 7/4/2024 +91 9876543210 123, ABC Street, Delhi
Manish Singh Dr Naresh Singh 7/9/2024 +91 4321098765 567, HIJ Road, Hyderabad
Zoya Verma Dr Naresh Verma 8/1/2024 +91 8765432109 456, XYZ Road, Mumbai
Abhinav Verma Dr Nitin Verma ### +91 5432109876 234, EFG Lane, Bangalore
Suman Verma Dr Nitin Verma ### +91 5432109876 234, EFG Lane, Bangalore
Simran Yadav Dr Nitin Yadav 6/7/2024 +91 9876543210 123, ABC Street, Delhi
Suman Kumar Dr Om Kumar 6/9/2024 +91 7654321098 789, PQR Colony, Kolkata
Ananya Gupta Dr Pradeep Gupta ### +91 8765432109 456, XYZ Road, Mumbai
Mohit Patel Dr Pradeep Patel ### +91 2109876543 345, UVW Colony, Jaipur
Nirav Sharma Dr Pradeep Sharma ### +91 2109876543 345, UVW Colony, Jaipur
Sanjay Singh Dr Pradeep Singh ### +91 9876543210 123, ABC Street, Delhi
Ananya Yadav Dr Pradeep Yadav ### +91 1098765432 678, WXY Avenue, Lucknow
Aditi Patel Dr Prakash Patel 5/5/2024 +91 6543210987 987, LMN Avenue, Chennai

Excel Data File

 Student Data File
Udit Patel Dr Prakash Patel ### +91 3210987654 890, STU Street, Pune
Alisha Verma Dr Prakash Verma ### +91 2109876543 345, UVW Colony, Jaipur
Vedant Singh Dr Praveen Singh ### +91 4321098765 567, HIJ Road, Hyderabad
Aditi Singh Dr Rajendra Singh ### +91 4321098765 567, HIJ Road, Hyderabad
Aashi Gupta Dr Rajesh Gupta 5/3/2024 +91 8765432109 456, XYZ Road, Mumbai
Sonali Patel Dr Rajesh Patel 6/8/2024 +91 8765432109 456, XYZ Road, Mumbai
Pooja Verma Dr Rajesh Verma ### +91 8765432109 456, XYZ Road, Mumbai
Gaurav Singh Dr Rajiv Singh ### +91 3210987654 890, STU Street, Pune
Jatin Verma Dr Rajiv Verma 7/6/2024 +91 7654321098 789, PQR Colony, Kolkata
Sagarika Sharma Dr Raju Sharma 6/4/2024 +91 3210987654 890, STU Street, Pune
Aahana Sharma Dr Rakesh Sharma ### +91 9876543210 123, ABC Street, Delhi
Ritu Singh Dr Rakesh Singh ### +91 4321098765 567, HIJ Road, Hyderabad
Neha Sharma Dr Ramesh Sharma ### +91 1098765432 678, WXY Avenue, Lucknow
Abhinav Singh Dr Ramesh Singh 5/4/2024 +91 7654321098 789, PQR Colony, Kolkata
Tanvi Singh Dr Ramesh Singh ### +91 4321098765 567, HIJ Road, Hyderabad
Pooja Yadav Dr Ramesh Yadav ### +91 1098765432 678, WXY Avenue, Lucknow
Ankit Patel Dr Ravi Patel ### +91 9876543210 123, ABC Street, Delhi
Arnav Patel Dr Ravi Patel ### +91 6543210987 987, LMN Avenue, Chennai
Sagarika Verma Dr Ravi Verma ### +91 1098765432 678, WXY Avenue, Lucknow
Akash Kumar Dr Sandeep Kumar ### +91 3210987654 890, STU Street, Pune
Shreya Patel Dr Sandeep Patel ### +91 8765432109 456, XYZ Road, Mumbai
Yash Gupta Dr Sanjay Gupta ### +91 2109876543 345, UVW Colony, Jaipur
Nirav Singh Dr Sanjay Singh ### +91 9876543210 123, ABC Street, Delhi
Akash Verma Dr Sanjay Verma 5/6/2024 +91 5432109876 234, EFG Lane, Bangalore
Kavya Gupta Dr Sanjeev Gupta ### +91 8765432109 456, XYZ Road, Mumbai
Sanjay Gupta Dr Sudhir Gupta 6/5/2024 +91 2109876543 345, UVW Colony, Jaipur
Ritu Verma Dr Sunil Verma 6/1/2024 +91 6543210987 987, LMN Avenue, Chennai
Aman Sharma Dr Suresh Sharma ### +91 1098765432 678, WXY Avenue, Lucknow
Neha Singh Dr Suresh Singh ### +91 3210987654 890, STU Street, Pune
Sonali Singh Dr Suresh Singh ### +91 6543210987 987, LMN Avenue, Chennai
Aaradhya Gupta Dr Sushil Gupta ### +91 8765432109 456, XYZ Road, Mumbai
Simran Sharma Dr Sushil Sharma ### +91 7654321098 789, PQR Colony, Kolkata
Saanvi Patel Dr Vijay Patel 6/3/2024 +91 4321098765 567, HIJ Road, Hyderabad
Vedant Verma Dr Vijay Verma ### +91 2109876543 345, UVW Colony, Jaipur
Mohit Kumar Dr Vikas Kumar ### +91 4321098765 567, HIJ Road, Hyderabad
Yash Patel Dr Vikas Patel ### +91 9876543210 123, ABC Street, Delhi
Aarav Sharma Dr Vikram Sharma 5/2/2024 +91 9876543210 123, ABC Street, Delhi
Vivaan Singh Dr Vinay Singh ### +91 1098765432 678, WXY Avenue, Lucknow
Jatin Patel Dr Vinod Patel ### +91 9876543210 123, ABC Street, Delhi
Gaurav Patel Dr Vinod Patel 7/3/2024 +91 1098765432 678, WXY Avenue, Lucknow
Aashi Patel Dr Vishal Patel ### +91 6543210987 987, LMN Avenue, Chennai
Saanvi Singh Dr Vishal Singh ### +91 2109876543 345, UVW Colony, Jaipur
Rahul Verma Dr Vishal Verma ### +91 5432109876 234, EFG Lane, Bangalore
Isha Sharma Dr Vivek Sharma 7/5/2024 +91 8765432109 456, XYZ Road, Mumbai
Manish Verma Dr Vivek Verma ### +91 6543210987 987, LMN Avenue, Chennai
Minal Verma Dr Vivek Verma ### +91 3210987654 890, STU Street, Pune

Excel Data File

 Student Data File
Caste Salary
Brahmin 55000
General 57000
Rajput 64000
OBC 64000
SC 68000
Rajput 58000
Rajput 60000
SC 55000
General 59000
Brahmin 60000
OBC 52000
Rajput 61000
SC 60000
SC 51000
Rajput 48000
OBC 66000
SC 60000
General 63000
OBC 64000
SC 58000
Brahmin 62000
Rajput 52000
Rajput 65000
Brahmin 57000
SC 54000
General 67000
General 61000
Brahmin 59000
SC 56000
Brahmin 66000
General 56000
General 66000
Brahmin 54000
OBC 67000
OBC 67000
Rajput 72000
General 64000
Brahmin 72000
Rajput 60000
OBC 57000
Brahmin 69000
Brahmin 65000
Brahmin 55000
Rajput 71000
OBC 53000
OBC 52000

Excel Data File

 Student Data File
SC 67000
SC 62000
Rajput 65000
Brahmin 67000
Rajput 55000
SC 64000
OBC 70000
Brahmin 61000
Brahmin 61000
OBC 59000
Brahmin 63000
SC 70000
Rajput 68000
SC 48000
Rajput 71000
Rajput 58000
General 56000
SC 63000
Brahmin 70000
Rajput 59000
SC 65000
OBC 64000
SC 69000
General 60000
General 63000
General 63000
Brahmin 58000
OBC 63000
General 62000
General 69000
Rajput 66000
OBC 68000
SC 62000
OBC 70000
OBC 60000
Brahmin 73000
Brahmin 50000
General 74000
OBC 59000
SC 65000
OBC 61000
General 67000
Rajput 69000
General 70000
Rajput 57000
General 62000

Excel Data File

 Welcome to my worksheet Sales Report

Date Month Bill No Product Product Type Amount City District

7-May-21 May 2121 Acer Laptop 13500 Bhopal Sagar
7-May-21 May 1066 Acer Laptop 13000 Bhopal Sehore
25-May-21 May 1099 Acer Laptop 35000 Bhopal Indore
24-Jul-21 July 1152 DELL Laptop 0 Bhopal Dhar
1-May-21 May 1007 Intex Mobile 17000 Bhopal Sagar
2-May-21 May 1018 Intex Mobile 17000 Bhopal Sehore
7-May-21 May 1051 Intex Mobile 0 Bhopal Indore
1-May-21 May 1003 LED Sony TV 24" Television 10000 Bhopal Indore
1-May-21 May 1002 LED Sony TV 32" Television 1100 Bhopal Jabalpur
1-May-21 May 1001 LED TV Sony 42" Television 19000 Bhopal Shivpuri
7-May-21 May 1056 LED TV Sony 42" Television 45000 Bhopal Dhar
1-Jun-21 June 1103 MI Mobile 25000 Bhopal Sagar
9-Jun-21 June 1114 MI Mobile 15000 Bhopal Sehore
24-Jul-21 July 1147 MI Mobile 45000 Bhopal Indore
1-Jun-21 June 1104 POCO Mobile 16000 Bhopal Dhar
24-Jul-21 July 1151 POCO Mobile 35000 Bhopal Sagar
8-Aug-21 August 1162 POCO Mobile 40000 Bhopal Sehore
1-May-21 May 1008 POCO max pro Mobile 13500 Bhopal Dhar
1-Jun-21 June 1100 LED TV Sony 42" Television 19000 Damoh Jabalpur
9-Jun-21 June 1111 LED TV Sony 42" Television 45000 Damoh Morena
1-May-21 May 1004 MI Mobile 25000 Damoh Jabalpur
2-May-21 May 1015 MI Mobile 25000 Damoh Morena
7-May-21 May 1052 POCO Mobile 16000 Damoh Jabalpur
24-Jul-21 July 1148 POCO Mobile 35000 Damoh Jabalpur
1-Aug-21 August 1159 POCO Mobile 13500 Damoh Morena
7-May-21 May 1063 POCO max pro Mobile 10000 Damoh Morena
10-May-21 May 1089 LED TV Sony 42" Television 10000 Gadarwara Sidhi
8-Jul-21 July 1137 POCO Mobile 45000 Gadarwara Sidhi
31-Aug-21 August 1185 POCO Mobile 13000 Gadarwara Sidhi
3-May-21 May 1041 POCO max pro Mobile 17000 Gadarwara Sidhi
1-May-21 May 1011 Acer Laptop 40000 Gwaliar Dhar
10-May-21 May 1077 Acer Laptop 25000 Gwaliar Balaghat
9-Jun-21 June 1110 Acer Laptop 40000 Gwaliar Ujjain
8-Jul-21 July 1132 Acer Laptop 17000 Gwaliar Neemuch
18-Jul-21 July 1143 Acer Laptop 16000 Gwaliar Neemuch
7-May-21 May 1053 DELL Laptop 13000 Gwaliar Rewa
10-May-21 May 1086 DELL Laptop 35000 Gwaliar East Nimar
23-Jun-21 June 1119 DELL Laptop 17000 Gwaliar Morena
18-Jul-21 July 1141 DELL Laptop 10000 Gwaliar Narsimhapur
10-May-21 May 1087 HP Laptop 19000 Gwaliar Neemuch
9-Jun-21 June 1109 HP Laptop 35000 Gwaliar Gwalior
8-Jul-21 July 1131 HP Laptop 13000 Gwaliar Damoh
18-Jul-21 July 1142 HP Laptop 25000 Gwaliar Katni
2-May-21 May 1029 Intex Mobile 13500 Gwaliar Balaghat
7-May-21 May 1062 Intex Mobile 15000 Gwaliar Ujjain
10-May-21 May 1084 Intex Mobile 40000 Gwaliar Neemuch
10-May-21 May 1095 Intex Mobile 45000 Gwaliar Neemuch
3-May-21 May 1039 LAVA Mobile 16000 Gwaliar Neemuch
7-May-21 May 1061 LAVA Mobile 19000 Gwaliar Gwalior
10-May-21 May 1083 LAVA Mobile 35000 Gwaliar Damoh

Sales Data
 Welcome to my worksheet Sales Report

Date Month Bill No Product Product Type Amount City District

10-May-21 May 1094 LAVA Mobile 13500 Gwaliar Katni
24-Jul-21 July 1149 LAVA Mobile 40000 Gwaliar Rewa
2-May-21 May 1014 LED Sony TV 24" Television 10000 Gwaliar Ujjain
3-May-21 May 1036 LED Sony TV 24" Television 15000 Gwaliar Neemuch
3-May-21 May 1047 LED Sony TV 24" Television 35000 Gwaliar Neemuch
8-Jul-21 July 1135 LED Sony TV 24" Television 35000 Gwaliar Neemuch
1-Aug-21 August 1157 LED Sony TV 24" Television 13000 Gwaliar Gwalior
20-Aug-21 August 1173 LED Sony TV 24" Television 25000 Gwaliar Balaghat
27-Aug-21 August 1183 LED Sony TV 24" Television 25000 Gwaliar Neemuch
2-May-21 May 1013 LED Sony TV 32" Television 15000 Gwaliar Gwalior
3-May-21 May 1035 LED Sony TV 32" Television 19000 Gwaliar Damoh
3-May-21 May 1046 LED Sony TV 32" Television 45000 Gwaliar Katni
1-Jun-21 June 1101 LED Sony TV 32" Television 15000 Gwaliar Rewa
8-Jul-21 July 1134 LED Sony TV 32" Television 45000 Gwaliar East Nimar
14-Aug-21 August 1167 LED Sony TV 32" Television 10000 Gwaliar Morena
27-Aug-21 August 1182 LED Sony TV 32" Television 10000 Gwaliar East Nimar
2-May-21 May 1023 LED TV Sony 42" Television 15000 Gwaliar Morena
3-May-21 May 1045 LED TV Sony 42" Television 40000 Gwaliar Narsimhapur
10-May-21 May 1078 LED TV Sony 42" Television 16000 Gwaliar Neemuch
1-Aug-21 August 1155 LED TV Sony 42" Television 25000 Gwaliar Dhar
31-Aug-21 August 1191 LED TV Sony 42" Television 15000 Gwaliar Neemuch
7-May-21 May 1059 MI Mobile 45000 Gwaliar Dhar
1-Jul-21 July 1125 MI Mobile 35000 Gwaliar Balaghat
1-Aug-21 August 1158 MI Mobile 17000 Gwaliar Ujjain
20-Aug-21 August 1174 MI Mobile 16000 Gwaliar Neemuch
27-Aug-21 August 1179 MI Mobile 16000 Gwaliar Damoh
31-Aug-21 August 1189 MI Mobile 16000 Gwaliar Narsimhapur
1-May-21 May 1005 POCO Mobile 16000 Gwaliar Rewa
2-May-21 May 1030 POCO Mobile 45000 Gwaliar Neemuch
3-May-21 May 1038 POCO Mobile 25000 Gwaliar East Nimar
10-May-21 May 1071 POCO Mobile 40000 Gwaliar Morena
9-Jun-21 June 1107 POCO Mobile 13500 Gwaliar Dhar
1-Jul-21 July 1126 POCO Mobile 19000 Gwaliar Neemuch
27-Aug-21 August 1180 POCO Mobile 13000 Gwaliar Neemuch
31-Aug-21 August 1190 POCO Mobile 13000 Gwaliar Katni
10-May-21 May 1093 POCO max pro Mobile 17000 Gwaliar Narsimhapur
3-May-21 May 1044 Acer Laptop 35000 Indore East Nimar
31-Aug-21 August 1188 LED Sony TV 24" Television 25000 Indore East Nimar
10-May-21 May 1092 MI Mobile 13000 Indore East Nimar
8-Jul-21 July 1140 POCO Mobile 15000 Indore East Nimar
3-May-21 May 1033 Acer Laptop 45000 Katni Sehore
2-May-21 May 1020 DELL Laptop 45000 Katni Damoh
9-Jun-21 June 1108 DELL Laptop 45000 Katni Chhindwara
8-Aug-21 August 1163 DELL Laptop 45000 Katni Vidisha
3-May-21 May 1032 HP Laptop 40000 Katni East Nimar
7-May-21 May 1054 HP Laptop 17000 Katni Rewa
8-Aug-21 August 1164 HP Laptop 35000 Katni Damoh
1-Jul-21 July 1128 Intex Mobile 10000 Katni East Nimar
24-Jul-21 July 1150 Intex Mobile 45000 Katni Rewa
1-May-21 May 1006 LAVA Mobile 13000 Katni Rewa

Sales Data
 Welcome to my worksheet Sales Report

Date Month Bill No Product Product Type Amount City District

23-Jun-21 June 1116 LAVA Mobile 25000 Katni Damoh
10-May-21 May 1080 LED Sony TV 24" Television 17000 Katni East Nimar
1-Jun-21 June 1102 LED Sony TV 24" Television 10000 Katni Rewa
7-May-21 May 1068 LED Sony TV 32" Television 13500 Katni Damoh
1-Aug-21 August 1156 LED Sony TV 32" Television 16000 Katni Chhindwara
27-Aug-21 August 1177 LED Sony TV 32" Television 10000 Katni Sehore
1-May-21 May 1012 LED TV Sony 42" Television 19000 Katni Chhindwara
7-May-21 May 1067 LED TV Sony 42" Television 17000 Katni Vidisha
27-Aug-21 August 1176 LED TV Sony 42" Television 15000 Katni East Nimar
10-May-21 May 1081 MI Mobile 13500 Katni Sehore
7-May-21 May 1060 POCO Mobile 35000 Katni Chhindwara
23-Jun-21 June 1115 POCO Mobile 10000 Katni Vidisha
1-Jul-21 July 1129 POCO Mobile 25000 Katni Sehore
2-May-21 May 1019 POCO max pro Mobile 13500 Katni Vidisha
23-Jun-21 June 1121 Acer Laptop 45000 Panna Bhind
1-May-21 May 1009 DELL Laptop 45000 Panna Rewa
3-May-21 May 1031 DELL Laptop 35000 Panna Mandla
3-May-21 May 1042 DELL Laptop 13500 Panna East Nimar
25-May-21 May 1097 DELL Laptop 40000 Panna East Nimar
10-May-21 May 1076 HP Laptop 10000 Panna Ratlam
24-Jul-21 July 1153 HP Laptop 15000 Panna Rewa
10-May-21 May 1073 Intex Mobile 35000 Panna Bhind
2-May-21 May 1028 LAVA Mobile 17000 Panna Ratlam
1-Jun-21 June 1105 LAVA Mobile 13000 Panna Rewa
1-Jul-21 July 1127 LAVA Mobile 15000 Panna Mandla
8-Jul-21 July 1138 LAVA Mobile 35000 Panna East Nimar
2-May-21 May 1025 LED Sony TV 24" Television 25000 Panna Bhind
1-Jul-21 July 1124 LED Sony TV 24" Television 45000 Panna Ratlam
7-May-21 May 1057 LED Sony TV 32" Television 35000 Panna Rewa
10-May-21 May 1090 LED Sony TV 32" Television 25000 Panna East Nimar
10-May-21 May 1079 LED Sony TV 32" Television 13000 Panna Mandla
18-Jul-21 July 1145 LED Sony TV 32" Television 17000 Panna East Nimar
20-Aug-21 August 1172 LED Sony TV 32" Television 10000 Panna Ratlam
31-Aug-21 August 1186 LED TV Sony 42" Television 15000 Panna East Nimar
14-Aug-21 August 1169 MI Mobile 16000 Panna Bhind
3-May-21 May 1049 POCO Mobile 15000 Panna East Nimar
20-Aug-21 August 1175 POCO Mobile 13000 Panna Mandla
2-May-21 May 1022 Acer Laptop 19000 Ratlam Barwani
1-Aug-21 August 1154 Acer Laptop 10000 Ratlam Satna
1-May-21 May 1010 HP Laptop 35000 Ratlam Satna
9-Jun-21 June 1106 Intex Mobile 17000 Ratlam Satna
7-May-21 May 1058 LED Sony TV 24" Television 40000 Ratlam Satna
8-Aug-21 August 1166 LED TV Sony 42" Television 15000 Ratlam Barwani
7-May-21 May 1070 MI Mobile 35000 Ratlam Barwani
23-Jun-21 June 1118 POCO Mobile 13000 Ratlam Barwani
7-May-21 May 1064 DELL Laptop 25000 Rewa Harda
7-May-21 May 1065 HP Laptop 16000 Rewa Umaria
8-Aug-21 August 1161 Intex Mobile 35000 Rewa Umaria
2-May-21 May 1017 LAVA Mobile 13000 Rewa Umaria
1-Aug-21 August 1160 LAVA Mobile 45000 Rewa Harda

Sales Data
 Welcome to my worksheet Sales Report

Date Month Bill No Product Product Type Amount City District

9-Jun-21 June 1113 LED Sony TV 24" Television 19000 Rewa Umaria
9-Jun-21 June 1112 LED Sony TV 32" Television 35000 Rewa Harda
23-Jun-21 June 1122 LED TV Sony 42" Television 35000 Rewa Dhar
2-May-21 May 1026 MI Mobile 16000 Rewa Dhar
2-May-21 May 1016 POCO Mobile 16000 Rewa Harda
10-May-21 May 1074 POCO Mobile 19000 Rewa Dhar
14-Aug-21 August 1170 POCO Mobile 13000 Rewa Dhar
25-May-21 May 1098 HP Laptop 45000 Sagar Satna
3-May-21 May 1050 LAVA Mobile 10000 Sagar Satna
18-Jul-21 July 1146 LED Sony TV 24" Television 13500 Sagar Satna
18-Jul-21 July 1144 LED TV Sony 42" Television 13000 Sagar Bhind
3-May-21 May 1048 MI Mobile 19000 Sagar Bhind
25-May-21 May 1096 POCO Mobile 35000 Sagar Bhind
10-May-21 May 1088 Acer Laptop 15000 Ujjain Damoh
8-Aug-21 August 1165 Acer Laptop 19000 Ujjain Singrauli
10-May-21 May 1075 DELL Laptop 15000 Ujjain Seoni
1-Jul-21 July 1130 DELL Laptop 16000 Ujjain East Nimar
2-May-21 May 1021 HP Laptop 35000 Ujjain Singrauli
3-May-21 May 1043 HP Laptop 45000 Ujjain Jabalpur
23-Jun-21 June 1120 HP Laptop 13500 Ujjain Betul
3-May-21 May 1040 Intex Mobile 13000 Ujjain Damoh
23-Jun-21 June 1117 Intex Mobile 16000 Ujjain Singrauli
8-Jul-21 July 1139 Intex Mobile 19000 Ujjain Jabalpur
10-May-21 May 1072 LAVA Mobile 0 Ujjain Betul
7-May-21 May 1069 LED Sony TV 24" Television 45000 Ujjain Singrauli
10-May-21 May 1091 LED Sony TV 24" Television 16000 Ujjain Jabalpur
14-Aug-21 August 1168 LED Sony TV 24" Television 25000 Ujjain Betul
27-Aug-21 August 1178 LED Sony TV 24" Television 25000 Ujjain East Nimar
2-May-21 May 1024 LED Sony TV 32" Television 10000 Ujjain Betul
23-Jun-21 June 1123 LED Sony TV 32" Television 40000 Ujjain Seoni
31-Aug-21 August 1187 LED Sony TV 32" Television 10000 Ujjain Jabalpur
3-May-21 May 1034 LED TV Sony 42" Television 35000 Ujjain East Nimar
8-Jul-21 July 1133 LED TV Sony 42" Television 13500 Ujjain Guna
20-Aug-21 August 1171 LED TV Sony 42" Television 15000 Ujjain Seoni
27-Aug-21 August 1181 LED TV Sony 42" Television 15000 Ujjain Guna
3-May-21 May 1037 MI Mobile 15000 Ujjain Guna
8-Jul-21 July 1136 MI Mobile 40000 Ujjain Damoh
27-Aug-21 August 1184 MI Mobile 6200 Ujjain Damoh
2-May-21 May 1027 POCO Mobile 45006 Ujjain Seoni
10-May-21 May 1085 POCO Mobile 45000 Ujjain Guna
10-May-21 May 1082 POCO Mobile 45000 Ujjain East Nimar

Sales Data
Timeline Values Forecast Lower Confidence Bound Upper Confidence Bound 1000
1/1/2023 200 900
2/1/2023 300
800
3/1/2023 500
700
4/1/2023 100
5/1/2023 900 900 900.00 900.00 600
6/1/2023 400 400 400 500
7/1/2023 600 600 600 400
8/1/2023 450 450 450 300
9/1/2023 650 650 650
200
10/1/2023 500 500 500
100
11/1/2023 700 700 700
12/1/2023 550 550 550 0
1/1/2023 3/1/202
1000
900
800
700
600
500
400
300
200
100
0
1/1/2023 3/1/2023 5/1/2023 7/1/2023 9/1/2023 11/1/2023

Values Forecast
Lower Confidence Bound Upper Confidence Bound
 Page 12 of 74 Student Data

Student ID AC1001 AC1002

Name AKASH CHAKRAVARTI AMAN JAIN
Conatct Number +91 9125658977 +91 8602147531
Email ID akashchakravarti@gmail.com amanjain24372@gmail.com
Qualification B.Com 12th Pass
Sem/ Year V Sem 1st Year
Address (Location) Pandey Chowk Pandey Chowk
Receipts No 103 104
Caste SC GEN
Amount 15000 15000
1st installment 5000 5000
2nd installment 5000 5000
3rd installment 5000 5000
Remaining fees 5000 414
Remaining Fees2 PAID PAID
Types Installment Installment
Fees Status Paid Paid
Fees status 2 0 0
Status Paid Paid

12 74 01/03/202505:18:37file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 13 of 74 Student Data

AC1003 AC1004 AC1005

ANIKET VISHWAKARMA ANJALI YADAV ANSHU SAHU
+91 9340079715 +91 975596590 +91 83055995700
aniket3132000vishwakarma@gmail.com harshita97.sahy@gmail.com sahuansh1999@gmail.com
BSc BSc B.A
B.Com (1st Year) VI Sem 2nd Year
Ghamapur (Jbp) Patan Bargi
106 107 108
ST OBC SC
15000 15000 15000
5000 5000
5000 5000
5000 5000 5000
100 0 10000
PAID PAID Installment due 210000
Installment Installment Lumsum
Paid Paid Due Fees
0 0 2
Paid Paid Due

13 74 01/03/202505:18:37file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 14 of 74 Student Data

AC1006 AC1007 AC1008 AC1009

ARADHANA SAHU ARPANA KUSHWAHA ARPITA AGARWAL ASHISH CHOUBEY
+91 9309321457 +91 9111923325 +91 9717454589 +91 9717454585
aradhana2234@gmail.com arpanahrt@gmail.com arpitaagarwalk@gmail.com sarnav549@gmail.com
M.A BSc BSc B.A
1st Year Final year 1st Year VI Sem
Ranjhi Gwarighat Jabalpur Umariya
109 110 111 112
GEN ST OBC SC
15000 15000 15000 15000
5000 5000 5000 5000
4500 500
5000 5000 5000
5000 5000 500 9500
Installment due 15000 Installment due 15000 PAID Installment due 15000
Lumsum Lumsum Installment Installment
Due Fees Due Fees Paid Due Fees
1 1 0 1
Due Due Paid Due

14 74 01/03/202505:18:37file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 15 of 74 Student Data

AC1010 AC1011 AC1012 AC1013

ASHISH KUMAR JHORIYA ASHISH MISHRA AVUSH RAJORIA B GYANSINGH LODHI
+91 7610245177 +91 9755520760 +91 7999730689 +91 62609867420
ashishkumar83774@gmail.com ashisg345@gmail.com avush.rajoria@gmail.com lodhigyansingh@gmail.com
B.Com ITI 12th B.Com
VI Sem VI Sem Pass Pass
Hanumanpuri Rewa 583 Kotwali Dhanpuri
113 114 115 116
GEN ST OBC SC
15000 15000 15000 15000
5000 5000 5000 5000
6000 7000 6000 3000
4000 1000 10500
0 3000 3000 -3500
PAID Installment due 15000 PAID PAID
Installment Installment Installment Installment
Paid Due Fees Paid Paid
0 1 0 0
Paid Due Paid Paid

15 74 01/03/202505:18:37file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 16 of 74 Student Data

AC1014 AC1015 AC1016 AC1017

BRIJENDRA SHRIVAS DEEPAK PATEL DEEPAK TAIMUR DEVENDRA KUMAR MARKAM
+91 7999766245 +91 9993893366 +91 8602412587 +91 7697641314
brijendrea@gmail.com deepak345@gmail.com deepaktaimur@gmail.com markdeo254@gmail.com
BSc B.Com B.B.A BSc
PCM Final year Final year Final year
Ahadhartaal Jabalpur Beyohaar Bagh Gokalpur
117 118 119 120
GEN ST OBC SC
15000 15000 15000 15000
5000 5000 5000 5000
3000 1900 12000 12000
1000
6000 8100 -2000 -2000
PAID Installment due 15000 Installment due 15000 Installment due 15000
Installment Installment Installment Installment
Paid Due Fees Due Fees Due Fees
0 1 1 1
Paid Due Due Due

16 74 01/03/202505:18:37file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 17 of 74 Student Data

AC1018 AC1019 AC1020 AC1021

GAURAV SINGH THAKUR GYANENDRA KUMAR SHRMA HARISH SINGH RAJPUT HARSHITA SAHU
+91 8982878312 +91 9209857545 +91 8319288562 +91 917475234
harshita797.sahu@gmail.com gyanendrasharma@gmail.com sawrnav809@gmail.com harshita02.sahu@gmail.com
B.Com BSc B.A BSc
Vth Sem B.A 1st Year 1st Year
South Civil Lines Rampur (Satna) M.P MKB Hostel Garha (Jbp)
121 122 123 124
GEN ST OBC SC
15000 15000 15000 15000
9000 700 5800
14000 900 6000
1000 1100 6000 1000
0 4000 8300 2200
Installment due 15000 PAID Installment due 15000 PAID
Installment Installment Installment Installment
Due Fees Paid Due Fees Paid
1 0 1 0
Due Paid Due Paid

17 74 01/03/202505:18:37file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 18 of 74 Student Data

AC1022 AC1023 AC1024 AC1025

HIRENDRA DHURVEY LOKMAN KULASHTE MADDHU SINGH MAHINEE ORNOL
+91 9171743361 +91 9111562949 +91 7142458898 +91 9754346088
hirendradhurvey1916@gmail.com lok98@gmail.com madhusingh@gmail.com mohinee@gmail.com
B.Com B.Com 12th Pass B.A
2nd Year First Year Pass Iv Sem
South Civil Lines Seoni Manikpur Beyohaar Bagh
125 126 127 128
GEN ST OBC SC
15000 15000 15000 15000
800 600 3000 400
1000 1800 1500
5000 5000 3000
8200 7600 7500 14600
PAID PAID PAID Installment due 210000
Installment Installment Installment Installment
Paid Paid Paid Due Fees
0 0 0 2
Paid Paid Paid Due

18 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 19 of 74 Student Data

AC1026 AC1027 AC1028 AC1029

MAHITI PARORIYA MANGAL SINGH RAJPUT MUSKAN VISHWAKARMA NAVEEN SHAREY
+91 9754414022 +91 9755662669 +91 7723833289 +91 8602875823
mahngit@gmail.com vikramsinghthakur578@gmail.com harshitaq97.sahu@gmail.com harshita97.sahu@gmail.com
B.Com 12th Pass B.Com B.Com
VI Sem 1st Year 1st Year 1st Year
Hanuantaal Shastri Vihar Colony Vinod Nagar Forest Compound
129 130 131 132
GEN ST OBC SC
15000 15000 15000 15000
4000 6000 1800 15000
1500 1500 1500
3000 3000 3000
6500 4500 8700 0
PAID PAID PAID Installment due 210000
Installment Installment Installment lumsam
Paid Paid Paid Due Fees
0 0 0 2
Paid Paid Paid Due

19 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 20 of 74 Student Data

AC1030 AC1031 AC1032 AC1033

NITISH KUMAR PALLAVI VERMA POOJA CHAUBEY POONAM SONI
+91 9300118273 +91 8109979662 +91 8103760606 +91 8223814109
rajneesh@gmail.com harshita197.sahu@gmail.com harshiwta97.sahu@gmail.com harshita97.saahu@gmail.com
B.Com B.Com MBA (MM) M.A
Ist Year 1st Year 1st Year II Sem
Patan South Civil Lines Hanumaan Taal Ghamapur (Jbp)
133 134 135 136
GEN ST OBC SC
15000 15000 15000 15000
4500 600 900 10000
5000 1400 1500 1650
1000 11000 7500 1200
4500 2000 5100 2150
PAID PAID PAID PAID
Installment Installment Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

20 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 21 of 74 Student Data

AC1034 AC1035 AC1036

POONAMVATI DHARUWALI PRABHA PATEL PRASHANT PANDEY
+91 7845123569 +91 9575504722 +91 7812865489
poonamwai@gmail.com prabhapatel2131@gmail.com pandeyprashat4251@gmail.com
B.A B.A BSc
Final year V Sem Pass
Garha (Jbp) Garha (Jbp) Kanchghar Chowk
137 138 139
GEN ST OBC
15000 15000 15000
1500 7000 5000
1260 3000 5000
1900 5000 5000
10340 0 0
PAID PAID PAID
Installment Installment Installment
Paid Paid Paid
0 0 0
Paid Paid Paid

21 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 22 of 74 Student Data

AC1037 AC1038 AC1039 AC1040

PRIYANKA SINGH VANSH JANIN VANSHIKA SHARMA PRIYANK SINGH
+91 7869020644 +91 932990475 +91 9329765773 +91 7855896977
priyankasingh39784@gmail.com harshita97.sahw@gmail.com harshita97.sahu@gmail.com rajthakur@gmail.com
B.B.A BSc BSc B.Com
2nd Year 1st Year 6th Sem III Sem
Jabalpur Gohalpur Thane Garha (Jbp) Civil ines
140 101 102 141
SC GEN ST GEN
15000 15000 15000 15000
4800 4000 3000 1560
1500 3500 2500 1472
3000 500 4000 8500
5700 7000 5500 3468
PAID PAID PAID PAID
Installment Installment Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

22 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 23 of 74 Student Data

AC1041 AC1042 AC1043 AC1044

RAJIV KHUSWAHA RAM ANUSAAR RASHMI BHUMIYA RESHMA BARMAN
+91 9823093939 +91 8871458579 +91 9753245878 +91 9897456896
amanjain244121@gmail.com rashmityt12@gmail.com rashmityt@gmail.com reshman215@gmail.com
B.B.A BSc BSc Graduate
Vth Sem 2nd Year First Year Graduate
South Civil Lines Jabalpur Bheraghat Bilahri
142 143 144 145
GEN GEN OBC OBC
15000 15000 15000 15000
5500 3000 1750 6000
2500 3500 6900 3000
2590 1500 186 -2000
4410 7000 6164 8000
PAID PAID PAID PAID
Installment Installment Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

23 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 24 of 74 Student Data

AC1045 AC1046 AC1047 AC1048

RHIT SHUKLA RITESH KANUJIA ROHIT KUMAR VISHWAKARMA] RUBI SHASTRI
+91 9398568787 +91 7509494277 +91 8822868419 +91 9039950579
rohiutshukla@gmail.com satyamnamdeo.22@gmail.com rohitkumar081@gmail.com amanjain24375@gmail.com
BBA B.Com (C.A) B.A B. Com
Final year 5th Sem 1st Year 1st Year
Civil ines Forest Compound Karmundi, Ranjhi South Civil Lines
146 147 148 149
GEN OBC OBC OBC
15000 15000 15000 15000
5900 1200 6500 6000
3600 4500 3500 5000
1400 9000 -1500 13500
4100 300 6500 -9500
PAID PAID PAID PAID
Installment Installment Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

24 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 25 of 74 Student Data

AC1049 AC1050 AC1051 AC1052

RUPESH SINDHIYA SAGAR NAMDEO SANDEEP PATIL SANUP JAMWANTI
+91 8871862544 +91 9144428655 +91 7223000812 +91 9826535897
rupeshgyt@gmail.com sagar7899@gmail.com harshita97.sahu@gmail.com sahnupjam@gmail.com
12th Pass B.Com B.Com B.A
pass 2nd Year 1st Year II year
Ghamapur (Jbp) Barela Patan Gwarighat
150 151 152 153
OBC OBC - OBC
15000 15000 15000 15000
3000 7000 1200 18500
5000 4000 1900 15500
1000 1700 1400 1580
6000 2300 10500 -20580
PAID PAID PAID PAID
Installment Installment Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

25 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 26 of 74 Student Data

AC1053 AC1054 AC1055 AC1056

SATYAM NAMDEO SATYAM PANDEY SAURAV GUPTA SHAKTI RAIKWAR
+91 8602808770 +91 8545778112 +91 9329958144 +91 7413262564
satyamnamdeo.22@gmail.com satyamcompuers@gmail.com sauravv@gmail.com amanjain24561@gmail.com
BSc B.Com B.Com (C.A)
Iv Sem III Sem III Sem 1st Year
Jabalpur Gwarighat Nandgaon South Civil Lines
154 155 156 157
OBC OBC GEN GEN
15000 15000 15000 15000
7500 1590 19000 8000
4500 3570 16000 5000
2000 9000 11000 0
1000 840 -31000 2000
PAID PAID PAID PAID
Installment Installment Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

26 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 27 of 74 Student Data

AC1057 AC1058 AC1059 AC1060

SHILPI SAHU SHIVANI NAMDEO SHIVANI PASTE SHIVKUMAR PATL
+91 8827893955 +91 7489530123 +91 9171299083 +91 9758245888
shrutishau@gmail.com Shivang@gmail.com sarnav878@gmail.com shivkumarshat@gmail.com
BBA BSc B.A BBA
1st Year V Sem 1st Year Final year
Sanjay Gandhi Nagar Panagar Sheetlamai Jbp Sihpor
158 159 160 161
OBC OBC OBC OBC
15000 15000 15000 15000
1500 15000 8500 4500
1200 0 5500 1000
7000 0 500 5000
5300 0 500 4500
PAID PAID PAID PAID
Installment lumsum Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

27 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 28 of 74 Student Data

AC1061 AC1062 AC1063 AC1064

SHOBHANA SONI SHRISSHTI SHUKLA SHUBHAM PATEL SHWETA MASHEWARI
+91 8518833651 +91 7845122365 +91 8305277775 +91 9698547897
harshita977.sahu@gmail.com lalmattisidhbabarpad@gmail.com shubhamngs@gmail.com Shweta234@gmail.com
M.A BBA B.A BBA
IV Sem Final year 1st Year
South Civil Lines Lal Matti Sudama Nagar South Civil Lines
162 163 164 165
OBC GEN OBC GEN
15000 15000 15000 15000
7800 900 900 900
1300 6000 6000 6000
6000 1000 1000 1000
-100 7100 7100 7100
PAID PAID PAID PAID
Installment Installment Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

28 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 29 of 74 Student Data

AC1065 AC1066 AC1067 AC1068

SUBHASH GAUTAM SUJATA SHARMA SWATI SAXENA SWATI SINGH
+91 7999795496 +91 88712558906 +91 9981426198 +91 9131116868
subashgautam@gmail.com harshita01.sahu@gmail.com swati.saxena@gmail.com singhswati2356@gmail.com
BSc M.Com B.Com (C.A) BBA
1st Year 3rd Year 2nd Year IInd Year
Boondiwali Gali Bargi Kanchghar (Jbp) Jabalpur
166 167 168 169
GEN GEN GEN GEN
15000 15000 15000 15000
900 900 900 900
6500 4500 4500 4500
1500 8700 6000 2000
6100 900 3600 7600
PAID PAID PAID PAID
Installment Installment Installment Installment
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

29 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 30 of 74 Student Data

AC1069 AC1070 AC1071 AC1072

UMESH KUMAR CHAUDHARY VAISHALI VERTHE VASU JAIN VEERDAS PARATSE
+91 9182352658 +91 8269845716 +91 9933666210 +91 789702939
umc@gmail.com amanjain24376@gmail.com vasujain@gmail.com sarnaasv809@gmail.com
12 Base B.A B.A B.com BA
2nd Year 1st Year Final year 1st Year
Kanchghar (Jbp) VidyaSagar Ward Civil ines Central Jail
170 171 172 173
SC OBC OBC ST
15000 15000 15000 15000
900 6200 200 15000
4500 4500 4500 0
1400 -3500 1400 0
8200 7800 8900 0
PAID PAID PAID PAID
Installment Installment Installment Lumsum
Paid Paid Paid Paid
0 0 0 0
Paid Paid Paid Paid

30 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Page 31 of 74 Student Data

AC1073 AC1074
VINOD KUMAR PASTE VIRMAL NARTI
+91 9753255214 +91 9009800328
paste7077@gmail.com veermalanareti21@gmail.com
B.A Graduate
1st Year 1st Year
Kanchghar (Jbp) MKB Hostel
174 175
ST ST
15000 15000
6000 1200
4500 4500
-2000 -6600
6500 15900
PAID PAID
Installment Installment
Paid Paid
0 0
Paid Paid

31 74 01/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsxHorizontal Entry
 Norm
Student ID AC1001 AC1002 AC1003 AC1004
Name AKASH CHAKRAVARTI AMAN JAIN ANIKET VISHWAKA ANJALI YADAV
Conatct Number 9125658977 8602147531 9340079715 975596590
Email ID akashchakravarti@gmail.com amanjain24372@gm aniket3132000vis harshita97.sahy@g
Qualification B.Com 12th Pass BSc BSc
Sem/ Year V Sem 1st Year B.Com (1st Year) VI Sem
Address (Location) Pandey Chowk Pandey Chowk Ghamapur (Jbp) Patan
Receipts No 103 104 106 107
Caste SC GEN ST OBC
Amount 15000 15000 15000 15000

Hlooku
Student ID AC1001 AC1002 AC1003 AC1004
Name
Conatct Number
Email ID
Qualification
Sem/ Year
Address (Location)
Receipts No
Caste
Amount
 Normal Hlookup
AC1005 AC1006 AC1007 AC1008 AC1009
ANSHU SAHU ARADHANA SAHU ARPANA KUSHWAHARPITA AGARWAL ASHISH CHOUBEY
83055995700 9309321457 9111923325 9717454589 9717454585
sahuansh1999@gma aradhana2234@gma arpanahrt@gmail.carpitaagarwalk@gmsarnav549@gmail.
B.A M.A BSc BSc B.A
2nd Year 1st Year Final year 1st Year VI Sem
Bargi Ranjhi Gwarighat Jabalpur Umariya
108 109 110 111 112
SC GEN ST OBC SC
15000 15000 15000 15000 15000

Hlookup With Match

AC1005 AC1006 AC1007 AC1008 AC1009
AC1010
ASHISH KUMAR JHORIYA
7610245177
ashishkumar83774@gmail.com
B.Com
VI Sem
Hanumanpuri
113
GEN
15000

AC1010
 Salary Budget Plan
S.No Exp Amount Types
1 Basic Pay 17892 Changing Cell
2 Dearness Allowance 1000 Fixed
3 Servant Allowance 1000 Variable
4 Madical Allowance 1000 Fixed
5 House rent Allowance 1500 Variable
6 Standrad Deduction 1000
Total Salary 21392
36 74 01/03/2025

A B C D E F G
1 Serial No: Name Contact Number Email ID Qualification Sem/ Year Address (Location)
2 1 VIRMAL NARTI 9009800328 veermalanareti21@gmail.com BCOM 2nd Year MKB Hostel
3 2 VINOD KUMAR PASTE 9753255214 paste7077@gmail.com MSC 3rd Year Kanchghar (Jbp)
4 3 VEERDAS PARATSE 789702939 sarnaasv809@gmail.com BCOM 3rd Year Central Jail
5 4 VASU JAIN 9933666210 vasujain@gmail.com BCOM 1st Year Civil ines
6 5 VANSHIKA SHARMA 9329765773 harshita97.sahu@gmail.com MSC 2nd Year Garha (Jbp)
7 6 VANSH JANIN 932990475 harshita97.sahw@gmail.com BCOM 3rd Year Gohalpur Thane
8 7 VAISHALI VERTHE 8269845716 amanjain24376@gmail.com BCOM 3rd Year VidyaSagar Ward
9 8 UMESH KUMAR CHAUDHARY 9182352658 umc@gmail.com MSC 1st Year Kanchghar (Jbp)
10 9 SWATI SINGH 9131116868 singhswati2356@gmail.com BCOM 2nd Year Jabalpur
11 10 SWATI SAXENA 9981426198 swati.saxena@gmail.com BCOM 3rd Year Kanchghar (Jbp)
12 11 SUJATA SHARMA 88712558906 harshita01.sahu@gmail.com MSC 3rd Year Bargi
13 12 SUBHASH GAUTAM 7999795496 subashgautam@gmail.com BCOM 1st Year Boondiwali Gali
14 13 SHWETA MASHEWARI 9698547897 Shweta234@gmail.com BCOM 2nd Year South Civil Lines
15 14 SHUBHAM PATEL 8305277775 shubhamngs@gmail.com MSC 3rd Year Sudama Nagar
16 15 SHRISSHTI SHUKLA 7845122365 lalmattisidhbabarpad@gmail.com BCOM 3rd Year Lal Matti
17 16 SHOBHANA SONI 8518833651 harshita977.sahu@gmail.com BCOM 1st Year South Civil Lines
18 17 SHIVKUMAR PATL 9758245888 shivkumarshat@gmail.com MSC 2nd Year Sihpor
19 18 SHIVANI PASTE 9171299083 sarnav878@gmail.com BCOM 3rd Year Sheetlamai Jbp
20 19 SHIVANI NAMDEO 7489530123 Shivang@gmail.com BCOM 3rd Year Panagar
21 20 SHILPI SAHU 8827893955 shrutishau@gmail.com MSC 1st Year Sanjay Gandhi Nagar
22 21 SHAKTI RAIKWAR 7413262564 amanjain24561@gmail.com BCOM 2nd Year South Civil Lines
23 22 SAURAV GUPTA 9329958144 sauravv@gmail.com BCOM 3rd Year Nandgaon
24 23 SATYAM PANDEY 8545778112 satyamcompuers@gmail.com MSC 3rd Year Gwarighat
25 24 SATYAM NAMDEO 8602808770 satyamnamdeo.22@gmail.com BCOM 1st Year Jabalpur
26 25 SANUP JAMWANTI 9826535897 sahnupjam@gmail.com BCOM 2nd Year Gwarighat
27 26 SANDEEP PATIL 7223000812 harshita97.sahu@gmail.com MSC 3rd Year Patan
28 27 SAGAR NAMDEO 9144428655 sagar7899@gmail.com BCOM 3rd Year Barela
29 28 RUPESH SINDHIYA 8871862544 rupeshgyt@gmail.com BCOM 1st Year Ghamapur (Jbp)
30 29 RUBI SHASTRI 9039950579 amanjain24375@gmail.com MSC 2nd Year South Civil Lines
31 30 ROHIT KUMAR VISHWAKARMA] 8822868419 rohitkumar081@gmail.com BCOM 3rd Year Karmundi, Ranjhi
32 31 RITESH KANUJIA 7509494277 satyamnamdeo.22@gmail.com BCOM 3rd Year Forest Compound
33 32 RHIT SHUKLA 9398568787 rohiutshukla@gmail.com MSC 1st Year Civil ines
34 33 RESHMA BARMAN 9897456896 reshman215@gmail.com BCOM 2nd Year Bilahri
35 34 RASHMI BHUMIYA 9753245878 rashmityt@gmail.com BCOM 3rd Year Bheraghat
36 35 RAM ANUSAAR 8871458579 rashmityt12@gmail.com MSC 3rd Year Jabalpur
37 36 RAJIV KHUSWAHA 9823093939 amanjain244121@gmail.com BCOM 1st Year South Civil Lines
38 37 PRIYANKA SINGH 7869020644 priyankasingh39784@gmail.com BCOM 2nd Year Jabalpur
39 38 PRIYANK SINGH 7855896977 rajthakur@gmail.com MSC 3rd Year Civil ines
40 39 PRASHANT PANDEY 7812865489 pandeyprashat4251@gmail.com BCOM 3rd Year Kanchghar Chowk
41 40 PRABHA PATEL 9575504722 prabhapatel2131@gmail.com BCOM 1st Year Garha (Jbp)
42 41 POONAMVATI DHARUWALI 7845123569 poonamwai@gmail.com MSC 2nd Year Garha (Jbp)
43 42 POONAM SONI 8223814109 harshita97.saahu@gmail.com BCOM 3rd Year Ghamapur (Jbp)
44 43 POOJA CHAUBEY 8103760606 harshiwta97.sahu@gmail.com BCOM 3rd Year Hanumaan Taal
45 44 PALLAVI VERMA 8109979662 harshita197.sahu@gmail.com MSC 1st Year South Civil Lines
46 45 NITISH KUMAR 9300118273 rajneesh@gmail.com BCOM 2nd Year Patan
47 46 NAVEEN SHAREY 8602875823 harshita97.sahu@gmail.com BCOM 3rd Year Forest Compound
48 47 MUSKAN VISHWAKARMA 7723833289 harshitaq97.sahu@gmail.com MSC 3rd Year Vinod Nagar
49 48 MANGAL SINGH RAJPUT 9755662669 vikramsinghthakur578@gmail.com BCOM 1st Year Shastri Vihar Colony
50 49 MAHITI PARORIYA 9754414022 mahngit@gmail.com BCOM 2nd Year Hanuantaal
51 50 MAHINEE ORNOL 9754346088 mohinee@gmail.com MSC 3rd Year Beyohaar Bagh
52 51 MADDHU SINGH 7142458898 madhusingh@gmail.com BCOM 3rd Year Manikpur
53 52 LOKMAN KULASHTE 9111562949 lok98@gmail.com BCOM 1st Year Seoni
54 53 HIRENDRA DHURVEY 9171743361 hirendradhurvey1916@gmail.com MSC 2nd Year South Civil Lines
55 54 HARISH SINGH RAJPUT 8319288562 sawrnav809@gmail.com BCOM 3rd Year MKB Hostel
56 55 GYANENDRA KUMAR SHRMA 9209857545 gyanendrasharma@gmail.com BCOM 3rd Year Rampur (Satna) M.P
57 56 GAURAV SINGH THAKUR 8982878312 harshita797.sahu@gmail.com MSC 1st Year South Civil Lines
58 57 DEVENDRA KUMAR MARKAM 7697641314 markdeo254@gmail.com BCOM 2nd Year Gokalpur
59 58 DEEPAK TAIMUR 8602412587 deepaktaimur@gmail.com BCOM 3rd Year Beyohaar Bagh
60 59 DEEPAK PATEL 9993893366 deepak345@gmail.com MSC 3rd Year Jabalpur
61 60 BRIJENDRA SHRIVAS 7999766245 brijendrea@gmail.com BCOM 1st Year Ahadhartaal
62 61 B GYANSINGH LODHI 62609867420 lodhigyansingh@gmail.com BCOM 2nd Year Dhanpuri
63 62 AVUSH RAJORIA 7999730689 avush.rajoria@gmail.com MSC 3rd Year 583 Kotwali
64 63 ASHISH MISHRA 9755520760 ashisg345@gmail.com BCOM 3rd Year Rewa
65 64 ASHISH KUMAR JHORIYA 7610245177 ashishkumar83774@gmail.com BCOM 1st Year Hanumanpuri
66 65 ASHISH CHOUBEY 9717454585 sarnav549@gmail.com MSC 2nd Year Umariya
67 66 ARPITA AGARWAL 9717454589 arpitaagarwalk@gmail.com BCOM 3rd Year Jabalpur
68 67 ARPANA KUSHWAHA 9111923325 arpanahrt@gmail.com BCOM 3rd Year Gwarighat
69 68 ARADHANA SAHU 9309321457 aradhana2234@gmail.com MSC 1st Year Ranjhi
70 69 ARADHANA SAHU 917475234 harshita02.sahu@gmail.com BCOM 2nd Year Garha (Jbp)
71 70 ANSHU SAHU 83055995700 sahuansh1999@gmail.com BCOM 3rd Year Bargi
72 71 ANJALI YADAV 975596590 harshita97.sahy@gmail.com MSC 3rd Year Patan
73 72 ANIKET VISHWAKARMA 9340079715 aniket3132000vishwakarma@gmail.com BCOM 1st Year Ghamapur (Jbp)
74 73 AMAN JAIN 8602147531 amanjain24372@gmail.com BCOM 2nd Year Pandey Chowk
75 74 AKASH CHAKRAVARTI 9125658977 akashchakravarti@gmail.com MSC 3rd Year Balaghat
76
77 1234567890
37 74 01/03/2025

H I J K L M N O P Q R
1 Receipts No Caste Amount 1st installment 2nd installment 3rd installment Remaining fees Remaining Fees2 Types Fees Status Fees status 2
2 175 ST 15000 1200 4500 6600
3 174 ST 15000 6000 4500 2000
4 173 ST 15000 15000 0 0
5 172 OBC 15000 200 4500 1400
6 102 ST 15000 3000 2500 4000
7 101 GEN 15000 4000 3500 500
8 171 OBC 15000 6200 4500 3500
9 170 SC 15000 900 4500 1400
10 169 GEN 15000 900 4500 2000
11 168 GEN 15000 900 4500 6000
12 167 GEN 15000 900 4500 8700
13 166 GEN 15000 900 6500 1500
14 165 GEN 15000 900 6000 1000
15 164 OBC 15000 900 6000 1000
16 163 GEN 15000 900 6000 1000
17 162 OBC 15000 7800 1300 6000
18 161 OBC 15000 4500 1000 5000
19 160 OBC 15000 8500 5500 500
20 159 OBC 15000 15000 0 0
21 158 OBC 15000 1500 1200 7000
22 157 GEN 15000 8000 5000 0
23 156 GEN 15000 19000 16000 11000
24 155 OBC 15000 1590 3570 9000
25 154 OBC 15000 7500 4500 2000
26 153 OBC 15000 18500 15500 1580
27 152 - 15000 1200 1900 1400
28 151 OBC 15000 7000 4000 1700
29 150 OBC 15000 3000 5000 1000
30 149 OBC 15000 6000 5000 13500
31 148 OBC 15000 6500 3500 1500
32 147 OBC 15000 1200 4500 9000
33 146 GEN 15000 5900 3600 1400
34 145 OBC 15000 6000 3000 2000
35 144 OBC 15000 1750 6900 186
36 143 GEN 15000 3000 3500 1500
37 142 GEN 15000 5500 2500 2590
38 140 SC 15000 4800 1500 3000
39 141 GEN 15000 1560 1472 8500
40 139 OBC 15000 5000 5000 5000
41 138 ST 15000 7000 3000 5000
42 137 GEN 15000 1500 1260 1900
43 136 SC 15000 10000 1650 1200
44 135 OBC 15000 900 1500 7500
45 134 ST 15000 600 1400 11000
46 133 GEN 15000 4500 5000 1000
47 132 SC 15000 15000
48 131 OBC 15000 1800 1500 3000
49 130 ST 15000 6000 1500 3000
50 129 GEN 15000 4000 1500 3000
51 128 SC 15000 400
52 127 OBC 15000 3000 1500 3000
53 126 ST 15000 600 1800 5000
54 125 GEN 15000 800 1000 5000
55 123 OBC 15000 700 6000
56 122 ST 15000 9000 900 1100
57 121 GEN 15000 14000 1000
58 120 SC 15000 5000 12000
59 119 OBC 15000 5000 12000
60 118 ST 15000 5000 1900
61 117 GEN 15000 5000 3000 1000
62 116 SC 15000 5000 3000 10500
63 115 OBC 15000 5000 6000 1000
64 114 ST 15000 5000 7000
65 113 GEN 15000 5000 6000 4000
66 112 SC 15000 5000 500
67 111 OBC 15000 5000 4500 5000
68 110 ST 15000 5000 5000
69 109 GEN 15000 5000 5000
70 124 SC 15000 5800 6000 1000
71 108 SC 15000 5000
72 107 OBC 15000 5000 5000 5000
73 106 ST 15000 5000 5000 5000
74 104 GEN 15000 5000 5000 5000
75 103 SC 15000 5000 5000 5000
76
77
38 74 01/03/2025

S
1 Status
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
 Vloo
Name Contact Email ID
Akash Chakravarti 9125658977 akashchakravarti@gmail.com
Aman Jain 8602147531 amanjain24372@gmail.com
Aniket Vishwakarma 9340079715 aniket3132000vishwakarma@gmail.com
B Gyansingh Lodhi 62609867420 lodhigyansingh@gmail.com
Brijendra Shrivas 7999766245 brijendrea@gmail.com
Deepak Patel 9993893366 deepak345@gmail.com
Deepak Taimur 8602412587 deepaktaimur@gmail.com
Devendra Kumar Markam 7697641314 markdeo254@gmail.com

Vlookup + Choose(Reverse V
Conatct Number Name Email ID
9717454589 3rd Year
8602147531
9340079715
9755520760
7999730689
9309321457
9111923325
9717454589

Vlookup + Match
7610245177 contact number Qualification
POONAM SONI 8223814109
POONAMVATI DHARUWALI 7845123569
PRABHA PATEL 9575504722
PRASHANT PANDEY 7812865489
PRIYANKA SINGH 7869020644
VANSH JANIN 932990475
VANSHIKA SHARMA 9329765773
PRIYANK SINGH 7855896977

Index + Match
Conatct Number contact number Qualification
9717454589 Err:502
9309321457
9717454589
9755520760
7999730689
7999766245

VLOOKUP+MATCH
Lookup Value Qualification
VAISHALI VERTHE
 Vlookup
Qualification Sem/ Year Address (LocatReceipts N Caste Amount
MSC 3rd Year Balaghat 103 SC 15000
BCOM 2nd Year Pandey Chowk 104 GEN 15000
BCOM 1st Year Ghamapur (Jbp 106 ST 15000
BCOM 2nd Year Dhanpuri 116 SC 15000
BCOM 1st Year Ahadhartaal 117 GEN 15000
MSC 3rd Year Jabalpur 118 ST 15000
BCOM 3rd Year Beyohaar Bagh 119 OBC 15000
BCOM 2nd Year Gokalpur 120 SC 15000
13

ose(Reverse Vlookup) 8

Sem/ Year Address (Location) 2nd installment

kup + Match
Sem/ Year Sem/ Year Caste Amount 1st installment 2nd installment

h
1st installment 2nd installment 9309321457
UP+MATCH
1st installment 2nd installment 3rd installment RemainiTypes Rank
9125658977

3rd installment Remaining Fees Types

3rd installment Remaining Fees Types

 834123161.xlsx7401/03/202505:18:38file:///conversion/tmp/activity_task_scratch/834123161.xlsx
834123161.xlsxSparklines

S.No Product Q 1st Q 2nd Q 3rd Q 4th

1 LED TV Soni 42" 5000 -1 500 10000

2 LED Soni TV 32" 1200 -1 7800 9630

3 LED Soni TV 24" 1590 7896 4561 1236

4 MI 7890 4560 3000 9000

5 POCO 9630 1472 3654 1562

6 LAVA 3214 2587 3698 1478

7 Index 3210 6540 6987 9874

8 POCO max pro 5 1479 8 1587

SANGEO
MURLI SIR
APAAR
 IF,AND,OR
If Product Sales >10000 If Product Sales >15000
Product Sales OR Sales Quantity >5 AND Sales Quantity >15
Sr No.
Sales Quantity Discount=10% Discount=30%
1 15000.1 16 1500.01 4500.03
2 90000 5 9000 No Discount
3 5000 18 500 No Discount
4 30000 20 3000 9000
5 10001 3 1000.1 No Discount
6 35000 16 3500 10500

nested

TRUE
And & OR
If Sales >=20000 Disc=30%
Sales>=15000 Disc=20%
Sales>=10000 Disc=10%
3000.02
27000
No Discount
9000
1000.1
10500
 517401/03/2025file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsx

10 Students Dat
S.no Contact No Valid Invalid NAME G.K Hindi English Maths S.S.T
1 9755662669 1 Mangal singh rajpoot 95 55 55 90 55
2 7247808558 Maddhu Singh Maddhu singh 55 75 0 44 74
3 9755120760 Ashish Mishra 84 57 89 78 72
4 8962938432 Samar Sharma 78 63 58 22 27
5 9713737891 Sandhya Aiyan 47 55 12 74 23
6 9827618345 Sourabh Ahirwar 29 55 55 36
7 8269717210 rahul ahirwar 50 45 45 62 51
8 9301182731 Ashish Mishra 45 58 88 85 48
9 9993293366 Deepedh Patel 65 54 45 45 65
10 9389575592 Rohit shukla 13 63 12 65 94
11 9329958144 Shourab Gupta 75 25 45 86 72
13 9111562949 Lokman Kuluste 78 57 72 60
14 9399780040 Surendra Kumar 94 62 84 42 43
15 7509103851 Bhanu pratap singh 54 50 83 52 12
16 9399182415 Rupendra kumar nandu 78 36 68 45
17 8103904262 Vikas singh chouhan 75.5 35 74 64 89
18 7974010359 Neeraj Rathor 29 37 67 69 43
19 9407860750 nikesh mehra 37 49 66 63 72

Salary Increment Criteria

HR Sales Marketing
17.50% 20% 10%

Name DeparSalary Increment

Adhrit HR 49260 8744
Siddharth HR 68765
Nishant Market 78691
Kapil Sales 76435
Lashika Sales 41523
Nishika HR 45959
 527401/03/2025file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsx

tudents Data
SOCIAL SCIENCE Sum min max Average If Trim Len Round RoundUp
100 450 55 100 75
55 divyansh soni divyansh soni 13 123
57 78.29 78
44 78.99 79
75 kbhkjhkj 78
89
23
53
27
99
40
43
96
28
35
75
64
95
 537401/03/2025file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsx

RoundDown Rank Upper Lower Proper Count Counta CountBlank Mid

DIVYANSH SONI Divyansh Soni 6236541230 6541

7 9 6
 547401/03/2025file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsx

left right Now Day Month Year Date Text Index

### Tuesday
6236 1/3/2025
557401/03/2025file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsx

4/6/2024
3:35 PM
4/6/2024
3:36 PM+10
 567401/03/2025file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsx

6/9/2024
###
###
###
4/6/2024 ###
4/7/2024 ###
4/8/2024 ###
4/9/2024 ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### ###
### 7/1/2024
### 7/2/2024
### 7/3/2024
### 7/4/2024
### 7/5/2024
### 7/6/2024
###
5/1/2024
5/2/2024
5/3/2024
5/4/2024
5/5/2024
5/6/2024
5/7/2024
5/8/2024
5/9/2024
###
###
###
###
###
###
###
###
###
 577401/03/2025file:///conversion/tmp/activity_task_scratch/834123161.xlsx834123161.xlsx

###
###
###
###
###
###
###
###
###
###
###
###
###
6/1/2024
6/2/2024
6/3/2024
6/4/2024
6/5/2024
6/6/2024
6/7/2024
6/8/2024
6/9/2024
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
7/1/2024
5/2/2024
 Salary Calculation
Other
Working Gross over time Allowanc
S.No Name Basic Pay Day Leave Total over time amount PF (9%) e
Amit Ahirw 70000 25 0 67307.7 20 53846.15 6300 500
Aniket Vishwakarma
Anjali Yadav
Anshu Sahu
Aradhana Sahu
Arpana Kushwaha
Arpita Agarwal
Ashish Choubey
 Net
Deductio salary
n payable
100 ###
 January February March April May June July
1 LED TV Soni 42" 7800 9600 12500 7890 4580 7860 74845
2 LED Soni TV 32" 4500 8400 7840 6540 7845 99500 7800
3 LED Soni TV 24" 3210 4500 4622 4878 6320 7800 1470
4 MI 6320 4502 7470 9630 5200 1455 6320
5 POCO 4780 6300 4569 3214 6320 1520 6540

Drop down list September

9000
8000
7000
6000 6053
5000
4000
3000
2000
1000
0
LED TV Soni 42" LED Soni TV 32" LED Soni TV 24" MI POCO
 August September October November December MAY
7894 8805 4750 6980 4789 LED TV Soni 42" 4580
4125 6485 1258 7896 4521 LED Soni TV 32" 7845
2540 6301 7840 9654 1478 LED Soni TV 24" 6320
4512 3205 7854 6985 1236 MI 5200
3210 8954 6321 3654 7899 POCO 6320

10 -10
20 30
30 40
40 50
MAY
50 60
Average 60 70
70 80
80 90
90 100

V 24" MI POCO
Average
6053

-11
22
33
44
55
66
77
88
99
 Employee
Employee ID Name Contact Department Adderss 4-Jan-23
E002101 Akash Chakravarti 9369258140 IT Damoh p
E002102 Aman Jain 9369258150 IT Jabalpur p
E002103 Aniket Vishwakarma 9369258160 Finance Katni p
E002104 Anjali Yadav 9369258170 IT Rewa p
E002105 Anshu Sahu 9369258180 Sales Satna p
E002106 Aradhana Sahu 9369258190 IT Damoh p
E002107 Arpana Kushwaha 9369258200 Finance Jabalpur p
E002108 Arpita Agarwal 9369258210 Accounting Katni p
E002109 Ashish Choubey 9369258220 Finance Rewa p
E002110 Ashish Kumar Jhoriya 9369258230 Human Resources Satna a
E002111 Ashish Mishra 9369258240 Engineering Damoh h
E002112 Avush Rajoria 9369258250 Human Resources Jabalpur a
E002113 B Gyansingh Lodhi 9369258260 Finance Katni p
E002114 Brijendra Shrivas 9369258270 Accounting Rewa p
E002115 Deepak Patel 9369258280 Marketing Satna ot
E002116 Deepak Taimur 9369258290 Finance Damoh ot
E002117 Devendra Kumar Markam 9369258300 Marketing Jabalpur p
E002118 Gaurav Singh Thakur 9369258310 IT Katni p
E002119 Gyanendra Kumar Shrma 9369258320 Sales Rewa p
E002120 Harish Singh Rajput 9369258330 IT Satna h
E002121 Harshita Sahu 9369258340 Sales Damoh h
E002122 Hirendra Dhurvey 9369258350 IT Jabalpur h
E002123 Lokman Kulashte 9369258360 Sales Katni a
E002124 Maddhu Singh 9369258370 Sales Rewa a
E002125 Mahinee Ornol 9369258380 Human Resources Satna a
E002126 Mahiti Paroriya 9369258390 Engineering Damoh p
E002127 Mangal Singh Rajput 9369258400 Engineering Jabalpur p
E002128 Muskan Vishwakarma 9369258410 Engineering Katni h
E002129 Naveen Sharey 9369258420 IT Rewa h
E002130 Nitish Kumar 9369258430 IT Satna h
E002131 Pallavi Verma 9369258440 Finance Damoh p
E002132 Pooja Chaubey 9369258450 Sales Jabalpur p
E002133 Poonam Soni 9369258460 Sales Katni p
E002134 Poonamvati Dharuwali 9369258470 Finance Rewa p
E002135 Prabha Patel 9369258480 IT Satna p
E002136 Prashant Pandey 9369258490 Engineering Damoh p
E002137 Priyanka Singh 9369258500 Marketing Jabalpur p
E002138 Vansh Janin 9369258510 IT Katni a
E002139 Vanshika Sharma 9369258520 IT Rewa h
E002140 Priyank Singh 9369258530 Human Resources Satna a
E002141 Rajiv Khuswaha 9369258540 Marketing Damoh p
E002142 Ram Anusaar 9369258550 IT Jabalpur p
E002143 Rashmi Bhumiya 9369258560 Sales Katni ot
E002144 Reshma Barman 9369258570 Marketing Rewa ot
E002145 Rhit Shukla 9369258580 IT Satna p
E002146 Ritesh Kanujia 9369258590 IT Damoh p
E002147 Rohit Kumar Vishwakarm 9369258600 IT Jabalpur p
E002148 Rubi Shastri 9369258610 Engineering Katni h
E002149 Rupesh Sindhiya 9369258620 Engineering Rewa h
E002150 Sagar Namdeo 9369258630 Human Resources Satna h
E002151 Sandeep Patil 9369258640 Marketing Damoh a
E002152 Sanup Jamwanti 9369258650 IT Jabalpur a
E002153 Satyam Namdeo 9369258660 Marketing Katni a
E002154 Satyam Pandey 9369258670 Accounting Rewa p
E002155 Saurav Gupta 9369258680 Engineering Satna p
E002156 Shakti Raikwar 9369258690 Engineering Damoh h
E002157 Shilpi Sahu 9369258700 Engineering Jabalpur h
E002158 Shivani Namdeo 9369258710 Human Resources Katni h
E002159 Shivani Paste 9369258720 Marketing Rewa p
E002160 Shivkumar Patl 9369258730 IT Satna p
E002161 Shobhana Soni 9369258740 Accounting Damoh p
E002162 Shrisshti Shukla 9369258750 Engineering Jabalpur p
E002163 Shubham Patel 9369258760 Human Resources Katni p
E002164 Shweta Mashewari 9369258770 Finance Rewa p
E002165 Subhash Gautam 9369258780 Sales Satna p
E002166 Sujata Sharma 9369258790 Human Resources Damoh a
E002167 Swati Saxena 9369258800 Marketing Jabalpur h
E002168 Swati Singh 9369258810 IT Katni a
E002169 Umesh Kumar Chaudhary 9369258820 IT Rewa p
E002170 Vaishali Verthe 9369258830 Engineering Satna p
E002171 Vasu Jain 9369258840 Finance Damoh ot
E002172 Veerdas Paratse 9369258850 Accounting Jabalpur ot
E002173 Vinod Kumar Paste 9369258860 Engineering Katni p
E002174 Virmal Narti 9369258870 Marketing Rewa p
E002175 Yashwant Singh 9369258880 IT Satna p
 Employee Data
5-Jan-23 6-Jan-23 7-Jan-23 8-Jan-23 9-Jan-23 10-Jan-23 11-Jan-23 12-Jan-23 13-Jan-23
p p p p p p a h a
p p p p p p a h a
a p p ot ot p p p h
p p ot ot p p p h h
p p ot ot p p
 14-Jan-23 15-Jan-23 16-Jan-23 17-Jan-23 18-Jan-23 19-Jan-23 20-Jan-23 21-Jan-23
p p ot ot p p p h
p p ot ot p p p h
h h a a a p p h
h a a a p p h h
 22-Jan-23 23-Jan-23 24-Jan-23 25-Jan-23 26-Jan-23 27-Jan-23 28-Jan-23 29-Jan-23
h h a a a p p h
h h a a a p p h
h h p p p p p p
h p p p p p p p
 30-Jan-23 31-Jan-23 Total Salary
h h 8200
h h 8200
p a 6000
a h 9800
2000
0
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
400
Name Gender Updated Column
Akash Chakravarti nbn No Gender Specified
Aman Jain Male Mr Aman Jain
Amit Ahirwar Male Mr Amit Ahirwar
Aniket Vishwakarma Male Mr Aniket Vishwakarma
Anjali Yadav Female Mrs Anjali Yadav
Anshika Sahu Female Mrs Anshika Sahu
Aradhana Sahu Female Mrs Aradhana Sahu
Arpana Kushwaha Female Mrs Arpana Kushwaha
Arpita Agarwal Female Mrs Arpita Agarwal
Ashish Choubey Male Mr Ashish Choubey
Ashish Kumar Jhoriya Male Mr Ashish Kumar Jhoriya
Ashish Mishra Male Mr Ashish Mishra
Avush Rajoria Male Mr Avush Rajoria
B Gyansingh Lodhi Male Mr B Gyansingh Lodhi
Brijendra Shrivas Male Mr Brijendra Shrivas
Deepak Patel Male Mr Deepak Patel
Deepak Taimur Male Mr Deepak Taimur
Devendra Kumar Markam Male Mr Devendra Kumar Markam
Gaurav Singh Thakur Male Mr Gaurav Singh Thakur
Gyanendra Kumar Shrma Male Mr Gyanendra Kumar Shrma
Harish Singh Rajput Male Mr Harish Singh Rajput
Harshita Sahu Female Mrs Harshita Sahu
Hirendra Dhurvey Male Mr Hirendra Dhurvey
Lokman Kulashte Male Mr Lokman Kulashte
Maddhu Singh Female Mrs Maddhu Singh
Mahinee Ornol Female Mrs Mahinee Ornol
Mahiti Paroriya Female Mrs Mahiti Paroriya
Mangal Singh Rajput Male Mr Mangal Singh Rajput
Muskan Vishwakarma Female Mrs Muskan Vishwakarma
Naveen Sharey Male Mr Naveen Sharey
Nitish Kumar Male Mr Nitish Kumar
Pallavi Verma Female Mrs Pallavi Verma
Pooja Chaubey Female Mrs Pooja Chaubey
Poonam Soni Female Mrs Poonam Soni
Poonamvati Dharuwali Female Mrs Poonamvati Dharuwali
Prabha Patel Female Mrs Prabha Patel
Prashant Pandey Male Mr Prashant Pandey
Priyanka Singh Female Mrs Priyanka Singh
Vansh Janin Male Mr Vansh Janin
Vanshika Sharma Female Mrs Vanshika Sharma
Priyank Singh Male Mr Priyank Singh
Rajiv Khuswaha Male Mr Rajiv Khuswaha
Ram Anusaar Male Mr Ram Anusaar
Rashmi Bhumiya Female Mrs Rashmi Bhumiya
Reshma Barman Female Mrs Reshma Barman
Rhit Shukla Male Mr Rhit Shukla
Ritesh Kanujia Male Mr Ritesh Kanujia
Rohit Kumar Vishwakarma] Male Mr Rohit Kumar Vishwakarma]
Rubi Shastri Female Mrs Rubi Shastri
Rupesh Sindhiya Male Mr Rupesh Sindhiya
Sagar Namdeo Male Mr Sagar Namdeo
Sandeep Patil Male Mr Sandeep Patil
Sanup Jamwanti Male Mr Sanup Jamwanti
Satyam Namdeo Male Mr Satyam Namdeo