tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787c3e8e-d359-4493-b0f0-bfaeecff3ff3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2124 | 5993 | [NAME] | [NAME] | SVK | 75 | 00:30:39 | 00:00:56 | 00:40:30 | 00:01:25 | 00:30:55 | 1 | 01:43:27
2124 | 10473 | [NAME] | [NAME] | AUT | 74 | 00:31:19 | 00:01:02 | 00:40:31 | 00:01:30 | 00:30:46 | 2 | 01:44:05
2124 | 7767 | [NAME] | Viana | ITA | 73 | 00:30:27 | 00:01:00 | 00:47:10 | [NAME] | 00:30:32 | 3 | 01:49:37
2124 | 10436 | [NAME] | Powlison | USA | 0 | 00:34:44 | 00:01:13 | 00:44:41 | 00:01:43 | [NAME] | 4 | 01:56:07
2124 | 9956 | [NAME] | Lobo | ESP | 72 | 00:32:08 | 00:01:08 | 00:50:00 | [NAME] | 00:35:27 | 5 | 01:59:22
Spreadsheet: 125668d1319149954-using-names-to-reference-a-worksheet-workingpayroll
Sheet: ABC 10-15

Detail Departmental Report
ICONTROLESI (2941700)
Dept Total |  |  | 86.67 | 0 | 86.67 | 1750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1750 | 2197.97 | 447.97
Dept Total |  |  | 346.68 | 0 | 346.68 | 12195.83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12195.83 | 14442.87 | 2247.04
Dept Total |  |  | 173.34 | 0 | 173.34 | 14194.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14194.06 | 15608.59 | 1414.53
Dept Total |  |  | 520.02 | 1.5 | 521.52 | 14376.72 | 29.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14405.97 | 17426.74 | 3020.77
Dept Total |  |  | 173.34 | 0 | 173.34 | 7291.67 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7291.67 | 8359.88 | 1068.21
Grand Total |  |  | 1300.05 | 1.5 | 1301.55 | 49808.28 | 29.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 49837.53 | 58036.05 | 8198.52
Spreadsheet: 0c8932cf-e0de-4ad0-a99c-a7fe094d2e3e
Sheet: Sheet1

Creator: | [NAME]
[NAME] | [EMAIL]
College | Oglala Lakota College
Date: | 2009-03-30 00:00:00
Field Date: | June, 2008
Overview: | This spreadsheet includes data for the ACT-Intl project funded by National Science Foundation International Travel Grant.  [NAME] were taken by a team of faculty and students from Oglala Lakota College (OLC), Ohio Northern University (ONU), South Dakota School of Mines and Technology (SDSMT), University of Jordan at Muctah (UnJ) and the Erdenet Branch of Mongolian University of Science and Technology (EST).  [NAME] and [NAME] (OLC) conducted the preliminary geospatial analysis.  [NAME] (ONU) prepared the Quality Assurance Project Plan.  [NAME] (EST) was the Mongolian project coordinator.
Field Conditions: | Site 1 was sampled on a clear day.  All other sample sites were samped following a significant rainstorm.  Stream sites other than Site 1 were flowing at or near bankfull levels of flow (e.g. 2-year flood stage).
Field Sampling: | We collected triplicate samples of stream water.  [NAME] were filtered using a 0.2 ug filter and preserved with nitric acid.  We collected unpreserved samples for IC analysis.  We collected grab samples of stream bed and terrace deposits.  We measured the following physical parameters: Temperature, pH, TDS, Flow (using surface flow and multiplying by 0.85 to convert to mean flow), stream bed ([NAME] pebble count).  We also surveyed the sites using a theadolite.  We also collected ground water samples from a nearby well and a sample of tap water at the Erdenet Hotel.
Laboratory Analysis | Sediment samples were analyzed by [NAME] (OLC) using an XRF semi-quantitative method and on AA flame and furnace (Arsenic only) after  following EPA Method 3050 to leach metals from sediments using nitric acid.  Sample site 4.5B (T005) was also analyzed on ICP MS for quality control.
Raw Data - XRF | This spreadhsheet contains raw XRF data
XRF-Results | This spreadsheet contains XRF data as oxides in mass percent and ppm and metal oxides reported as metals in ppm
AA_Sediments | This spreadsheet contains the results of AA analysis of the supernatent after leaching with nitic acid following EPA method 3050
Method_Compare | This spreadsheet compares the two methods XRF and AA flame
AA_water | This spreadsheet contains data about the water samples we collected, which was analyzed using AA furnace.  Flow rates are measured flows at the time of sample collection.  Simulated flow assumes a baseflow of 30% of the 2-year peak flow.
Quality Assurance | This spreadsheet contains quality assurance data from ICP MS for a "white sands" sample (e.g. mine tailings)
Spreadsheet: 2eb3ad96-c443-47c0-b67e-ecbec8e4ac4a
Sheet: Region 7E

