tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116185d1311658223-summarizing-or-indexing-book1-1-1-1-1-
Sheet: b

Airline Name | Sector Traveled | NettPay |  |  |  |  |  |  |  |  | Hide column L & M |  |  | Data sorted from column L&M
[NAME] | Delhi-Bhubaneswar | 5633 |  |  |  |  |  |  |  |  | [NAME] | 59354 |  | [NAME] | 59354
[NAME] | Delhi-Bhubaneswar | 5633 |  |  |  |  |  |  |  |  | Indigo Airlines | 51667 |  | Indigo Airlines | 51667
[NAME] | Delhi-Bhubaneswar | 5633 |  |  |  |  |  |  |  |  | Jet Airways | 22475 |  | Jet Airways | 22475
[NAME] | Bhubaneswar-Delhi | 5383 |  |  |  |  |  |  |  |  | Spice Jet | 4809 |  | Air India | 19248
[NAME] | Bhubaneswar-Delhi | 5383 |  |  |  |  |  |  |  |  | Air India | 19248 |  | Spice Jet | 4809
[NAME] | Bhubaneswar-Delhi | 5383 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Indigo Airlines | Bhubaneswar-Delhi | 5057 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Indigo Airlines | Bhubaneswar-Delhi | 5057 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Indigo Airlines | Delhi-Bhubaneswar | 6073 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Indigo Airlines | Delhi-Bhubaneswar | 9534 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
[NAME] | Kolkata-Raipur | 5198 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Jet Airways | [NAME] | 4068 |  |  |  |  |  |  |  |  | Note arrary formula is used in column L and should be confirmed through Shift+Ctrl+Enter |  |  | Note arrary formula is used in column O and should be confirmed through Shift+Ctrl+Enter
Indigo Airlines | Delhi-Bhubaneswar | 6373
[NAME] | Bhubaneswar-Delhi | 5383
Spice Jet | Delhi-Gauhati | 795
[NAME] | Delhi-Bhubaneswar | 5633
[NAME] | Bhubaneswar-Delhi | 5383
Jet Airways | Delhi-Nagpur | 840
Air India | Delhi-Hyderabad | 8745
Indigo Airlines | Vadodara-Delhi | 3413
Jet Airways | [NAME] | 7149
Air India | [NAME] | 4281
Spice Jet | Delhi-Nagpur | 4014
Jet Airways | Delhi-Jodhpur | 7059
[NAME] | Mumbai-Bangalore | 4709
Jet Airways | Bangalore-Mumbai | 3359
Indigo Airlines | Delhi-Ahmedabad | 8775
Air India | Delhi-Raipur | 6222
Indigo Airlines | Delhi-Lucknow-Delhi | 1680
Indigo Airlines | Delhi-Bangalore | 5705
Spreadsheet: 765040d1643131730-sum-sheets-starting-with-br-where-criteria-is-the-same-formula-to-sum-data-where-criteria-is-the-same
Sheet: Southern

Nominal | Description | 3/2022(YTD)
40100901 |  | 691
41090901 |  | 35
40109012 |  | 354
40109014 |  | 951
40109014 |  | 0
40109015 |  | 38
40109016 |  | 0
90108000 |  | -36257
90108005 |  | 0
40809010 |  | 0
90109015 |  | 0
90108020 |  | -4016
90108025 |  | -3285
90108090 |  | -3549
90108901 |  | -3175
Spreadsheet: 88141d1288054833-excel-2010-conditional-formatting-across-mulitpe-colums-patch
Sheet: Sheet2

