0% found this document useful (0 votes)
169 views8,920 pages

SQL Query File Prog.

The document contains SQL statements and queries for creating tables, inserting data, joining tables, and selecting data. It includes statements for creating tables with various columns, inserting sample data into the tables, joining two tables on a common column, and selecting data from the joined tables.

Uploaded by

leo17.pass
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)
169 views8,920 pages

SQL Query File Prog.

The document contains SQL statements and queries for creating tables, inserting data, joining tables, and selecting data. It includes statements for creating tables with various columns, inserting sample data into the tables, joining two tables on a common column, and selecting data from the joined tables.

Uploaded by

leo17.pass
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
You are on page 1/ 8920

Sr No Statement Syntax Use

1 Create New Data Base


2
3
4 select select * from batch_Sep_data; Selcet form the Data Table
dTable (ServerIP, UserID,
Password)
5 Insert --VALUES ('34.75.181.50 create table Sep_2023
--', 'Web', 'Web@#12!'); (S_Class int,
fess char (4),
S_name Varchar(30),
)

select * from sep_2023


6 Insert insert into
insert
insert intointo table
Sep_2023
Oct_Batch_2022(S_name,St
(S_Class,fess,S_name)
Alld,Fess,Baord)Values
Rows will be ddeleted
values
7 Truncate Truncate Table Name ('Jiv',1,'700',MS'),
into Table.
(3,'5000','rohit'),
create table Sep_2023
('Shorya',4,'700','CBSC'),
(3,'4000','ankit'),
(S_Class int,
('Nani',4,'700','CBSC'),
(3,'3000','rahul')
8 fess char (4),
('Piu',5,'1200','ISCS'),
S_name Varchar(30),
('Shrutika',5,'1200','ISCS'),
)
('Vedant
Gaikwad',5,'1200','CBSC'),
update Bulk select * from sep_2023
('Ahil',5,'700','ISCS'),
9
data ('Anirudha',1,'700','ICSC')
UPDATE TBL_inner Join_2022 set paid insert into Sep_2023
(S_Class,fess,S_name)
update Bulk values
10
data UPDATE TBL_inner Join_2022 set paid_date ='' WHERE stu_id= 'AMRUT'
(3,'5000','rohit'),
11 date text data (3,'4000','ankit'),
12 time #NAME? (3,'3000','rahul')

INNER JOIN
EMP_ID EMP_NAME EMP_LAST_NAME EMM_CODE
1 ANNAD WADE 100
2 RAMA WADE 200
3 RAJSHREE WADE 300
4 MUKESH WADE 400
5 AMRUT WADE 500
6 NEELA WADE 600
DEPT_ID DEPT_NAME SALARY
1 1 DEFENCE 500,000
2 2 ARMY 400000
3 3 EDUCATION 100000
4 4 IT 200000
5 5 CORPORATION 50000
6 6 HOUSE 0
SELECT * FROM JOIN_iNNER_EMP_1 INNER JOIN JOIN_INNER_EMP_2_DEPT ON JOIN_iNNER_EMP_1.EMP_ID =JO

create table family1(


familyid int primary key,
name varchar (30),
middle_name varchar (30),
city varchar (20)
) familyid,name ,middle_name,

familyid name middle_name city


1 AMRUT JAYRAM CHOPDA
2 NEELA AMRUT PUNE
3 MUKESH AMRUT PUNE
4 RAJSHREE MUKESH PUNE
5 RAMA MUKESH PUNE
6 ANAND MUKESH PUNE
1 AMRUT RETD 75
2 NEELA HOME MAKER 65
3 MUKESH JOB IT SECTOR 38
4 RAJSHREE JOB TEACHER 34
5 RAMA STUDENT 4
6 ANAND CHILDHOOD 2 MONTH
ID NAME SALARY Sector
1 AMRUT CHOPDA SALARY
2 NEELA PUNE HOME MAKER
3 MUKESH PUNE JOB IT SECTOR
4 RAJSHREE PUNE JOB TEACHER
5 RAMA PUNE STUDENT
6 ANAND PUNE CHILDHOOD

ID First_name Middle_Name Last_name


1 AMRUT JAYRAM WADE
2 NEELA AMRUT WADE
3 MUKESH AMRUT WADE
4 RAJSHREE MUKESH WADE
5 RAMA MUKESH WADE
6 ANAND MUKESH WADE
3
ID First_name dob-TIME BORNPALCE
1 AMRUT 01-01-1951- 12:10:12 THANLNER

2 NEELA 01-01-1960 :14:50:23 THANLNER

3 MUKESH 31-07-1984 : 10:54:20 THANLNER

4 RAJSHREE 17-07-1987 : 04:12:30 JALGAON

5 RAMA 08-11-2019 :11:45:12 JALGAON

6 ARIHANT 08-08-2023 : 07:45:12 CHOPDA

Jan-24

SUN 0 7

MON 1 8

TUE 2 9
WED 3 10

THU 4 11

FRI 5 12

SAT 6 13

innner join
dt 30-jan-2024 familyid name middle_name
1 AMRUT JAYRAM
2 NEELA AMRUT
3 MUKESH AMRUT
4 RAJSHREE MUKESH
5 RAMA MUKESH
6 ANAND MUKESH

ID NAME DEPT

1 AMRUT RETD

2 NEELA HOME MAKER

3 MUKESH JOB IT SECTOR


4 RAJSHREE JOB TEACHER

5 RAMA STUDENT

6 ARIHANT CHILDHOOD

ID NAME SALARY

1 AMRUT 22000

2 NEELA 0

3 MUKESH 20000

4 RAJSHREE 4000

5 RAMA DEPENDENT

6 ARIHANT DEPENDENT

Msg 544, Level 16, State 1, Line 10


Cannot insert explicit value for
identity column in table
'right_join1' when
IDENTITY_INSERT is set to OFF.
number contert into date and Am/pm

RE stu_id= 'AMRUT'

EMP_NAME INT PRIMARY KEY ,


EMP_LAST_NAME VARCHAR (20),
EMP_SALARY VARCHAR (20),
EMP_CODE VARCHAR (2)
NNER JOIN )
(EMP_ID,EMP_NAME,EMP_LAST_NAME,EMP_CODE)VALUES (' 1',' ANNAD',' WADE',' 100')
(EMP_ID,EMP_NAME,EMP_LAST_NAME,EMP_CODE)VALUES (' 2',' RAMA',' WADE',' 200')
EMP_ID,EMP_NAME,EMP_LAST_NAME,EMP_CODE)VALUES (' 3',' RAJSHREE',' WADE',' 300')
EMP_ID,EMP_NAME,EMP_LAST_NAME,EMP_CODE)VALUES (' 4',' MUKESH',' WADE',' 400')
(EMP_ID,EMP_NAME,EMP_LAST_NAME,EMP_CODE)VALUES (' 5',' AMRUT',' WADE',' 500')
(EMP_ID,EMP_NAME,EMP_LAST_NAME,EMP_CODE)VALUES (' 6',' NEELA',' WADE',' 600')

