tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7762__imbalsumm0106
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
NNG |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
[NAME] |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
PNM |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | being reconciled with CIG
Amoco |  |  |  | Volumetric | [NAME]
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | ending 5/31/01 bal of $295,327 invoiced
Oasis |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Receivable imbalances
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
SoCal |  |  |  | Volumetric | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 864484d1711637394-merging-multiple-tables-based-on-unique-id-merging-multiple-tables-based-on-unique-id-jt
Sheet: x1

Sr. No. | Description | X1
1 | AAA | 1
2 | BBB | 2
3 | CCC | 1
4 | DDD | 3
5 | EEE | 1
6 | FFF | 0
7 | GGG | 2
8 | HHH | 1
9 | III | 0
10 | JJJ | 1
11 | KKK | 2
12 | LLL | 1
Spreadsheet: 822187d1679156325-comparing-known-data-to-text-string-book1
Sheet: Sheet1

Compare column C supplied data to known data in column A and if any of the
text matches, column D will be populated with info from the same row in column B.
Supplied data will not always have the same format but it will contain partial text that matches column A.
KNOWN DATA |  | SUPPLIED DATA | RESULT
ABC123ABC | XYZ123XYZ | DKIXEL.SEK_DEF456.WKXJ3KS |  | <- Result would show RST456RST without having to edit supplied data
ABC456ABC | XYZ456XYZ | DEF456 |  | <- Correct match but having to edit supplied data is not time saving
ABC789ABC | XYZ789XYZ | DEF |  | <- If supplied data is edited too much, results default to first match instance of known data
DEF123DEF | RST123RST | 456
DEF456DEF | RST456RST |  |  | <- Tried adding in IF " " statements but no go…if supplied data is empty, result should be empty
Spreadsheet: kevin_ruscitti__20261__OPEN11b
Sheet: overview

Prompt
may
june-Oct
Red Nov-Mar
red apr-oct
Gas Daily
CHANGE ON DAY
may
june-oct
april
Oct
Nov
Dec
Jan
feb
[NAME]
APR-OCT
TOTAL
combined
[NAME]
Oct
Nov
Dec
Jan
feb
[NAME]
APR-OCT
Spreadsheet: 267536d1380105625-help-with-lookup-formulae-please-test-2-
Sheet: Array Option

Name | Last Name | Club | Class | No
 |  |  |  |  | while entering this formula hold control and shift then press enter
Spreadsheet: daren_farmer__5382__Monthly Capacity Matrix
Sheet: Jan 00

Locations | Transport Receipts | Buy | Net Supply | Transport Deliveries | Sell | Net Market | Net Throughput
HPL 1 - Thompsonville |  | 165065 |  | 1430 | 10125
HPL 14 - South TX | 150 | 4582 |  | 125 | 14199
HPL 18 - Three Rivers |  | 9278 |  |  | 4617
HPL 21 - Big Cowboy | 550 | 632 |  |  | 0
HPL 22 - Nueces |  | 0 |  | 3465 | 5000
HPL 2 - Robstown | 16071 | 138988 |  |  | 617
HPL 19 - King Ranch | 23600 | 0 |  | 22880 | 1500
HPL 3 - A/S South |  | 159017 |  | 10000 | 301
HPL 4 - A/S Central |  | 23030 |  |  | 177855
HPL 5 - Edna |  | 167181 |  |  | 68249
HPL 6 - Texas City | 1555 | 7671 |  | 26098 | 148689
HPL 10 - Ship Channel |  | 48316 |  |  | 500848
HPL 15 - Katy | 11550 | 123348 |  |  | 59472
HPL 16 - West Loop |  | 92500 |  |  | 34001
HPL 17 - East Loop |  | 5000 |  | 5000 | 97260
HPL 13 - Mid Texas
HPL 23 - Bammel |  | 68799 |  | 7095 | 130085
HPL 7 - A/S East |  | 115 |  |  | 48
HPL 8 - East Texas |  | 254946 |  |  | 150120
HPL 9 - Freeport |  | 5713 |  | 20708 | 15351
HPL 11 - Corpus | 1121 | 1118 |  |  | 40063
HPL 12 - Valley |  | 15105 |  |  | 11294
HPL 20 - Hardin |  | 1 |  | 2249 | 1501
HPL 24 - Gas Loss |  | 1 |  |  | 2303
HPL OffSystem | 2024 |  |  |  | 11833
 | Need to find out for Dynegy - guessed all at zone 8 (Texoma)