DEVICE | PORTS
EDGE1 | 1
R2C2-PPA | 1/01
R2C2-PPB | 1/02
R2C2-PPC | 1/03
EDGE2 | 1/04
BCC-RR1 | 1/05
R5C4-PPA | 1/06
CISCO-DWDM-BCT-BCC | 1/07
R1C4-PPA | 1/08
BDC-NOC-ASA | 1/09
R1C0-NORTEL SWITCH | 1/10
R2C3-PPY | 1/11
BCT-SW1 | 1/12
BDC-NOC-SW1 | 1/13
R1C2-PPB | 1/14
BCC-PIPN1 | 1/15
 | 1/16
 | 1/17
 | 1/18
 | 1/19
 | 1/20
 | 1/21
 | 1/22
 | 1/23
 | 1/24
 | 1/25
 | 1/26
 | 1/27
 | 1/28
 | 1/29
 | 1/30
 | 1/31
 | 1/32
 | 1/33
 | 1/34
 | 1/35
 | 1/36
 | 1/37
 | 1/38
 | 1/39
 | 1/40
 | 1/41
 | 1/42
 | 1/43
 | 1/44
 | 1/45
 | 1/46
 | 1/47
 | 1/48
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 2
 | 2/01
 | 2/02
 | 2/03
 | 2/04
 | 2/05
 | 2/06
 | 2/07
 | 2/08
 | 2/09
 | 2/10
 | 2/11
 | 2/12
 | 2/13
 | 2/14
 | 2/15
 | 2/16
 | 2/17
 | 2/18
 | 2/19
 | 2/20
 | 2/21
 | 2/22
 | 2/23
 | 2/24
 | 2/25
 | 2/26
 | 2/27
 | 2/28
 | 2/29
 | 2/30
 | 2/31
 | 2/32
 | 2/33
 | 2/34
 | 2/35
 | 2/36
 | 2/37
 | 2/38
 | 2/39
 | 2/40
 | 2/41
 | 2/42
 | 2/43
 | 2/44
 | 2/45
 | 2/46
 | 2/47
 | 2/48
 | 20
 | 21
 | 22
 | 23
 | 24
 | 3
 | 3/01
 | 3/02
 | 3/03
 | 3/04
 | 3/05
 | 3/06
 | 3/07
 | 3/08
 | 3/09
 | 3/10
 | 3/11
 | 3/12
 | 3/13
 | 3/14
 | 3/15
 | 3/16
 | 3/17
 | 3/18
 | 3/19
 | 3/20
 | 3/21
 | 3/22
 | 3/23
 | 3/24
 | 3/25
 | 3/26
 | 3/27
 | 3/28
 | 3/29
 | 3/30
 | 3/31
 | 3/32
 | 3/33
 | 3/34
 | 3/35
 | 3/36
 | 3/37
 | 3/38
 | 3/39
 | 3/40
 | 3/41
 | 3/42
 | 3/43
 | 3/44
 | 3/45
 | 3/46
 | 3/47
 | 3/48
 | 4
 | 5
 | 6
 | 6/1
 | 6/2
 | 7
 | 8
 | 9
 | SL17-UC
 | SL8-UC
 | GE0/1
Spreadsheet: 768610d1645042048-formula-function-for-adding-hours-from-multiple-locations-staffing-example-spreadsheet-upload
Sheet: Sheet2

 |  |  |  | Employee Utilization/ Availability
 |  |  |  | January |  |  |  | February |  |  |  | March |  |  |  | April
 |  |  | Employee | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4
 |  |  | Angelica
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  |  | Planned Hours
 |  |  |  | January |  |  |  | February |  |  |  | March |  |  |  | April
 | Project Name |  | Employee | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4
 | Smith House Renovation | Executive | Angelica | 10 | 12 | 10 | 10
 | Smith House Renovation | Manager | [NAME] | 30 | 32 | 24 | 40
 | Smith House Renovation | Coordinator | [NAME] | 40 | 38 | 40 | 38
 | Smith House Renovation | Intern | [NAME] | 20 | 22 | 25 | 24
 | Factory Expansion | Executive | Angelica | 10 | 12 | 10 | 10
 | Factory Expansion | Manager | [NAME] | 30 | 32 | 24 | 40
 | Factory Expansion | Coordinator | [NAME] | 40 | 38 | 40 | 38
 | Factory Expansion | Intern #1 | [NAME] | 40 | 40 | 40 | 40
 | Factory Expansion | Intern #2 | [NAME] | 20 | 22 | 25 | 24