Early Scholars by Region
Inputs: |  | Compensatory Multiplier | 0.39
 |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O
 |  |  |  |  |  |  |  |  |  | Enrollment |  |  |  | Portion of
 |  |  |  |  |  |  | Enrollment |  | Capped | Adjusted |  | Initial | Cumulative | Available | Pathway II
 |  |  |  |  |  |  | KGN |  | Poverty | For Low |  | Scholarship | Scholarships | Pathway II | Total Amount | Existence of
 |  |  |  | Enrollment | Enrollment | Enrollment | Low | Poverty | Portion | Income | Compensatory | Count | Until [NAME] of | Scholarships | for all 4 Star | City of 1st Class (C),
 |  |  |  | KGN | KGN | KGN | Income | Concentration | = Lesser of | Portion | Multiplier | =Greater of |  | After Adjusting | Programs within | FY13 Scholarships (S), |  | Parent
District # | Type | District Name | EconDev | Total | Free | Reduced | =E+F*0.5 | =D/A | E or .8 | =D*F | * G | 10 or G | is [NAME] | for [NAME] | District Boundary | or Priority School (P) | County | Aware
480 | 1 | ONAMIA PUBLIC SCHOOL DISTRICT | 07E | 41 | 27 | 4 |  |  |  |  |  |  |  |  |  | P | [NAME] | 14
2165 | 1 | HINCKLEY-FINLAYSON SCHOOL DISTRICT | 07E | 81 | 45 | 7 |  |  |  |  |  |  |  |  |  |  | Pine | 13
2580 | 1 | EAST CENTRAL SCHOOL DISTRICT | 07E | 58 | 31 | 4 |  |  |  |  |  |  |  |  |  |  | Pine | 13
332 | 1 | MORA PUBLIC SCHOOL DISTRICT | 07E | 148 | 74 | 12 |  |  |  |  |  |  |  |  |  |  | [NAME] | 14
333 | 1 | [NAME] PUBLIC SCHOOL DISTRICT | 07E | 51 | 24 | 5 |  |  |  |  |  |  |  |  |  |  | [NAME] | 14
473 | 1 | ISLE PUBLIC SCHOOL DISTRICT | 07E | 40 | 17 | 7 |  |  |  |  |  |  |  |  |  |  | [NAME] | 14
578 | 1 | PINE CITY PUBLIC SCHOOL DISTRICT | 07E | 124 | 56 | 8 |  |  |  |  |  |  |  |  |  |  | Pine | 13
139 | 1 | RUSH CITY PUBLIC SCHOOL DISTRICT | 07E | 64 | 28 | 2 |  |  |  |  |  |  |  |  |  |  | [NAME] | 15
314 | 1 | BRAHAM PUBLIC SCHOOL DISTRICT | 07E | 55 | 20 | 7 |  |  |  |  |  |  |  |  |  |  | Isanti | 14
911 | 1 | CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST | 07E | 421 | 151 | 32 |  |  |  |  |  |  |  |  |  |  | Isanti | 14
912 | 1 | MILACA PUBLIC SCHOOL DISTRICT | 07E | 149 | 50 | 15 |  |  |  |  |  |  |  |  |  |  | [NAME] | 14
477 | 1 | PRINCETON PUBLIC SCHOOL DISTRICT | 07E | 237 | 66 | 13 |  |  |  |  |  |  |  |  |  |  | [NAME] | 14
577 | 1 | WILLOW RIVER PUBLIC SCHOOL DISTRICT | 07E | 23 | 6 | 1 |  |  |  |  |  |  |  |  |  |  | Pine | 13
138 | 1 | NORTH BRANCH PUBLIC SCHOOLS | 07E | 208 | 50 | 16 |  |  |  |  |  |  |  |  |  |  | [NAME] | 15
2144 | 1 | CHISAGO LAKES SCHOOL DISTRICT | 07E | 228 | 43 | 13 |  |  |  |  |  |  |  |  |  |  | [NAME] | 15
Spreadsheet: 793669d1661623758-generate-a-list-of-a-filtered-dataset-generatelists
Sheet: GenerateLists

