tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 183962d1349103629-excel-pivot-tables-tf-performance-2-latest-q3
Sheet: Glencore Pivot Table

Year | 2012
Month | (Multiple Items)
Count of Client | Column Labels
Row Labels | Glencore | Grand Total
PMS | 3 | 3
Grand Total | 3 | 3
Client | Glencore
Month | (Multiple Items)
Row Labels | Sum of Nominated Cargo Quantity (MT)
AGO | 267532
PMS | 127400
Grand Total | 394932
Client | (Multiple Items)
Month | (Multiple Items)
Row Labels | Count of Support Craft
Glory | 7
Mensah | 9
Top Fenders 1 | 3
Grand Total | 19
Year | 2012
Client | (Multiple Items)
Row Labels | Average of Total Fendering Time
July | 01:20:00
Grand Total | 01:20:00
Year | 2011
Month | (All)
Count of Client | Column Labels
Row Labels | Glencore | Grand Total
AGO | 73 | 73
Fuel Oil | 2 | 2
PMS | 20 | 20
Other | 5 | 5
Grand Total | 100 | 100
Year | 2011
Client | Glencore
Month | (All)
Row Labels | Sum of Nominated Cargo Quantity (MT)
AGO | 607904.5989999999
Fuel Oil | 45700
PMS | 487060
Other | 37587
Grand Total | 1178251.599
Year | 2011
Client | (Multiple Items)
Row Labels | Average of Total Fendering Time
January | 01:05:32.727000
February | 01:07:52.500000
March | 01:24:20
April | 01:31:12
May | 01:08:43.636000
June | 00:57:40
July | 01:00:42.857000
August | 01:08:35
September | 01:00:42.857000
October | 00:55:20
November | 01:00:00
December | 00:56:38.571000
Grand Total | 01:05:25.294000
Spreadsheet: 887644d1737911438-filter-robsonslz-filter-5-spill-365-aligw
Sheet: Sumário

RESP: | João
Nº | ITENS | DATA | RESP | JAN | FEV | MAR | ABR | MAI | JUN | JUL | AGO | SET | OUT | NOV | DEZ
 | A | 2025-01-01 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
2 | B | 2025-01-02 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
3 | B | 2025-01-03 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
4 | B | 2025-01-04 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
5 | B | 2025-01-05 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
6 | A | 2025-01-06 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
7 | A | 2025-01-07 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
8 | A | 2025-01-08 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
9 | B | 2025-01-09 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
3 | C | 2025-01-03 00:00:00 | João |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12
4 | D | 2025-01-04 00:00:00 | João |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12
5 | E | 2025-01-05 00:00:00 | João |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12
6 | F | 2025-01-06 00:00:00 | João |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12
7 | G | 2025-01-07 00:00:00 | João |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12
8 | H | 2025-01-08 00:00:00 | João |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12
9 | I | 2025-01-09 00:00:00 | João |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12
Spreadsheet: 97331d1296552512-pivot-table-will-not-return-top-10-filter-762470_dalew
Sheet: Sheet1