Spreadsheet: 781743d1653507325-formula-to-find-duplicate-email-addresses-across-sheets-30-60-90-etaf
Sheet: 90

Office ID | Office ID2 | First | Last | [NAME] | DATA | DATA | DATA | DATA | DATA | DATA | DATA | DATA | DATA | DATA | DATA | DATA | DATA | DATA
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
DATA | DATA | DATA | DATA | [EMAIL]
Spreadsheet: 205990d1357970504-selecting-multiple-items-in-a-list-danh-sach-nhap-lieu-
Sheet: Cafe

 |  |  | Sao | 1 | 2
Tiện ích | Internet | Chỗ đậu xe | Ăn sáng - ăn trưa | Tổ chức sn
Không gian | Sân vườn | Trong nhà | Vỉa hè | Bệt
[NAME] | Khách sạn | Nhà nghỉ | Resort
Phù hợp | Gặp gỡ bạn bè | Công việc | Riêng tư | [NAME] trí - Ca nhạc - Bóng đá
STT | [NAME] | [NAME] | Điện thoại | Website | [NAME] | Không gian | Phù hợp | Nội dung
 |  |  |  |  |  |  |  | Hanoi Calypso Hotel cung cấp chỗ ở sang trọng tại khu mua sắm của [NAME]. Tại đây có Wi-Fi miễn [NAME] được trang bị [NAME]. Từ khách sạn đến Hồ Hoàn [NAME] chỉ mất 5 phút tản bộ. Được trang trí với các gam màu trung tính dễ chịu, các phòng máy lạnh đầy phong cách của Calypso [NAME] có đồ nội thất bằng gỗ cổ điển [NAME]. Ấm đun nước điện và tủ lạnh cũng được cung cấp ngay trong phòng. Hanoi Calypso Hotel cách Sân bay Quốc tế [NAME] phút lái xe và từ khách sạn đến Ga Hà Nội mất 10 phút lái xe. Khách có thể đi tham quan quanh Hà Nội một cách dễ [NAME] dịch vụ tour và đặt vé có tại đây. [NAME] ra, xe đạp [NAME] cũng được cho thuê tại Calypso. Sau 1 ngày hoạt động, khách có thể thư giãn với dịch vụ [NAME] nhẹ nhàng. Vô tuyến [NAME], vệ tinh, [NAME] trang điểm, Điều hòa, Tủ lạnh, [NAME] thoại liên lạc trực tiếp quốc tế, [NAME] tính truy cập Internet, điều hòa, [NAME] tắm, Bồn tắm và [NAME] sen riêng trong phòng, [NAME] sấy tóc trong phòng, Tường cách âm, [NAME] pha, Bàn ghế, Đầy đủ các đồ phục vụ vệ sinh cá nhân, [NAME] mới, Ăn sáng,hoa quả.
Spreadsheet: 43592d1242234723-finding-most-recurring-values-in-a-table-most-frequently-name-string
Sheet: Sheet1

TV
Table
Pc |  |  | Table
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Pc
TV
Table
Table
Table
Spreadsheet: 7e5848a9-6f63-48a4-ba2f-0b7909f785a6
Sheet: Sheet1

Rank | Unnamed: 1 | Unnamed: 2 | Score | Score.1 | Score.2 | Score.3 | Score.4 | Name | [NAME] | First Contact Phone #
MULTIPLE COMPONENT EXAM SCORING - For Combined Score Evaluation Step
 | Exam Plan Name:
Multi-Step  Components- Exam Names: |  | ADMIN Basic | Excel 2007 | ETC… |  |  |  | TOTAL WEIGHT Must = 100
Exam Weights: |  | 25 | 25 | 50 | 0 | 0 | 0 | 100
 | Final Score for the Combined Evaluation Step | ATTENTION: DO NOT ENTER RAW SCORES!  ENTER PERCENTAGE SCORES FROM CO-JOBS, SHOWN UNDER DISPOSITION COLUMN!
 |  | ADMIN Basic | Excel 2007 | ETC… | 0 | 0 | 0
 | Combined Score for  CO-Jobs | Percentage Score | Percentage Score | Percentage Score | Percentage Score | Percentage Score | Percentage Score | Last Name | First Name | Person ID
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 306e0d59-60fd-4d51-ad9d-cb82c1befde1
Sheet: Reading Gr. 10

