tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167199d1341926650-matching-columns-examplewriteoff
Sheet: Sheet1

Customer A | Customer Payment Balance | Customers with Credit balance | Credit Balance | More Credits than Payment Balance?
100 | 100 | 100 | 150 | Yes
200 | 300 | 200 | 0 | No
300 | 200 | 300 | 300 | No
400 | 500 | 800 | 100 | No
500 | 150 | 1000 | 425 | Yes
600 | 200 | Show all customers from col [NAME] If they do not show up in Col C, make col D balance  0
700 | 300 | Customers with no credit do not populate. I would like them to automatically pull from A
800 | 150
900 | 250
1000 | 400
 |  |  |  | Need help with highlighted
What I would Ideally like
Customer A | Customer Payment Balance | Customers with Credit balance | Credit Balance | More Credits than Payment Balance?
100 | 100 | 100 | 150 | Yes
200 | 300 | 200 | 0 | No
300 | 200 | 300 | 300 | No
400 | 500 | 400 | 0 | No
500 | 150 | 500 | 0 | Yes
600 | 200 | 600 | 0 | No
700 | 300 | 700 | 0 | No
800 | 150 | 800 | 100 | No
900 | 250 | 900 | 0 | No
1000 | 400 | 1000 | 425 | Yes
 |  | Red filled by new code given by poster
Spreadsheet: 01ff3e09-968d-4653-bae2-ef8266189083
Sheet: Sheet1

Member Association | Name | Last | [NAME] | Phone | Assignor | Last | [NAME] | Phone #
Seattle Youth Soccer Association | Cyndy | Masada | [EMAIL] | [PHONE] | Greg | Parker | [EMAIL] | [PHONE]
Yakima Youth Soccer Association | [NAME] | Bredwell | [EMAIL] | [PHONE] | [NAME] | Sabari | [EMAIL] | [PHONE]
North County Youth Soccer Association | Naomi | [NAME] | [EMAIL] | [PHONE]
Spokane Valley Junior Soccer Association | [NAME] | Philp | [EMAIL] | [PHONE] | [NAME] | [NAME] | [EMAIL] | [PHONE]
Lake Washington Youth Soccer Association | Connie | [NAME] | [EMAIL] | [PHONE] | [NAME] | Butler | [EMAIL] | [PHONE]
Federal Way Soccer Association | Novella | [NAME] | [EMAIL] | [PHONE] | [NAME] | Simone | [EMAIL] | [PHONE]
Northwest Sound Youth Soccer Association | [NAME] | Bjornemo | [EMAIL] | [PHONE] | [NAME] | Sommers | [EMAIL] | [PHONE]
South Snohomish County Youth Soccer Association | Dina | [NAME] | [EMAIL] | [PHONE] | Betty | Schmeck | [EMAIL] | [PHONE]
Whatcom County Youth Soccer Association | Lauire | Mueller | [EMAIL] | [PHONE] | Lance | Calloway | [EMAIL] | [PHONE]
Inland Empire Youth Soccer Association | [NAME] | Heuett | [EMAIL] | [PHONE] | Saeed | [NAME] | [EMAIL] | [PHONE]
Kent Youth Soccer Association | [NAME] | Crocker | [EMAIL] | 9194644613 | Scott | [NAME] | [EMAIL] | [PHONE]
Southwest Washington Youth Soccer Association | [NAME] | Hunting | [EMAIL] | [PHONE] | [NAME] | Brooks | [EMAIL] | [PHONE]
Eastside Youth Soccer Association | [NAME] | deCillia | [EMAIL] | 4253927966 | Iraj | Jalali | [EMAIL] | [PHONE]
Eastside Youth Soccer Association | [NAME] | deCillia | [EMAIL] | [PHONE] | [NAME] | Isaacson | [EMAIL] | [PHONE]
Tacoma Pierce County Junior Soccer Association | Ray | Moffatte | [EMAIL] | 2532975040 | [NAME] | Schmitt | [EMAIL] | [PHONE]
Whidbey Island Youth Soccer Association | Mark | Helpenstell | [EMAIL] | 4258792603 | Nick | Buschko | [EMAIL] | [PHONE]
 |  |  |  | 3605798633 |  |  |  | [PHONE]
