tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864445d1711615088-merging-multiple-tables-based-on-unique-id-merging-multiple-tables-based-on-unique-id-jt
Sheet: x2

Sr. No. | Description | X2
1 | AAA | 1
2 | BBB | 2
3 | CCC | 1
4 | DDD | 0
5 | EEE | 2
6 | FFF | 1
7 | GGG | 3
8 | HHH | 1
9 | III | 4
10 | JJJ | 2
11 | KKK | 1
12 | LLL | 0
Spreadsheet: 673166d1587224975-please-check-where-is-the-problem-so-that-not-getting-result-in-column-d-pls-check-the-file
Sheet: Sheet1

 | S.No. | Year | Entry | Batch | Flag
Entry | 1 | 1980 |  | 3000
 | 2 | 1985 |  | 3200
 | 3 | 1984 |  | 8000
 | 4 | 1982 |  | 4000
 | 5 | 1981 |  | 2000
 | 6 | 1986 |  | 3000
 | 7 | 1987 |  | 8000
 | 8 | 1988 |  | 4000
 | 9 | 1999 |  | 6000
 | 10 | 2000 |  | 3000
 | 11 | 2001 |  | 5000
 | 12 | 2002 |  | 6000
Spreadsheet: 828158d1683266435-concat-and-if-conditions-for-different-columns-sample
Sheet: SAMPLE

ACTIVITY | INDICATOR | TARGET  TO DATE | TARGET ANNUAL | ACCOMPLISHMENT TO DATE | PERCENTAGE (E/D)
1. Coordination | No. of meetings attended | 2 | 4 | 3
2. Data gathering
 | No. of soil samples collected | 6 | 12 | 5
 | No. of water samples collected | 6 | 12 | 15
3. Data analysis | No. of samples analyzed | 12 | 24 | 0
4. Report writing | No. of report submitted | 0 | 1 | 0
INDICATORS WITH  ACCOMP > 100% | INDICATORS WITH  ACCOMP < 100% | INDICATORS WITH REMAINING TARGETS
 |  |  |  | Output of the current formulas
No. of water samples collected - 3 | No. of soil samples collected - 1 No. of samples analyzed - 12 | No. of meetings attended - 1 No. of soil samples collected - 7 No. of samples analyzed - 24 No. of report submitted - 1 |  | Intended results
Accomp to date VS  target (annual) | Accomp to date VS  target (to date) | Accomp to date VS target (annual) VS target (to date)
Spreadsheet: 471580d1469096947-corresponding-values-in-a-row-forum-6-q
Sheet: Sheet1

Pucrhase Order | Item | Material | 1 | 1 | Required ---> As many entries for the same values in column1 - corresponding values from colum3
1211 | 1 | ZMRO
1211 | 2 | ZMRO
1211 | 3 | ZMRO
1211 | 4 | ZCCH
1211 | 5 | [NAME]
1211 | 6 | ZCCH
1211 | 7 | ZMRO
1211 | 8 | ZMRO
1211 | 9 | [NAME]
1212 | 1 | ZMRO
1212 | 2 | ZMRO
1212 | 3 | ZCCH
1212 | 4 | [NAME]
1212 | 5 | ZCCH
1212 | 6 | ZMRO
1213 | 1 | ZMRO
1213 | 2 | ZMRO
1213 | 3 | ZCCH
1213 | 4 | ZCCH
1213 | 5 | ZMRO
1213 | 6 | ZMRO
1214 | 1 | ZCCH
1214 | 2 | ZCCH
1214 | 2 | ZCCH
1214 | 3 | ZCCH
Spreadsheet: 84343d1b-35f6-4ab1-a946-087030bbbbf0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6734 | 50248 | [NAME] | Maroto | CRC | 0 | 00:17:41 | [NAME] | [NAME] | [NAME] | 00:10:26 | 1 | 01:00:52
6734 | 50249 | Martin | [NAME] | PAN | 0 | [NAME] | 00:00:46 | 00:32:34 | [NAME] | [NAME] | 2 | 01:04:52
6734 | 12251 | [NAME] | Rocha | BRA | 0 | 00:16:03 | [NAME] | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 806891d1669652439-help-converting-an-attendance-tracker-from-days-to-hrs-attendance-pbi
Sheet: H

 | RESULT | Value