2012 Minnesota Comprehensive Assessments-Series II (MCA-II)
Grade 10 Reading
Raw Score | Scale Score | Level | Percentile Rank
0 | 1001 | D | 1
1 | 1001 | D | 1
2 | 1001 | D | 1
3 | 1001 | D | 1
4 | 1001 | D | 1
5 | 1001 | D | 1
6 | 1001 | D | 1
7 | 1001 | D | 1
8 | 1001 | D | 1
9 | 1001 | D | 1
10 | 1001 | D | 1
11 | 1001 | D | 1
12 | 1006 | D | 1
13 | 1012 | D | 1
14 | 1016 | D | 1
15 | 1019 | D | 1
16 | 1021 | D | 1
17 | 1024 | D | 1
18 | 1026 | D | 1
19 | 1027 | D | 2
20 | 1029 | D | 2
21 | 1030 | D | 3
22 | 1032 | D | 3
23 | 1033 | D | 4
24 | 1034 | D | 4
25 | 1035 | D | 5
26 | 1037 | D | 5
27 | 1038 | D | 6
28 | 1039 | D | 7
29 | 1040 | P | 8
30 | 1041 | P | 8
31 | 1042 | P | 9
32 | 1043 | P | 11
33 | 1043 | P | 11
34 | 1044 | P | 13
35 | 1045 | P | 15
36 | 1046 | P | 16
37 | 1047 | P | 18
38 | 1048 | P | 20
39 | 1049 | P | 22
40 | 1050 | M | 24
41 | 1051 | M | 27
42 | 1052 | M | 30
43 | 1053 | M | 33
44 | 1054 | M | 36
45 | 1055 | M | 40
46 | 1056 | M | 44
47 | 1057 | M | 48
48 | 1058 | M | 53
49 | 1059 | M | 58
50 | 1061 | M | 63
51 | 1062 | E | 68
52 | 1064 | E | 74
53 | 1066 | E | 79
54 | 1068 | E | 84
55 | 1071 | E | 89
56 | 1075 | E | 93
57 | 1080 | E | 97
58 | 1089 | E | 99
59 | 1099 | E | 99
Spreadsheet: 79048d1279278827-disappearing-info-advanced-filters-running-down-the-page-with-macro-new-cost-centre-system-forumex
Sheet: Q1303