Spreadsheet: 878057d1725019456-need-help-with-data-formula-dummy-data-1
Sheet: Sheet1

 |  |  |  | Name | Service1 | Service2 | Service3 | Service4 | Service5 | Service6 | Service7 | Service8 | Service9 | Service10 | Service11 | Account1 | Account2 | Account3 | Account4 | Account5 | Account6 | Account7 | Account8 | Account9 | Account10 | Account11 | [NAME] | Account13 | Account14 | Account15 |  | Account | X | we | rd | Y | Z | R | Rd2
 |  |  |  | A | X | we | rd |  |  |  | X |  |  |  | rd | xx | yy | zz |  |  |  |  |  |  |  |  |  |  |  | zz |  | cd | C |  | C | C | C
 |  |  |  | B | Y | rd | X | X |  | X | X |  |  |  | X | zd | zf | zg |  |  |  |  |  |  |  |  |  |  |  | zg |  | ht | C,E | E | C | C | C |  | E
 |  |  |  | C | Z | Y | X | X |  | X | rd |  |  |  | X | cd | xx |  |  |  |  |  |  |  |  |  |  |  |  | ht |  | hu | E | E |  |  |  |  | E
 |  |  |  | D | we | R | rd | rd |  | rd |  |  |  |  | rd | se | sr |  |  |  |  |  |  |  |  |  |  |  |  | st |  | hy | E | E |  |  |  |  | E
 |  |  |  | E | X | we | Rd |  |  |  |  |  |  |  | Rd | ht | hy | hu |  |  |  |  |  |  |  |  |  |  |  | hu |  | se |  | D | D |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sr |  | D | D |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | st |  | D | D |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xx | A,C | A | A,C | C | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yy | A | A | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | zd | B |  | B | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | zf | B |  | B | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | zg | B |  | B | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | zz | A | A | A
Spreadsheet: 792882d1661196256-need-to-list-unique-values-from-3-separate-table-columns-test-sheet
Sheet: Sheet1

data I would enter in tables |  |  |  |  |  |  |  |  |  |  |  |  | desired output
XPARTS | Item | Cost |  | YPARTS | Item | Cost |  | [NAME] | Item | Cost |  |  | Part | Cost
PT1 | Widget | 10 |  | PT3 | Other | 20 |  | PT5 | Wire | 1
PT2 | Thing | 15 |  | PT4 | Item | 25 |  | PT6 | Connector | 2
PT1 | Widget | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | would want this to read "PT3" in column N and "$20" in column O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | would want this to read "PT4" in column N and "$25" in column O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | would want this to read "PT5" in column N and "$1" in column O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | would want this to read "PT6" in column N and $2 in column O
 |  |  |  |  |  |  |  |  |  |  |  |  | PARTS | Cost
 |  |  |  |  |  |  |  |  |  |  |  |  | PT1 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | PT2 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | PT3 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | PT4 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  | PT5 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | PT6 | 2
Spreadsheet: e6429647-99f7-42ce-99a8-2623d1e337d1
Sheet: December

1 | Eat a Red Apple Day | http://www.holidayinsights.com/moreholidays/December/eataredappleday.htm
2
3
4
5
6
7 | Letter Writing Day | http://www.holidayinsights.com/moreholidays/December/letterwritingday.htm
8
9
10
11
12
13 | National Violin Day | http://www.holidayinsights.com/moreholidays/December/violinday.htm
14
15
16
17
18
19 | Oatmeal Muffin Day | http://www.holidayinsights.com/moreholidays/December/oatmealmuffinday.htm
20
21 | National Flashlight Day | http://www.holidayinsights.com/moreholidays/December/flashlightday.htm
22 | National Date Nut Bread | http://www.holidayinsights.com/moreholidays/December/datenutbreadday.htm
23
24
25
26
27 | Make Cut Out Snowflake Day | http://www.holidayinsights.com/moreholidays/December/snowflakeday.htm
28 | Card Playing Day | http://www.holidayinsights.com/moreholidays/December/cardplayingday.htm
29
30
31
Spreadsheet: 716780d1612361711-convert-raw-data-into-table-with-various-subtotals-sample-data
Sheet: RawData