Sales | Manager | Customer | States | Key
2777000 | m3 | c7 | s9
6758000 | m4 | c15 | s2 |  |  | Row Labels | Sum of Sales
3110000 | m5 | c17 | s6 |  |  | [NAME] : c19 : s1 | 21734000
1708000 | m1 | c17 | s1 |  |  | m4 : c13 : s7 | 20106000
4875000 | m3 | c7 | s6 |  |  | m1 : c14 : s8 | 18019000
4905000 | m4 | c6 | s10 |  |  | m1 : c8 : s4 | 17390000
6379000 | m4 | c5 | s8 |  |  | m1 : c3 : s8 | 17357000
11994000 | m2 | c2 | s9 |  |  | m5 : c8 : s2 | 17239000
11901000 | m3 | c2 | s1 |  |  | m5 : c6 : s3 | 17122000
14826000 | m2 | c14 | s7 |  |  | m3 : c14 : s5 | 16782000
7478000 | m2 | c12 | s3 |  |  | m2 : c4 : s2 | 16687000
6485000 | m4 | c4 | s3 |  |  | m3 : c9 : s5 | 16521000
15337000 | m3 | c17 | s7 |  |  | Grand Total | 178957000
9237000 | m2 | c6 | s9
7408000 | m1 | c14 | s5
15993000 | m2 | c3 | s9
11282000 | m2 | c10 | s6
15021000 | m5 | c11 | s5
15170000 | m3 | c7 | s2
10495000 | m3 | c14 | s2
13260000 | m4 | c1 | s1
9927000 | m2 | c11 | s4
9138000 | m1 | c5 | s8
17390000 | m1 | c8 | s4
4679000 | m4 | c1 | s8
12152000 | m3 | c6 | s9
15419000 | m4 | c14 | s2
9052000 | m2 | c9 | s5
12003000 | m2 | c19 | s1
8572000 | m4 | c6 | s9
6271000 | m4 | c15 | s3
2441000 | m2 | c15 | s8
2316000 | m3 | c8 | s10
12267000 | m2 | c19 | s7
3718000 | m4 | c18 | s1
7613000 | m3 | c20 | s5
16148000 | m5 | c1 | s3
16076000 | m5 | c11 | s2
7490000 | m2 | c12 | s4
5712000 | m2 | c17 | s7
9541000 | m4 | c2 | s3
4772000 | m2 | c6 | s2
6161000 | m4 | c13 | s7
13574000 | m5 | c8 | s3
1855000 | m2 | c15 | s7
4044000 | m2 | c2 | s7
13463000 | m3 | c12 | s1
15687000 | m2 | c16 | s5
12418000 | m1 | c14 | s8
16687000 | m2 | c4 | s2
3486000 | m3 | c11 | s3
13945000 | m4 | c13 | s7
15240000 | m3 | c5 | s4
12420000 | m1 | c8 | s7
4248000 | m3 | c15 | s5
3604000 | m4 | c17 | s2
9188000 | m1 | c13 | s6
2967000 | m3 | c20 | s7
11566000 | m3 | c6 | s7
6121000 | m4 | c2 | s10
4444000 | m5 | c11 | s9
16314000 | m2 | c6 | s6
4288000 | m1 | c4 | s10
10797000 | m1 | c13 | s3
5275000 | m1 | c6 | s10
12604000 | m5 | c14 | s9
6156000 | m3 | c11 | s4
4634000 | m4 | c16 | s9
4428000 | m3 | c8 | s1
10170000 | m5 | c18 | s10
5801000 | m2 | c12 | s1
12071000 | m3 | c10 | s4
16521000 | m3 | c9 | s5
17122000 | m5 | c6 | s3
10570000 | m1 | c19 | s4
9731000 | m2 | c19 | s1
2357000 | m4 | c18 | s7
16782000 | m3 | c14 | s5
12822000 | m5 | c13 | s3
3980000 | m2 | c8 | s2
5601000 | m1 | c14 | s8
10081000 | m3 | c19 | s7
17239000 | m5 | c8 | s2
17357000 | m1 | c3 | s8
9665000 | m5 | c1 | s7
16190000 | m1 | c8 | s2
14094000 | m5 | c9 | s8
5972000 | m1 | c5 | s8
12556000 | m3 | c7 | s3
14160000 | m5 | c20 | s9
7469000 | m2 | c14 | s3
6690000 | m1 | c4 | s7
5595000 | m3 | c17 | s4
3362000 | m4 | c16 | s10
2482000 | m1 | c6 | s4
15519000 | m1 | c2 | s7
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 15

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-15 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1151 |  | 937 |  | 67694 |  |  |  |  |  | 32 | 1 | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 2 | 35
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 2237 |  | 1596 |  | 67694 |  |  |  |  |  | 32 | 3 | 34
 |  |  |  |  |  |  |  |  | 7000 |  | 7000 |  | 68918 | 0 |  |  |  |  | 33 | 4 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 5 | 36
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1249 |  | 1122 |  | 67694 |  |  |  |  |  | 30 | 6 | 34
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 33 | 7 | 34
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 35 | 8 | 37
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 | 0 |  |  |  |  | 35 | 9 | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 15 | 42
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 10325 |  | 9028 |  | 67694 |  |  |  |  |  | 35 | 35 | 38
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 33 | 39 | 35
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1337 |  | 1138 |  | 67694 |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 654 |  | 500 |  | 67694 |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 9487 |  | 8250 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3760 |  | 3333 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3407 |  | 3178 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4257 |  | 3971 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1087 |  | 853 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 32 |  | 30 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: eric_saibi__9985__112601
Sheet: San Juan 03