Cost Centre |  |  | Date | 2010-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Annual | Projection
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B | Projection | YTD | Manual |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1303 | 301 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A | -2.857142857142857 | 174.2857142857143 | 160 |  |  |  | 301 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 302 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 303
Q1303 | 302 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A | -2.857142857142857 |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1303 | 303 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 3 | 5 | TUFC | A | -2.142857142857143 |  |  |  |  | Q1303 | 301 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A |  |  |  |  |  | Q1303 | 302 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 2 | 10 | Robins | A |  |  |  |  |  | Q1303 | 303 | 1234 | [NAME] | 2010-04-01 00:00:00 | 2010-03-31 00:00:00 | 3 | 5 | TUFC | A
Q1303 | 301 | 2345 | [NAME] | 2010-06-01 00:00:00 | 2010-06-02 00:00:00 | 4 | 10 | TUFC | B | 5.714285714285714 |  |  |  |  | Q1303 | 301 | 2345 | [NAME] | 2010-06-01 00:00:00 | 2010-06-02 00:00:00 | 4 | 10 | TUFC | B |  |  |  |  |  | Q1303 | 302 | 3456 | [NAME] | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 1 | 5 | Sizzles | A |  |  |  |  |  | Q1303 | 303 | 1234321 | [NAME] | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2 | 10 | Sparrows | B
Q1303 | 302 | 3456 | [NAME] | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 1 | 5 | Sizzles | A | 22.14285714285715 |  |  |  |  | Q1303 | 301 | 1234 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Q1303 | 302 | 1234 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Q1303 | 303 | 1234 | [NAME] | 2010-01-05 00:00:00 | 2010-06-05 00:00:00 | 2 | 10 | Apollo | A
Q1303 | 303 | 1234321 | [NAME] | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2 | 10 | Sparrows | B | 1042.857142857143 |  |  |  |  |  | 301 |  | [NAME]
Q1303 | 301 | 1234 | [NAME] |  |  |  |  |  |  | 0
Q1303 | 302 | 1234 | [NAME] |  |  |  |  |  |  | 0
Q1303 | 303 | 1234 | [NAME] | 2010-01-05 00:00:00 | 2010-06-05 00:00:00 | 2 | 10 | Apollo | A | 431.4285714285714
Spreadsheet: 871489d1717918310-used-input-function-and-text-but-unable-to-format-the-number-amt-input-and-format
Sheet: INV

 | xyz
 | xyz
 | xyz
 | BUYERS DETAILS:
 | xyz
 | xzz
 | zzz
 | zzzz
 | Material Description: |  | z
 | Invoice Quantity: |  | z
 | Rate: |  |  | <----- NEED THIS CELL NUMBER TO BE FORMATTED AS 0,000.00 ie 2,221.30 (THOUSAND COMMAS AND CENTS TWO DIGITS AT THE END), INPUT FORMULA IS USED WITH SOME TEXT(ITS CLEAR WHEN YOU CLICK THE CELL D18 AND SEE IN THE FORMULA BAR)
 | x |  | xx
 | x |  | xx
 | x |  | xx
 | x |  | xx
 | x |  | xx
Spreadsheet: daren_farmer__5382__Monthly Capacity Matrix
Sheet: June 00

Locations | Transport Receipts | Buy | Transport Usage | Net Supply | Transport Deliveries | Sell | Transport Usage | Net Market | Net Throughput
HPL 1 - Thompsonville |  | 203524 | 9189 |  | 1376 | 13000 | 0
HPL 14 - South TX | 7 | 547 | 0 |  | 45 | 6901 | 0
HPL 18 - Three Rivers | 766 | 300 | 0 |  |  | 4357 | 20973
HPL 21 - Big Cowboy | 630 | 0 |  |  |  | 0 | 9700
HPL 22 - Nueces |  | 0 | 0 |  | 1750 | 3000 | 50
HPL 2 - Robstown | 5320 | 157117 | 1 |  | 15102 | 3100 | 64271
HPL 19 - King Ranch | 148140 | 0 |  |  | 148140 | 0 | 0
HPL 3 - A/S South |  | 112822 | 0 |  | 7 | 21850 | 0
HPL 4 - A/S Central |  | 10000 | 0 |  | 34800 | 191362
HPL 5 - Edna | 5250 | 149189 | 50 |  | 15321 | 54109 | 0
HPL 6 - Texas City | 1409 | 17711 | 7801 |  | 984 | 147485
HPL 10 - Ship Channel |  | 77055 | 0 |  |  | 357271 | 400
HPL 15 - Katy |  | 188524 | 1084 |  |  | 178661 | 800
HPL 16 - West Loop |  | 134022 | 18 |  |  | 40001 | 0
HPL 17 - East Loop |  | 3604 | 0 |  |  | 42710
HPL 13 - Mid Texas |  |  | 0 |  |  |  | 45000
HPL 23 - Bammel |  | 52289 | 0 |  | 1770 | 29508 | 0
HPL 7 - A/S East | 37000 | 9224 | 0 |  |  | 48 | 0
HPL 8 - East Texas | 103 | 282075 | 25000 |  |  | 252150 | 5466
HPL 9 - Freeport |  | 4003 | 0 |  | 992 | 32001
HPL 11 - Corpus | 5000 | 1027 | 0 |  |  | 90137 | 0
HPL 12 - Valley |  | 19332 | 0 |  |  | 5097 | 0
HPL 20 - Hardin |  |  | 0 |  | 1046 | 3201 | 0
HPL 24 - Gas Loss |  | 0 |  |  |  | 64
HPL OffSystem | 7048 | 478 |  |  | 6076 | 11794
Transport Thruput
Net Supply and Market include transportation throughput.
Spreadsheet: 853431d1703280878-calculate-ytd-with-criteria-sample
Sheet: Sheet1