Northshore Youth Soccer Association | M'ily | Reiter | [EMAIL] | (406) 671-5804 | Iraj | Jalali | [EMAIL] | [PHONE]
Three Rivers Soccer Club | [NAME] | [NAME] | [EMAIL]
Greater Renton Junior Soccer Association | Rich | Turner | [EMAIL] | (206) 948-6936 | [NAME] | Moore | [EMAIL] | (253) 653-1342
Snohomish County Youth Soccer Association | [NAME] | [NAME] | [EMAIL] | [PHONE]
Spreadsheet: 85427d1285529905-autofill-vlookup-function-stats-aggregate-example
Sheet: Week 11

TEAM AWESOME | ACW | Not Ready | Transfers | Hold | [NAME] | Unplanned Break |  | CSAT
1-2-1 = Done
1-2-1 = Ready
Week 11       Targets: | 00:00:20 | 0.15 | 0.15 | 00:01:10 | 0.07 | 0.005 |  | 4
user 1
user 2 | 0:00:18.815000 | 0.1428927606187232 | 0.2808988764044944 | 0:01:23.674000 | 0.1035593541502528 | 0.03720916316781522
user 3 | 0:00:39.137000 | 0.1127027634239497 | 0.2857142857142857 | 0:01:59.375000 | 0.07518310492024265 | 0
user 4
user 5 | 0:00:27.316000 | 0.2329994688519614 | 0.2363636363636364 | 0:01:21.313000 | 0.06544502617801047 | 0.04036725092950907
user 6 | 0:00:37.895000 | 0.1546010706092276 | 0.3064516129032258 | 0:02:09.653000 | 0.05830288611323532 | 0.03621094967003709
user 7 | 0:00:17.824000 | 0.1840753901507134 | 0.3602941176470588 | 0:02:27.662000 | 0.08626201641919062 | 0.004032392812983859 |  |  |  | Customer Install:
user 8 | 0:00:21.957000 | 0.1458239407572255 | 0.2131519274376417 | 0:00:36.812000 | 0.0828736966301835 | 0.003664303734328387 |  |  |  | ACW=20s
user 9 | 0:00:48.702000 | 0.1357239871281158 | 0.1904761904761905 | 0:00:55.161000 | 0.07976735929125739 | 0.007935031926105016 |  |  |  | Not Ready=15%
user 10 | 0:00:11.342000 | 0.19295251053904 | 0.1107594936708861 | 0:00:24.570000 | 0.08263579264514719 | 0.009506396316499216 |  |  |  | Total Transfers=15% or less
user 11 | 0:00:05.384000 | 0.2041063994919919 | 0.152 | 0:00:47.632000 | 0.1623932830028928 | 0.02367882593664009 |  |  |  | Hold=1min, 10sec
user 12 | 0:00:05.502000 | 0.1016278508380651 | 0.2060085836909871 | 0:00:26.476000 | 0.06840961806903934 | 0.01180742870936932
user 13 | 0:00:49.029000 | 0.08601704906787473 | 0.2821428571428571 | 0:02:36.039000 | 0.06688865229476453 | 0.006373750437659433
user 14 | 0:00:36.861000 | 0.1603529642683416 | 0.2913907284768212 | 0:00:44.447000 | 0.1116667662294438 | 0.01379086696421714
user 15 | 0:00:53.913000 | 0.1392165817670824 | 0.2644230769230769 | 0:03:09.346000 | 0.08255752678728263 | 0.01490251185666608
user 16 | 0:00:51.809000 | 0.1109536703189813 | 0.2508833922261484 | 0:02:39.134000 | 0.07112894400875433 | 0.006981953544054583
user 17 | 0:00:20.316000 | 0.1247424260486027 | 0.2782608695652174 | 0:02:19.113000 | 0.07918802472709933 | 0.02123033781213989
user 18 | 0:00:11.619000 | 0.1095930589107353 | 0.2156862745098039 | 0:01:42.188000 | 0.08179883853008461 | 0.01424907077074034
user 19
user 20
user 21
Spreadsheet: michelle_lokay__26611__Jan01pnr
Sheet: USGT(NA) 500622

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | USGT | 27268 | 00/12 | 500622 | PnR
1 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
2 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
3 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
4 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
5 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
6 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
7 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
8 |  |  |  |  |  |  |  |  |  |  | 0 | 0.3883
9 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
10 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
12 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
13 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
14 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
15 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
16 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
17 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
18 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
19 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
20 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
21 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
22 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
25 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
27 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
29 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
30 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
31 |  |  |  |  |  |  |  | 0 |  |  | 0.383 | 0.3883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 25725d1217262091-finding-a-match-in-a-table-example
Sheet: Sheet1

 | Orange | Red | Blue | Yellow | Green