Owner Name |  | Public Service Company
Station Name |  | San Juan Generating
Unit Name |  | San Juan 03
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 534
Start Date |  | 2001-11-25 00:00:00
End Date |  | 2001-11-28 00:00:00
Comments |  | Tube Leak
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007771
Outage ID |  | 18969
Spreadsheet: 681397d1591546474-reopened-lining-up-row-of-numbers-with-column-of-numbers-using-index-match-index-match-question
Sheet: Sheet1

LIST 1 | LIST 2 | LIST 3 | LIST 4 | LIST 5 | LIST 6 | LIST 7 | LIST 8 | LIST 9 | LIST 10 | LIST 11 | LIST 12 | LIST 13 | LIST 14 | LIST 15 | LIST 16
1 | 1 | 3 | 2 | 7 | 6 | 3 | 2 | 4
1 | 2 |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
1 | 3 |  |  |  |  |  |  |  | 3 |  |  |  | 3
1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
1 | 5
1 | 6 |  |  |  |  |  |  |  |  |  |  | 6
1 | 7 |  |  |  |  |  |  |  |  |  | 7
1 | 8
1 | 9
1 | 10
 |  |  |  |  |  |  |  |  | VLOOKUPS
LIST 1 | LIST 2 | LIST 3 | LIST 4 | LIST 5 | LIST 6 | LIST 7 | LIST 8 | LIST 9 | LIST 10 | LIST 11 | LIST 12 | LIST 13 | LIST 14 | LIST 15 | LIST 16
1 | 1 | 3 | 2 | 7 | 6 | 3 | 2 | 4
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
1 | 8
1 | 9
1 | 10
LIST 1 | LIST 2 | LIST 3 | LIST 4 | LIST 5 | LIST 6 | LIST 7 | LIST 8 | LIST 9 | LIST 10 | LIST 11 | LIST 12 | LIST 13 | LIST 14 | LIST 15 | LIST 16
1 | 1 | 3 | 2 | 7 | 6 | 3 | 2 | 4
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
1 | 8
1 | 9
1 | 10
Spreadsheet: 826656d1682136839-perpetual-meeting-calendar-perpetual-calendar-attempt2
Sheet: Calendar Data

Meeting Schedule
Year | 2023
Title | Day of Week | Numeric day of week for code | Week of Month | Frequency
Meeting A | Friday |  | 2 | 1
Meeting B | Tuesday |  | 3 | 1
Meeting C | Wednesday |  | 3 | 2
Spreadsheet: 690808d1597306485-company-redundancy-payments-xl-forum-payment-of-co-redundancy
Sheet: TOTAL