POST
INSERT INTO JOIN_INNER_EMP_2_DEPT
FLYING OFFCER (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 1 ',' DEFENCE ',' 500000 ',' FLYING OFFCER ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
DOCTOR (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 2 ',' ARMY ',' 400000 ',' DOCTOR ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
TEACHER (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 3 ',' EDUCATION ',' 100000 ',' TEACHER ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
IT DEVELOPER (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 4 ',' IT ',' 200000 ',' IT DEVELOPER ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
FIREMAN (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 5 ',' CORPORATION ',' 50000 ',' FIREMAN ')
INSERT INTO JOIN_INNER_EMP_2_DEPT
HOME (DEPT_ID,DEPT_NAME,SALARY,POST)VALUES(' 6 ',' HOUSE ',' 0 ',' HOME ')
_DEPT ON JOIN_iNNER_EMP_1.EMP_ID =JOIN_INNER_EMP_2_DEPT.DEPT_ID

FAMILIY_ID INT PRIMARY KEY,


NAME VARCHAR (20),
WORK VARCHAR(20),
AGE

INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 1 ', ' AMRUT ', ' JAYRAM ', ' CHOPDA ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 2 ', ' NEELA ', ' AMRUT ', ' PUNE ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 3 ', ' MUKESH ', ' AMRUT ', ' PUNE ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 4 ', ' RAJSHREE ', ' MUKESH ', ' PUNE ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 5 ', ' RAMA ', ' MUKESH ', ' PUNE ')
INSERT INTO family1 (familyid,name ,middle_name,city) VALUES (' 6 ', ' ANAND ', ' MUKESH ', ' PUNE ')
INSERT INTO (familyid,name ,middle_name,city) VALUES (' 1 ', ' AMRUT ', ' RETD ', ' 75 ')
INSERT INTO FAMILY2(FAMILIY_ID,NAME,WORK,AGE) VALUES (' 1', ' AMRUT', ' RETD', ' 75')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 2', ' NEELA', ' HOME MAKER', ' 65')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 3', ' MUKESH', ' JOB IT SECTOR', ' 38')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 4', ' RAJSHREE', ' JOB TEACHER', ' 34')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 5', ' RAMA', ' STUDENT', ' 4')
INSERT INTO FAMILY2(FAMILY_ID,NAME,WORK,AGE) VALUES (' 6', ' ANAND', ' CHILDHOOD', ' 2 MONTH')
dob
Monday, January 1, 1951 01-01-1951
01 January 1960 01-01-1960
07-31-1984 07-31-1984
Friday, July 31, 1987 31-07-1987
Sunday, August 11, 2019 11-08-2019
Monday, October 8, 2029 08-10-2029
) )
E_Add INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 1
CHOPDA INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 2
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 3
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 4
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 5
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 6
PUNE INSERT INTO inner1(ID,FIRST_NAME, MIDDLE_NAME,LAST_NAME,E_ADD)( ' 3 ', ', ',

DATE AN D TIME
INSERT INTO date_time ( id,name,
DOB,)VALUES( ' 1 ', ' AMRUT ', ' 01-01-
1951- 12:10:12 ')
INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 1 ', ' AMRUT ', ' TH
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 2 ', '
NEELA ', ' 01-01-1960 :14:50:23 ', '
THANLNER ') INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 2 ', ' NEELA ', ' THA
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 3 ', '
MUKESH ', ' 31-07-1984 : 10:54:20 ', '
THANLNER ') INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 3 ', ' MUKESH ', ' T
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 4 ', '
RAJSHREE ', ' 17-07-1987 : 04:12:30 ', '
JALGAON ') INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 4 ', ' RAJSHREE ', '
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 5 ', '
RAMA ', ' 08-11-2019 :11:45:12 ', '
JALGAON ') INSERT INTO INN_DEPT2(ID,FIRST_NAME, POST,SALARY)VALUES( ' 5 ', ' RAMA ', ' JALG
INSERT INTO Update_STM ( id,name,
DOB,BORN_PALaCE)VALUES( ' 6 ', '
ARIHANT ', ' 08-08-2023 : 07:45:12 ', '
CHOPDA ')

Jan-24

14 21 28

15 22 29

16 23 30
17 24 31

18 25 --

19 26 --

20 27 --

city
CHOPDA
PUNE
PUNE
PUNE
PUNE
PUNE

AGE
INSERT INTO
75 family1(ID,NAME,DEPT,AGE)VALUES('
1 ','AMRUT ','RETD ','75 ')
INSERT INTO
65 family1(ID,NAME,DEPT,AGE)VALUES('
2 ','NEELA ','HOME MAKER ','65 ')
INSERT INTO
38 family1(ID,NAME,DEPT,AGE)VALUES('
3 ','MUKESH ','JOB IT SECTOR ','38 ')
INSERT INTO
34 family1(ID,NAME,DEPT,AGE)VALUES('
4 ','RAJSHREE ','JOB TEACHER ','34 ')
INSERT INTO
4 family1(ID,NAME,DEPT,AGE)VALUES('
5 ','RAMA ','STUDENT ','4 ')
INSERT INTO
5 family1(ID,NAME,DEPT,AGE)VALUES('
6 ','ARIHANT ','CHILDHOOD ','5 ')

Sector
INSERT INTO
RETD famlily2(ID,NAME,SALARY,Sector)VAL
UES('1 ','AMRUT ','22000 ','RETD ')

HOME MAKER INSERT INTO


famlily2(ID,NAME,SALARY,Sector)VAL
UES('2 ','NEELA ','0 ','HOME MAKER ')

INSERT INTO
JOB IT SECTOR famlily2(ID,NAME,SALARY,Sector)VAL
UES('3 ','MUKESH ','20000 ','JOB IT
SECTOR ')

INSERT INTO
JOB TEACHER famlily2(ID,NAME,SALARY,Sector)VAL
UES('4 ','RAJSHREE ','4000 ','JOB
TEACHER ')

INSERT INTO
STUDENT famlily2(ID,NAME,SALARY,Sector)VAL
UES('5 ','RAMA ','DEPENDENT
','STUDENT ')

INSERT INTO
CHILDHOOD famlily2(ID,NAME,SALARY,Sector)VAL
UES('6 ','ARIHANT ','DEPENDENT
','CHILDHOOD ')
VARCHAR (20),

VARCHAR (20),
EMP_CODE VARCHAR (2)
)
EMP_NAME INT PRIMARY KEY ,
EMP_LAST_NAME VARCHAR (20),
EMP_SALARY VARCHAR (20),
EMP_CODE VARCHAR (2)

S(' 1 ',' DEFENCE ',' 500000 ',' FLYING OFFCER ')


ALUES(' 2 ',' ARMY ',' 400000 ',' DOCTOR ')
UES(' 3 ',' EDUCATION ',' 100000 ',' TEACHER ')
ALUES(' 4 ',' IT ',' 200000 ',' IT DEVELOPER ')
ES(' 5 ',' CORPORATION ',' 50000 ',' FIREMAN ')
T)VALUES(' 6 ',' HOUSE ',' 0 ',' HOME ')

', ' JAYRAM ', ' CHOPDA ')


, ' AMRUT ', ' PUNE ')
H ', ' AMRUT ', ' PUNE ')
EE ', ' MUKESH ', ' PUNE ')
, ' MUKESH ', ' PUNE ')
', ' MUKESH ', ' PUNE ')

RETD', ' 75')


OME MAKER', ' 65')
JOB IT SECTOR', ' 38')
' JOB TEACHER', ' 34')
TUDENT', ' 4')
CHILDHOOD', ' 2 MONTH')

MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 1 ', ' AMRUT ',' JAYRAM ',' WADE ', ' CHOPDA ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 2 ', ' NEELA ',' AMRUT ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 3 ', ' MUKESH ',' AMRUT ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 4 ', ' RAJSHREE ',' MUKESH ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 5 ', ' RAMA ',' MUKESH ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)VALUES( ' 6 ', ' ANAND ',' MUKESH ',' WADE ', ' PUNE ')
MIDDLE_NAME,LAST_NAME,E_ADD)( ' 3 ', ', ', ', ' ')
ME, POST,SALARY)VALUES( ' 1 ', ' AMRUT ', ' THANLNER ', ' 01-01-1951- 12:10:12 ')

ME, POST,SALARY)VALUES( ' 2 ', ' NEELA ', ' THANLNER ', ' 01-01-1960 :14:50:23 ')

ME, POST,SALARY)VALUES( ' 3 ', ' MUKESH ', ' THANLNER ', ' 31-07-1984 : 10:54:20 ')

ME, POST,SALARY)VALUES( ' 4 ', ' RAJSHREE ', ' JALGAON ', ' 17-07-1987 : 04:12:30 ')

ME, POST,SALARY)VALUES( ' 5 ', ' RAMA ', ' JALGAON ', ' 08-11-2019 :11:45:12 ')

INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
SUN ',' 0 ', ' 7 ',' 14 ','
21 ',' 28 ')

INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
MON ',' 1 ', ' 8 ',' 15 ','
22 ',' 29 ')

INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
TUE ',' 2 ', ' 9 ',' 16 ',' 23
',' 30 ')
INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
WED ',' 3 ', ' 10 ',' 17 ','
24 ',' 31 ')

INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
THU ',' 4 ', ' 11 ',' 18 ','
25 ',' -- ')

INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( ' FRI
',' 5 ', ' 12 ',' 19 ',' 26 ','
-- ')

INSERT INTO
CALENDOR_JAN_2024(
SUN,MON,TUE,WED,TH
U,FRI,SAT)VALUES( '
SAT ',' 6 ', ' 13 ',' 20 ','
27 ',' -- ')
select * from STUDENT_OCT2022
CREATE TABLE STUDENT_OCT2022
(
STUDENT_Id int IDENTITY(1,1) PRIMARY KEY,
STUDENT_Class int NOT NULL UNIQUE,
First_Name varchar(50) NOT NULL,
Last_Name varchar(50) NOT NULL,
Area_Code int NULL,
S_Address varchar(50) NULL,
Phone varchar (50) NULL,
)
insert into STUDENT_OCT2022 (STUDENT_Id ,STUDENT_Class,First_Name,Last_Name,
Area_Code,S_Address, Phone )
values
(1,5,'Shorya','Devekar',28,12,'Hadpasar',12345) ;

VARCHAR (2)

00 ',' FLYING OFFCER ')


0000 ',' DOCTOR ')
100000 ',' TEACHER ')
',' IT DEVELOPER ')
,' 50000 ',' FIREMAN ')
,' 0 ',' HOME ')

ME,E_ADD)VALUES( ' 1 ', ' AMRUT ',' JAYRAM ',' WADE ', ' CHOPDA ')
ME,E_ADD)VALUES( ' 2 ', ' NEELA ',' AMRUT ',' WADE ', ' PUNE ')
ME,E_ADD)VALUES( ' 3 ', ' MUKESH ',' AMRUT ',' WADE ', ' PUNE ')
ME,E_ADD)VALUES( ' 4 ', ' RAJSHREE ',' MUKESH ',' WADE ', ' PUNE ')
ME,E_ADD)VALUES( ' 5 ', ' RAMA ',' MUKESH ',' WADE ', ' PUNE ')
ME,E_ADD)VALUES( ' 6 ', ' ANAND ',' MUKESH ',' WADE ', ' PUNE ')
ME,E_ADD)( ' 3 ', ', ', ', ' ')
ES( ' 1 ', ' AMRUT ', ' THANLNER ', ' 01-01-1951- 12:10:12 ')

ES( ' 2 ', ' NEELA ', ' THANLNER ', ' 01-01-1960 :14:50:23 ')

ES( ' 3 ', ' MUKESH ', ' THANLNER ', ' 31-07-1984 : 10:54:20 ')

ES( ' 4 ', ' RAJSHREE ', ' JALGAON ', ' 17-07-1987 : 04:12:30 ')

ES( ' 5 ', ' RAMA ', ' JALGAON ', ' 08-11-2019 :11:45:12 ')
Data Types, Primary-Foreign Keys & Constraints in SQL | SQL
ys & Constraints in SQL | SQL Tutorial In Hindi 2 Name(Rishabh Mishra)
NAME OF
SR NO DESCRIPATION USE TO
FORMULA
1 SUM : Adds up all the numbers in a range.
2 AVERAGE:
Calculates the average of a range of
numbers.
3 MAX: Returns the largest number in a range.
4 MIN : Returns the smallest number in a range.

5 COUNT
: Counts the number of cells in a range
containing numbers.
6 IF
: Returns one value if a condition is true
and another value if it's false.

7 VLOOKUP : Searches for a value in a table and


function returns a corresponding value.

8 HLOOKUP
: Similar to VLOOKUP but searches in a
horizontal table.

9 INDEX:
Returns the value of a cell in a specified
row and column of a range.

10 MATCH
: Searches for a specified value in a range
and returns its relative position.
11 CONCATENATE
: Combines text from multiple cells into
one cell.

Converts a value to text with a specified


number format.The INDEX function in
Excel is used to return the value of a cell
12 TEXT:
within a specified range based on its row
and column numbers. It is a versatile
function and can be used for a variety of
tasks. The basic syntax of the INDEX
function is as follows:

: Returns a specified number of


13 LEFT characters from the beginning of a text
string.

14 RIGHT
: Returns a specified number of
characters from the end of a text string.

15 LEN
: Returns the length (number of
characters) in a text string.
16 DATE
: Creates a date value from year, month,
and day components.
17 NOW : Returns the current date and time.
18 TODAY : Returns the current date.
19 SUMIF:
Adds up all the numbers in a range that
meet a single criterion.
20 COUNTIF
: Counts the number of cells in a range
that meet a single criterion.
S/W Application
1
2
3
4
5
6
7

8
SYNATAX ALL = SING
ACTUL FORMULA RANGE
LEFT

AVERAGE(range)
AVVEREERER
max(range)
min(range)

count(range)

(logical_test, value_if_true, value_if_false)

INDEX(array,
row_num,
[column_num])
1)rate: The interest rate for each period.
2)per: The period for which you
want to calculate the principal
payment.3 )nper: The total number
of payment periods. 4) pv: The
present value or the principal
amount of the loan or investment.
5) [fv] (optional): The future
value or a cash balance you want to
attain after the last payment. If
omitted, Excel assumes it is 0.6)
[type] (optional): This indicates
whether the payment is made at the
beginning or end of the period. Use
0 for end of the period (default)
or 1 for the beginning.