Produit | Reference Contract | Garantie / Support | Date début effet | Date fin effet | Type de Commission | Date de règlement | Prime TTC | Prime HT | Montant commission | Taux de commission | Type de transaction
W0E | Agent1 | DA |  | 82020 | PSC | 21/01/2021 | 0 | 0 | -12971.13 | 0 | Manual
W0E | Agent1 | DS |  | 82020 | PSC | 21/01/2021 | 0 | 0 | 5.970000000000001 | 0 | Manual
W0E | Agent1 | LR |  | 82020 | PSC | 21/01/2021 | 0 | 0 | -194584.92 | 0 | Manual
W0O | Agent1 | DA |  | 82020 | PSC | 21/01/2021 | 0 | 0 | -11346.87 | 0 | Manual
W86 | Agent2 | DA | 01-JAN-21 | 31-JAN-21 | COM | 21/01/2021 | 170 | 170 | -27.9 | 16.4 | Premium Collection
W86 | Agent2 | DS | 01-JAN-21 | 31-JAN-21 | COM | 21/01/2021 | 830 | 830 | -136.2 | 16.4 | Premium Collection
W86 | Agent2 | LR | 01-JAN-21 | 31-JAN-21 | COM | 21/01/2021 | 9000 | 9000 | -1476.9 | 16.4 | Premium Collection
WH3 | Agent3 | DA | 01-DEC-19 | 31-DEC-19 | COM | 21/01/2021 | 28.13 | 25.81000000000001 | -0.39 | 1.5 | Premium Collection
WH3 | Agent3 | DA | 01-DEC-20 |  | COM | 21/01/2021 | 0 | 0 | -0.08 | 0 | Manual
WH3 | Agent3 | DS | 01-DEC-19 | 31-DEC-19 | COM | 21/01/2021 | 137.35 | 126.01 | -1.89 | 1.5 | Premium Collection
WH3 | Agent3 | DS | 01-DEC-20 |  | COM | 21/01/2021 | 0 | 0 | -0.39 | 0 | Manual
WH3 | Agent3 | LR | 01-DEC-19 | 31-DEC-19 | COM | 21/01/2021 | 321.2099999999999 | 321.2099999999999 | -4.819999999999999 | 1.5 | Premium Collection
WH3 | Agent3 | LR | 01-DEC-20 |  | COM | 21/01/2021 | 0 | 0 | -0.99 | 0 | Manual
WKE | Agent4 | DA |  | 82020 | PSC | 21/01/2021 | 0 | 0 | 0.06 | 0 | Manual
WKE | Agent4 | DS |  | 82020 | PSC | 21/01/2021 | 0 | 0 | 0.36 | 0 | Manual
WKE | Agent4 | LR |  | 82020 | PSC | 21/01/2021 | 0 | 0 | 0.48 | 0 | Manual
WKI | Agent4 | LR |  | 82020 | PSC | 21/01/2021 | 0 | 0 | -4308.78 | 0 | Manual
WPA | Agent4 | LR |  | 82020 | PSC | 21/01/2021 | 0 | 0 | -4308.78 | 0 | Manual
Y6Y | Agent1 | DA |  | 82020 | PSC | 21/01/2021 | 0 | 0 | -68623.02 | 0 | Manual
Y6Y | Agent1 | DS |  | 82020 | PSC | 21/01/2021 | 0 | 0 | 34.92 | 0 | Manual
Y6Y | Agent1 | DT |  | 82020 | PSC | 21/01/2021 | 0 | 0 | -6908.28 | 0 | Manual
Y6Y | Agent1 | DU |  | 82020 | PSC | 21/01/2021 | 0 | 0 | 0.42 | 0 | Manual
Y6Y | Agent1 | LR |  | 82020 | PSC | 21/01/2021 | 0 | 0 | 14923.59 | 0 | Manual
Y6Z | Agent1 | DA |  | 82020 | PSC | 21/01/2021 | 0 | 0 | -11914.02 | 0 | Manual
Y6Z | Agent1 | DA | 04-JAN-21 | 18-JAN-21 | COM | 21/01/2021 | 0 | 0 | -122 | 0 | Manual
Spreadsheet: 745384d1629894406-count-unique-value-with-multiple-criteria-sample-data
Sheet: Sheet1

 |  |  | Expected Result
 |  |  | 1 |  |  | Invoice No. | Date | Line Value
 |  |  | 1 |  |  | 100001 | 2021-02-01 00:00:00 | 100
 |  |  | 1 |  |  | 100001 | 2021-02-01 00:00:00 | 120
 |  |  | 2 |  |  | 100002 | 2021-03-05 00:00:00 | 130
 |  |  | 1 |  |  | 100003 | 2021-04-05 00:00:00 | 110
 |  |  | 1 |  |  | 100003 | 2021-04-05 00:00:00 | 120
 |  |  | 2 |  |  | 100003 | 2021-04-05 00:00:00 | 130
 |  |  |  |  |  | 100003 | 2021-04-05 00:00:00 | 140
 |  |  |  |  |  | 100004 | 2021-05-01 00:00:00 | 150
 |  |  |  |  |  | 100005 | 2021-05-05 00:00:00 | -20
 |  |  |  |  |  | 100006 | 2021-06-12 00:00:00 | 130
 |  |  |  |  |  | 100006 | 2021-06-12 00:00:00 | 110
 |  |  |  |  |  | 100007 | 2021-07-18 00:00:00 | 120
 |  |  |  |  |  | 100007 | 2021-07-18 00:00:00 | 130
 |  |  |  |  |  | 100008 | 2021-08-19 00:00:00 | 140
 |  |  |  |  |  | 100009 | 2021-08-20 00:00:00 | 110