Redundancy Tracker
Emp # | Redundancy? | Contractual start date | Notice period In weeks or months? | ER notice period | Length of service at redundancy date plus notice | DOB | Age @ Redundancy + Notice | Number of weeks redundancy | Salary | Statutory redundancy pay @ £538 | Company redundancy pay | Total redundancy pay | Notice pay calculation | Benefits calculation | Total PILON payment | Pension for notice period | Life Assurance for notice period | Holiday days | Holiday pay | TOTAL COST (redundancy, notice pay, outplacement, holiday pay)
1 | 2022-06-30 00:00:00 | 2009-11-09 00:00:00 | Weeks | 12 |  | 1949-10-19 00:00:00 |  |  | 35701.34 |  |  |  |  |  |  | 0 | 0 | 0
2 | 2022-06-30 00:00:00 | 2002-02-01 00:00:00 | Weeks | 12 |  | 1970-10-03 00:00:00 |  |  | 20797.15 |  |  |  |  |  |  | 0 | 0 | 0
4 | 2022-06-30 00:00:00 | 1999-06-01 00:00:00 | Weeks | 12 |  | 1956-01-19 00:00:00 |  |  | 32266.3 |  |  |  |  |  |  | 0 | 0 | 0
5 | 2022-06-30 00:00:00 | 2018-05-01 00:00:00 | Weeks | 12 |  | 1961-10-26 00:00:00 |  |  | 32287.5 |  |  |  |  |  |  | 0 | 0 | 0
6 | 2022-06-30 00:00:00 | 1990-11-05 00:00:00 | Weeks | 12 |  | 1957-08-31 00:00:00 |  |  | 21902.92 |  |  |  |  |  |  | 0 | 0 | 0
7 | 2022-06-30 00:00:00 | 1999-08-01 00:00:00 | Weeks | 12 |  | 1960-10-01 00:00:00 |  |  | 20837.5 |  |  |  |  |  |  | 0 | 0 | 0
8 | 2022-06-30 00:00:00 | 2006-09-25 00:00:00 | Weeks | 12 |  | 1971-04-02 00:00:00 |  |  | 25112.5 |  |  |  |  |  |  | 0 | 0 | 0
12 | 2022-06-30 00:00:00 | 1978-08-29 00:00:00 | Weeks | 12 |  | 1959-06-21 00:00:00 |  |  | 61064.71 |  |  |  |  |  |  | 0 | 0 | 0
13 | 2022-06-30 00:00:00 | 2003-02-17 00:00:00 | Weeks | 12 |  | 1972-04-18 00:00:00 |  |  | 63095.41 |  |  |  |  |  |  | 0 | 0 | 0
14 | 2022-06-30 00:00:00 | 2002-02-04 00:00:00 | Weeks | 12 |  | 1948-01-09 00:00:00 |  |  | 16174.5 |  |  |  |  |  |  | 0 | 0 | 0
15 | 2022-06-30 00:00:00 | 1991-01-03 00:00:00 | Weeks | 12 |  | 1957-09-04 00:00:00 |  |  | 72966.4 |  |  |  |  |  |  | 0 | 0 | 0
16 | 2022-06-30 00:00:00 | 2011-09-05 00:00:00 | Weeks | 8 |  | 1984-10-10 00:00:00 |  |  | 13283.33 |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Apr 22

Enter 1st of Month Here -> | 2022-04-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: errol_mclaughlin_jr__10271__Book Admin List
Sheet: Data Sheet

Book Administrator Listing
Company | Group | Report To
Company | Group
Name | Book ID | Primary / Back-up | Phone
[NAME] | PG Official |  | [PHONE]
 | NG-Exotics
 | NG-LTX
 | NG-LTX Basis
 | NG-LTX Gas Daily
 | NG-PR-Can
 | NG-MM
 | EOL Gas Daily
 | EOL Basis
 | EOL GD Position Calc
Spreadsheet: 98884d1297710617-appending-data-in-excel-sheets-excel-query
Sheet: Sheet1

Verify the Minimum and Maximum entry age validations for all the [NAME] sum disability benefits for New Load(This is a common test case for All Premium patterns, [NAME] and Benefit Terms and PLA,SLA) | 1) Model should be signed off | Check the Data Sheet | Step 1 | Login to application | User should have access to the BNBQ and [NAME].
 |  |  | Step 2 | choose the option 1-Load new individual quotations | user should be able to access the BNBQ options
 |  |  | Step 3 | Choose 1=Lifestyle protector option | user should be able to fill in all the details
 |  |  | Step 4 | Fill in the Premium Type as <<<Premium Pattern>>> | User should be able to enter the details
 |  |  | Step 5 | Enter the entry age as <<<Age>>> in Age Next field | Validation result <<<Output>>>
 |  |  | Step 6 | Navigate to the Disability benefit screen for <<<Life Assured>>> and Choose <<<Benefit Type>>> | User should be able to choose the benefit type
 |  |  | Step 7 | Choose the Benefit Term as <<<Benefit Terms>>> | Validation result <<<Output>>>