CUSTOMER SUPPORT/SERVICES.
Parent-Menu Child-Menus
Feture Details of Login
if Owner -Wings/ Bulding /Flat No/
Customer Login
Name/ Mob No. Nos Of Time Login.
1) Date 2) Time In
Service given Date Time
via App login SMS/ code Details
Admin (Main ) All details
Opertator one should be control
Data base generate
Reply to Customer 1)Call 2) SMS 3)
By Operator Done Work(Operate by Operator of custome ,
Email Services 4) whatsapps 5) App
Reply(Admin) Two way Communication)
to App

Type of services. (Facilities)


Parent Menu Parent Menu
TYPE Non Paid Service Paid Service
date come form- first login (if
date come form- first login (if Owner/rent ) -
Owner/rent ) -Wings/ Bulding /Flat
Services Wings/ Bulding /Flat No/ Name/ Mob No. Nos
No/ Name/ Mob No. Nos Of Time
Of Time Login.
Login.
1 Pumbing Barber
2 Electicition House Keeping
3 Furnuture Cobler
4 Feedbak Driver
5 Date / Time Maid servent
6 Market Assitance
7 Pest Control
8 Other Services
9 work done Date / Time
10 Feedbak Date / Time
Store Data
App Run on 1) Mob-Anroid base
User no of ...
2)Laptop/ desktop MS 3) imac
5 Yrs Services
PRACTICAL EG.
Name of formula
SUM 20
average 20
max 20
min 20

count 20

if 20

VLOOKUP function 20

CONCATENATE Mukesh

(value: This is the numeric value (number,


date, or time) that you want to convert into
text.
format_text: This is a text string that
specifies the format you want to apply to the
value. The format_text argument uses
various placeholders to represent different
TEXT: parts of the value. For example, if you want
to format a date, you can use placeholders
like "dd" for the day, "mm" for the month,
and "yyyy" for the year.
1)--Formatting a Date:---->=TEXT(A1, "dd-
mmm-yyyy". 3)----> Formatting a Number:
=TEXT(C1, "$#,##0.00")

TEXT:
2) Formatting a Time:---> =TEXT(B1,
"hh:mm AM/PM").

TEXT:
3)----> Formatting a Number: =TEXT(C1,
"0")

In Excel, the LEFT function is used to extract


a specified number of characters from the left-----> =left(cell no, 3)
beginning (left side) of a text string.
left-----> =lright(cell no, 3)
len -nos of charcter count in a string len---> =len()
Now -Gave today date now----> =now()

finacial Formulas Loan Amount


pmt (EMI) Inrterst of rate
Loan Period (Year )
EMI

finacial Formulas Loan


IPMT (Rate of Int) Loan Amount
Inrterst of rate
Loan Period (Year )
Installment on Interst / Monthly

finacial Formulas Loan


PPMT ((Principal Payment)) Loan Amount
PPMT(rate, per, nper, pv, [fv], [type]) Inrterst of rate
Loan Period (Year )
0 Installment / Monthly
20,833
Result with Formaul 2 nd Method/ Insert
Fuction on Formula
30 40 30 120 120
30 40 30 30
30
30 40 30 40 40
30 40 30 20
20
30 40 30 4
4
30 40 30
TRUE

30 40 30

Amrut wade pune Mukesh Amrut wade pune

1/1/1951 Date 01-01-1951

Time
14:45 02:45 PM
Text

Error $#,##0.00
$#,##0.00

8668840489 489
8668840489 89
38
2/4/2024 15:17

88,000
10%
2
4,060.75

figures
1500000
10%
15
12,500

figures
1,500,000.00
10%
15
8,333

20,833
8,833
Column1 Column2 Column3 Column4 Column5 Column6
SUPPORT_PERS CALL_DURA
Tokan_id Date Time NAME_OF_CALLER
ON_NAME TION

1 07-04-2023 09:30:00 Sachin Govind (Barmer sec. control Room) 120 sec

2 07-04-2023 10:09:00 Sachin Abhilash Diwan 2 Min

3 07-04-2023 10:11:00 Sachin Abhilash Diwan 45 sec

4 07-04-2023 10:12:00 Sachin Govind (Barmer sec. control Room) 41 sec

5 07-04-2023 11:04:00 Sachin Laxman 149 sec


6 07-04-2023 11:24:00 Sachin Laxman 39 sec

7 07-04-2023 11:25:00 Sachin Lumba Ram 62 sec

8 07-04-2023 12:25:00 Sachin kw2 control Room 21 sec

9 07-04-2023 13:24:00 Sachin Laxman 175 sec

10 07-04-2023 13:41:00 Sachin Laxman 140 sec


11 07-04-2023 18:15:00 Sachin Laxman 232 sec

12 07-04-2023 16:56:00 Sachin Lumba Ram 103 sec

13 07-04-2023 14:03:00 Sudhir Lumba Ram 12 sec

14 07-04-2023 14:12:00 Sudhir kuldeep Singh 35 sec

15 07-04-2023 14:24:00 Sudhir Lumba Ram 14 sec


16 07-04-2023 16:31:00 Sudhir (Barmer sec. control Room) 1 MIN

17 07-04-2023 16:44:00 Sudhir kuldeep Singh 1 MIN

18 07-04-2023 17:27:00 Sudhir kuldeep Singh 38 sec

19 07-04-2023 18:07:00 Sudhir Lumba Ram 47 sec

20 07-04-2023 21:10:00 Sudhir Laxman 151 sec


21 07-04-2023 18:17:00 Sudhir kuldeep Singh 23 sec

22 07-04-2023 19:03:00 Sudhir kuldeep Singh 58 sec

23 07-04-2023 19:05:00 Sudhir kuldeep Singh 378 sec

24 07-04-2023 16:12:00 Sudhir kuldeep Singh 35 sec

25 07-04-2023 16:14:00 Sudhir (Barmer sec. control Room) 44 sec


26 08-04-2023 10:12:00 Mukesh Barmer Laxman Service Enginner. 4 minute

27 08-04-2023 12:15:00 Mukesh Control Room Kw-2 14 Sec

28 08-04-2023 13:58:00 Mukesh Sara control Room 1 MIN

29 08-04-2023 14:14:00 Sudhir Sara control Room 26 sec

30 08-04-2023 14:19:00 Sudhir Sara control Room 11 sec


31 08-04-2023 14:28:00 Sudhir Ashish IT 14 sec

32 08-04-2023 14:32:00 Sudhir Barmer Passenger control Room 33 sec

33 08-04-2023 14:33:00 Sudhir Prithvi Singh 39 sec

34 08-04-2023 14:49:00 Sudhir Suvali Jigar 93 sec

35 08-04-2023 15:18:00 Sudhir Kuldeeep Singh 78 sec


36 08-04-2023 16:20:00 Sudhir kw2 control Room 1 MIN

37 08-04-2023 16:37:00 Sudhir (Barmer sec. control Room) 1 MIN

38 08-04-2023 17:53:00 Sudhir Lumba Ram 1 MIN

39 09-04-2023 09:02:00 Sachin Contol Room Suvali Jigar. 4 munute

40 09-04-2023 14:32:00 Mukesh Contol Room Barmer (Govind) 37 Sec


41 09-04-2023 15:06:00 Mukesh Contol Room Barmer (Govind) 47sec

42 09-04-2023 15:28:00 Mukesh Contol Room Barmer (Govind) 30 sec

1 min:
43 09-04-2023 18:45:00 Mukesh Laxman Service Engineer
55Sec

1 min:
44 09-04-2023 18:45:00 Mukesh Abhilash Diwan Sir .
12Sec

1 min, 42
45 10-04-2023 07:52:00 Mukesh Barmer Comtrol Room (Govind)
Sec
46 10-04-2023 08:40:00 Mukesh Laxman Service Engineer (Barmer) 22 min

47 10-04-2023 10:28:00 Mukesh Control Room Sara-1 (Tejas) 1 min 22 sec

48 10-04-2023 10:40:00 Mukesh Control Room Guda- (Ravi) 1 min 58 sec

49 10-04-2023 12:30:00 Mukesh Control Room Suvali- (Yash Patel) 1 min 12 sec