Spreadsheet: 273206d1382635645-generate-a-filename-from-cells-text-content-filenames-02-moo
Sheet: Sheet1

 |  | marca | nome | gr | peso | cad. | prezzo | note | @image 1 | @image 2
rep | 1 | Barilla | sugo [NAME] | gr | 250 |  | 1.5 | flash | Barilla_sugo al basilico_gr_250.jpg | flash.eps
 | 2 | Mulino Bianco | [NAME] | gr | 700 |  | 3.6 |  | Mulino Bianco_pan di stelle_gr_700.jpg
 | 3 | Mulino Bianco | tarallucci | gr | 500 |  | 2.9 | 3x2 | Mulino Bianco_tarallucci_gr_500.jpg | 3x2.eps
 | 4 | Moretti | birra | cl | 33x3 |  | 4 |  | Moretti_birra_cl_33x3.jpg
 | 5 | Orogel | [NAME] | gr | 600 |  | 4.2 |  | Orogel_bastoncini di merluzzo_gr_600.jpg
 | 6 | Bonduelle | insalata [NAME]/iceberg/rucola | gr | 126 |  | 0.8 |  | Bonduelle_insalata mista/iceberg/rucola_gr_126.jpg
 | 7 | Moretti | / | cl | 33x3 | cad. | 4
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
rep | 31
 | 32
 | 33
Spreadsheet: 866515d1713446449-conditional-formatting-to-highlights-duplicate-date-from-yesterdays-date-conditional-formatting
Sheet: Sheet1

 |  |  |  |  | Date | Number | Color
 |  |  |  |  | 2024-04-17 00:00:00 | 1 | Blue
 |  |  |  |  | 2024-04-17 00:00:00 | 2 | Yellow
 |  |  |  |  | 2024-04-17 00:00:00 | 3 | Red
 |  |  |  |  | 2024-04-17 00:00:00 | 4 | Violet
 |  |  |  |  | 2024-04-17 00:00:00 | 5 | Blue
 |  |  |  |  | 2024-04-17 00:00:00 | 6 | Yellow
 |  |  |  |  | 2024-04-17 00:00:00 | 7 | Red
 |  |  |  |  | 2024-04-17 00:00:00 | 8 | Violet
 |  |  |  |  | 2024-04-17 00:00:00 | 6 | Yellow
 |  |  |  |  | 2024-04-18 00:00:00 | 17 | Blue
 |  |  |  |  | 2024-04-19 00:00:00 | 17 | Blue
 |  |  |  |  | 2024-04-17 00:00:00 | 20 | Red