SUNDAY | True |  |  | January | 1
MONDAY | False |  |  | February | 2
TUESDAY | False |  |  | March | 3
WEDNESDAY | False |  |  | April | 4
THURSDAY | False |  |  | May | 5
FRIDAY | False |  |  | June | 6
SATURDAY | True |  |  | July | 7
 |  |  |  | August | 8
 |  |  |  | September | 9
 |  |  |  | October | 10
 |  |  |  | November | 11
 |  |  |  | December | 12
Spreadsheet: daren_farmer__5441__0900Co-Owners Volumes to Enron
Sheet: Avails 4-6

[NAME] (PennzEnergy) South Texas Properties
Effective: | 2000-04-06 00:00:00
Pipeline | Location | [NAME] | Base | Swing | Total | WIO | Grand Total | Comments
[NAME] | [NAME] | Gulf Plains Plant | 8718 | 459 |  | 0
 | [NAME] | Gulf Plains Plant | 3132 | 165 |  | 0
Carthage | American Central | Tailgate | 64255 | 7139 |  |  |  | 3500 makeup is taken out
 | [NAME] | Tailgate | 0 | 500 |  | 0
 | Ruby-Lacy | Tailgate | 0 | 250 |  | 0
 | [NAME] (Net of PVR)* | Tailgate | 9600 |  |  |  |  | Gathering nomination on [NAME] gathering system as Pennzoil's agent
Corpus Christi Gas Gath. | Virginia | 3358 | 1009 | 88 |  | 0
Delhi (Koch Midstream) | Volpe | LL-1-0027 | 1179 | 102 |  | 0
 | [NAME] | LL-1-0027 | 41 | 4 |  | 7
 | Comitas C.P. | LL-1-0030 | 631 | 55 |  | 315
 |  |  |  |  |  |  |  | Termed up with Delhi (evergreen)
Gulf Energy | [NAME] | 19-1043-00 | 439 | 33 |  | 0 |  | Termed up with Gulf Energy (evergreen)
 | Comitas South | 440-559 | 857 | 74 |  | 446
 | Tejas Plant | 29320 | 106 | 9 |  | 4
 | Jennings 63 Plant | 440-565 | 6642 | 578 |  | 0 |  | Termed up with Tejas thru 12/00
 | Haynes Plant | 440-557 | 180 | 16 |  | 30 |  | MTM - Terminate for 4/99
 | Haynes 17, 18 | 23-603-01 | 1592 | 138 |  | 283
 | [NAME] | 31-504-04 | 4478 | 389 |  | 361
 | Garza Plant | 440-552 |  |  |  | 0 |  | Trevino Plant gas is sometimes re-routed through Garza Plant
 | [NAME] | 21-022-08 | 0 | 71 |  | 0
Lone Star | Sandtrap | 178477 | 3805 | 423 |  | 702 |  | Termed up with TXU Energy thru 11/00
Midcon Texas | [NAME] / TOC | 5553 | 353 | 27 |  | 0
 | Hall Plant | 5576 | 703 | 61 |  | 0
 | Jennings Ranch | 446 | 1229 | 107 |  | 0
 | [NAME] at Carthage |  | 0.2192
 |  | Gross | PVR | Net
 | [NAME] | 13402
 | [NAME] | 1858
 |  |  |  |  | Deal #
 | Base |  |  |  | 139257
 | WIO
 | Swing |  |  |  | 143567
Spreadsheet: 84650d1284671461-if-then-function-for-library-accounting-sampleencumbracesheet
Sheet: Budget-Balance