[NAME] | 23 |  | 44 |  | 67
[NAME] |  |  | 55 | 87
[NAME] | 26 | 23
[NAME] | 1 |  | 65 | 44
[NAME] | 51 | 57 |  |  | 77
[NAME]
Spreadsheet: 685122d1593747980-determine-if-combination-of-data-in-excel-b-referencing-a-is-correct-checking_if_data_matches_reference_file
Sheet: Sheet1

Reference Dataset A
Country | unit | sub unit | Level1 | level2 | level 3 | level 4
UK | A | AA | x | all | all
France | B | ABC | x | y2 | y2a | all
UK | A | AA | x | x1 | x2
Dataset B
Unique ID | Review Group | Country | unit | sub unit | Level1 | level2 | level 3 | level 4 | Correct/Wrong?
123 | 111 | UK | A | AA | x | all | All |  | Correct
124 | 222 | France | B | ABC | y | y2 | y2a | all | Wrong
125 | 111 | UK | A | AA | z | x1 | All |  | Wrong
Spreadsheet: 831972d1686037379-combine-pairing-multiple-row-in-one-column-to-another-column-learning-excel-case-2
Sheet: Sheet1

 | SKU | CHANNEL
 | ABC | AA
 | BCD | BB
 | CDE | CC
 | DEF
 | EFG
 | FGH
 | GHI
 | HIJ
 | IJK
 | JKL
 | MODEL | CHANNEL | UNIQUE
 |  |  |  |  | blue color is expected result
Spreadsheet: 63888d1264746736-formula-assistance-needed-book1
Sheet: Sheet1

89 |  |  | 0 | 49 | 0
34 |  |  | 50 | 59 | 2500
58 |  |  | 60 | 69 | 5000
46 |  |  | 70 | 79 | 75000
95 |  |  | 80 | 100 | 10000
29
94
22
87
46
36
17
31
88
29
91
74
23
65
29
66
24
17
62
79
20
99
3
48
74
70
43
83
4
62
63
10
43
29
7
87
7
40
8
52
9
66
97
44
11
44
34
96
93
69
49
25
79
58
1
40
27
11
38
29
99
62
8
73
39
38
70
71
75
57
5
89
90
66
25
21
Spreadsheet: 866311d1713270609-consolidating-reults-in-summary-sheet-summary
Sheet: Summary Sheet