Spreadsheet: 707885d1607525196-how-to-assign-a-country-to-a-specific-area-dashboard
Sheet: POLAND

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 21115d1208267231-need-vlookup-to-miss-blanks-test
Sheet: PL(Ast)

Pos | Number | Name | Position | Height | Weight | DOB | [NAME] | Previous Club
G0 | 1 | [NAME] | G | 6'03" | 12 05 | 1976-06-12 00:00:00 | [NAME] | Sunderland
D0 | 3 | [NAME] | D | 5'11" | 12 13 | 1978-06-15 00:00:00 | Helmond | PSV Eindhoven
D1 | 4 | [NAME] | D | 6'01'' | 12 10 | 1977-09-03 00:00:00 | Amncharad | [NAME]
D2 | 5 | [NAME] | D | 6'02" | 12 06 | 1977-07-26 00:00:00 | [NAME] | Milan
D3 | 6 | [NAME] | D | 5'11" | 12 06 | 1981-02-23 00:00:00 | Hastings | None
M0 | 7 | [NAME] | M | 5'11" | 10 03 | 1985-07-09 00:00:00 | Stevenage | Watford
F0 | 8 | [NAME] | F | 5'10'' | 11 13 | 1986-02-13 00:00:00 | Birmingham | None
F1 | 9 | [NAME] | F | 6'01" | 13 03 | 1979-08-25 00:00:00 | Hampstead | West Ham U
F2 | 10 | [NAME] | F | 6'05" | 14 00 | 1979-09-05 00:00:00 | Lørenskog | Lyon
F3 | 11 | [NAME] | F | 5'11" | 12 05 | 1986-10-13 00:00:00 | Birmingham | None
[NAME] | 13 | [NAME] | G | 6'04" | 11 05 | 1980-11-28 00:00:00 | Romford | Arsenal
F4 | 14 | [NAME] | F | 0 | 0 | 1991-02-02 00:00:00 | 0 | None
D4 | 15 | Curtis Davies | D | 6'02" | 12 00 | 1985-03-15 00:00:00 | London | WBA
D5 | 16 | Zatyai Knight | D | 6'06" | 13 08 | 1980-05-02 00:00:00 | Solihull | Fulham
M1 | 17 | [NAME] | M | 5'11" | 10 12 | 1983-06-01 00:00:00 | Lomé | FC Wil
M2 | 18 | [NAME] | M | 5'06'' | 10 07 | 1985-01-07 00:00:00 | Eltham | Tottenham H
M3 | 19 | [NAME] | M | 5'09" | 12 01 | 1979-07-05 00:00:00 | Montana | Celtic
M4 | 20 | [NAME] | M | 5'08'' | 10 05 | 1984-05-14 00:00:00 | Southwark | West Ham U
G2 | 22 | [NAME] | G | 6'03" | 13 07 | 1985-09-03 00:00:00 | [NAME] | Liverpool
M5 | 23 | [NAME] | M | 6'01" | 12 06 | 1973-11-10 00:00:00 | Prague | Portsmouth
M6 | 26 | [NAME] | M | 5'10" | 11 13 | 1986-11-25 00:00:00 | Solihull | None
M7 | 27 | [NAME] | M | 6'02" | 12 07 | 1987-11-05 00:00:00 | Birmingham | None
F5 | 28 | [NAME] | F | 5'07'' | 10 02 | 1983-01-24 00:00:00 | [NAME] | Celtic
D6 | 29 | [NAME] | D | 6'00" | 11 07 | 1987-11-29 00:00:00 | Cork | None
Spreadsheet: 747266d1631323615-calculate-response-time-between-set-hours-sla-hours-between-dates-shift-work-xlsx-
Sheet: Holidays