BUDGET/BALANCE REMAINING
BY ACCOUNT
ACCOUNT | ITEM | BUDGET | ENCUMBRANCE | BALANCE
Periodicals | 57400 | 23500 | 23500 | 23500
CD-ROM - not used anymore | 57500 | 0 | 0 | 0
On-line Databases | 64000 | 13000 | 13000 | 13000
Book Acquisition – G | 64101 | 10000 | 10000 | 10000
Book Acquisition – D | 64110 | 6000 | 6000 | 6000
Book Acquisition – F | 64150 | 5000 | 5000 | 5000
Book Acquisition – N | 64160 | 6000 | 6000 | 6000
Book Acquisition – NT | 64161 | 1300 | 1300 | 1300
Book Acquisition – E | 64191 | 1600 | 1600 | 1600
Book Acquisition – K | 64192 | 100 | 100 | 100
Book Acquisition – T | 64193 | 800 | 800 | 800
Book Acquisition – Fi | 64210 | 600 | 600 | 600
Book Acquisition – C | 64220 | 2300 | 2300 | 2300
Book Acquisition – R | 64221 | 3000 | 3000 | 3000
Non Book Media | 64428 | 1000 | 1000 | 1000
 | TOTALS | 74200 |  | 74200
DATE ORDERED | ISBN | TITLE | ACCOUNT | ENCUMBRANCE | DATE RECEIVED | FINAL COST
2010-09-10 00:00:00 | 10-10-14014-13 | Test 1 | Periodicals | 10
2010-09-11 00:00:00 | 10-10-13119-11 | Test 2 | Book Acquisition – NT | 40
2010-09-11 00:00:00 | 10-234-324-3 | Test 3 | Book Acquisition – N | 340
2010-09-12 00:00:00 | 10-234-23-1 | Test 4 | Book Acquisition – T | 23
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 2. HCV

 |  | HCV screening |  |  |  |  | HCV screening
 |  |  |  |  |  |  | HCV rapid test | 0
 |  |  |  |  |  |  | only pre-donation screening | 0
 |  | HCV rapid test |  |  |  |  | only 1st time donor | 0
 |  |  |  |  |  |  | every donation | 0
 |  | only pre-donation screening |  |  |  |  | please specify supplier | 0
 |  |  |  |  |  |  | please specify test used | 0
 |  | only 1st time donor |  |  |  |  | HCV NAT | 0
 |  |  |  |  |  |  | mandated by government | 0
 |  | every donation |  |  |  |  | performed since | 0 | 0
 |  |  |  |  |  |  | only 1st time donor | 0
 |  | please specify supplier |  |  |  |  | every donation | 0
 |  | please specify test used
 |  | HCV NAT
 |  | mandated by government
 |  | performed since
 |  | (please indicate month and year of introduction)
 |  | only 1st time donor
 |  | every donation
 |  |  |  | Page 15 of 34
Spreadsheet: 690668d1597231660-create-sum-out-of-a-list-based-on-activated-options-in-2-different-lists-example1-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | List
 |  |  |  |  |  |  |  |  |  | France | Germany | Swiss | GB
 |  |  |  |  |  |  |  |  | Car | 20 | 4 | 8 | 43
 |  |  |  |  |  |  |  |  | Engine | 15 | 2 | 5 | 5
 |  |  |  |  |  |  |  |  | Wheel | 80 | 6 | 3 | 35
 |  |  |  |  |  |  |  |  | Tire | 22 | 5 | 26 | 35
 |  |  |  |  | Matrix 1 |  |  |  |  | Matrix 2
 |  |  |  |  | France | Germany | Swiss | GB |  | Car | Engine | Wheel | Tire |  |  | total | example for total:
 |  |  | Business 1: |  |  | x |  | x |  | x | x |  |  |  |  |  | "=Germany car + Germany Engine + GB car + GB Engine" | "=4+2+43+5"
 |  |  | Business 2: |  | x |  | x | x |  | x | x | x | x
Spreadsheet: 250555d1373976900-calculating-time-to-do-a-task-time-calculation-jhren-
Sheet: Sheet1