Name | Put/Call | Strike | Amount
A29 | P | 700 | 4
AEX | P | 725 | -10
A29 | P | 713 | -1
A29 | P | 718 | 3
A29 | C | 722 | -3
A29 | C | 718 | 8
A29 | C | 720 | 3
A29 | C | 716 | -5
A29 | P | 712 | 1
A29 | P | 717 | -3
A29 | P | 716 | -5
AEX | P | 710 | -4
AEX | C | 700 | -2
AEX | P | 700 | 3
AEX | C | 715 | 4
AEX | C | 710 | -4
AEX | P | 705 | 4
AEX | P | 700 | 4
AEX | C | 730 | 5
AEX | P | 720 | 1
AEX | C | 755 | 2
Unique names (extrcted by UNIQUE; there could be more)
AEX
Sorted array on Strike with Amount > 0 for P of each unique name (how can I loop through all and create the following?)
 | P | 718 | 3
A29 | P | 712 | 1
A29 | P | 700 | 4
 | P | 717 | -3
A29 | P | 716 | -5
A29 | P | 713 | -1
Sorted array on Strike with Amount < 0 for P of each unique name
 | P | 720 | 1
AEX | P | 705 | 4
AEX | P | 700 | 3 |  | Remark: October
AEX | P | 700 | 4 |  | Remark: November
 | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF!
Hoe can I do this?
list to generate for each unique name
A29 | P | 718 |  | 717 |  |  |  | P | 718 |  | 717
A29 | P | 718 |  | 717 |  |  | A29 | P | 718 |  | 717
A29 | P | 718 |  | 717 |  |  | A29 | P | 718 |  | 717
A29 | P | 712 |  | 715 |  |  | A29 | P | 712 |  | 716
A29 | P | 700 |  | 715 |  |  | A29 | P | 700 |  | 716
A29 | P | 700 |  | 715 |  |  | A29 | P | 700 |  | 716
A29 | P | 700 |  | 715 |  |  | A29 | P | 700 |  | 716
A29 | P | 700 |  | 715 |  |  | A29 | P | 700 |  | 716
A29 | P |  |  | 713 |  |  |  |  |  |  | 713
AEX | P | 720 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 710
AEX | P |  |  | 710
AEX | P |  |  | 710
Spreadsheet: 117432d1312808137-combining-data-chicago-79
Sheet: Lamp, Dennis (P)