Holidays | Weekday
2021-06-28 00:00:00
2021-05-24 00:00:00
2021-05-31 00:00:00
2021-05-17 00:00:00
2021-07-05 00:00:00
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6274 | 6163 |  |  | 1156 | 1178 | 2098 | 1619
2 | 6245 | 6163 |  |  | 1038 | 1178 | 2024 | 1619
3 | 6272 | 6163 |  |  | 1004 | 1178 | 1965 | 1619
4 | 6067 | 6163 |  |  | 1008 | 1178 | 2150 | 1619
5 | 5977 | 6163 |  |  | 571 | 1178 | 1663 | 1619
6 | 6222 | 6163 |  |  | 695 | 1178 | 1911 | 1619
7 | 6569 | 6163 |  |  | 743 | 1178 | 2009 | 1619
8 | 6569 | 6163 |  |  | 923 | 1178 | 1207 | 1619
9 | 6543 | 6163 |  |  | 848 | 1178 | 2085 | 1619
10 | 6466 | 6163 |  |  | 686 | 1178 | 2052 | 1619
11 | 6317 | 6163 |  |  | 238 | 1178 | 1968 | 1619
12 | 1 |  |  |  | 875 | 1178 | 1999 | 1619
13 |  |  |  |  | 843 | 1178 | 1962 | 1619
14 |  |  |  |  | 1056 | 1178 | 1914 | 1619
15 |  |  |  |  | 805 | 1178 | 1974 | 1619
16 |  |  |  |  | 823 | 1178 | 1941 | 1619
17 |  |  |  |  | 1000 | 1178 | 1910 | 1619
18 |  |  |  |  | 414 | 1178 | 1874 | 1619
19 |  |  |  |  | 1033 | 1178 | 1826 | 1619
20 |  |  |  |  | 1265 | 1178 | 1784 | 1619
21 |  |  | 1 |  | 1242 | 1178 | 1393 | 1619
22 |  |  |  |  | 1325 | 1178 | 1384 | 1619
23 |  |  |  |  | 1264 | 1178 | 1388 | 1619
24 |  |  |  |  | 1328 | 1178 | 2001 | 1619 |  |  | 377
25 |  |  |  |  | 1200 | 1178 | 1937 | 1619 |  |  | 725
26 |  |  |  |  | 1236 | 1178 | 1747 | 1619
27 |  |  |  |  | 1228 | 1178 | 74 | 1619
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  |  |  |  |  | 362097.29
2001-06-27 00:00:00
Spreadsheet: 860941d1708958664-less-than-or-greater-than-with-time-shift-log
Sheet: Sheet3

Start 1st shift | End 1st Shift | 1st Shift Length | Start 2nd Shift | End 2nd Shift | Break | Total (Hrs)
 |  |  | 19:45:00 | 05:30:00