Start Time | Hours | End Time |  |  | Shift start | hrs after shift start | <<< + Hours | INT | MOD | End, no comp for break | End, comp'd for break
2013-07-15 07:00:00 | 10.75
2013-07-15 07:00:00 | 9.2
2013-07-15 07:00:00 | 9.2
2013-07-15 07:00:00 | 12.75
2013-07-15 07:00:00 | 12.75
2013-07-16 09:45:00 | 15.2
2013-07-16 08:12:00 | 15.2
2013-07-16 08:12:00 | 12.75
2013-07-16 11:45:00 | 9.65
2013-07-16 11:45:00 | 9.65
2013-07-17 17:27:00 | 9.65
2013-07-17 15:54:00 | 9.65
2013-07-17 13:27:00 | 12.75
2013-07-17 13:54:00 | 12.75
2013-07-17 13:54:00 | 12.75
2013-07-18 19:36:00 | 12.75
2013-07-18 18:03:00 | 13.5
2013-07-18 18:42:00 | 9.65
2013-07-18 19:09:00 | 7.1
2013-07-18 19:09:00 | 7.1
2013-07-20 00:21:00 | 15.2
 | 13.15
 | 13.15
 | 13.15
 | 10.5
 |  |  |  |  | Combine formulas
 |  |  |  |  | Fill = Start Time outside shift hours
 |  |  |  |  | Fill = Copy End/Paste(Link) Start
Spreadsheet: 693332d1598924964-how-to-write-a-formula-to-repeat-the-name-and-type-twice-or-more-sample831
Sheet: Sheet2

NAME | TYPE |  |  |  |  |  |  | Result | TYPE >=2 and above
[NAME] | A |  |  |  |  |  |  | NAME | TYPE
[NAME] | A
[NAME] | B
[NAME] | B
Xiaomei | D
Big fat | E
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
Xiao'e | B
[NAME] | C
[NAME] | A
[NAME] | A
[NAME] | F
[NAME] | B
Spreadsheet: 44270d1242902914-copy-and-paste-excel-cell-value-example123
Sheet: Sample

 | A | B | C | D | E | F | G | H | I | J
Part Descriptions | Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7 | Part 8 | Part 9 | Part 10
Sample | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 | Sample 6 | Sample 7 | Sample 8 | Sample 9 | Sample 10
Spreadsheet: 840945d1693221451-use-lookup-function-to-total-all-cells-that-contain-text-mock1
Sheet: Sheet2

Award Date | Award Year | Start Date | End Date | category Type | Category | totals | Company | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027
2018-02-01 00:00:00 |  | 2018-01-01 00:00:00 | 2019-03-31 00:00:00 | central public organisation | category2 | 94961 | [NAME]
2018-02-01 00:00:00 |  | 2018-01-01 00:00:00 | 2019-03-31 00:00:00 | central public organisation | category2 | 94961 | [NAME]
2018-01-23 00:00:00 |  | 2017-11-01 00:00:00 | 2019-04-30 00:00:00 | overseas other | category2 | 75301 | department2
2018-02-02 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-31 00:00:00 | overseas central public orgainisation | category2 | 116188 | department3
2018-02-08 00:00:00 |  | 2018-03-04 00:00:00 | 2020-03-03 00:00:00 | uk company,buying,purchasing company,central public organisation | category1 | 1658.77 | department3
2018-03-22 00:00:00 |  | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | central public organisation | category2 | 960.76 | [NAME]
2018-03-23 00:00:00 |  | 2017-10-01 00:00:00 | 2020-09-30 00:00:00 | UK company, buying, purchasing company | category1 | 110000 | [NAME]
2018-04-23 00:00:00 |  | 2018-09-01 00:00:00 | 2021-09-30 00:00:00 | central public organisation | category2 | 30000 | department2
2018-05-11 00:00:00 |  | 2017-09-01 00:00:00 | 2019-08-31 00:00:00 | research council | category2 | 121126.56 | [NAME]
2018-05-11 00:00:00 |  | 2017-09-01 00:00:00 | 2019-08-31 00:00:00 | research council | category2 | 65610.22 | [NAME]
2018-05-26 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-28 00:00:00 | research council | category2 | 7456.8 | [NAME]
2018-05-26 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-28 00:00:00 | research council | category2 | 286.8 | department3
2018-06-11 00:00:00 |  | 2018-04-01 00:00:00 | 2019-03-31 00:00:00 | central public organisation | category2 | 1092.13 | [NAME]
2018-07-03 00:00:00 |  | 2018-05-01 00:00:00 | 2019-04-30 00:00:00 | research council | category2 | 0 | department2
2018-06-02 00:00:00 |  | 2017-10-01 00:00:00 | 2021-03-31 00:00:00 | UK company, buying, purchasing company | category1 | 40868 | department3
2018-07-06 00:00:00 |  | 2017-03-01 00:00:00 | 2017-10-16 00:00:00 | uk Educational Institution | category2 | 11272 | department2
2018-07-11 00:00:00 |  | 2018-09-01 00:00:00 | 2020-10-17 00:00:00 | overseas company(non-european) | category1 | 7999.95 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | category2 | 151014.15 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | category2 | 302028.3 | [NAME]
2018-08-09 00:00:00 |  | 2018-04-23 00:00:00 | 2021-04-30 00:00:00 | central public organisation | category2 | 21573.45 | department3
2018-08-21 00:00:00 |  | 2018-01-01 00:00:00 | 2020-12-31 00:00:00 | central public organisation | category2 | 36000 | [NAME]
 | [NAME] | department2 | department3 |  | [NAME] | [NAME] | category1