Spreadsheet: 793001d1661260274-filter-formula-arrangements-filter-sort
Sheet: Days

ABC
Operator | X | Sun 21/08/2022 | Mon 22/08/2022 | Tue 23/08/2022 | Wed 24/08/2022 | [NAME] | Fri 26/08/2022 | Sat 27/08/2022 | Hours
 | x | 0 | 0 | 0 | 0 | 06:00-18:00 | 0 | 0
(A) HS | x | 0 | 0 | 0 | 0 | 06:00-18:00 | 0 | 0
AN | x | 06:00-18:00 | 0 | 0 | 0 | 06:00-18:00 | 0 | 0
BB | x | 0 | 0 | 0 | 0 | 12:00-18:00 | 0 | 0
BA | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 06:00-18:00
CS | x | 0 | 0 | 0 | 0 | 0 | 0 | 09:00-18:00
CK | x | 06:00-18:00 | 0 | 0 | 0 | 06:00-18:00 | 0 | 0
FS | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 0 | 06:00-18:00
FS | x | 0 | 0 | 0 | 0 | 0 | 06:00-18:00 | 0
I | x | 0 | Unscheduled | 0 | 0 | Unscheduled | 0 | 0
AN | x | 06:00-18:00 | 0 | 0 | 0 | 06:00-18:00 | 0 | 0
B | x | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | x | 06:00-15:00 | 0 | 0 | 0 | 0 | 0 | 0
D | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 06:00-18:00
E | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 06:00-18:00
FS | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 06:00-18:00
G | x | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | x | Unscheduled | Unscheduled | 0 | 0 | Unscheduled | 0 | 0
I | x | 09:00-18:00 | 0 | 0 | 0 | 0 | 0 | 0
J | x | 06:00-18:00 | 0 | 0 | 0 | 06:00-18:00 | 0 | 0
K | x | 0 | 0 | 0 | 0 | 0 | 0 | 0
L | x | Unscheduled | Unscheduled | 0 | 0 | Unscheduled | 0 | 0
M | x | 0 | 0 | 0 | 0 | 0 | 0 | 0
N | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 06:00-18:00
Operator | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 06:00-18:00
P | x | 0 | Unscheduled | Unscheduled | 0 | 0 | Unscheduled | Unscheduled
Q | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 06:00-18:00
R | x | 06:00-18:00 | 0 | 0 | 0 | 06:00-18:00 | 0 | 0
S | x | Unscheduled | Unscheduled | 0 | 0 | Unscheduled | 0 | 0
T | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 0
U | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 0 | 06:00-18:00
V | x | 0 | 0 | 0 | 0 | 0 | 0 | 0
W | x | 06:00-14:30 | 0 | 0 | 0 | 0 | 0 | 06:00-14:30
X | x | 0 | 06:00-18:00 | 06:00-18:00 | 0 | 0 | 06:00-18:00 | 06:00-18:00
Y | x | 0 | 0 | 0 | 0 | 0 | 0 | 0
Z | x | 0 | 0 | 0 | 0 | 0 | 0 | 0
Operator | x | Sun21/08/2022 | [NAME] | Tue23/08/2022 | Wed24/08/2022 | Thu25/08/2022 | Fri26/08/2022 | Sat27/08/2022
Spreadsheet: 820397d1678089823-sumifs-to-aggregate-hours-in-scheduling-problem2
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  | Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  | Project | Jan | Feb | Mar | Apr | May | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  | A | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  | Table of Inputs |  |  |  |  |  |  |  |  | B |  | 1 | 2 | 3 | 4 | 5
 |  |  |  | No | Job A | Job B | Job C | Beg M | End M |  |  |  | C |  |  | 1 | 2 | 3 | 4
 |  |  |  | A | 8 |  |  | 1 | 2
 |  |  |  | B | 7 |  |  | 1 | 3
 |  |  |  | C | 6 |  |  | 1 | 4
 |  |  |  | D | 5 |  |  | 1 | 3
 |  |  |  | E | 3 |  |  | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  | My Formula
 |  |  |  |  |  |  |  |  |  |  |  | Expected Result
 |  |  |  |  |  |  |  |  |  |  |  | Job A
 |  |  |  |  |  |  |  |  |  |  |  | Job A
 |  |  |  |  |  |  |  |  |  |  |  | Job B
 |  |  |  |  |  |  |  |  |  |  |  | Job C