Ticket Numbers | 2024-04-15 00:00:00 | 2024-04-14 00:00:00 | 2024-04-13 00:00:00 | 2024-04-12 00:00:00
Ticket 1 | Closed | Closed | Open | Open
Ticket 2 | Open | Closed | Closed | Open
Ticket 3 | Closed | Closed | Open | N/A
Ticket 4 | Closed | Closed | Open | N/A
Ticket 5 | Closed | Open | N/A | N/A
Ticket 6 | Closed | Open | N/A | N/A
Ticket 7 | Closed | Open | N/A | N/A
Ticket 8 | Closed | Open | N/A | N/A
Ticket 9 | Closed | Open | N/A | N/A
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: firm9712

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1997-12-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.35 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.44
IFGMR (PEPL/TX/OK) |  |  | 2.35
IFGMR (ANR/LA) |  |  | 2.43
IFGMR (HENRY HUB) |  |  | 2.55
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001 | 3.93
 | 1993 | 2.4 | 2002 | 4.23
 | 1994 | 2.51 | 2003 | 4.73
 | 1995 | 2.61 | 2004 | 5.07
 | 1996 | 2.53 | 2005 | 5.43
 | 1997 | 2.65 | 2006 | 5.82 | JAN-SEP
 | 1998 | 2.67 | 2006 | 5.95 | OCT-DEC
 | 1999 | 2.9 | 2007 | 6.37
 | 2000 | 3.33
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 762362d1641509611-countif-department-matches-and-date-range-30-matches-fake-report-keebellah-
Sheet: December Data

Name | Department | Last Logon Date | X
Fake User 1 | Fake Department 1 | 03/11/2019
Fake User 2 | Fake Department 2
Fake User 3 | Fake Department 2 | 01/01/2022
Fake User 4 | Fake Department 3
Fake User 5 | Fake Department 1 | 29/06/2021
Fake User 6 | Fake Department 1 | 01/01/2022
Fake User 7 | Fake Department 3 | [NAME]
Spreadsheet: darrell_schoolcraft__7344__Displacement-Bidirectional011002
Sheet: Sheet1

POI # | POI Name | POI Status | Type | Flow Direction | Group Name | Valid Pool Basin
500540 | El Paso Bloomfield | Active | Displacement | O | Displacement IT Group
56422 | PNM Bloomfield | Active | Displacement | O | Displacement IT Group
8516 | Oasis Block 16 | Active | Displacement | O | Displacement IT Group
57245 | [NAME] | Active | Displacement | O | Displacement IT Group
6838 | [NAME] | Active | Displacement | I | Displacement IT Group
500154 | [NAME] | Active | Displacement | O | Displacement IT Group
56698 | PGE Topock | Active | Displacement | O | Displacement IT Group
500540 | El Paso Bloomfield | Active | Displacement | O | Displacemet SP Group | [NAME]
56422 | PNM Bloomfield | Active | Displacement | O | Displacemet SP Group | San Juan
8516 | Oasis Block 16 | Active | Displacement | O | Displacemet SP Group | West Texas
57245 | [NAME] | Active | Displacement | O | Displacemet SP Group | West Texas
6838 | [NAME] | Active | Displacement | I | Displacemet SP Group | Central
500154 | [NAME] | Active | Displacement | O | Displacemet SP Group | West Texas
500515 | Velero Pecos | Active | Bi-Dierctional | B
1635 | NNG Ward | Active | Bi-Dierctional | B
9278 | NNG Cactus Lateral | Active | Bi-Dierctional | B
60667 | NNG Gray | Active | Bi-Dierctional | B
60749 | NNG Halley | Active | Bi-Dierctional | B
60921 | PNM Rio Puerco | Active | Bi-Dierctional | B
500168 | Westrar Ward | Active | Bi-Dierctional | B
Spreadsheet: 807086d1669734094-looking-for-a-better-option-than-sumproduct-due-to-near-15-000-formulas-of-it-sample-sheet
Sheet: Sheet3

Type 1 |  | Name 1
Type 2 |  | Name 2
Type 3 |  | Name 3
Type 4 |  | Name 4
Type 5 |  | Name 5
Type 6 |  | Name 6
Type 7 |  | Name 7
Type 8 |  | Name 8
Type 9 |  | Name 9
Type 10 |  | Name 10
 |  | Name 11
 |  | Name 12
 |  | Name 13
 |  | Name 14
 |  | Name 15
 |  | Name 16
 |  | Name 17
 |  | Name 18
 |  | Name 19
 |  | Name 20
Spreadsheet: 789331d1659038517-error-when-adding-a-blank-cell-midshires-master-test
Sheet: Playing

 |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total |  | Stroke Index
