0% found this document useful (0 votes)
12 views17 pages

Sales Order Summary and Results Data

The document contains sales data detailing orders made from January 2021 to December 2022, including information on order dates, regions, representatives, items, units sold, unit costs, and total sales amounts. It summarizes totals for different categories such as binders, desks, pens, pen sets, and pencils, with a grand total of 19,627.88 across 2,121 units sold. Additionally, there is a section listing student results for a DCA course from 2018.

Uploaded by

rajindere saini
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
12 views17 pages

Sales Order Summary and Results Data

The document contains sales data detailing orders made from January 2021 to December 2022, including information on order dates, regions, representatives, items, units sold, unit costs, and total sales amounts. It summarizes totals for different categories such as binders, desks, pens, pen sets, and pencils, with a grand total of 19,627.88 across 2,121 units sold. Additionally, there is a section listing student results for a DCA course from 2018.

Uploaded by

rajindere saini
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

OrderDate Region Rep Item Units Unit Cost Total

1/6/21 East Jones Pencil 95 1.99 189.05


1/23/21 Central Kivell Binder 50 19.99 999.50
2/9/21 Central Jardine Pencil 36 4.99 179.64
2/26/21 Central Gill Pen 27 19.99 539.73
3/15/21 West Sorvino Pencil 56 2.99 167.44
4/1/21 East Jones Binder 60 4.99 299.40
4/18/21 Central Andrews Pencil 75 1.99 149.25
5/5/21 Central Jardine Pencil 90 4.99 449.10
5/22/21 West Thompson Pencil 32 1.99 63.68
6/8/21 East Jones Binder 60 8.99 539.40
6/25/21 Central Morgan Pencil 90 4.99 449.10
7/12/21 East Howard Binder 29 1.99 57.71
7/29/21 East Parent Binder 81 19.99 1,619.19
8/15/21 East Jones Pencil 35 4.99 174.65
9/1/21 Central Smith Desk 2 125.00 250.00
9/18/21 East Jones Pen Set 16 15.99 255.84
10/5/21 Central Morgan Binder 28 8.99 251.72
10/22/21 East Jones Pen 64 8.99 575.36
11/8/21 East Parent Pen 15 19.99 299.85
11/25/21 Central Kivell Pen Set 96 4.99 479.04
12/12/21 Central Smith Pencil 67 1.29 86.43
12/29/21 East Parent Pen Set 74 15.99 1,183.26
1/15/22 Central Gill Binder 46 8.99 413.54
2/1/22 Central Smith Binder 87 15.00 1,305.00
2/18/22 East Jones Binder 4 4.99 19.96
3/7/22 West Sorvino Binder 7 19.99 139.93
3/24/22 Central Jardine Pen Set 50 4.99 249.50
4/10/22 Central Andrews Pencil 66 1.99 131.34
4/27/22 East Howard Pen 96 4.99 479.04
5/14/22 Central Gill Pencil 53 1.29 68.37
5/31/22 Central Gill Binder 80 8.99 719.20
6/17/22 Central Kivell Desk 5 125.00 625.00
7/4/22 East Jones Pen Set 62 4.99 309.38
7/21/22 Central Morgan Pen Set 55 12.49 686.95
8/7/22 Central Kivell Pen Set 42 23.95 1,005.90
8/24/22 West Sorvino Desk 3 275.00 825.00
9/10/22 Central Gill Pencil 7 1.29 9.03
9/27/22 West Sorvino Pen 76 1.99 151.24
10/14/22 West Thompson Binder 57 19.99 1,139.43
10/31/22 Central Andrews Pencil 14 1.29 18.06
11/17/22 Central Jardine Binder 11 4.99 54.89
12/4/22 Central Jardine Binder 94 19.99 1,879.06
12/21/22 Central Andrews Binder 28 4.99 139.72
OrderDate Region Rep Item Units Unit Cost Total
1/23/21 Central Kivell Binder 50 19.99 999.50
4/1/21 East Jones Binder 60 4.99 299.40
6/8/21 East Jones Binder 60 8.99 539.40
7/12/21 East Howard Binder 29 1.99 57.71
7/29/21 East Parent Binder 81 19.99 1,619.19
10/5/21 Central Morgan Binder 28 8.99 251.72
1/15/22 Central Gill Binder 46 8.99 413.54
2/1/22 Central Smith Binder 87 15.00 1,305.00
2/18/22 East Jones Binder 4 4.99 19.96
3/7/22 West Sorvino Binder 7 19.99 139.93
5/31/22 Central Gill Binder 80 8.99 719.20
10/14/22 West Thompson Binder 57 19.99 1,139.43
11/17/22 Central Jardine Binder 11 4.99 54.89
12/4/22 Central Jardine Binder 94 19.99 1,879.06
12/21/22 Central Andrews Binder 28 4.99 139.72
Binder Total 722 172.86 9,577.65
9/1/21 Central Smith Desk 2 125.00 250.00
6/17/22 Central Kivell Desk 5 125.00 625.00
8/24/22 West Sorvino Desk 3 275.00 825.00
Desk Total 10 525.00 1,700.00
2/26/21 Central Gill Pen 27 19.99 539.73
10/22/21 East Jones Pen 64 8.99 575.36
11/8/21 East Parent Pen 15 19.99 299.85
4/27/22 East Howard Pen 96 4.99 479.04
9/27/22 West Sorvino Pen 76 1.99 151.24
Pen Total 278 55.95 2,045.22
9/18/21 East Jones Pen Set 16 15.99 255.84
11/25/21 Central Kivell Pen Set 96 4.99 479.04
12/29/21 East Parent Pen Set 74 15.99 1,183.26
3/24/22 Central Jardine Pen Set 50 4.99 249.50
7/4/22 East Jones Pen Set 62 4.99 309.38
7/21/22 Central Morgan Pen Set 55 12.49 686.95
8/7/22 Central Kivell Pen Set 42 23.95 1,005.90
Pen Set Total 395 83.39 4,169.87
1/6/21 East Jones Pencil 95 1.99 189.05
2/9/21 Central Jardine Pencil 36 4.99 179.64
3/15/21 West Sorvino Pencil 56 2.99 167.44
4/18/21 Central Andrews Pencil 75 1.99 149.25
5/5/21 Central Jardine Pencil 90 4.99 449.10
5/22/21 West Thompson Pencil 32 1.99 63.68
6/25/21 Central Morgan Pencil 90 4.99 449.10
8/15/21 East Jones Pencil 35 4.99 174.65