Spreadsheet: monika_causholli__28193__Price Forecast
Sheet: Sheet1

Updated | Date: August 13, 2001 | Price Forecast
 | Firm/Analyst | Lumber | Newsprint | Market Pulp | Recovered | Containerboard | LWC | CFS | UCFS
 | PPCC
 | [NAME] |  | 560
 | PPW |  | 600 |  |  | $445 Liner |  | 840 | 700
 | Random Lengths | $189 OSB
 |  | $273 SPF
 | Merrill Lynch |  | Spot pricing up $10-20 mt
 | [NAME]
 | CS First Boston
 | Salomon Smith Barney
 | Chip Dillion
 | Morgan Stanley |  | $600 US East | $490 - 520 US NBSK |  | $445 Liner |  | $823 Coated #5 | $780 #4 20lb cutsize
 |  |  | $605 US West | $465 US SBSK |  | $400/ton Medium |  | $840 Coated #3
 | [NAME]
 | National Bank of Canada
 | Scotiabank |  | 550
 | [NAME]
 | TD Securities
 | [NAME]
 | JP Morgan
* | Deutche Bank | $349 (Lumber Composite) | 590 | 480 | $35 OCC Midwest | $440 Linerboard | 805 | 810 | 795
 | [NAME] | $281 (Panel Composite) |  |  | $50 OCC West | $400 CM
 | CIBC Securities
 | First Associate Investment Inc. |  | $50/tonne deterioration
 | Reel Time |  | 500
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 17022
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 1496
Index Tranche | Asia | <100
 | Europe | <100
 | North America | 120
Index | Asia | 127
 | Europe | 2508
 | North America | 4505
TOTAL |  | 25778
Estimated swap transaction volumes, week ending December 21, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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.
**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: 51908d1251485808-counting-numbers-in-one-column-by-criteria-in-another-697570-counting-numbers-in-one-column-by-criteria-in-another
Sheet: Sheet1

 |  |  |  | 4a | 4b | 6b
4b | 4 |  | 1 | 2 | 2 | 2
6b | 1 |  | 2 | 0 | 0 | 1
4b | 1 |  | 3 | 0 | 0 | 1
6b | 2 |  | 4 | 0 | 1 | 0
4a | 1 |  | 5 | 0 | 0 | 1
4b | 1
6b | 3
6b | 1
4a | 1
6b | 5
Spreadsheet: 830401d1684896654-sum-and-count-values-with-criteria-sum-and-count-values-with-criteria
Sheet: Sheet1

Salespeople |  | Salesperson | Sales | Month |  | Problem #1
[NAME] |  | Regan | 49 | May |  |  | [NAME] | $ Total Sales
[NAME] |  | [NAME] | 25 | February
Mark |  | Molly | 83 | March |  |  |  | 326
Regan |  | [NAME] | 39 | May |  |  | [NAME] | 170
[NAME] |  | [NAME] | 74 | April |  |  | [NAME] | 164
Shaun |  | [NAME] | 78 | June
Molly |  | [NAME] | 80 | July
[NAME] |  | Heather | 23 | August |  | Problem #2
Heather |  | [NAME] | 43 | September |  |  | [NAME] | $ Sales in MAY
[NAME] |  | [NAME] | 64 | October
[NAME] |  | Mark | 91 | November |  |  |  | 170
Lauren |  | Lauren | 86 | December |  |  | Regan | 49
[NAME] |  | [NAME] | 90 | January |  |  | [NAME] | 2
 |  | [NAME] | 2 | May
 |  | [NAME] | 36 | March
 |  | Shaun | 69 | April |  | Problem #3
 |  | [NAME] | 84 | May |  |  | [NAME] | Number of Sales in MAY
 |  | [NAME] | 47 | May
 |  |  |  |  |  |  |  | 3 |  |  |  | 3
 |  |  |  |  |  |  | Regan | 1 |  |  | Regan | 1
 |  |  |  |  |  |  | [NAME] | 1 |  |  | [NAME] | 1
 |  |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  |  | Molly | 0
 |  |  |  |  |  |  | [NAME] | 0