1 |  | PLAYER             Par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAR | Playing H'Caps
1 | H'Cap | Stroke/Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | 3 | S/I 1 | S/I 2 | S/I 3
1 |  | SKINS
1
Spreadsheet: 849512d1699966133-sort-with-unique-filter-piper
Sheet: Manual Solution

MY parkruns - ALL COMPLETED RUNS - PIPER |  |  |  |  |  |  | RETURN TO CONTENTS & INSTRUCTIONS / GUIDE
Complete at least 5 Unique Events (Venues) in 5 different countries.
Country # | Unique Event (Venue) # | Country | Event (Venue) | Date Completed | # [NAME]
Country #1 | Run #1 | United Kingdom
Country #1 | Run #2 | United Kingdom
Country #1 | Run #3 | United Kingdom
Country #1 | Run #4 | United Kingdom
Country #1 | Run #5 | United Kingdom
Country #2 | Run #1 | Netherlands
Country #2 | Run #2 | Netherlands
Country #2 | Run #3 | Netherlands
Country #2 | Run #4
Country #2 | Run #5
Country #3 | Run #1 | Poland
Country #3 | Run #2 | Poland
Country #3 | Run #3
Country #3 | Run #4
Country #3 | Run #5
Country #4 | Run #1 | Germany
Country #4 | Run #2 | Germany
Country #4 | Run #3
Country #4 | Run #4
Country #4 | Run #5
Country #5 | Run #1 | France
Country #5 | Run #2
Country #5 | Run #3
Country #5 | Run #4
Country #5 | Run #5
Spreadsheet: 224186d1364480252-remove-the-absent-students-from-the-list-of-failing-students-list-of-faling-students
Sheet: List of Failing Students

List of Failures
SN | Student's Name | Student No. | Mark | Grade
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Spreadsheet: 60544d1261064840-vllokup-across-multiple-tabs-sample
Sheet: Price Sheet

Product # | Quantity | Price | Roll | Position | [NAME] (across) | Length (around) | Die | Stock | Liner | Adhesive | Colors
10376907 | 6200 | 89.5 | 8" | Left Off | 0.625 | 2.85 | 0914D-L-40 | 3 [NAME] Matte White BOPP | 50# Paper | S4600 | 2 + V
30-2775 | 18000 | 37.8 | 8" | Left Off | 0.8 | 3.35 | 0873D-L-32 | 3 [NAME] Matte White BOPP | 50# Paper | S4600 | 2 + V
4062VL | 78000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
831398 |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 24

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap dollar volumes, week ending January 4, by product type and cleared status (value of all trades in millions of USD), all participant types, tenors, and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 754892d1636557252-counting-from-left-to-right-counting-left-to-right
Sheet: Sheet1

 |  | FIRST PART OF FORMULA RESULTING IN |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | SECOND PART OF SAME FORMULA |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | RESULTING IN |  |  |  | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 11 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 13 | 0 | 0
 |  |  |  |  |  | 0 | 2 | 0 | 0 | 0 | 14 | 0 | 0
 |  |  |  |  |  | 0 | 3 | 0 | 0 | 0 | 15 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 4 | 0 | 0 | 0 | 16 | 0
 |  |  |  |  |  | 0 | 0 | 5 | 0 | 0 | 0 | 17 | 0
 |  |  |  |  |  | 0 | 0 | 6 | 0 | 0 | 0 | 18 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 747481d1631532850-data-extraction-from-other-sheets-based-on-the-value-from-the-dropdown-list-book1
Sheet: Details of Salary