Control room barmer(Crude


50 10-04-2023 15:10:00 Sachin 1 min 15 sec
teamsecurity(vikram)
51 10-04-2023 15:29:00 Sachin Suvali Service engineer(Kunj) 1 min 45 sec

52 10-04-2023 16:22:00 Sachin Abhilash sir (IT HEAD vedanta) 1 min 32 sec

Control room barmer(Crude


53 10-04-2023 16:54:00 Sachin 1 min 04 sec
teamsecurity(vikram)

54 10-04-2023 17:35:00 Sachin Barmer Service engineer(Lumba) 1 min 07sec


Control room barmer(Crude
55 10-04-2023 17:37:00 Sachin 30 sec
teamsecurity(Govind)

Suvali Vehicle Tracking System


56 10-04-2023 18:07:00 Sachin 5 min 31 sec
(Jigar)

57 10-04-2023 18:26:00 Sachin Abhilash sir (IT HEAD vedanta) 3 min 13 sec

58 11-04-2023 08:35:00 Mukesh Barmer Control Room (Govind) 2 min 44 sec


59 11-04-2023 10:41:00 Mukesh ASO-kuldeep Sir (Barmer/Tanker) 1 min 47 sec

60 11-04-2023 11:08:00 Mukesh Service Engg.. Kunj Suvali 3.min. 14

61 11-04-2023 11:10:00 Mukesh Service Engg… Lumbaram Barmer 1. Min 15

62 11-04-2023 15:08:00 Sachin Service Engg… Lumbaram Barmer 26 sec

63 11-04-2023 15:13:00 Sachin Service Engg… Lumbaram Barmer 1 min


64 11-04-2023 16:24:00 Sachin Service Engg.. Kunj Suvali 2 min 44 sec

65 11-04-2023 16:28:00 Sachin Service Engg.. Kunj Suvali 5 min

66 11-04-2023 16:51:00 Sachin Barmer Control Room (Govind) 1 min

67 11-04-2023 16:52:00 Sachin Barmer Control Room (Vikram) 1 min

68 11-04-2023 16:54:00 Sachin Barmer Control Room (Vikram) 1 min


69 11-04-2023 16:59:00 Sachin RTSO Suvali Abbas ali 1 min

70 11-04-2023 17:01:00 Sachin RTSO Suvali Abbas ali 1 min

71 11-04-2023 17:10:00 Sachin Barmer Passenger (hubi location) 2 min

72 11-04-2023 17:12:00 Sachin Service Engg… Lumbaram Barmer 1 min

73 11-04-2023 17:15:00 Sachin Laxman Service Engineer (Barmer) 2 min


74 11-04-2023 17:33:00 Sachin Laxman Service Engineer (Barmer) 3 min

75 11-04-2023 17:52:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min

76 11-04-2023 19:20:00 Sachin Laxman Service Engineer (Barmer) 1 min

77 12-04-2023 08:54:00 Mukesh Barmer Control Room (Rakesh 16 Sec


1 Min 23
78 12-04-2023 10:34:00 Mukesh Service Engg.. Suvali (Kunj)
Sec

1 Min 12
79 12-04-2023 10:37:00 Mukesh Service Engg…. Barmer (Lumbaram)
Sec

1 Min 12
80 12-04-2023 11:37:00 Mukesh Service Engg…. Barmer (Lumbaram)
Sec

1 Min 12
81 12-04-2023 10:37:00 Mukesh Abhilash sir (IT HEAD Of vedanta)
Sec
1 Min 12
82 12-04-2023 10:37:00 Mukesh RTSO Passenger (BomaRam)
Sec

83 12-04-2023 14:28:00 Sachin Suvali Service engineer(Kunj) 2 min

84 12-04-2023 14:45:00 Sachin Barmer Control Room (Rakesh 1 min

85 12-04-2023 14:57:00 Sachin Barmer Control Room (Rakesh 1 min


86 12-04-2023 15:02:00 Sachin Suvali Service engineer(Kunj) 2 min

87 12-04-2023 15:05:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min

88 12-04-2023 15:09:00 Sachin Suvali Service engineer(Kunj) 1 min

89 12-04-2023 15:12:00 Sachin Suvali Service engineer(Kunj) 2 min


90 12-04-2023 15:38:00 Sachin Service Engg…. Barmer (Lumbaram) 1 min

91 12-04-2023 15:43:00 Sachin Service Engg…. Barmer (Lumbaram) 2 min

92 12-04-2023 15:42:00 Sachin Abhilash sir (IT HEAD Of vedanta) 1 min

Dharma regarding passenger panic


93 12-04-2023 15:47:00 Sachin 1 min
alert
Ashok Saran (call regarding 3209
94 12-04-2023 15:48:00 Sachin 1 min
passenger panic alert

Ashok Saran (call regarding 3209


95 12-04-2023 15:54:00 Sachin 1 min
passenger panic alert

96 12-04-2023 16:39:00 Sachin Barmer Control Room (Rakesh 1 min

97 12-04-2023 17:06:00 Sachin Laxman Service Engineer (Barmer) 2 min

98 12-04-2023 17:29:00 Sachin Laxman Service Engineer (Barmer) 4 min


99 12-04-2023 18:16:00 Sachin Laxman Service Engineer (Barmer) 3 min

100 12-04-2023 18:33:00 Sachin Abhilash sir (IT HEAD Of vedanta) 3 min

101 13-04-2023 09:18:00 Sachin Suvali Service engineer(Kunj) 1 min

102 13-04-2023 10:11:00 Mukesh Suvali Service engineer(Laxman ) 8 min


103 13-04-2023 10:53:00 Mukesh Abhilash sir (IT HEAD Of vedanta) 2 min

Security Control Room Barmer


104 13-04-2023 11:07:00 Mukesh 1 Min
(Rakesh)

Security Control Room Barmer


105 13-04-2023 15:03:00 Sachin 1 Min
(Rakesh)

Security Control Room Barmer


106 13-04-2023 15:37:00 Sachin 1 Min
(Rakesh)
Security Control Room Barmer
107 13-04-2023 15:48:00 Sachin 1 Min
(Rakesh)

Security Control Room Barmer


108 13-04-2023 16:25:00 Sachin 1 Min
(Rakesh)

109 14-04-2023 08:41:00 Sudhir Mayuresh Berde 2 min

110 14-04-2023 08:43:00 Sudhir Laxman Service engg. 40 sec

111 14-04-2023 09:05:00 Sudhir Laxman Service engg. 12 min


112 14-04-2023 09:37:00 Sudhir Laxman Service engg. 2 min 15 sec

113 14-04-2023 14:00:00 Sudhir Guda Control Room 29 sec

Calling from SARA2 control room


114 14-04-2023 14:32:00 Sachin 2 min
team

Security Control Room Barmer


115 14-04-2023 16:27:00 Sachin 1 Min
(Rakesh)

Security Control Room Barmer


116 14-04-2023 16:42:00 Sachin 1 Min
(Rakesh)
Security Control Room Barmer
117 14-04-2023 16:47:00 Sachin 1 Min
(Rakesh)

118 14-04-2023 17:47:00 Sachin Laxman Service Engineer (Barmer) 4 min

Security Control Room Barmer


119 15-04-2023 10:17:00 Sudhir 40 sec
(Rakesh)

120 15-04-2023 15:12:00 Mukesh Suvali Service engineer(Kunj) 18 min

121 15-04-2023 15:10:00 Mukesh Abhilash sir (IT HEAD Of vedanta) 1 min
Security Control Room Barmer
122 15-04-2023 15:52:00 Mukesh 1 Min
(Rakesh)

123 15-04-2023 16:04PM Mukesh Suvali Service engineer(Kunj) 2 min

124 15-04-2023 17:31PM Mukesh Control Room Suvali (Abbas Ali) 2 min

Security Control Room Barmer


125 15-04-2023 17:35:00 PM Mukesh 1 Min
(Rakesh)

Security Control Room Barmer


126 15-04-2023 19:20:00 PM Mukesh 2 Min
(Vikram )
Security Control Room Barmer
127 15-04-2023 19:35:00 PM Mukesh 1 Min
(Vikram )

128 16-04-2023 19:35:00 PM Sachin Security Control Room Barmer 1 Min

129 16-04-2023 15:12:00 Mukesh Suvali Service engineer(Kunj) 1 min

Security Control Room Barmer


130 16-04-2023 17:35:00 PM Mukesh 2 Min
(Pushpendra)

Security Control Room Barmer


131 16-04-2023 17:35:00 PM Mukesh 2Min
(Vikram)
132 16-04-2023 19:5:00 PM Mukesh Laxman Service engg. 2Min

Security Control Room Barmer


133 16-04-2023 7:25PM Mukesh 2 Min
(Vikram )

134 17-04-2023 07:23:00 Sudhir Lumba Ram 1 min

135 17-04-2023 08:25:00 Sudhir Laxman Service engg. 1 min

136 17-04-2023 09:44:00 Sudhir Lumba Ram 1 min 44 sec


01 min 03
137 17-04-2023 11:53:00 Sudhir Suvali Jigar
sec

03 min 17
138 17-04-2023 11:54:00 Sudhir Kunj Suvali
sec

139 17-04-2023 01:40:48 Sudhir Kunj Suvali 1 min

140 17-04-2023 14:43:00 Sachin Lumba Ram 15 min

141 17-04-2023 15:06:00 Sachin Lumba Ram 6 Min


142 17-04-2023 15:12:00 Sachin Lumba Ram 1 min

143 17-04-2023 15:17:00 Sachin Lumba Ram 5 Min

144 17-04-2023 15:25:00 Sachin Lumba Ram 8 Min

145 17-04-2023 15:33:00 Sachin Lumba Ram 1 min

146 17-04-2023 16:11:00 Sachin Lumba Ram 1 min


147 17-04-2023 16:58:00 Sachin Lumba Ram 1 min

148 17-04-2023 18:24:00 Sachin Lumba Ram 2 Min

Security Control Room


149 17-04-2023 15:47:00 Sachin 1 min
Barmer(Rakesh

Security Control Room


150 17-04-2023 16:44:00 Sachin 1 min
Barmer(Rakesh

Security Control Room


151 17-04-2023 16:48:00 Sachin 1 min
Barmer(Rakesh
Security Control Room
152 17-04-2023 17:17:00 Sachin 1 min
Barmer(Rakesh

Security Control Room


153 17-04-2023 17:38:00 Sachin 5 Min
Barmer(Rakesh

Security Control Room


154 17-04-2023 18:54:00 Sachin 1 min
Barmer(Rakesh

01 min 22
155 18-04-2023 09:14:00 Sudhir Lumba Ram
sec
Security Control Room 02 min 44
156 18-04-2023 10:33:00 Sudhir
Barmer(Rakesh sec

Security Control Room 01 min 42


157 18-04-2023 10:52:00 Sudhir
Barmer(Rakesh sec

158 18-04-2023 11:40:00 Sudhir Lumba Ram 01 min 6 sec

Security Control Room


159 18-04-2023 13:32:00 Sudhir 46 sec
Barmer(Rakesh
Security Control Room
160 18-04-2023 13:53:00 Sudhir 46 sec
Barmer(Rakesh

161 18-04-2023 13:59:00 Sudhir Guda (Ravi) 50 sec

162 18-04-2023 14:03:00 Sudhir Guda (Ravi) 46 sec

Security Control Room


163 18-04-2023 14:08:00 Sudhir 1 min
Barmer(Rakesh

Security Control Room


164 18-04-2023 14:10:00 Sudhir 1 min
Barmer(Rakesh
165 18-04-2023 14:19:00 Sachin Guda (Ravi) 1 min

166 18-04-2023 14:28:00 Sachin Guda (Ravi) 1 min

Security Control Room


167 18-04-2023 14:20:00 Sachin 1 min
Barmer(Rakesh

Security Control Room


168 18-04-2023 14:25:00 Sachin 2 Min
Barmer(Rakesh

Security Control Room


169 18-04-2023 15:08:00 Sachin 1 min
Barmer(Rakesh
Security Control Room
170 18-04-2023 15:16:00 Sachin 1 min
Barmer(Rakesh

171 18-04-2023 17:37:00 Sachin Laxman Service engg. 1 min

172 18-04-2023 17:46:00 Sachin Laxman Service engg. 4 min

Security Control Room


173 18-04-2023 19:48:00 Sachin 1 min
Barmer(Rakesh
174 19-04-2023 09:16:00 Sudhir Laxman Service engg. 2 min 5 sec

175 19-04-2023 10:37:00 Sudhir Laxman Service engg. 2 min

01 min 36
176 19-04-2023 11:51:00 Sudhir Laxman Service engg.
sec

177 19-04-2023 12:27:00 Sudhir Laxman Service engg. 31 sec

178 19-04-2023 13:39:00 Sudhir Guda (Ravi) 1 min


179 19-04-2023 15:10:00 Sachin Security Control Room Barmer 1 min

180 19-04-2023 14:40:00 Sachin Laxman Service engg. 3 min

181 19-04-2023 16:04:00 Sachin Laxman Service engg. 2 min

182 19-04-2023 16:10:00 Sachin Laxman Service engg. 4 min


183 19-04-2023 16:30:00 Sachin Laxman Service engg. 1 min

184 19-04-2023 16:38:00 Sachin Laxman Service engg. 1 min

185 19-04-2023 17:27:00 Sachin Laxman Service engg. 2 min

186 19-04-2023 17:40:00 Sachin Laxman Service engg. 2 min

187 19-04-2023 17:46:00 Sachin Laxman Service engg. 1 min


188 19-04-2023 17:50:00 Sachin Laxman Service engg. 10 Min

189 19-04-2023 18:04:00 Sachin Laxman Service engg. 2 min

190 19-04-2023 18:00:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min

191 19-04-2023 18:09:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min

192 19-04-2023 18:14:00 Sachin Security Control Room Barmer 3 min


193 19-04-2023 18:56:00 Sachin Abhilash sir (IT HEAD Of vedanta) 1 min

194 19-04-2023 19:53:00 Sachin Security Control Room Barmer 2 min

195 20-04-2023 10:22:00 Sudhir Laxman Service engg. 2 min

196 20-04-2023 11:54:00 Sudhir Parthapritam Assam region 2 min 14 sec

197 20-04-2023 12:16:00 Sudhir Parthapritam Assam region 1 min 40 sec


198 20-04-2023 12:39:00 Sudhir Parthapritam Assam region 1 min 33 sec

199 20-04-2023 15:08:00 Sachin Security Control Room Barmer 1 min

200 20-04-2023 15:28:00 Sachin Parthapritam Assam region 2 min

Parthapritam Assam region(Service


201 20-04-2023 15:35:00 Sachin 2 min
engineer)
Parthapritam Assam region(Service
202 20-04-2023 15:44:00 Sachin 1 min
engineer)

Parthapritam Assam region(Service


203 20-04-2023 15:53:00 Sachin 1 min
engineer)

204 20-04-2023 17:10:00 Sachin Laxman Service engg. 4 min

205 20-04-2023 17:34:00 Sachin Suvali Service engineer(Kunj) 1 min


206 20-04-2023 17:40:00 Sachin Abhilash sir (IT HEAD Of vedanta) 1 min

207 20-04-2023 17:45:00 Sachin Suvali Service engineer(Kunj) 1 min

208 20-04-2023 17:44:00 Sachin Abbas RTSO Suvali 1 min

209 20-04-2023 18:14:00 Sachin Laxman Service engg. 1 min

210 20-04-2023 18:24:00 Sachin Laxman Service engg. 1 min


211 20-04-2023 19:31:00 Sachin Security Control Room Barmer 1 min

212 20-04-2023 19:33:00 Sachin Security Control Room Barmer 1 min

213 21-04-2023 07:31:00 Sachin Laxman Service engg. 3 min

214 21-04-2023 08:09:00 Sachin Suvali Service engineer(Kunj) 1 min

215 21-04-2023 08:20:00 Sachin Suvali Service engineer(Kunj) 7 min


216 21-04-2023 10:37:00 Sachin Suvali Service engineer(Kunj) 2 min

217 21-04-2023 10:45:00 Sachin Suvali Service engineer(Kunj) 1 min

218 21-04-2023 10:46:00 Sachin Raag Oil 1 Control Room 1 min

219 21-04-2023 13:46:00 Sachin From SARA Control room 2 min

220 21-04-2023 13:53:00 Sachin From SARA Control room 1 min


221 21-04-2023 13:54:00 Sachin Security Control Room Barmer 2 min

222 21-04-2023 15:01:00 Sudhir Security Control Room Barmer 1 min

223 21-04-2023 15:09:00 Sudhir Kunj Suvali 1 min

224 21-04-2023 18:26:00 Sudhir Security Control Room Barmer 1 min

225 21-04-2023 19:33:00 Sudhir Laxman Service engg. 2 min


226 21-04-2023 19:51:00 Sudhir Laxman Service engg. 2 min

227 21-04-2023 19:59:00 Sudhir Laxman Service engg. 1 min

228 21-04-2023 22:05:00 Mukesh Laxman Service engg. 1 min

Security Control Room Barmer


229 22-04-2023 08:05:00 Mukesh 1 Min
Pushpendra )

230 22-04-2023 09:15:00 Mukesh Suvali Service engineer(Kunj) 2 min


231 22-04-2023 14:15:00 AM Mukesh Suvali Service engineer(Kunj) 2 min

232 22-04-2023 14:23:00 Sudhir Sara2 control Room 1 min

233 22-04-2023 14:31:00 Sudhir Sara2 control Room 1 min

234 22-04-2023 14:37:00 Sudhir Laxman Service engg. 23 min

235 22-04-2023 15:53:00 Sudhir Security Control Room Barmer 1 min


236 22-04-2023 16:02:00 Sudhir Radio officer Barmer 2 min

237 22-04-2023 16:04:00 Sudhir Laxman Service engg. 1 min

238 22-04-2023 16:09:00 Sudhir Radio officer Barmer 1 min

239 22-04-2023 16:39:00 Sudhir Security Control Room Barmer 1 min

240 22-04-2023 16:57:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
241 22-04-2023 17:14:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min

242 22-04-2023 17:26:00 Sudhir Laxman Service engg. 3 min

243 22-04-2023 17:29:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min

244 22-04-2023 17:34:00 Sudhir Security Control Room Barmer 1 min

245 22-04-2023 17:35:00 Sudhir Security Control Room Barmer 1 min


246 22-04-2023 18:17:00 Sudhir Security Control Room Barmer 1 min

247 22-04-2023 20:05:00 Sudhir Security Control Room Barmer 1 min

248 22-04-2023 20:10:00 Sudhir Laxman Service engg. 1 min

249 22-04-2023 20:20:00 Sudhir Laxman Service engg. 1 min

250 23-04-2023 10:40:00 Mukesh Laxman Service engg. 1 min


251 23-04-2023 10:45:00 Mukesh Abhilash sir (IT HEAD Of vedanta) 1 min

252 23-04-2023 11:05:00 Mukesh Control Room Bomaram (vedanta) 1 min

253 23-04-2023 11:05:00 Mukesh Laxman Service engg. 1 min

254 23-04-2023 13:36:00 Pm Mukesh Control Room Sara 2 (Saurab) 1 min

255 23-04-2023 16:48:00 Sachin Security Control Room Barmer 1 min


256 23-04-2023 16:49:00 Sachin Security Control Room Barmer 1 min

257 23-04-2023 16:50:00 Sachin Kuldeep sir (Crude security team) 1 min

258 23-04-2023 18:31:00 Sachin Kuldeep sir (Crude security team) 1 min

259 23-04-2023 18:37:00 Sachin Laxman Service engg. 2 min

260 24-04-2023 08:38:00 Sudhir Laxman Service engg. 2 min


261 24-04-2023 09:15:00 Sudhir Laxman Service engg. 1 min

Calling from SARA2 control room


262 24-04-2023 14:06:00 Sudhir 1 min
team

Calling from SARA2 control room


263 24-04-2023 14:06:00 Sudhir 3 min
team

264 24-04-2023 14:10:00 Sudhir Security Control Room Barmer 1 min

265 24-04-2023 14:11:00 Sudhir Security Control Room Barmer 1 min


266 24-04-2023 14:26:00 Sudhir Prithvi Singh 3 min

267 24-04-2023 16:06:00 Sachin Yash Patel Suvali 2 min

268 24-04-2023 16:48:00 Sachin Kuldeep sir (Crude security team) 1 min

269 24-04-2023 16:53:00 Sachin Kuldeep sir (Crude security team) 1 min
270 24-04-2023 17:08:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min

Security Control Room Barmer


271 24-04-2023 17:08:00 Sachin 2 min
(Govind)

272 24-04-2023 18:01:00 Sachin Laxman Service engg. 1 min

273 24-04-2023 18:08:00 Sachin Laxman Service engg. 2 min

274 24-04-2023 18:21:00 Sachin Kunj Suvali 1 min


275 24-04-2023 18:45:00 Sachin Kuldeep sir (Crude security team) 1 min

276 25-04-2023 09:27:00 Sudhir Suvali Service engineer(Kunj) 1 min

277 25-04-2023 09:31:00 Sudhir Security Control Room Barmer 1 min

278 25-04-2023 10:39:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min

279 25-04-2023 10:42:00 Sudhir Security Control Room Barmer 1 min


280 25-04-2023 10:49:00 Sudhir Laxman Service engg. 1 min

281 25-04-2023 11:21:00 Sudhir Prithvi Singh 1 min

282 25-04-2023 11:53:00 Sudhir Laxman Service engg. 1 min

283 25-04-2023 12:27:00 Sudhir Laxman Service engg. 1 min

284 25-04-2023 13:30:00 Sudhir Kunj Suvali 2 min


285 25-04-2023 13:52:00 Sachin Kunj Suvali 1 min

286 25-04-2023 14:51:00 Sachin Laxman Service engg. 1 min

287 25-04-2023 14:52:00 Sachin Laxman Service engg. 1 min

288 25-04-2023 15:32:00 Sachin RTSO supervisor Passenger Barmer 1 min

289 25-04-2023 16:54:00 Sachin Laxman Service engg. 1 min


290 25-04-2023 16:55:00 Sachin Laxman Service engg. 3 min

291 25-04-2023 16:59:00 Sachin Laxman Service engg. 2 min

292 25-04-2023 18:43:00 Sachin Security Control Room Barmer 1 min

293 26-04-2023 07:51:00 Sudhir Laxman Service engg. 1 min

294 26-04-2023 08:35:00 Sudhir Laxman Service engg. 2 min


295 26-04-2023 08:54:00 Sudhir Laxman Service engg. 3 min

296 26-04-2023 09:16:00 Sudhir Kunj Suvali 1 min

297 26-04-2023 09:43:00 Sudhir Kunj Suvali 1 min

298 26-04-2023 10:12:00 Sudhir Laxman Service engg. 1 min

299 26-04-2023 10:24:00 Sudhir Kunj Suvali 1 min


300 26-04-2023 10:35:00 Sudhir Security Control Room Barmer 2 min

301 26-04-2023 10:43:00 Sudhir Laxman Service engg. 2 min

302 26-04-2023 10:49:00 Sudhir Laxman Service engg. 2 min

303 26-04-2023 11:31:00 Sudhir Sara2 control Room 1 min

304 26-04-2023 11:32:00 Sudhir Laxman Service engg. 1 min


305 26-04-2023 12:07:00 Sudhir Laxman Service engg. 8 min

306 26-04-2023 14:40:00 Sachin Laxman Service engg. 2 min

307 26-04-2023 15:48:00 Sachin Laxman Service engg. 1 min

308 26-04-2023 16:06:00 Sachin Security Control Room Barmer 1 min

309 26-04-2023 16:17:00 Sachin Security Control Room Barmer 1 min


310 26-04-2023 16:19:00 Sachin Security Control Room Barmer 1 min

311 26-04-2023 16:21:00 Sachin Laxman Service engg. 4 min

312 26-04-2023 16:31:00 Sachin Kuldeep sir (Crude security team) 1 min

313 26-04-2023 17:46:00 Sachin Kuldeep sir (Crude security team) 1 min

314 26-04-2023 17:47:00 Sachin Kuldeep sir (Crude security team) 1 min
315 26-04-2023 17:47:00 Sachin Kuldeep sir (Crude security team) 1 min

316 26-04-2023 18:14:00 Sachin Laxman Service engg. 2 min

317 26-04-2023 18:18:00 Sachin Kuldeep sir (Crude security team) 1 min

318 26-04-2023 18:58:00 Sachin Laxman Service engg. 4 min

319 26-04-2023 19:49:00 Sachin Laxman Service engg. 1 min


320 26-04-2023 19:53:00 Sachin Laxman Service engg. 3 min

321 27-04-2023 09:54:00 Sudhir Laxman Service engg. 5 min

322 27-04-2023 10:04:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 3 min

323 27-04-2023 10:12:00 Sudhir Amit Salaria 2 min

324 27-04-2023 10:34:00 Sudhir Kunj Suvali 1 min


325 27-04-2023 10:45:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min

326 27-04-2023 10:59:00 Sudhir Kunj Suvali 1 min

327 27-04-2023 12:48:00 Sudhir Laxman Service engg. 1 min

328 27-04-2023 13:47:00 Sudhir Kunj Suvali 1 min

329 27-04-2023 13:56:00 Sudhir Laxman Service engg. 2 min


330 27-04-2023 14:51:00 Sachin Raag Oil 1 Control Room 1 min

331 27-04-2023 16:27:00 Sachin Laxman Service engg. 1 min

332 27-04-2023 16:29:00 Sachin Laxman Service engg. 1 min

333 27-04-2023 16:45:00 Sachin Kuldeep sir (Crude security team) 1 min

334 27-04-2023 16:56:00 Sachin Kuldeep sir (Crude security team) 1 min
335 27-04-2023 17:01:00 Sachin Kuldeep sir (Crude security team) 1 min

336 27-04-2023 17:00:00 Sachin Call from Tuka Trip 1 min

337 27-04-2023 17:09:00 Sachin Laxman Service engg. 1 min

338 28-04-2023 10:52:00 Sudhir Laxman Service engg. 1 min

339 28-04-2023 11:03:00 Sudhir Kunj Suvali 1 min


340 28-04-2023 11:06:00 Sudhir Kunj Suvali 1 min

341 28-04-2023 11:06:00 Sudhir Kunj Suvali 1 min

342 28-04-2023 11:26:00 Sudhir Kunj Suvali 1 min

343 28-04-2023 12:00:00 Sudhir Sara2 control Room 1 min

344 28-04-2023 12:29:00 Sudhir Laxman Service engg. 1 min


345 28-04-2023 14:08:00 Sudhir Raag Oil 1 Control Room 1 min

346 28-04-2023 14:51:00 Sachin Security Control Room Barmer 1 min

Call from Tanker installtion (tanker


347 28-04-2023 15:54:00 Sachin 1 min
Owner)

Call from Tanker installtion (tanker


348 28-04-2023 15:56:00 Sachin 2 min
Owner)
Call from Tanker installtion (tanker
349 28-04-2023 16:44:00 Sachin 1 min
Owner)

350 28-04-2023 16:01:00 Sachin Abhilash sir (IT HEAD Of vedanta) 3 min

351 28-04-2023 16:22:00 Sachin Abhilash sir (IT HEAD Of vedanta) 1 min

352 28-04-2023 16:58:00 Sachin Abhilash sir (IT HEAD Of vedanta) 1 min
Call from Tanker installtion (tanker
353 28-04-2023 16:59:00 Sachin 2 min
Owner)

354 28-04-2023 14:40:00 Sachin Laxman Service engg. 1 min

355 28-04-2023 14:43:00 Sachin Laxman Service engg. 8 min

356 28-04-2023 14:56:00 Sachin Laxman Service engg. 2 min

357 28-04-2023 15:02:00 Sachin Laxman Service engg. 1 min


358 28-04-2023 15:05:00 Sachin Laxman Service engg. 13 min

359 28-04-2023 15:17:00 Sachin Laxman Service engg. 1 min

360 28-04-2023 15:18:00 Sachin Laxman Service engg. 9 min

361 28-04-2023 15:29:00 Sachin Laxman Service engg. 1 min

362 28-04-2023 15:59:00 Sachin Laxman Service engg. 2 min


363 28-04-2023 17:02:00 Sachin Laxman Service engg. 3 min

364 28-04-2023 17:05:00 Sachin Kuldeep sir (Crude security team) 1 min

365 28-04-2023 17:14:00 Sachin Kuldeep sir (Crude security team) 1 min

366 28-04-2023 17:18:00 Sachin Abhilash sir (IT HEAD Of vedanta) 3 min

367 29-04-2023 09:50:00 Sudhir Pratik (hpcl/bpcl) 1 min


368 29-04-2023 10:28:00 Sudhir Guda Control Room 1 min

369 29-04-2023 14:58:00 Mukesh Contral Room Sara 1 min

370 29-04-2023 14:56:00 PM Mukesh Sara control Room 2 min

371 29-04-2023 18:21:00 Mukesh Laxman Service engg. 1 min

372 29-04-2023 18:02:00 Mukesh Kuldeep sir (Crude security team) 1 min
373 30-04-2023 08:41:00 Mukesh Laxman Service engg. 1 min

Control Room Barmer (RTSO-


374 30-04-2023 10:30:00 Mukesh 1 min
Dhhrma)

375 30-04-2023 14:51:00 Sachin Security Control Room Barmer 1 min

376 30-04-2023 14:51:00 Sachin Kuldeep sir (Crude security team) 1 min

377 30-04-2023 17:16:00 Sachin Kuldeep sir (Crude security team) 1 min
378 30-04-2023 18:32:00 Sachin Laxman Service engg. 1 min

379 01-05-2023 07:14:00 Mukesh Kunj Suvali Service Engg.. 40 min

380 01-05-2023 07:40:00 Mukesh Contol Room Suvali (Jigar ) 2 min

381 01-05-2023 10:25:00 Mukesh Laxman Service engg. 2 min

382 01-05-2023 12:51:00 Mukesh Control Room Sara. 1 min


383 01-05-2023 14:43:00 Sachin Kuldeep sir (Crude security team) 1 min

384 01-05-2023 15:35:00 Sachin Kuldeep sir (Crude security team) 1 min

385 01-05-2023 16:13:00 Sachin Kuldeep sir (Crude security team) 1 min

386 01-05-2023 16:15:00 Sachin Kuldeep sir (Crude security team) 1 min

387 01-05-2023 17:39:00 Sachin Kuldeep sir (Crude security team) 1 min
388 01-05-2023 17:32:00 Sachin Laxman Service engg. 3 min

389 02-05-2023 8:56Am Mukesh Govind (Barmer sec. control Room) 2 min

390 02-05-2023 9:18:00Am Mukesh Abas Ali (Suvali. control Room) 2 min

391 02-05-2023 10:40:00 Mukesh Control Room Saara 1 1 min

392 02-05-2023 10:40:00 Mukesh Control Room Saara 2 1 min


393 02-05-2023 11:10:00 Mukesh Kunj Suvali Service Engg.. 3 min

394 02-05-2023 12:43:00 Mukesh Security Control Room Barmer 1 min

395 02-05-2023 14:51:00 Sachin Security Control Room Barmer 1 min

396 02-05-2023 16:05:00 Sachin Laxman Service engg. 5 min

397 02-05-2023 16:16:00 Sachin Security Control Room Barmer 3 min


398 02-05-2023 16:46:00 Sachin Kuldeep sir (Crude security team) 1 min

399 02-05-2023 17:27:00 Sachin Kuldeep sir (Crude security team) 3 min

400 02-05-2023 17:40:00 Sachin Security Control Room Barmer 3 min

401 02-05-2023 17:45:00 Sachin Security Control Room Barmer 3 min


402 02-05-2023 16:46:00 Sachin Kuldeep sir (Crude security team) 1 min

403 02-05-2023 17:27:00 Sachin Kuldeep sir (Crude security team) 3 min

404 02-05-2023 18:42:00 Sachin Kuldeep sir (Crude security team) 1 min

405 02-05-2023 18:45:00 Sachin Kuldeep sir (Crude security team) 1 min

406 02-05-2023 18:45:00 Sachin Kuldeep sir (Crude security team) 1 min
407 02-05-2023 18:43:00 Sachin Laxman Service engg. 1 min

408 02-05-2023 18:46:00 Sachin Laxman Service engg. 1 min

409 02-05-2023 19:31:00 Sachin Abhilash sir (IT HEAD Of vedanta) 3 min

410 02-05-2023 19:51:00 Sachin Laxman Service engg. 1 min

411 02-05-2023 19:53:00 Sachin Laxman Service engg. 1 min


412 02-05-2023 20:05:00 Sachin Laxman Service engg. 2 min

413 03-05-2023 20:14:00 Sachin Laxman Service engg. 7 min

414 03-05-2023 07:13:00 Sachin Security Control Room Barmer 1 min

415 03-05-2023 07:11:00 Sachin Kuldeep sir (Crude security team) 1 min

416 03-05-2023 12:08:00 Sachin Call from Tuka 1Z location 1 min


417 03-05-2023 12:08:00 Sachin Call from SARA 2 location 2 min

418 03-05-2023 12:11:00 Sachin Call from SARA 2 location 1 min

419 03-05-2023 16:19:00 Sudhir Kuldeep sir (Crude security team) 1 min

420 03-05-2023 17:47:00 Sudhir Laxman Service engg. 1 min

421 03-05-2023 17:50:00 Sudhir Laxman Service engg. 1 min


422 03-05-2023 18:13:00 Sudhir Kuldeep sir (Crude security team) 1 min

423 03-05-2023 18:27:00 Sudhir Laxman Service engg. 2 min

424 03-05-2023 18:50:00 Sudhir Laxman Service engg. 2 min

425 03-05-2023 19:05:00 Sudhir Laxman Service engg. 1 min

426 03-05-2023 19:47:00 Sudhir Laxman Service engg. 2 min


427 04-05-2023 09:47:00 Sudhir Security Control Room Barmer 1 min

428 04-05-2023 11:03:00 Sudhir Laxman Service engg. 4 min

429 04-05-2023 13:09:00 Sudhir Tuka 1Z control Room 1 min

430 04-05-2023 15:10:00 Sudhir Kuldeep sir (Crude security team) 1 min

431 04-05-2023 15:48:00 Sudhir Kuldeep sir (Crude security team) 2 min
432 04-05-2023 16:16:00 Sudhir Kuldeep sir (Crude security team) 1 min

433 04-05-2023 16:19:00 Sudhir Kuldeep sir (Crude security team) 3 min

434 04-05-2023 18:02:00 Sudhir Laxman Service engg. 1 min

435 05-05-2023 10:09:00 Sachin Sara 1 control Room 1 min

436 05-05-2023 10:10:00 Sachin Sara 1 control Room 2 min


437 05-05-2023 10:17:00 Sachin Sara 1 control Room 1 min

438 05-05-2023 11:27:00 Sachin Security Control Room Barmer 1 min

439 05-05-2023 11:31:00 Sachin Security Control Room Barmer 1 min

440 05-05-2023 14:40:00 Sudhir Security Control Room Barmer 1 min

441 05-05-2023 16:07:00 Sudhir Security Control Room Barmer 1 min


442 05-05-2023 16:40:00 Sudhir Security Control Room Barmer 1 min

443 05-05-2023 17:23:00 Sudhir Laxman Service engg. 2 min

444 05-05-2023 18:13:00 Sudhir Security Control Room Barmer 1 min

445 05-05-2023 18:23:00 Sudhir Security Control Room Barmer 1 min

446 05-05-2023 19:46:00 Sudhir Laxman Service engg. 1 min


447 06-05-2023 14:28:00 Sudhir Security Control Room Barmer 2 min

448 06-05-2023 14:56:00 Sudhir Tuka 1Z control Room 1min

449 06-05-2023 16:58:00 Sudhir Lumba Ram 2 min

450 06-05-2023 17:04:00 Sudhir Security Control Room Barmer 4 min

451 06-05-2023 17:11:00 Sudhir Security Control Room Barmer 2 min


452 06-05-2023 17:17:00 Sudhir Security Control Room Barmer 1 min

453 06-05-2023 17:24:00 Sudhir Lumba Ram 1 min

454 06-05-2023 17:37:00 Sudhir Lumba Ram 1 min

455 06-05-2023 17:39:00 Sudhir Lumba Ram 1 min

456 06-05-2023 17:48:00 Sudhir Lumba Ram 12 min


457 06-05-2023 19:03:00 Sudhir Lumba Ram 1 min

458 06-05-2023 10:38:00 Mukesh Security Control Room Barmer 1 min

459 06-05-2023 13:52:00 Mukesh Security Control Room Barmer 1 min

460 06-05-2023 14:02:00 Mukesh Security Control Room Barmer 1 min

461 06-05-2023 07:13:00 Mukesh Laxman Service engg. 1 min


462 06-05-2023 07:13:00 Mukesh Laxman Service engg. 1 min

463 07-05-2023 09:35:00 Mukesh Security Control Room Barmer 1 min

464 07-05-2023 13:34:00 Mukesh Control Room Raag Oil 1 1 min

465 07-05-2023 15:39:00 Sachin Barmer Passenger(Hukma ram) 3 min

466 07-05-2023 16:08:00 Sachin Kuldeep sir (Crude security team) 1 min
467 07-05-2023 16:16:00 Sachin Laxman Service engg. 1 min

468 07-05-2023 17:37:00 Sachin Kuldeep sir (Crude security team) 1 min

469 07-05-2023 17:46:00 Sachin Kuldeep sir (Crude security team) 1 min

470 07-05-2023 19:07:00 Sachin Laxman Service engg. 1 min

471 08-05-2023 08:53:00 Sachin Security Control Room Barmer 1 min


472 08-05-2023 08:56:00 Sachin Security Control Room Barmer 1 min

473 08-05-2023 09:50:00 Sachin Laxman Service engg. 3 min

474 08-05-2023 10:47:00 Sachin Laxman Service engg. 3 min

475 08-05-2023 11:10:00 Sachin Call from SARA location 1 min

476 08-05-2023 11:18:00 Sachin Kunj Suvali Service Engg.. 3 min


477 08-05-2023 11:19:00 Sachin Kunj Suvali Service Engg.. 1 min

478 08-05-2023 11:36:00 Sachin Kunj Suvali Service Engg.. 1 min

479 08-05-2023 11:42:00 Sachin Kunj Suvali Service Engg.. 1 min

480 08-05-2023 11:46:00 Sachin Kunj Suvali Service Engg.. 1 min


481 08-05-2023 00:56:00 Sachin Laxman Service engg. 1 min

482 08-05-2023 15:04:00 Sudhir Laxman Service engg. 1 min

483 08-05-2023 16:48:00 Sudhir Security Control Room Barmer 2 min

484 08-05-2023 18:10:00 Sudhir Security Control Room Barmer 1 min

485 08-05-2023 18:20:00 Sudhir Security Control Room Barmer 1 min


486 08-05-2023 18:32:00 Sudhir Lumba Ram 1 min

487 08-05-2023 18:45:00 Sudhir Lumba Ram 1 min

488 08-05-2023 18:55:00 Sudhir Lumba Ram 2 min

489 08-05-2023 19:02:00 Sudhir Lumba Ram 1 min

490 08-05-2023 19:12:00 Sudhir Lumba Ram 2 min


491 08-05-2023 19:16:00 Sudhir Lumba Ram 6 min

492 09-05-2023 09:45:00 Sachin Lumba Ram 2 min

493 09-05-2023 09:52:00 Sachin Lumba Ram 1 min

494 09-05-2023 09:49:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min

495 09-05-2023 10:05:00 Sachin Raag Oil 1 Control Room 1 min


496 09-05-2023 10:35:00 Sachin Lumba Ram 1 min

497 09-05-2023 10:37:00 Sachin Lumba Ram 1 min

498 09-05-2023 10:50:00 Sachin Lumba Ram 16 min

499 09-05-2023 11:00:00 Sachin Lumba Ram 2 min

500 09-05-2023 00:43:00 Sachin Abhilash sir (IT HEAD Of vedanta) 2 min
501 09-05-2023 13:09:00 Sachin Kuldeep sir (Crude security team) 1 min

502 09-05-2023 13:12:00 Sachin Kuldeep sir (Crude security team) 1 min

Mutthu kumar(Raag Oil 1 Control


503 09-05-2023 13:33:00 Sachin 2 min
Room)

Mutthu kumar(Raag Oil 1 Control


504 09-05-2023 13:40:00 Sachin 2 min
Room)
505 09-05-2023 13:52:00 Sachin Prithvi sir 1 min

506 09-05-2023 15:04:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 2 min

507 09-05-2023 15:09:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 2 min

508 09-05-2023 15:35:00 Sudhir Kuldeep sir (Crude security team) 1 min

509 09-05-2023 15:42:00 Sudhir Kuldeep sir (Crude security team) 1 min
510 09-05-2023 15:43:00 Sudhir Kuldeep sir (Crude security team) 1 min

511 09-05-2023 16:42:00 Sudhir Kuldeep sir (Crude security team) 1 min

512 09-05-2023 16:45:00 Sudhir Kuldeep sir (Crude security team) 1 min

513 09-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 1 min

514 09-05-2023 16:49:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min
515 09-05-2023 16:53:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min

516 09-05-2023 16:55:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min

517 09-05-2023 16:58:00 Sudhir Abhilash sir (IT HEAD Of vedanta) 1 min

518 09-05-2023 17:00:00 Sudhir Laxman Service engg. 2 min

519 09-05-2023 17:21:00 Sudhir Kuldeep sir (Crude security team) 1 min
520 09-05-2023 17:22:00 Sudhir Kuldeep sir (Crude security team) 1 min

521 09-05-2023 18:37:00 Sudhir Laxman Service engg. 2 min

522 10-05-2023 10:27:00 Sachin Abhilash sir (IT HEAD Of vedanta) 4 min

523 10-05-2023 11:32:00 Sachin Amit Salaria 1 min


524 10-05-2023 11:33:00 Sachin Laxman Service engg. 2 min

525 10-05-2023 12:19:00 Sachin Laxman Service engg. 4 min

526 10-05-2023 12:47:00 Sachin Laxman Service engg. 2 min

527 10-05-2023 12:54:00 Sachin Balkishan 4 min


528 10-05-2023 13:23:00 Sachin Raag Oil 1 Control Room 1 min

529 10-05-2023 13:26:00 Sachin Lumba Ram 2 min

530 10-05-2023 13:35:00 Sachin Raag Oil 1 Control Room 1 min

531 10-05-2023 15:03:00 Sudhir Kuldeep sir (Crude security team) 1 min

532 10-05-2023 15:07:00 Sudhir Kuldeep sir (Crude security team) 1 min
533 10-05-2023 15:27:00 Sudhir Lumba Ram 1 min

534 10-05-2023 16:04:00 Sudhir Lumba Ram 2 min

535 10-05-2023 16:21:00 Sudhir Lumba Ram 1 min

536 10-05-2023 16:30:00 Sudhir Lumba Ram 2 min

537 10-05-2023 16:42:00 Sudhir Lumba Ram 1 min


538 10-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 1 min

539 10-05-2023 16:47:00 Sudhir Kuldeep sir (Crude security team) 1 min

540 10-05-2023 16:52:00 Sudhir Kuldeep sir (Crude security team) 2 min

541 10-05-2023 17:11:00 Sudhir Kuldeep sir (Crude security team) 1 min

542 10-05-2023 18:50:00 Sudhir Laxman Service engg. 2 min


543 11-05-2023 12:17:00 Sachin Laxman Service engg. 3 min

544 11-05-2023 12:51:00 Sachin Laxman Service engg. 2 min

545 11-05-2023 12:43:00 Sachin Ashish IT 1 min

546 11-05-2023 12:50:00 Sachin Ashish IT 1 min

547 11-05-2023 15:13:00 Sudhir Security Control Room Barmer 1 min


548 11-05-2023 15:42:00 Sudhir Kuldeep sir (Crude security team) 2 min

549 11-05-2023 15:59:00 Sudhir Tuka 1Z control Room 1 min

550 11-05-2023 16:01:00 Sudhir Kuldeep sir (Crude security team) 1 min

551 11-05-2023 16:04:00 Sudhir Kunj (Suvali Service engg.) 1 min

552 11-05-2023 16:13:00 Sudhir Kuldeep sir (Crude security team) 1 min
553 11-05-2023 16:21:00 Sudhir Kuldeep sir (Crude security team) 1 min

554 11-05-2023 16:22:00 Sudhir Kuldeep sir (Crude security team) 1 min

555 11-05-2023 18:26:00 Sudhir Lumba Ram 1 min

556 11-05-2023 18:34:00 Sudhir Kuldeep sir (Crude security team) 2 min

557 11-05-2023 18:40:00 Sudhir Kuldeep sir (Crude security team) 1 min
558 11-05-2023 18:45:00 Sudhir Lumba Ram 1 min

559 11-05-2023 20:13:00 Sudhir Lumba Ram 1 min

560 11-05-2023 20:55:00 Sudhir Lumba Ram 1 min

561 12-05-2023 10:41:00 Sachin Raag Oil 1 Control Room 1 min

562 12-05-2023 12:31:00 Sachin Laxman Service engg. 2 min


563 12-05-2023 12:53:00 Sachin Kunj (Suvali Service engg.) 1 min

564 12-05-2023 13:49:00 Sachin SARA 2 Nikhil 1 min

565 12-05-2023 14:26:00 Sudhir Tuka 1Z control Room 1 min

566 12-05-2023 16:12:00 Sudhir Kuldeep sir (Crude security team) 1 min

567 12-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 1 min
568 13-05-2023 17:33:00 Sudhir Laxman Service engg. 1 min

569 12-05-2023 18:12:00 Sudhir Kuldeep sir (Crude security team) 1 min

570 13-05-2023 15:52:00 Mukesh (Crude security team Barmer) 1 min

571 13-05-2023 15:56:00 Mukesh Kuldeep sir (Crude security team) 1 min

572 13-05-2023 17:36:00 Mukesh Service Eng.. Lumbaram Barmer 2 min


573 13-05-2023 18:29:00 Mukesh Kuldeep sir (Crude security team) 1 min

574 13-05-2023 19:11:00 Mukesh Laxman Service engg. 1 min

575 13-05-2023 19:13:00 Mukesh Kuldeep sir (Crude security team) 1 min

576 13-05-2023 19:16:00 Mukesh Service Eng.. Lumbaram Barmer 1 min

577 14-05-2023 No Calls . Mukesh No Calls . No Calls .


578 14-05-2023 15:41:00 Sudhir Kuldeep sir (Crude security team) 1 min

579 14-05-2023 16:41:00 Sudhir Kuldeep sir (Crude security team) 1 min

580 14-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 1 min

581 14-05-2023 17:44:00 Sudhir Kuldeep sir (Crude security team) 1 min

582 14-05-2023 17:48:00 Sudhir Laxman Service engg. 1 min


583 14-05-2023 18:05:00 Sudhir Kuldeep sir (Crude security team) 1 min

584 14-05-2023 18:28:00 Sudhir Laxman Service engg. 1 min

585 14-05-2023 19:14:00 Sudhir Laxman Service engg. 1 min

586 15-05-2023 09:26:00 Mukesh Laxman Service engg. 4 min

587 15-05-2023 09:28:00 Mukesh Lumbaram Service engg. 2 min


588 15-05-2023 09:34:00 Mukesh Control Room Raag Oil 1 1 min

589 15-05-2023 15:08:00 Sudhir Kuldeep sir (Crude security team) 1 min

590 15-05-2023 15:25:00 Sudhir Kuldeep sir (Crude security team) 1 min

591 15-05-2023 15:26:00 Sudhir Kuldeep sir (Crude security team) 1 min

592 15-05-2023 15:42:00 Sudhir Kuldeep sir (Crude security team) 1 min
593 15-05-2023 15:55:00 Sudhir Kuldeep sir (Crude security team) 2 min

594 15-05-2023 15:57:00 Sudhir Kuldeep sir (Crude security team) 1 min

595 15-05-2023 16:26:00 Sudhir Kuldeep sir (Crude security team) 5 min

596 15-05-2023 17:36:00 Sudhir Kuldeep sir (Crude security team) 1 min

597 15-05-2023 17:39:00 Sudhir Kuldeep sir (Crude security team) 1 min
598 15-05-2023 17:55:00 Sudhir Lumbaram Service engg. 1 min

599 15-05-2023 19:16:00 Sudhir Lumbaram Service engg. 2 min

600 16-05-2023 10:08:00 Mukesh Control Room Barmer Security 1 min

601 16-05-2023 10:33:00 Mukesh Kuldeep sir (Crude security team) 12 min

602 16-05-2023 12:12:00 Mukesh RTSO Suvali (Abbas Ali Sir) 1Min
603 16-05-2023 14:36:00 Sudhir Kuldeep sir (Crude security team) 1 min

604 16-05-2023 15:46:00 Sudhir Kuldeep sir (Crude security team) 1 min

605 16-05-2023 17:09:00 Sudhir Kuldeep sir (Crude security team) 1 min

606 16-05-2023 17:09:00 Sudhir Kuldeep sir (Crude security team) 1 min

607 16-05-2023 17:50:00 Sudhir Laxman Service engg. 2 min


608 16-05-2023 17:55:00 Sudhir Laxman Service engg. 3 min

609 16-05-2023 18:25:00 Sudhir Laxman Service engg. 1 min

610 16-05-2023 18:51:00 Sudhir Kuldeep sir (Crude security team) 1 min

611 16-05-2023 19:21:00 Sudhir Crude Security Control Room 2 min

612 17-05-2023 05:30:00 Mukesh Control Room Suvali (Jigar) 2 min


613 17-05-2023 05:37:00 Mukesh Control Room Suvali (Jigar) 2 min

614 17-05-2023 07:20:00 Mukesh AOT Office (Mayursh) 3 Min

615 17-05-2023 07:22:00 Mukesh Service Engg.. Kunj Suvali 22 Min

616 17-05-2023 07:49:00 Mukesh Vedanta IT Head Abhilash Sir. 3 Min

617 17-05-2023 08:03:00 Mukesh AOT Umesh Kasar 2 Min


618 17-05-2023 08:32:00 Mukesh Service Engg…Lumbaram 5 Min

619 17-05-2023 10:16:00 Mukesh Service Engg…Kunj (Suvali) 24 Min

620 17-05-2023 12:05:00 Mukesh Service Engg…Lumbaram 5 Min

621 17-05-2023 13:30:00 Mukesh AOT Umesh Kasar 10 Min

622 17-05-2023 13:30:00 Mukesh Control Room Guda 7- (Ravi) 1 Min


623 17-05-2023 10:16:00 Mukesh Service Engg…Kunj (Suvali) 12 Min

624 17-05-2023 15:22:00 Sudhir Kuldeep sir (Crude security team) 1 min

625 17-05-2023 16:21:00 Sudhir Kuldeep sir (Crude security team) 2 min

626 17-05-2023 16:46:00 Sudhir Kuldeep sir (Crude security team) 2 min

627 17-05-2023 16:04:00 Sudhir Anand (Vedanta) 1 min


628 17-05-2023 16:51:00 Sudhir Anand (Vedanta) 2 min

629 17-05-2023 17:04:00 Sudhir Anand (Vedanta) 1 min

630 17-05-2023 17:09:00 Sudhir Kuldeep sir (Crude security team) 1 min

631 17-05-2023 17:13:00 Sudhir Kuldeep sir (Crude security team) 1 min

632 17-05-2023 17:17:00 Sudhir Kuldeep sir (Crude security team) 2 min
633 17-05-2023 17:33:00 Sudhir Laxman Service engg. 2 min

634 17-05-2023 17:39:00 Sudhir Service Engg…Kunj (Suvali) 1 min

635 17-05-2023 18:11:00 Sudhir Laxman Service engg. 1 min

636 17-05-2023 19:44:00 Sudhir Service Engg…Kunj (Suvali) 1 min

Barmer Pushpendra (Crude security


637 18-05-2023 06:34:00 Mukesh 1 min
team)
638 18-05-2023 08:00:00 Mukesh Service Engg.. Laxamn 1 min

Barmer Rakesh (Crude security


639 18-05-2023 08:08:00 Mukesh 1 min
team)

640 18-05-2023 10:30:00 Mukesh Service Engg Kunj Suvali 9 Min

641 18-05-2023 11:51:00 Mukesh Service Engg Barmer Lumbaram. 10 Min

642 18-05-2023 14:32:00 Sudhir Service Engg…Kunj (Suvali) 1 min


Barmer Rakesh (Crude security
643 18-05-2023 15:19:00 Sudhir 1 min
team)

644 18-05-2023 15:22:00 Sudhir Kuldeep sir (Crude security team) 1 min

Barmer Rakesh (Crude security


645 18-05-2023 15:27:00 Sudhir 1 min
team)

646 18-05-2023 17:11:00 Sudhir Kuldeep sir (Crude security team) 1 min

647 18-05-2023 18:20:00 Sudhir Lumba Ram 2 min


648 18-05-2023 19:08:00 Sudhir Lumba Ram 1 min

649 19-05-2023 10:59:00 Sudhir Tuka 1Z control Room 1 min

650 19-05-2023 11:02:00 Sudhir Tuka 1Z control Room 1 min

651 19-05-2023 14:29:00 Sachin RTSO Passenger Barmer 1 min

652 19-05-2023 14:31:00 Sachin RTSO Passenger Barmer 2 min