Cost Center Group | Date | Month number | Month | Year | Cash Out Periodic ACT 2023 | Cash Out YTD ACT 2023
ABC | 202301 | 01 | January | 2023 | -103.163
ABC | 202302 | 02 | February | 2023 | -126.68645954
ABC | 202303 | 03 | March | 2023 | -694.0294817612
ABC | 202304 | 04 | April | 2023 | -335.606061274
ABC | 202305 | 05 | May | 2023 | -112.265388672
ABC | 202306 | 06 | June | 2023 | -1014.767945601
ABC | 202307 | 07 | July | 2023 | 72.51450167889998
ABC | 202308 | 08 | August | 2023 | -490.786
ABC | 202309 | 09 | September | 2023 | -342.311
ABC | 202310 | 10 | October | 2023 | -378.4301621365
ABC | 202311 | 11 | November | 2023 | -263.086
ABC | 202312 | 12 | December | 2023 | -318.301044478
XYZ | 202301 | 01 | January | 2023 | -103.163
XYZ | 202302 | 02 | February | 2023 | -126.68645954
XYZ | 202303 | 03 | March | 2023 | -10.3714817612
XYZ | 202304 | 04 | April | 2023 | -30.402892344
XYZ | 202305 | 05 | May | 2023 | -7.154388672000001
XYZ | 202306 | 06 | June | 2023 | -5.362568712
XYZ | 202307 | 07 | July | 2023 | -14.1935640142
XYZ | 202308 | 08 | August | 2023 | 0
XYZ | 202309 | 09 | September | 2023 | 0
XYZ | 202310 | 10 | October | 2023 | -2.2667058672
XYZ | 202311 | 11 | November | 2023 | 0
XYZ | 202312 | 12 | December | 2023 | -4.324044477999999
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 7a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 134039181 | 78843600 | 212882781
FRA | 55461384 | 8464263 | 63925647
OIS | 28294597 | 9183257 | 37477854
Swaption | - | 21459397 | 21459397
OTHER* | 6700640 | 28308389 | 35009029
TOTAL | 224495802 | 146258906 | 370754708
* OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 1462eff4-5801-4a05-a2cf-cb4532e8f5c6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5253 | 32803 | [NAME] | Pe Benito | PHI | 61 | 00:23:35 | 00:00:00 | 00:38:26 | 00:00:00 | 00:14:47 | 1 | 01:16:47
5253 | 34720 | [NAME] | Lloyd | AUS | 0 | 00:23:06 | 00:00:00 | 00:43:28 | 00:00:00 | [NAME] | 2 | 01:19:07
5253 | 10625 | May | Benedicto | PHI | 0 | 00:22:42 | 00:00:00 | 00:43:57 | 00:00:00 | 00:13:36 | 3 | 01:20:17
Spreadsheet: 815950d1675277763-sumproduct-with-multiple-lookup-condition-sample-file
Sheet: Employee Data

Id | Employee | Position | Dept | Grade | Country | Joined on | Left on | Manager | Termination Status
Test | Test | Test | Test | Test | United States | 2019-07-15 00:00:00 | 2022-11-14 00:00:00 | Test | Voluntary
Test | Test | Test | Test | Test | United States | 2019-04-10 00:00:00 | 2022-05-14 00:00:00 | Test | Voluntary
Test | Test | Test | Test | Test | Denmark | 2019-04-10 00:00:00 | 2022-05-14 00:00:00 | Test | Involuntary
Spreadsheet: 109002d1305910625-excel-2007-multiple-frequencies-book1
Sheet: Sheet1

