| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Model Name | Bill Date | NEW CITY | Group | New Ser | Sold Dlr | First_Visit_Date | Last_Visit_Date | ||||
2 | BALENO | 1-Apr-19 | HYD | Ser | FRS | Oth | 1-Apr-19 | 3-Jun-19 | ||||
3 | WAGON R | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 18-Sep-20 | ||||
4 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 11-Mar-23 | Requiremets | |||
5 | RITZ | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 3-Apr-19 | 1 | No of vehicles to be calculated based Bill Date | Total Base | |
6 | WAGON R | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 22-Feb-20 | 2 | How many vehicle reported fromApr-19 to Mar-20 based on bill date alongwith how many new vehicles added in period of 19-20 based on First visit date, & how many vehicle lost using last visit date. | ||
7 | SWIFT | 1-Apr-19 | VZG | Ser | OTH | Oth | 1-Apr-19 | 1-Apr-19 | ||||
8 | VITARA BREZZA | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 6-Jul-19 | ||||
9 | SWIFT DZIRE | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 1-Apr-19 | ||||
10 | VITARA BREZZA | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 24-Jun-23 | ||||
11 | ALTO | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 28-May-22 | ||||
12 | BALENO | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 1-Dec-19 | ||||
13 | NEW SWIFT | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 28-Jun-19 | ||||
14 | ZEN ESTILO | 1-Apr-19 | HYD | Ser | RR | Oth | 1-Apr-19 | 14-Jul-23 | ||||
15 | WAGON R | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 1-Apr-19 | ||||
16 | SWIFT | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 6-Jul-23 | ||||
17 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 29-Apr-22 | ||||
18 | NEW SWIFT | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 21-Jan-23 | ||||
19 | BALENO | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 1-Apr-19 | ||||
20 | BALENO | 1-Apr-19 | VZG | Ser | OTH | Own | 1-Apr-19 | 30-Mar-23 | ||||
21 | ALTO | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 27-May-23 | ||||
22 | WAGON R | 1-Apr-19 | VZG | Ser | PMS | Own | 1-Apr-19 | 7-May-22 | ||||
23 | NEW SWIFT | 1-Apr-19 | HYD | BS | BS | Oth | 1-Apr-19 | 31-Jul-19 | ||||
24 | ALTO | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 10-Jul-20 | ||||
25 | DZIRE | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 31-Mar-21 | ||||
26 | BALENO | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 16-Nov-21 | ||||
27 | DZIRE | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 15-Jun-23 | ||||
28 | ERTIGA | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 26-Sep-20 | ||||
29 | ALTO 800 | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 3-Dec-20 | ||||
30 | VITARA BREZZA | 1-Apr-19 | VZG | Ser | FRS | Oth | 1-Apr-19 | 19-Aug-21 | ||||
31 | ALTO 800 | 1-Apr-19 | HYD | Ser | FRS | Oth | 1-Apr-19 | 5-Dec-22 | ||||
32 | NEW ERTIGA | 1-Apr-19 | HYD | Ser | FRS | Oth | 1-Apr-19 | 1-Apr-19 | ||||
33 | SUPER CARRY | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 19-Jul-23 | ||||
34 | NEW SWIFT | 1-Apr-19 | HYD | Ser | FRS | Oth | 1-Apr-19 | 29-Aug-19 | ||||
35 | BALENO | 1-Apr-19 | HYD | Ser | FRS | Oth | 1-Apr-19 | 9-Apr-19 | ||||
36 | DZIRE | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 26-Sep-20 | ||||
37 | VITARA BREZZA | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 15-Jun-19 | ||||
38 | SCROSS | 1-Apr-19 | HYD | Ser | FRS | Own | 1-Apr-19 | 23-Dec-19 | ||||
39 | BALENO | 1-Apr-19 | HYD | Ser | FRS | Own | 1-Apr-19 | 18-Nov-22 | ||||
40 | VITARA BREZZA | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 20-Jul-19 | ||||
41 | DZIRE | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 1-Apr-19 | ||||
42 | CELERIO | 1-Apr-19 | HYD | Ser | FRS | Own | 1-Apr-19 | 31-Mar-21 | ||||
43 | SUPER CARRY | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 8-Jan-21 | ||||
44 | BALENO | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 1-Apr-19 | ||||
45 | DZIRE | 1-Apr-19 | VZG | Ser | FRS | Own | 1-Apr-19 | 14-Jul-23 | ||||
46 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 11-Sep-20 | ||||
47 | WAGON R | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 1-Apr-19 | ||||
48 | SWIFT | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 11-Jul-20 | ||||
49 | VITARA BREZZA | 1-Apr-19 | HYD | Ser | RR | Oth | 1-Apr-19 | 29-Sep-22 | ||||
50 | ALTO K10 | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 2-Mar-20 | ||||
51 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 11-Mar-20 | ||||
52 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 27-Dec-21 | ||||
53 | SWIFT | 1-Apr-19 | VZG | BS | BS | Oth | 1-Apr-19 | 1-Apr-19 | ||||
54 | ERTIGA | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 14-Aug-19 | ||||
55 | ZEN ESTILO | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 12-Jan-21 | ||||
56 | SWIFT | 1-Apr-19 | VZG | Ser | PMS | Own | 1-Apr-19 | 30-May-23 | ||||
57 | ERTIGA | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 6-Jun-20 | ||||
58 | ALTO | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 17-Apr-19 | ||||
59 | WAGON R | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 19-Dec-19 | ||||
60 | SWIFT DZIRE | 1-Apr-19 | HYD | Ser | OTH | Oth | 1-Apr-19 | 1-Apr-19 | ||||
61 | SWIFT DZIRE | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 1-Apr-19 | ||||
62 | ALTO K10 | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 13-Feb-20 | ||||
63 | A-STAR | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 6-Jun-23 | ||||
64 | SWIFT | 1-Apr-19 | VZG | Ser | OTH | Oth | 1-Apr-19 | 5-Apr-19 | ||||
65 | SWIFT DZIRE | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 3-Apr-19 | ||||
66 | SWIFT | 1-Apr-19 | HYD | Ser | RR | Oth | 1-Apr-19 | 1-Apr-19 | ||||
67 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | OTH | Oth | 1-Apr-19 | 1-Apr-19 | ||||
68 | RITZ | 1-Apr-19 | HYD | Ser | RR | Oth | 1-Apr-19 | 18-Dec-20 | ||||
69 | ALTO | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 1-Jul-20 | ||||
70 | VITARA BREZZA | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 25-May-23 | ||||
71 | DZIRE | 1-Apr-19 | HYD | Ser | PMS | Oth | 1-Apr-19 | 31-Oct-19 | ||||
72 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 30-Jun-23 | ||||
73 | DZIRE | 1-Apr-19 | VZG | Ser | PMS | Oth | 1-Apr-19 | 6-Jan-23 | ||||
74 | A-STAR | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 31-Oct-19 | ||||
75 | ALTO | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 4-Dec-20 | ||||
76 | ALTO | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 12-Dec-22 | ||||
77 | CIAZ | 1-Apr-19 | VZG | BS | BS | Oth | 1-Apr-19 | 1-Apr-19 | ||||
78 | ALTO 800 | 1-Apr-19 | VZG | BS | BS | Oth | 1-Apr-19 | 19-Apr-21 | ||||
79 | SWIFT DZIRE | 1-Apr-19 | VZG | BS | BS | Oth | 1-Apr-19 | 22-Jan-22 | ||||
80 | M 800 | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 16-Nov-22 | ||||
81 | CIAZ | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 4-Jun-22 | ||||
82 | OMNI | 1-Apr-19 | VZG | Ser | RR | Oth | 1-Apr-19 | 1-Apr-19 | ||||
83 | ALTO K10 (NEW) | 1-Apr-19 | HYD | Ser | RR | Oth | 1-Apr-19 | 2-Jun-20 | ||||
84 | ALTO 800 | 1-Apr-19 | HYD | Ser | OTH | Oth | 1-Apr-19 | 6-Sep-21 | ||||
85 | SWIFT | 1-Apr-19 | HYD | Ser | RR | Oth | 1-Apr-19 | 30-Aug-22 | ||||
86 | CIAZ | 1-Apr-19 | HYD | Ser | PMS | Own | 1-Apr-19 | 23-Aug-19 | ||||
87 | SUPER CARRY | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 22-Jul-23 | ||||
88 | BALENO | 1-Apr-19 | HYD | Ser | RR | Own | 1-Apr-19 | 14-Jul-22 | ||||
89 | EECO | 1-Apr-19 | VZG | Ser | PMS | Own | 1-Apr-19 | 12-Apr-23 | ||||
90 | WAGON R | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 25-Jan-21 | ||||
91 | CIAZ | 1-Apr-19 | VZG | Ser | PMS | Own | 1-Apr-19 | 23-Jun-21 | ||||
92 | BALENO | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 24-Jan-23 | ||||
93 | BALENO | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 1-Feb-23 | ||||
94 | DZIRE | 1-Apr-19 | VZG | BS | BS | Own | 1-Apr-19 | 28-Jul-23 | ||||
95 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 2-Jun-21 | ||||
96 | DZIRE | 1-Apr-19 | VZG | Ser | PMS | Own | 1-Apr-19 | 16-May-22 | ||||
97 | ALTO 800 | 1-Apr-19 | VZG | BS | BS | Own | 1-Apr-19 | 31-Jul-19 | ||||
98 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 9-Jan-23 | ||||
99 | DZIRE | 1-Apr-19 | VZG | Ser | RR | Own | 1-Apr-19 | 12-Sep-20 | ||||
100 | SWIFT DZIRE | 1-Apr-19 | VZG | Ser | PMS | Own | 1-Apr-19 | 26-Dec-22 |