Developed by Contextures Inc. [Link] 05/08/2025


12/12/21 Central Smith Pencil 67 1.29 86.43
4/10/22 Central Andrews Pencil 66 1.99 131.34
5/14/22 Central Gill Pencil 53 1.29 68.37
9/10/22 Central Gill Pencil 7 1.29 9.03
10/31/22 Central Andrews Pencil 14 1.29 18.06
Pencil Total 716 36.07 2,135.14
Grand Total 2121 873.27 19,627.88

2121

Developed by Contextures Inc. [Link] 05/08/2025


Hartron Students Resu Apr-May(2019-20) 71
Pred By:RKSaini
[Link] Admission No Student Course Semester Result Date Exam Date Internal Theory
Ashok
1 13028445 DCA sem - 2 5/4/2018 28/02/2018 38 22
Kumar
Rahul
2 13028463 DCA sem - 2 5/4/2018 28/02/2018 38 0
singh

3 14028706 Asil kumar DCA sem - 2 5/4/2018 28/02/2018 38 0

4 14028761 Mohit DCA sem - 2 5/4/2018 28/02/2018 38 3


Kuldeep
5 150281078 DCA sem - 2 5/4/2018 3/28/2018 38 2
Tanwar
6 150281096 Priyanka DCA sem - 2 5/4/2018 28/02/2018 38 5
7 150281280 Deepak DCA sem - 2 5/4/2018 28/02/2018 38 2
8 150281293 Sandeep DCA sem - 2 5/4/2018 28/02/2018 38 3
9 150281395 Kapil DCA sem - 2 5/4/2018 28/02/2018 38 6
10 160281477 Satish DCA sem - 2 5/4/2018 28/02/2018 38 1
11 160281480 Ankit DCA sem - 2 5/4/2018 28/02/2018 38 8
Sunil
12 160281492 DCA sem - 2 5/4/2018 28/02/2018 38 0
Kumar
13 160281508 Ravinder DCA sem - 2 5/4/2018 28/02/2018 38 17
14 160281525 Sonu DCA sem - 2 5/4/2018 28/02/2018 38 10
15 160281526 Pawan DCA sem - 2 5/4/2018 28/02/2018 38 1
sachin
16 160281529 DCA sem - 2 5/4/2018 28/02/2018 38 1
Pawaria
17 160281534 Pawan DCA sem - 2 5/4/2018 28/02/2018 38 0
Ashish
18 160281535 CCFA sem - 1 5/4/2018 28/02/2018 38 0
Shovran