12:00:00 | 13:30:00 |  | 19:00:00 | 05:30:00
 |  |  | 19:00:00 | 05:30:00 | 01:00:00
 |  | 01:30:00 | 19:00:00 | 05:30:00
 |  |  | 19:45:00 | 07:30:00 | 03:00:00
 |  | 02:00:00 | 20:00:00 | 06:30:00
 |  |  | 19:45:00 | 07:30:00
 |  | 02:00:00 | 20:00:00 | 06:30:00
 |  |  | 20:00:00 | 07:30:00
 |  | 00:40:00 | 21:00:00 | 07:30:00 | 02:00:00
 |  | 01:00:00 | 19:00:00 | 04:30:00
 |  | 02:00:00 | 19:30:00 | 05:30:00
 |  |  | 20:00:00 | 05:30:00
 |  |  | 20:30:00 | 05:30:00
 |  |  | 19:45:00 | 05:30:00
 |  |  | 20:45:00 | 05:30:00
 |  | 02:30:00 | 19:30:00 | 06:00:00
 |  |  | 19:45:00 | 07:00:00
 |  | 02:00:00 | 19:30:00 | 06:00:00
 |  | 00:45:00 | 19:45:00 | 05:45:00
 |  | 02:00:00 | 19:45:00 | 06:00:00 | 01:00:00
 |  | 00:45:00 | 20:00:00 | 08:37:00
 |  | 01:00:00 | 20:00:00 | 08:00:00 | 01:40:00
 |  |  | 20:00:00 | 05:30:00
 |  | 01:00:00 | 20:00:00 | 05:31:00
 |  | 02:30:00 | 19:00:00 | 06:30:00
 |  | 00:45:00 | 20:00:00 | 06:15:00
 |  | 00:40:00 | 20:20:00 | 07:00:00
 |  | 01:40:00 | 20:30:00 | 06:30:00 | 01:00:00
 |  | 01:30:00 | 20:00:00 | 06:15:00
 |  |  | 20:20:00 | 06:15:00
 |  | 01:30:00 | 22:30:00 | 06:00:00
 |  | 01:00:00 | 20:00:00 | 06:15:00
 |  |  | 20:20:00 | 09:00:00 | 01:00:00
 |  | 01:30:00 | 20:45:00 | 06:00:00
Spreadsheet: 771262d1646564097-convert-a-value-that-is-in-minutes-to-hours-days-weeks-months-in-decimal-minutes-to-hours-etc-aligw
Sheet: Sheet1

25
60
150
300
900
1200
1440
2400
3600
21600
50400
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 58

कार्यक्रम PROGRAM |  |  | PROGRAMME ON AUDIT & COMPLIANCE | PROG CODE
 |  |  |  | IT 1907
तर्षर् समूह/JOB FAMILY |  |  | INTERNAL CONTROL, INSPECTION & RISK MANAGEMENT
उद्देश्य/OBJECTIVE |  |  | To Induct Knowledge on Important aspect of Compliance.
लतक्षि समूह/TARGET GROUP |  |  | MIXED
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration  &  Compliance  Monitoring:  -  Off-site  and  On-site  Test Checking. Managing and    Mitigating Risk of Non Compliance.
 | II | KYC, AML & CFT Compliance – FATF Recommendations, FIU, PMLA - Customer  Acceptance  and  Customer  due  diligence,  Risk  Profiling, Classification & Management.
 | III | Role of Regulators in Banking vis –a- vis compliance: RBI; MoF – DFS – GoI ; NABARD; SIDBI; NHB; FIMDA/ FBIL, AMPI , IBA: RBI Act, 1934, BR Act- 1949, NI Act.- relevant provisions  for Bankers.
 | IV | Monitoring of Transactions - EDD, Red Flag Indicators – Online/Offline, Rules for generation of Alerts, Closing AML Alerts & Filing STR – process & implications
Day 2 | I | Customer service related compliances - On-line Customer Grievance Redressal Mechanism in Banks, Provisions of Consumer Protection Act and  Right  to  Information  Act,  Consumer  Education,  RBI-  Integrated Ombudsman Scheme – 2021, Role of Internal Ombudsman,
 | II | Statutory  &  Regulatory  Compliances  for  Loans-  Exposure  norms, Priority Sector norms, IRAC Norms
 | III | ALM Guidelines & Functions of ALCO, Basel III compliance, Compliance related to Capital Adequacy Norms and Operational Risk management
 | IV | Compliances on Exports and Imports – RBI/ DGFT/ FEMA Regulations, Guidelines on NRI Deposits and Remittances, Foreign Currency Accounts; Remittance facilities for Residents, Foreign Contribution Regulation Act, Trade Based Money Laundering
Day 3 | I | Fraud Risk Management & Vigilance Framework.
 | II | Risk Based Supervision (RBS) - Supervisory Program for Assessment of Risk & Capital (SPARC), Off-site Submission of Data & Information to RBI
 | III | Compliances in Digital Banking & Alternate Delivery Channels, Limited Liability of Customers in Unauthorised Electronic Banking Transaction
 | IV | Feedback and Valediction