Total
ID | DEPT | BASIC SALARY | OVERTIME | BONUS | COMMISSION
B00003 |  | 150
B00005 |  | 200
B00009 |  | 100
B00014 |  | 300
B00025 |  | 275
[NAME] |  | 310
B00018 |  | 345
A00007 |  | 380 | 25
A00022 |  | 415 | 60
A00063 |  | 450 | 70
A00028 |  | 485 | 96.6666666666667
A00087 |  | 520 | 119.166666666667
A00044 |  | 555 | 141.666666666667
A00050 |  | 590 | 164.166666666667
A00056 |  | 625 | 186.666666666667
A00061 |  | 660 | 209.166666666667
[NAME] |  | 695 | 231.666666666667
A00038 |  | 730 | 254.166666666667
A00039 |  | 765 | 276.666666666667
A00040 |  | 800 | 299.166666666667
A00041 |  | 835 | 321.666666666667
[NAME] |  | 870 | 344.166666666667
A00075 |  | 905
A00005 |  | 940
A00006 |  | 975
A00011 |  | 1010
A00032 |  | 1045
A00043 |  | 1080
A00045 |  | 1115
A00052 |  | 1150
A00054 |  | 1185
A00049 |  | 1220
A00047 |  | 1255
A00046 |  | 1290
Spreadsheet: 5d7ec841-2ff1-47a7-b6a4-d650d6bfcb81
Sheet: 4X4

LIGHT TRUCKS, LESS THAN 12,500 GVWR, 4-WHEEL DRIVE (4X4)
 | Equip. | Federal | 2014 Monthly | 2014 Mileage
Vehicle Description | Code | Std. Item | Rate | Rate
Compact Pickup, [NAME] | 6121 | 66C | 217 | 0.21
Compact Pickup, [NAME] | 6122 | 67E | 222 | 0.21
4X4 Jeep [NAME] | 6165 | 122, 5A | 392 | 0.313
4X4 SUV, Compact | 6170 | 99A | 307 | 0.21
Sport Utility, 4-Door | 6175 | 99, 99Z | 298 | 0.21
Sport Utility | 6181 | 96 | 324 | 0.21
4X4 SUV, Crossover | 6188 | 96B | 327 | 0.21
Van, Passenger | 6208 | 21X | 220 | 0.25
Van, Cargo | 6209 | 31X | 196 | 0.25
Sport Utility, Police Use, 4-Door | 6223 | 100L | 359 | 0.275
Sport Utility, Special Services | 6243 | 105C, 105F | 354 | 0.26
Sport Utility, Intermediate, 4-Door | 6245 | 105A | 338 | 0.26
Pickup, Regular Cab | 6250 | 46, 47Z | 242 | 0.25
Pickup, [NAME] | 6251 | 46C | 250 | 0.25
Pickup, [NAME] | 6252 | 55 | 263 | 0.25
Pickup, [NAME] Special Services | 6253 | 55C | 303 | 0.26
Sport Utility, 4-Door | 6275 | 105B, 105J, 106C | 328 | 0.24
Sport Utility, 4-Door | 6277 | 106 | 346 | 0.295
Sport Utility, 4-Door | 6279 | 105A | 312 | 0.24
Pickup, Regular Cab | 6350 | 49, 49A, 49B | 275 | 0.31
Pickup, [NAME] | 6351 | 49C, 49D, 49E | 285 | 0.31
Pickup, [NAME] | 6352 | 57, 57A, 57Z, 59A | 308 | 0.31
Service Utility | 6355 | 87, 88, 89A | 296 | 0.32
Service Utility, [NAME] | 6356 | 147, 149 | 319 | 0.32
Service Utility, [NAME] | 6357 | 87C, 88C, 89C | 308 | 0.32
Chassis & Cab, 2-Door | 6370 | 77, 78, 79A | 296 | 0.32
Chassis & Extended Cab | 6371 | 77C, 78C, 79C | 308 | 0.32
Chassis & Crew Cab | 6372 | 78E, 79E | 319 | 0.32
Sport Utility, 4-Door | 6375 | 108C | 341 | 0.3
Stake [NAME], 2-Door | 6380 | 128, 129 | 296 | 0.33
Stake, [NAME] | 6381 | 128E, 129D | 319 | 0.33
Stake, Ext.Cab | 6382 | 128C, 129C | 308 | 0.33
Dump Truck | 6390 | 159 | 296 | 0.33