19 160281539 Manisha HDFA sem - 2 5/4/2018 28/02/2018 38 14

ARVIND
20 160281546 AGGARWA DCA sem - 2 5/4/2018 28/02/2018 38 0
L

DINESH
21 160281549 HDFA sem - 2 5/4/2018 28/02/2018 38 3
KUMAR

22 160281551 NEERAJ HDFA sem - 2 5/4/2018 28/02/2018 38 3

23 160281553 SACHIN HDFA sem - 2 5/4/2018 28/02/2018 38 7

24 160281554 DEEPAK DCA sem - 2 5/4/2018 28/02/2018 38 5


25 160281573 SACHIN DCA sem - 2 5/4/2018 28/02/2018 38 5
HITESH
26 160281575 DCA sem - 2 5/4/2018 28/02/2018 38 6
HOODA
27 160281577 GAUTAM DCA sem - 2 5/4/2018 28/02/2018 38 1
28 160281585 PRITI HDFA sem - 2 5/4/2018 28/02/2018 38 10

MANISH
29 160281589 CCFA sem - 1 5/4/2018 28/02/2018 38 0
KUMAR

30 160281591 YOGESH HDFA sem - 1 5/4/2018 28/02/2018 38 7

31 160281596 TARUN HDFA sem - 2 5/4/2018 28/02/2018 38 0

32 160281600 POONAM HDFA sem - 2 5/4/2018 28/02/2018 38 15

