Sales
Name January February
Sumit Sharma 254.00 0.00
Manoj Patra 324.00 105.00
Ajit Roy 702.00 197.00
Surajit Sen 220.00 462.00
Robert Peter 723.00 787.00
Sumita Pal 243.00 479.00
Amit Sana 115.00 223.00
Debasish Dey 690.00 364.00
Rahul Singh 2,735.00 507.00
Ansuma Baidya 834.00 230.00
Sukanya Panwar 275.00 360.00
Manoj Lal 631.00 450.00
Parminder Rani 258.00 623.00
Gagandeep Singh Bhamra 623.00 523.00
Parveen Kumar 412.00 452.00
Anita Singh 523.00 152.00
Arun 645.00 250.00
Jeevan Shaw 589.00 620.00
Puspendu Mukherjee 963.00 360.00
Sashikanta Mishra 452.00 458.00
Amit Kumar 125.00 520.00
Khushali Kotak 870.00 1,234.00
Taru Mehta 360.00 456.00
Amit 458.00 258.00
Kapil Chandra Upreti 956.00 266.00
Varsha Tyagi 623.00 120.00
Mudit Kumar Varshney 258.00 563.00
Desh Deepak 963.00 452.00
Mukesh Rawat 1,156.00 458.00
Anil Chauhan 923.00 369.00
Neeraj Upreti 456.00 458.00
Sandip Kumar 741.00 560.00
Harikrishan 256.00 6,578.00
Rajnish Kumar Ranjan 853.00 1,290.00
Renuka Ghai 956.00 396.00
Pooja Ahuja 586.00 458.00
Mudassar Sayed 623.00 256.00
Luman Adhikari 452.00 125.00
Priyanka Tharwal 621.00 623.00
Ajay Kumar Achchhelal Yadav 630.00 458.00
Laxmi Lalgi Jaiswal 845.00 147.00
Jyoti Prasad 850.00 258.00
Gulab Thakur 360.00 263.00
Anita Singh 450.00 369.00
Komal Gupta 286.00 458.00
Gurvinder Singh 654.00 412.00
Rajni Devi 956.00 369.00
Gurdeep Singh 623.00 548.00
Kirti Sudan 156.00 158.00
Shubham Chaplot 258.00 156.00
Rohit Kumar 956.00 623.00
Parvinder Kaur 623.00 620.00
Pardeep Kumar 360.00 258.00
Ankit Mehta 458.00 623.00
Robin Sharma 850.00 589.00
Gulshan Kumar 623.00 163.00
Sidhant Arora 458.00 654.00
Sumit Gupta 956.00 581.00
Manvir Singh 620.00 623.00
Ritika Sharma 369.00 582.00
Rubel 620.00 623.00
Lovedeep Singh 456.00 581.00
Sandeep Kumar 850.00 523.00
Sauren Pramanick 623.00 623.00
Sayed Obaidullah 956.00 589.00
Sayan Maitra 752.00 163.00
Apurba Chowdhury 520.00 456.00
Tushar Ganguly 456.00 156.00
Debarati Chakraborty 125.00 236.00
Shweta Rai 850.00 185.00
Rituparna Saha 623.00 145.00
Shreya Chakraborty 690.00 196.00
Reena Dutta 450.00 236.00
Saheen Parween 580.00 250.00
Arijit Das 620.00 175.00
Sonali Dash 123.00 148.00
Arshi Rustam 258.00 589.00
Prasanta Barman 690.00 156.00
Monika Agarwal 456.00 612.00
Susmita Ghosh 690.00 580.00
Pooja Patil 582.00 189.00
Santanu Mukherjee 450.00 140.00
Sangeeta Singh 620.00 236.00
Anita Singh 754.00 900.00
Richa Jena 450.00 245.00
Amal Saha 125.00 269.00
S Lukas Malto 950.00 583.00
Ananta Taliyan 620.00 629.00
Sales
March April May June Total Sales
100.00 0.00 456.00 494.00 1,304.00
781.00 620.00 542.00 879.00 3,251.00
883.00 310.00 74.00 230.00 2,396.00
71.00 85.00 690.00 682.00 2,210.00
988.00 923.00 878.00 988.00 5,287.00
226.00 520.00 856.00 400.00 2,724.00
825.00 445.00 ### 360.00 4,339.00
425.00 62.00 875.00 875.00 3,291.00
883.00 ### 620.00 692.00 10,312.00
434.00 694.00 581.00 330.00 3,103.00
485.00 945.00 458.00 125.00 2,648.00
596.00 623.00 859.00 280.00 3,439.00
256.00 845.00 745.00 256.00 2,983.00
125.00 623.00 652.00 865.00 3,411.00
586.00 589.00 452.00 963.00 3,454.00
965.00 623.00 125.00 456.00 2,844.00
623.00 458.00 125.00 523.00 2,624.00
369.00 582.00 623.00 452.00 3,235.00
956.00 123.00 856.00 623.00 3,881.00
632.00 256.00 458.00 458.00 2,714.00
258.00 456.00 745.00 741.00 2,845.00
623.00 582.00 982.00 765.00 5,056.00
458.00 623.00 956.00 250.00 3,103.00
512.00 458.00 458.00 623.00 2,767.00
263.00 745.00 652.00 369.00 3,251.00
589.00 856.00 613.00 569.00 3,370.00
693.00 458.00 258.00 852.00 3,082.00
256.00 123.00 645.00 456.00 2,895.00
876.00 ### 859.00 623.00 5,228.00
856.00 369.00 745.00 458.00 3,720.00
632.00 125.00 856.00 750.00 3,277.00
369.00 458.00 859.00 620.00 3,607.00
236.00 569.00 632.00 ### 11,637.00
125.00 458.00 ### 452.00 5,567.00
125.00 745.00 623.00 360.00 3,205.00
456.00 852.00 458.00 263.00 3,073.00
623.00 123.00 569.00 369.00 2,563.00
302.00 362.00 623.00 697.00 2,561.00
528.00 692.00 852.00 580.00 3,896.00
4,500.00 356.00 845.00 654.00 7,443.00
456.00 623.00 623.00 845.00 3,539.00
258.00 650.00 458.00 751.00 3,225.00
692.00 458.00 741.00 523.00 3,037.00
125.00 ### 510.00 ### 6,663.00
623.00 230.00 250.00 850.00 2,697.00
563.00 523.00 256.00 690.00 3,098.00
548.00 152.00 623.00 940.00 3,588.00
596.00 569.00 692.00 852.00 3,880.00
785.00 632.00 582.00 369.00 2,682.00
520.00 856.00 456.00 456.00 2,702.00
456.00 990.00 956.00 751.00 4,732.00
623.00 623.00 693.00 741.00 3,923.00
582.00 456.00 152.00 510.00 2,318.00
456.00 125.00 256.00 289.00 2,207.00
589.00 623.00 586.00 523.00 3,760.00
956.00 526.00 145.00 369.00 2,782.00
623.00 589.00 523.00 368.00 3,215.00
145.00 562.00 369.00 456.00 3,069.00
582.00 263.00 256.00 745.00 3,089.00
125.00 584.00 956.00 812.00 3,428.00
369.00 623.00 758.00 582.00 3,575.00
456.00 592.00 456.00 123.00 2,664.00
586.00 613.00 512.00 375.00 3,459.00
956.00 528.00 230.00 741.00 3,701.00
458.00 741.00 125.00 512.00 3,381.00
745.00 513.00 456.00 612.00 3,241.00
230.00 256.00 569.00 425.00 2,456.00
569.00 158.00 852.00 623.00 2,814.00
452.00 561.00 630.00 852.00 2,856.00
582.00 663.00 256.00 613.00 3,149.00
236.00 542.00 563.00 258.00 2,367.00
456.00 239.00 456.00 963.00 3,000.00
125.00 412.00 582.00 465.00 2,270.00
123.00 512.00 623.00 582.00 2,670.00
256.00 635.00 458.00 613.00 2,757.00
236.00 856.00 745.00 258.00 2,366.00
458.00 458.00 623.00 456.00 2,842.00
562.00 946.00 458.00 956.00 3,768.00
128.00 523.00 120.00 765.00 2,604.00
523.00 623.00 360.00 846.00 3,622.00
693.00 458.00 582.00 946.00 3,450.00
458.00 612.00 613.00 853.00 3,126.00
496.00 582.00 520.00 467.00 2,921.00
971.00 834.00 ### 465.00 5,214.00
758.00 623.00 412.00 862.00 3,350.00
956.00 523.00 256.00 690.00 2,819.00
880.00 853.00 523.00 630.00 4,419.00
692.00 456.00 263.00 451.00 3,111.00
Name Months Sales
Commission Sumit SharmaJune 494
0
1,200 Department wise Incentive
0 25% 30%
0 Total Sales Food Cosmetics
2,000 500 125 150
0 1500 375 450
1,200 2500 625 750
1,200 4000 1000 1200
2,400
1,200 Calculate Commission as follows
0 Total Sales Commision
1,200 1000 0
0 3000 1200
1,200 5000 2000
1,200 10000 2400
0 Calculate the total sales of Anita Singh with more
0 Anita Singh >4000 11877
1,200
1,200 configure the months column so that it should acce
0 highlight the complete data row whose sales are be
0
2,000 Calculate the total sales of the month in the below
1,200 Month Total Sales
0 April 53370
1,200
1,200
1,200
0
2,000
1,200
1,200 12 TRUE
1,200 sejal FALSE
2,400
2,000
1,200
1,200
0
0
1,200
2,000
1,200
1,200
1,200
2,000
0
1,200
1,200
1,200
0
0
1,200
1,200
0
0
1,200
0
1,200
1,200
1,200
1,200
1,200
0
1,200
1,200
1,200
1,200
0
0
0
1,200
0
1,200
0
0
0
0
0
1,200
0
1,200
1,200
1,200
0
2,000
1,200
0
1,200
1,200
ncentive
20%
Stationery
100
300
500
800
nita Singh with more than 4000
15971
so that it should accept only numbers
ow whose sales are below 3000
e month in the below mentioned