2018
2019
2020
2021
2022
2023
 |  |  |  |  |  |  | category2
Spreadsheet: eric_saibi__9952__110601
Sheet: Ormond Beach 01

Owner Name | Reliant Energy Ormond Beach LLC
Station Name | Ormond Beach Power Station
Unit Name | Ormond Beach 01
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas / Fuel Oil
Capacity | 806 MW
Start Date | 2001-11-05 00:00:00
End Date | 2001-11-07 00:00:00
Comments | [NAME]
SIC | 4931
Plant ID | 1013123
Unit ID | 1006706
Outage ID | 18810
Spreadsheet: 685293d1593886322-new-to-excel-formulas-and-in-need-of-help-price-calculation-formula-request
Sheet: Sheet1

Price | Service fee | Total price | Times multiples of price (A2) dependant on price (see table below) plus service fee
19.355 | 17.5 | See D1 | Under £25.00 x 3
19.355 | 17.5 |  | £25.00 to £35.00 x 2.9
19.355 | 17.5 |  | £35.00 to £45.00 x 2.8
19.355 | 17.5 |  | £45.00 to £60.00 x 2.7
63.59500000000001 | 17.5 |  | £60.00 to £8.000 x 2.6
59.25 | 17.5 |  | Over £80.00 x 2.5
63.59500000000001 | 17.5
63.59500000000001 | 17.5
67.15 | 17.5
67.15 | 17.5
63.59500000000001 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
77.815 | 17.5
14.615 | 17.5
14.615 | 17.5
68.33500000000001 | 17.5
63.99 | 17.5
68.33500000000001 | 17.5
68.33500000000001 | 17.5
71.89 | 17.5
71.89 | 17.5
68.33500000000001 | 17.5
82.555 | 17.5
82.555 | 17.5
82.555 | 17.5
82.555 | 17.5
82.555 | 17.5
82.555 | 17.5
60.04000000000001 | 17.5
52.14 | 17.5
60.04000000000001 | 17.5
74.26 | 17.5
74.26 | 17.5
66.36 | 17.5
66.36 | 17.5
74.26 | 17.5
Spreadsheet: 55494d1255612727-standard-deviation-and-nested-if-statement-sample
Sheet: Sheet2

AM/BA | Achievement rate ([NAME]) | Performance |  |  |  |  |  |  | -2 | -1 | 1 | 2
 |  |  |  | Min | [NAME] | Mean | [NAME] | Very Low | Low | Medium | Good | Very Good