RAHUL
33 160281605 HDFA sem - 2 5/4/2018 28/02/2018 38 0
SIWACH
34 160281618 ANITA DCA sem - 2 5/4/2018 28/02/2018 38 1
35 160281656 ARUN CCOA sem - 1 5/4/2018 28/02/2018 38 6
36 160281662 TARUN HDFA sem - 2 5/4/2018 28/02/2018 38 15
37 160281663 SACHIN DCA sem - 1 5/4/2018 28/02/2018 38 4
38 160281705 PREETI HDFA sem - 2 5/4/2018 28/02/2018 38 8
ANIL
39 160281712 HDFA sem - 1 5/4/2018 28/02/2018 38 3
KUMAR
MANISHA
40 160281715 HDFA sem - 2 5/4/2018 28/02/2018 38 0
SHARMA
41 160281718 LALITA DCA sem - 2 5/4/2018 28/02/2018 38 17
42 160281757 Mohan HDFA sem - 1 5/4/2018 28/02/2018 38 4
Gaurav
43 170281772 DCA sem - 2 5/4/2018 28/02/2018 38 10
Vats
44 170281774 Aaina DCA sem - 2 5/4/2018 28/02/2018 38 18
45 170281779 Dashrath DCA sem - 2 5/4/2018 28/02/2018 38 16
Rohit
46 170281781 DCA sem - 1 5/4/2018 28/02/2018 38 12
kumar
47 170281793 Rakhi HDFA sem - 1 5/4/2018 28/02/2018 38 16
48 170281796 Pawan DCA sem - 1 5/4/2018 28/02/2018 38 18
49 170281806 Divya CCOA sem - 1 5/4/2018 28/02/2018 38 19
Vikas
50 170281807 DCA sem - 1 5/4/2018 28/02/2018 38 10
Nehra
Sushma
51 170281809 HDFA sem - 1 5/4/2018 28/02/2018 38 14
Kumari
AUTOC
52 170281837 Pardeep sem - 1 5/4/2018 28/02/2018 18 6
AD
AUTOC
53 170281838 Tamanna sem - 1 5/4/2018 28/02/2018 18 8
AD
AUTOC
54 170281847 Ajay sem - 1 5/4/2018 28/02/2018 18 8
AD
55 170281868 Ajay CCOA sem - 1 5/4/2018 28/02/2018 38 13
56 170281869 Vijeta CCOA sem - 1 5/4/2018 28/02/2018 38 12
Sunil
57 170281874 CCOA sem - 1 5/4/2018 28/02/2018 38 10
Kumari
58 170281875 Manju CCOA sem - 1 5/4/2018 28/02/2018 38 14
AUTOC
59 170281887 Deepak sem - 1 5/4/2018 28/02/2018 18 9
AD
Vineet AUTOC
60 170281890 sem - 1 5/4/2018 28/02/2018 18 9
Dalal AD
61 170281896 Sachin CCOA sem - 1 5/4/2018 28/02/2018 38 0
AUTOC
62 170281897 Rebeca sem - 1 5/4/2018 28/02/2018 18 0
AD
63 170281911 Deepika CCOA sem - 1 5/4/2018 28/02/2018 38 9
Sanjeev
AUTOC
64 170281930 Kumar sem - 1 5/4/2018 28/02/2018 18 6
AD
Hooda
AUTOC
65 170281950 Vikash sem - 1 5/4/2018 28/02/2018 18 5
AD
AUTOC
66 170281964 Nishant sem - 1 5/4/2018 28/02/2018 18 6
AD
AUTOC
67 170281968 Amit sem - 1 5/4/2018 28/02/2018 18 6
AD
AUTOC
68 170281969 Pankaj sem - 1 5/4/2018 28/02/2018 18 4
AD
AUTOC
69 170281975 Sachin sem - 1 5/4/2018 28/02/2018 18 6
AD
AUTOC
70 170281980 Vishal sem - 1 5/4/2018 28/02/2018 18 3
AD
Pawan AUTOC
71 170281990 sem - 1 5/4/2018 28/02/2018 18 4
Kumar AD
Total Students 71
Objective Practicle Total Grade Project Marks Project Grade

18 22 100 B 0 B

21 55 114 B 0 B

0 0 38 REP 0 REP

20 60 121 B 50 B

23 60 123 B 50 B

24 60 127 B 50 B
22 42 104 B 50 B
10 0 51 REP 50 REP
26 64 134 B 50 B
10 0 49 REP 0 REP
13 64 123 B 50 B

10 0 48 REP 50 REP

23 40 118 B 0 B
17 40 105 B 50 B
15 0 54 REP 50 REP

23 50 112 B 50 B

16 0 54 REP 0 REP

0 0 38 REP 0 REP

19 63 134 B 0 B

6 0 44 REP 50 REP

11 0 52 REP 0 REP

18 58 117 B 0 B

14 0 59 REP 0 REP

13 0 56 REP 0 REP
17 64 124 B 0 B

15 55 114 B 50 B

12 0 51 REP 50 REP
15 56 119 B 0 B

0 0 38 REP 0 REP

9 0 54 REP 0 REP

0 0 38 REP 0 REP

21 65 139 B 0 B

0 0 38 REP 0 REP

15 0 54 REP 50 REP
12 0 56 REP 0 REP
19 50 122 B 0 B
14 0 56 REP 0 REP
17 65 128 B 0 B

19 0 60 REP 0 REP