Spreadsheet: 778082d1650853807-automatic-ranking-standings-bouwcenter-poule-f1-2022-v1a-clau46-
Sheet: Results Sprint

Results sprintraces
King of speed | 33 - Max Verstappen, Red Bull-RBPT |  | King of speed |  |  | King of speed
1 | 33 - Max Verstappen, Red Bull-RBPT |  | 1 |  |  | 1
2 | 16 - [NAME], Ferrari |  | 2 |  |  | 2
3 | 11 - Sergio Perez, Red Bull-RBPT |  | 3 |  |  | 3
4 | 55 - [NAME], Ferrari |  | 4 |  |  | 4
5 | 4 - Lando Norris, [NAME] |  | 5 |  |  | 5
6 | 3 - Daniel Ricciardo, [NAME] |  | 6 |  |  | 6
7 | 77 - Valtteri Bottas, [NAME] |  | 7 |  |  | 7
8 | 20 - [NAME], [NAME] |  | 8 |  |  | 8
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: RefWorks

RefWorks
2010-2011
COUNTER-Compliant?: | No
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
New Users | 17 | 7 | 71 | 112 | 18 | 8 | 8 | 139 | 63 | 28 | 12 | 8 |  | 0
Repeat Users | 31 | 20 | 39 | 96 | 120 | 86 | 35 | 66 | 131 | 135 | 76 | 37 |  | 0
Total Monthly Users | 48 | 27 | 110 | 208 | 138 | 94 | 43 | 205 | 194 | 163 | 88 | 45 |  | 0
Total Sessions per month | 243 | 109 | 337 | 698 | 570 | 378 | 160 | 793 | 1161 | 763 | 335 | 227 |  | 0
Average Sessions Per User | 5.06 | 4.04 | 3.06 | 3.36 | 4.13 | 4.02 | 3.72 | 3.87 | 5.98 | 4.68 | 3.81 | 5.04 |  | 0
Total Subscriber References added | 2225 | 6.53 | 3382 | 4553 | 2949 | 1009 | 1610 | 1669 | 4615 | 2762 | 767 | 1473 |  | 0
Average References added per user | 46.35 | 24.19 | 30.75 | 21.89 | 21.37 | 10.73 | 37.44 | 8.14 | 23.79 | 16.94 | 8.72 | 32.73 |  | 0
Spreadsheet: 605346d1547042971-alphabetize-column-while-moving-associated-data-alphabetize-help-please
Sheet: Summary

PartnerName | 2019-01-01 00:00:00 | 2019-01-02 00:00:00 | 2019-01-03 00:00:00 | 2019-01-04 00:00:00 | 2019-01-05 00:00:00 | 2019-01-06 00:00:00 | 2019-01-07 00:00:00 | 2019-01-08 00:00:00 | 2019-01-09 00:00:00 | 2019-01-10 00:00:00 | 2019-01-11 00:00:00 | 2019-01-12 00:00:00 | 2019-01-13 00:00:00 | 2019-01-14 00:00:00 | 2019-01-15 00:00:00 | 2019-01-16 00:00:00 | 2019-01-17 00:00:00 | 2019-01-18 00:00:00 | 2019-01-19 00:00:00 | 2019-01-20 00:00:00 | 2019-01-21 00:00:00 | 2019-01-22 00:00:00 | 2019-01-23 00:00:00 | 2019-01-24 00:00:00 | 2019-01-25 00:00:00 | 2019-01-26 00:00:00 | 2019-01-27 00:00:00 | 2019-01-28 00:00:00 | 2019-01-29 00:00:00 | 2019-01-30 00:00:00 | 2019-01-31 00:00:00
MNO
DEF
GHI
ABC
JKL