A | -0.03418803418803419 | Low |  | -0.9 | 4.503560364464692 | 1.698126803225091 | 0.9262219957058972 | -0.9 | -0.1543171881867034 | 0.7719048075191939 | 2.624348798930988 | 3.550570794636886
B | 0.6 | Low |  |  |  |  |  | 1 | 2 | 29 | 4 | 1
C | 2 | Medium
D | 2.5 | Medium
E | 2.078165680473373 | Medium
F | 1.662967142857143 | Medium
G | 1.322288874288217 | Medium
H | 2.181692482915718 | Medium
I | 2.510054844606947 | Medium
J | 1.134596957403651 | Medium
K | 2.408926417370326 | Medium
L | 1.280821917808219 | Medium
M | 0.9927234927234927 | Medium
N | 4.503560364464692 | Very Good
O | 0.9310344827586207 | Medium
P | 2.25282722513089 | Medium
Q | 1.009708737864078 | Medium
R | 2.968716289104639 | Good
S | 1.966618769185791 | Medium
T | 2.825037707390649 | Good
U | 2.272506082725061 | Medium
V | 2.752896665878458 | Good
W | 1.157601115760112 | Medium
X | 2.666881147540983 | Good
Y | 1.515672358355285 | Medium
Z | 1.286964888996139 | Medium
AA | -0.9 | Very Low
AB | 1.573924774010061 | Medium
AC | 1.700892857142857 | Medium
AD | 0.8565759637188208 | Medium
AE | 1.815443592552026 | Medium
AF | 1.83733929569592 | Medium
AG | 0.9304029304029304 | Medium
AH | 0.9322033898305084 | Medium
AI | 1.489347462353597 | Medium
AJ | 1.587097693879537 | Medium
AK | 2.259388148327678 | Medium
Spreadsheet: 869580d1716192752-calculate-monthly-paid-invoice-amount-based-on-the-activity-payment-status-and-date-book1-5-
Sheet: Sheet1

 |  |  |  |  |  | 2024
 |  |  |  |  |  |  | Paid | Paid | Paid | Paid | Paid | Paid | Paid | Paid | Paid | Paid | Paid | Paid
Activity | Invoice Name | Invoice Amount | Payment Status | Payment Date |  | Total PAID
Operations | ABC | 100 | PAID | 2024-01-20 00:00:00 |  | Operations
ALD | CBD | 50 | PAID | 2024-02-20 00:00:00 |  | ALD
BOOKFAIR | YAH | 1200 | PAID | 2024-02-21 00:00:00 |  | BOOKFAIR
PROGRAMS | YAN | 500 | PAID | 2024-03-22 00:00:00 |  | PROGRAMS
READ | ALF | 450 | PAID | 2024-04-23 00:00:00 |  | READ
Content | GKD | 200 | PAID | 2024-05-20 00:00:00 |  | Content
Operations | ABC | 200 | PAID | 2024-05-20 00:00:00
Spreadsheet: 559299d1517556569-separating-data-column-with-english-and-chinese-text-into-2-separate-columns-sample-list
Sheet: Sample

 |  |  |  |  | 63
Material Description | Specifications | English Description | Chinese Description | len | min | [NAME]
低压无功补偿装置 Low voltage reactive compensation device | G68
动力配电箱 Power distribution box | X94
动力配电箱 Power distribution box | X56
Electrical cables   电力电缆 | Y95
Electrical cables   电力电缆 | Y72
Electrical cables   电力电缆 | [NAME]
Electrical cables   电力电缆 | Y90
护套线 Sheath line | B53
花线 yarn | R63
单股铝绞线 Single stranded aluminum strand | B34
通讯电缆 Communication cable | M2
局扇风机 Local fan blower | 556
局扇风机 Local fan blower | 149
风带 Wind belt | 直23
风带 Wind belt | 直35
风带变节 Wind belt adjusting | 53
放炮器 Blaster | 2100
风镐  Air pick | [NAME]
风镐钎子 Air pick drill | G71
锚杆 Anchor bolt | 管99
橡胶垫 rubber pad | F72
止退垫 [NAME] back cushion | F12
棘轮爪 Ratchet wheel hand | Y2
扳机 [NAME] | Y22
钎卡螺栓 [NAME] bolt | Y10
导向套 Guide sleeve | Y78
钎卡 [NAME] | Y35
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 529865 | 7614987 | 529865 | 757008 | 1059730 | 8371995
 | Loans |  | 21630 |  |  |  | 21630
 | Municipal |  | 19477 |  | <1,000 |  | 19477
 | Recovery
 | Sovereign | 33998 | 2659416 | 33998 | 237560 | 67996 | 2896976