Game# | W | L | SV | H | BS | G | GS | CG | SO | OUTS | H | R | ER | BB | K
1
2 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 27 | 6 |  |  | 4 | 4
3
4
5 | 1 |  |  |  |  | 1 | 1 |  |  | 21 | 7 | 2 | 2 |  | 5
6
7
8
9
10 |  |  |  |  |  | 1 | 1 |  |  | 21 | 10 | 4 | 4 | 4 | 3
11
12
13
14 | 1 |  |  |  |  | 1 | 1 |  |  | 18 | 8 | 5 | 5 | 1 | 1
15
16
17
18
19 |  |  |  |  |  | 1 | 1 |  |  | 24 | 7 | 6 | 6 | 1 | 4
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
156
157
158
159
160
161
162
Totals | 3 | 0 | 0 | 0 | 0 | 5 | 5 | 1 | 1 | 111 | 38 | 17 | 17 | 10 | 17
Spreadsheet: 847910d1698754779-bulk-substitute-in-a-spilling-array-cannot-split-v2
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array) |  |  | spilling array with bulk substitute
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty
 |  |  |  |  |  |  | split (via substituted range O2#) - works |  |  |  | split (via substituted array) - does NOT work
 |  |  |  |  |  |  | ID | Size | Label |  | ID | Size | Label
 |  |  |  |  |  |  |  | 32 | rty
 |  |  |  |  |  |  | aze | 32 | rty
 |  |  |  |  |  |  | aze | 32 | rty
 |  |  |  |  |  |  | aze | 32 | rty
 |  |  |  |  |  |  | aze | 32 | rty
Spreadsheet: 877667d1724466392-redundancy-calc-with-a-difference-a-formula-question-redundancy-calc-with-a-difference-jt
Sheet: #30

 | Redundancy Calc with a difference
 |  |  |  |  | Age @ | Years | Age @ | 0.5 | 1 | 1.5 | Completed | Total
 | Employee Name | DOB | Hire Date | Exit Date | Hire | Worked | Exit | X | Y | Z | Years | Weeks
 | Empl 001 | 1964-04-23 00:00:00 | 2018-09-20 00:00:00 | 2024-09-30 00:00:00 |  |  |  |  |  |  |  |  |  | This one works
 | Empl 002 | 1964-04-23 00:00:00 | 2018-09-20 00:00:00 | 2024-09-19 00:00:00 |  |  |  |  |  |  |  |  |  | Should be 5 in Col K as there are 5 full years, 0 in Col I
 | Empl 008 | 1964-04-23 00:00:00 | 2017-02-20 00:00:00 | 2024-09-30 00:00:00 |  |  |  |  |  |  |  |  |  | Should be 7 in Col K as there are 7 full years, 0 in Col I
 |  | 0.5 week’s pay for each full year worked when you’re under 22
 |  | 1 week’s pay for each full year worked when you’re between 22 and 41
 |  | 1.5 week’s pay for each full year worked when you’re 41 or older
Spreadsheet: 775547d1649171872-i-would-like-to-remove-unit-suite-and-floor-from-and-addresses-revised-sample-address-file
Sheet: Sheet1

Current Address Format |  |  |  |  |  | Desired Address Format
8006 DISCOVERY DR STE 300 |  |  |  |  |  | 8006 Discovery Place | STE 300
7319 SPRING HILL DR
303 PEACHTREE CENTER AVE NE STE 200 |  |  |  |  |  | 303 Peachtree Center Ave NE | STE 200
2520 NORTHWINDS PKWY FL 4 |  |  |  |  |  | 2520 Northwinds Pkwy | FL 4
7455 CHANCELLOR DR FL 2 |  |  |  |  |  | 7455 Chancellor Dr | FL 2
3333 PEACHTREE RD NE FL 10 |  |  |  |  |  | 3333 Peachtree Rd NE | FL 10
110 S STRATFORD RD FL 3 |  |  |  |  |  | 110 S Stratford Rd | FL 3
434 FAYETTEVILLE ST FL 29 |  |  |  |  |  | 434 [NAME] | FL 29
150 W MAIN ST FL 14 |  |  |  |  |  | 150 W Main St | FL 14
1445 NEW YORK AVE NW FL 4 |  |  |  |  |  | 1445 New York Ave NW | FL 4
214 N TRYON ST FL 19 |  |  |  |  |  | 214 N Tryon St | FL 19
3333 PEACHTREE RD NE FL 11 |  |  |  |  |  | 3333 Peachtree Rd NE | FL 11
2 W WASHINGTON ST STE 800 |  |  |  |  |  | 2 Washington St | Ste 800
3333 PEACHTREE RD NE FL 10 |  |  |  |  |  | 3333 Peachtree Rd NE | FL 10
1001 SEMMES AVE FL 6 |  |  |  |  |  | 1001 Semmes Ave | FL 6
303 PEACHTREE CENTER AVE NE STE 200 |  |  |  |  |  | 303 Peachtree Ave NE | Ste 200
2636 W NORTH AVE UNIT 1A |  |  |  |  |  | 2636 W North Ave | Unit 1A
41 RACHEL DR
7455 CHANCELLOR DR
101 N CHERRY ST FL 7 |  |  |  |  |  | 101 N [NAME] | FL 7
Spreadsheet: 863795d1711190298-plug-y-if-last-4-letters-are-vowels-otherwise-leave-blank-last-4-letter-as-vowel-1-
Sheet: Sheet1

 |  |  |  |  | 4 | 3
[NAME] |  | s | 1963 | ABEEILNU
ABSEILER |  | s | 1964 | ABEEILRS
SEABLITE |  | s | 1965 | ABEEILST
BEAUTIES |  |  | 1966 | ABEEISTU
DELICATE |  | s | 1967 | ACDEEILT
AUDIENCE |  | s | 1968 | ACDEEINU
DECIARES |  |  | 1969 | [NAME]
SALIENCE |  | s | 1970 | ACEEILNS
ESCALIER |  | s | 1971 | ACEEILRS
EUCAINES |  |  | 1972 | ACEEINSU
CAUSERIE |  | s | 1973 | ACEEIRSU
Spreadsheet: 22151d1210729856-spread-sheet-formulas-and-drop-down-pay
Sheet: Pay Chart

 |  | Grade | 1 | 2 | 3 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26
 |  | O-10 | - | - | - | - | - | - | - | - | - | - | - | 1808 | 1808 | 1808 | 1808
 |  | [NAME] | - | - | - | - | - | - | - | - | - | - | - | 1649 | 1672 | 1707 | 1766
 |  | O-8 | 1166 | 1205 | 1229 | 1237 | 1268 | 1321 | 1333 | 1384 | 1398 | 1441 | 1504 | 1562 | 1600 | 1600 | 1600
 |  | O-7 | 969 | 1014 | 1035 | 1051 | 1082 | 1112 | 1145 | 1179 | 1214 | 1321 | 1412 | 1412 | 1412 | 1412 | 1419
 |  | O-6 | 717 | 789 | 840 | 840 | 844 | 880 | 885 | 885 | 935 | 1025 | 1076 | 1128 | 1158 | 1188 | 1246
 |  | O-5 | 598 | 675 | 721 | 730 | 759 | 776 | 815 | 842 | 879 | 935 | 960 | 987 | 1017 | 1017 | 1017
 |  | O-4 | 516 | 589 | 638 | 647 | 684 | 723 | 773 | 810 | 838 | 853 | 862 | 862 | 862 | 862 | 862
 |  | O-3 | 454 | 514 | 556 | 605 | 634 | 667 | 687 | 721 | 739 | 739 | 739 | 739 | 739 | 739 | 739
 |  | O-2 | 392 | 447 | 497 | 532 | 543 | 543 | 543 | 543 | 543 | 543 | 543 | 543 | 543 | 543 | 543
 |  | O-1 | 341 | 354 | 427 | 427 | 427 | 427 | 427 | 427 | 427 | 427 | 427 | 427 | 427 | 427 | 427
 |  | O-3E | - | - | - | 605 | 634 | 667 | 687 | 721 | 749 | 766 | 789 | 789 | 789 | 789 | 789
 |  | O-2E | - | - | - | 532 | 543 | 560 | 590 | 612 | 629 | 629 | 629 | 629 | 629 | 629 | 629
 |  | O-1E | - | - | - | 427 | 457 | 474 | 492 | 508 | 532 | 532 | 532 | 532 | 532 | 532 | 532
 |  | W-5 | - | - | - | - | - | - | - | - | - | - | - | 806 | 834 | 861 | 889
 |  | W-4 | 469 | 504 | 519 | 534 | 558 | 583 | 607 | 631 | 655 | 694 | 718 | 743 | 768 | 794 | 820
 |  | W-3 | 427 | 446 | 465 | 470 | 490 | 511 | 541 | 569 | 600 | 622 | 646 | 655 | 664 | 687 | 709
 |  | W-2 | 377 | 398 | 417 | 431 | 443 | 474 | 500 | 518 | 536 | 548 | 558 | 579 | 597 | 617 | 617
 |  | W-1 | 332 | 360 | 378 | 390 | 421 | 441 | 457 | 475 | 489 | 500 | 518 | 532 | 532 | 532 | 532
 |  | [NAME] | - | - | - | - | - | - | 566 | 580 | 596 | 615 | 634 | 664 | 691 | 718 | 760
 |  | [NAME] | - | - | - | - | - | 464 | 484 | 497 | 512 | 529 | 559 | 573 | 599 | 614 | 649
 |  | E-7 | 322 | 352 | 365 | 383 | 397 | 421 | 435 | 448 | 472 | 484 | 496 | 502 | 526 | 541 | 580
 |  | E-6 | 278 | 306 | 320 | 333 | 348 | 378 | 390 | 404 | 415 | 419 | 422 | 422 | 422 | 422 | 422
 |  | E-5 | 256 | 272 | 285 | 299 | 320 | 338 | 352 | 356 | 356 | 356 | 356 | 356 | 356 | 356 | 356
 |  | E-4 | 234 | 246 | 260 | 272 | 284 | 284 | 284 | 284 | 284 | 284 | 284 | 284 | 284 | 284 | 284
 |  | E-3 | 211 | 225 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238
 |  | E-2 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201 | 201
 |  | E-1 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 6

 | January 31 | February 7 | February 14 | February 21 | February 28
Total Interest Rate* | 4555653 | 9339945 | 5243923 | 6965767
SDs and MSPs** | 2674240 | 6452871 | 3030817 | 3600162 | 4646668.4818
Other | 1881413 | 2887074 | 2213107 | 3365605 | 3780794.7466
Total Cross-Currency | 89120 | 236818 | 167389 | 149250
SDs and MSPs | 57870 | 159882 | 121900 | 101881 | 115121.67731
Other | 31250 | 76936 | 45490 | 47369 | 58108.508215
Total Credit | 861287 | 697140 | 412345 | 467688
SDs and MSPs | 520370 | 413555 | 253616 | 264859 | 204605.54143
Other | 340917 | 283585 | 158729 | 202829 | 218649.36788
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 5506059 | 10273903 | 5823658 | 7582705
Weekly total, swap dollar volumes by asset class and participant type (value of all trades in millions of USD), all products and tenors, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Dollar Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***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: 56064d1256191508-mulitple-criteria-round-2-test-1-
Sheet: Sheet4

Count of Value 3 | Value 2
Value 1 | 1 | 2 | 3 | Grand Total
a | 1 | 1 | 1 | 1
b | 1 | 1 | 1 | 1
c | 1 | 1 | 1 | 1
d | 1 | 1 | 1 | 1
e | 1 | 1 | 1 | 1
Grand Total | 1 | 1 | 1 | 1
Spreadsheet: 158467d1338273354-excel-2007-index-function-problem-quiz
Sheet: bordro

 | BORDRO MAKBUZU
 | NAME | İLKER MURAT  GÜLER |  |  |  |  |  |  |  |  |  |  |  |  | HOURLY PAYING
 | ID |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH
 | DAYS | 1 | 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 | sum
 | WORKTIME
 | OVERTIME
 | SUNDAY
 | WORKTIME |  |  |  |  | OVERTIME |  |  |  |  |  |  |  | SUNDAY |  |  |  |  |  | [NAME] |  |  |  |  |  | balance
Spreadsheet: 853042d1702999669-how-to-get-a-specific-result-using-if-formula-based-on-multiple-conditions-form-2-
Sheet:  Decommissioning Request Form

 |  |  |  |  |  | =IF(AND(COUNTA($C$5:$C$7)=3,$C$9<>"",$C$14<>"",$C$22<>"",$C$30<>"",COUNTA($C$33:$D$34)=4),1,0)
 |  |  |  |  |  | =IF(AND(LEN($C$10)=14,ISNUMBER($C$10+0)),1,0)
 |  |  |  |  |  | =IF(AND($C$6="USA",$C$11<>""),1,0)
To Be Completed by Requestor | Decommissioning Product | Enter Product Details |  |  |  | =IF(AND(C14="Partial Batch Decommissioning",C20<>"",E42="QUANTITY MATCH"),1,0)
 | Supply Site or Market Warehouse or LOC | GSK |  |  |  | =iF(AND(B19="SGTIN Level",C19<>""),1,0)
 | Market (Lead Market) | USA |  |  |  | =IF(AND(B19="Case Level",COUNT(C19:D19)=2),1,0)
 | Batch (Lot Number) | ASDFGH |  |  |  | =IF(AND(B19="Pallet [NAME])
 | SKU Code | 60987654789876 |  |  |  | =IF(AND(B19="Cases + Pallets",COUNT(D19,E19)=2),1,0)
 | SKU Description | PANADOL |  |  |  | =IF(AND(B19="SGTIN + Cases",COUNT(C19,D19)=2),1,0)
 | GTIN | 03456789876544 |  |  |  | =IF(AND(B19="SGTIN + Pallets",COUNT(C19,E19)=2),1,0)
 | Case GTIN (for US Market Only) | N/A |  |  |  | ,=IF(AND(B19="SGTIN + Cases + Pallets",COUNT(C19:E19)=3),1,0)
 | Types of Decommissioning | Choose Type of Decommissioning
 | [NAME] with Rework | Partial Batch Decommissioning
 | [NAME] without Rework
 | Partial Batch Decommissioning
 | Choose Decommissioning Level | Enter SGTIN Quantity | Enter Case Quantity | Enter Pallet Quantity
 | SGTIN Level | 2 | 1
 |  | Case Level
 | Decommissioning Reason Codes | Choose Reason Code for Decommissioning |  | Description
 | FREE SAMPLE | DESTROYED
 | SAMPLE
 | DESTROYED
 | SUPPLIED
 | EXPORTED
 | OTHERS
 | [NAME]
 | RECALL
 | Decommissioning Comments (if any) | N/A
 | Role | MUD ID | Name
 | Data Provider | X | A
 | Quality Approver | X | B
 | SUMMARY |  |  | DRF Completion Status  (For details, refer row 20 in Instructions sheet)
To Be Completed by Requestor | Quantity of Serial Number/SGTINs Entered | Quantity of Cases Entered | Quantity of Pallets Entered | Verification: (For details, refer row 23 in Instructions sheet)
 | Enter Serial numbers / SGTINs to be decommissioned | Enter Case numbers (SGTINs / SSCCs) to be decommissioned | Enter [NAME] numbers (SSCCs) to be decommissioned
 | 17678987654345 | 1
 | 222