0 0 38 REP 0 REP

23 65 143 B 50 B
11 0 53 REP 0 REP

17 62 127 B 50 B

24 30 110 B 50 B
23 65 142 B 50 B

11 62 123 B 0 B

16 58 128 B 0 B
20 67 143 B 0 B
19 66 142 B 0 B

20 56 124 B 0 B

25 66 143 B 0 B

11 36 71 REP 0 REP

11 35 72 REP 0 REP

9 35 70 REP 0 REP

11 64 126 B 0 B
19 64 133 B 0 B
13 30 91 c 0 c

15 33 100 B 0 B

10 35 72 REP 0 REP

10 35 72 REP 0 REP

19 0 57 REP 0 REP

0 0 18 REP 0 REP

12 60 119 B 0 B

9 36 69 REP 0 REP

7 35 65 REP 0 REP

7 36 67 REP 0 REP

8 36 68 REP 0 REP

9 36 67 REP 0 REP

5 35 64 REP 0 REP

8 35 64 REP 0 REP

9 36 67 REP 0 REP
16028152 28/02/20
15 Pawan DCA sem - 2 5/4/2018 38 1 15
6 18
16028152 sachin 28/02/20
16 DCA sem - 2 5/4/2018 38 1 23
9 Pawaria 18

ARVIND
16028154 28/02/20
20 AGGARW DCA sem - 2 5/4/2018 38 0 6
6 18
AL
16028155 28/02/20
24 DEEPAK DCA sem - 2 5/4/2018 38 5 13
4 18
16028157 28/02/20
25 SACHIN DCA sem - 2 5/4/2018 38 5 17
3 18
16028171 28/02/20
41 LALITA DCA sem - 2 5/4/2018 38 17 23
8 18
17028177 Gaurav 28/02/20
43 DCA sem - 2 5/4/2018 38 10 17
2 Vats 18
17028177 28/02/20
44 Aaina DCA sem - 2 5/4/2018 38 18 24
4 18
17028177 28/02/20
45 Dashrath DCA sem - 2 5/4/2018 38 16 23
9 18
17028178 Rohit 28/02/20
46 DCA sem - 1 5/4/2018 38 12 11
1 kumar 18
17028179 28/02/20
48 Pawan DCA sem - 1 5/4/2018 38 18 20
6 18
16028152 sachin
0 54 REP 50 REP 16 DCA
9 Pawaria
16028153
50 112 B 50 B 17 Pawan DCA
4

16028155
0 44 REP 50 REP 24 DEEPAK DCA
4

16028157
0 56 REP 0 REP 25 SACHIN DCA
3
16028157 HITESH
64 124 B 0 B 26 DCA
5 HOODA
17028177 Gaurav
65 143 B 50 B 43 DCA
2 Vats
17028177
62 127 B 50 B 44 Aaina DCA
4
17028177
30 110 B 50 B 45 Dashrath DCA
9
17028178 Rohit
65 142 B 50 B 46 DCA
1 kumar
17028179
62 123 B 0 B 48 Pawan DCA
6

67 143 B 0 B
28/02/20
sem - 2 5/4/2018 38 1 23 50 112 B 50
18
28/02/20
sem - 2 5/4/2018 38 0 16 0 54 REP 0
18

28/02/20
sem - 2 5/4/2018 38 5 13 0 56 REP 0
18

28/02/20
sem - 2 5/4/2018 38 5 17 64 124 B 0
18
28/02/20
sem - 2 5/4/2018 38 6 15 55 114 B 50
18
28/02/20
sem - 2 5/4/2018 38 10 17 62 127 B 50
18
28/02/20
sem - 2 5/4/2018 38 18 24 30 110 B 50
18
28/02/20
sem - 2 5/4/2018 38 16 23 65 142 B 50
18
28/02/20
sem - 1 5/4/2018 38 12 11 62 123 B 0
18
28/02/20
sem - 1 5/4/2018 38 18 20 67 143 B 0
18
B

REP

REP

B
B

You might also like