Index Tranche | Asia |  |  |  | <100 |  | <100
 | Europe |  | 827129 |  | 86833 |  | 913962
 | North America |  | 896256 |  | 33251 |  | 929507
Index | Asia | 1339 | 272929 | 1641 | 45696 | 2981 | 318625
 | Europe | 291624 | 2683830 | 291624 | 422813 | 583248 | 3106643
 | North America | 468978 | 1489473 | 498257 | 342103 | 967235 | 1831576
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 1325804 | 16485126 | 1355385 | 1925264 | 2681189 | 18410390
Estimated gross notional amount outstanding, February 1 weekly snapshot, by product type (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 Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 79048d1279278827-disappearing-info-advanced-filters-running-down-the-page-with-macro-new-cost-centre-system-forumex
Sheet: Q1234

Cost Centre
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 |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Q1234 | 3401 | 561 | Spiros |  |  | 10 | 10000 | Primark | B |  |  |  |  |  |  | 3401
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1234 | 3401 | 561 | Spiros |  |  | 10 | 10000 | Primark | B |  |  |  |  |  | Q1234 | 3401 | 561 | Spiros |  |  | 10 | 10000 | Primark | B |  |  |  |  |  | Q1234 | 3401 | 561 | Spiros |  |  | 10 | 10000 | Primark | B
Spreadsheet: 75499d1276074713-how-to-retrieve-information-from-multiple-sheets-sheet-relatives
Sheet: day 2

 | Product | Data 2 | Data 3 | Data 4 | Data 5 | Data 6 | Data 7
 | Product 1 |  |  |  | 36
 | Product 2 |  |  |  | 95
 | Product 3 |  |  |  | 88
 | Product 4 |  |  |  | 54
 | Product 5 |  |  |  | 756
 | Product 6 |  |  |  | 359
 | Product 7 |  |  |  | 85
 | Product 8 |  |  |  | 156
 | Product 9 |  |  |  | 256
 | Product 10 |  |  |  | 35
 | Product 11 |  |  |  | 48
 | Product 12 |  |  |  | 465
 | Product 13 |  |  |  | 25
 | Product 14 |  |  |  | 351
 | Product 15 |  |  |  | 15
Spreadsheet: 600003d1543416171-need-to-calculate-different-pay-periods-for-different-pay-rates-excel-help-11-28-18
Sheet: Ingrid Theron

[NAME]
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  |  | Day Hours | 07:00:00 | 21:00:00
Time In | 03:00:00 | 04:00:00 |  |  |  |  |  |  |  |  | Night Hours | 21:00:00 | 07:00:00
Time Out | 09:00:00 | 07:00:00
Time In | 12:00:00 |  |  |  |  |  |  |  |  |  | Cleaning hours are subtracted from the period that has the most hours. Daily
Time Out | 22:00:00
Time In
Time Out
Total Hours
Cleaning Hours | 2 | 2 | 2 | 2 | 2
Nanny Day
Nanny Night
Cleaning Day
Cleaning Night
Nanny Day should equal 9hrs.
 | From 7AM to 9AM = +2hrs
 | From 12PM to 9PM= +9hrs
 | Minus cleaning       = -2hrs
Nanny Night should equal 5hrs
 | from 3AM to 7AM = 4hrs
 | from 9PM to 10PM=1hr
Spreadsheet: 720170d1614048822-inserting-additional-criteria-to-an-if-statement-worktimecalcefupdated
Sheet: Correct 2

STRT | END | WRK | RT | ST | OT |  | Overall Day
 |  |  |  |  |  |  | Report | 10:20:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | End Shift | 13:28:00
 |  |  |  |  |  |  | 1st Half Pay
 |  |  |  |  |  |  |  | Break
 |  |  |  |  |  |  | Report | 13:52:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | 11th Hour
 |  |  |  |  |  |  | End Shift | 17:53:00
 |  |  |  |  |  |  | Straight Time
 |  |  |  |  |  |  | Overtime