1 | 5 | 1 | 11 |  | 1-3 | 4-6 | 1-3 | 6-10 |  | 1
1 | 7 | 2 | 10
7 | 12 | 3 | 4
6 | 14 | 3 | 6
2 | 2 | 7 | 1
4 | 3 | 4 | 9
7 | 6 | 2 | 6
6 | 5 | 7 | 6
7 | 7 | 7 | 10
3 | 1 | 9 | 11
2 | 1 | 2 | 9
1 | 6 | 1 | 10
Spreadsheet: 46419d1245289420-lookup-match-list-names-matchteamlistnames
Sheet: Schedule

 |  | Team | 1 |  |  |  |  | Team |  | 2
 |  | [NAME] |  |  |  |  |  | Doug
 |  | [NAME] |  |  |  |  |  | Victor
 |  | [NAME] |  |  |  |  |  | [NAME]
 |  | [NAME] |  |  |  |  |  | [NAME]
 |  | Team | 8 |  |  |  |  | Team |  | 9
 |  | Bazil |  |  |  |  |  | Corinne
 |  | [NAME] |  |  |  |  |  | Connie
 |  | [NAME] |  |  |  |  |  | Sandra
 |  | Ian |  |  |  |  |  | [NAME]
Spreadsheet: 454958d1460045772-counting-customers-with-similar-names-count-customers
Sheet: Sheet1

Masters List |  | Step 1 - Delimit |  |  | Step 2 Show duplicates |  | Step 4 - Count # of Vendors
Walmart - sports |  | Walmart | sports |  | Walmart
Walmart - kitchen |  | Walmart | kitchen |  | Costco
Walmart - home good |  | Walmart | home good |  | Sams
Costco - toys |  | Costco | toys |  | Shop n Stop
Costco - food |  | Costco | food
Costco - home good |  | Costco | home good
Costco - electronics |  | Costco | electronics
Costco - pharmacy |  | Costco | pharmacy
Sams - toys |  | Sams | toys
Sams - goods |  | Sams | goods
Shop n Stop - food |  | Shop n Stop | food
Shop n Stop - drinks |  | Shop n Stop | drinks
Spreadsheet: 98726d1297593649-vlookup-or-other-formula-to-return-data-given-criteria-hadu
Sheet: Sheet1

Start | End | Date | No |  |  |  | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 2011-02-03 00:00:00
00:30:00 | 01:00:00 | 2011-02-01 00:00:00 | 15 |  | 00:30:00 | 01:00:00 | 15 | 5 | #N/A
01:30:00 | 02:00:00 | 2011-02-01 00:00:00 | 14 |  | 01:30:00 | 02:00:00 | 14 | 5
04:00:00 | 04:30:00 | 2011-02-01 00:00:00 | 15 |  | 04:00:00 | 04:30:00 | 15 | 4
05:00:00 | 05:30:00 | 2011-02-01 00:00:00 | 1 |  | 05:00:00 | 05:30:00 | 1 | 78
06:00:00 | 06:30:00 | 2011-02-01 00:00:00 | 8 |  | 06:00:00 | 06:30:00 | 8 | 112
06:30:00 | 07:00:00 | 2011-02-01 00:00:00 | 5 |  | 06:30:00 | 07:00:00 | 5 | 15
00:30:00 | 01:00:00 | 2011-02-02 00:00:00 | 5
01:30:00 | 02:00:00 | 2011-02-02 00:00:00 | 5
04:00:00 | 04:30:00 | 2011-02-02 00:00:00 | 4
05:00:00 | 05:30:00 | 2011-02-02 00:00:00 | 78
06:00:00 | 06:30:00 | 2011-02-02 00:00:00 | 112
06:30:00 | 07:00:00 | 2011-02-02 00:00:00 | 15
00:30:00 | 01:00:00 | 2011-02-03 00:00:00 | 19
01:30:00 | 02:00:00 | 2011-02-03 00:00:00 | 13
04:00:00 | 04:30:00 | 2011-02-03 00:00:00 | 11
05:00:00 | 05:30:00 | 2011-02-03 00:00:00 | 10
06:00:00 | 06:30:00 | 2011-02-03 00:00:00 | 5
06:30:00 | 07:00:00 | 2011-02-03 00:00:00 | 6