tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 55743d1255949180-multiple-interrogation-of-data-corres_test
Sheet: CORRES

CORRESPONDENCE
COUNTRY | BOOKING REF | DATE OF DEPARTURE | SUBJECT
Andorra | 123456 | 2009-12-01 00:00:00 | Complaint
Andorra | 654321 | 2009-12-13 00:00:00 | Compliment
Canada | 987654 | 2010-01-01 00:00:00 | Ticketing issue
Italy | 345634 | 2010-01-03 00:00:00 | Ticketing issue
USA | 123987 | 2010-01-23 00:00:00 | Ticketing issue
USA | 345234 | 2010-01-31 00:00:00 | Delayed flight
USA | 987234 | 2010-01-13 00:00:00 | Delayed flight
Canada | 987987 | 2009-12-01 00:00:00 | Ticketing issue
Austria | 123567 | 2009-12-13 00:00:00 | Complaint
Austria | 983456 | 2009-12-13 00:00:00 | Compliment
Switzerland | 567987 | 2009-12-25 00:00:00 | Compliment
Austria | 234876 | 2009-12-25 00:00:00 | Ticketing issue
Andorra | 234123 | 2010-01-01 00:00:00 | Ticketing issue
Spreadsheet: 150731d1334670564-index-match-or-sumproduct-with-concatenate-solution-to-problem
Sheet: Summary for Slides

 |  |  | Product 1 | Spacer | Product Group | Total Sales Inc ES
 |  |  | Product 1 | Aluminium | Product 1Aluminium | 95
 |  |  | Product 2 | Aluminium | Product 2Aluminium | 305
 |  |  | Product 3 | Aluminium | Product 3Aluminium | 72
 |  |  | Product 4 | Aluminium | Product 4Aluminium | 57
 |  |  | Product 5 | Aluminium | Product 5Aluminium | 84
 |  |  | Product 6 | Aluminium | Product 6Aluminium | 275
 |  |  | Product 7 | Aluminium | Product 7Aluminium | 254
 |  |  | Product 1 | [NAME] | Product 1Warm Edge | 184
 |  |  | Product 2 | [NAME] | Product 2Warm Edge | 285
 |  |  | Product 3 | [NAME] | Product 3Warm Edge | 454
 |  |  | Product 4 | [NAME] | Product 4Warm Edge | 392
 |  |  | Product 5 | [NAME] | Product 5Warm Edge | 199
 |  |  | Product 6 | [NAME] | Product 6Warm Edge | 271
 |  |  | Product 7 | [NAME] | Product 7Warm Edge | 154
Spreadsheet: 888036d1738343623-sumifs-excluding-contents-of-specific-cell-01-30-25-sumifs-conditionals-exclude-w-excel-forum-member-help
Sheet: Results

[NAME]
Product | Sum |  |  | Don't Count Conditions
CHI046 |  |  |  | hwkent
RB-SNK141 |  |  |  | FM-Reedley
SNK018
RB-CHE002
RB-SNK007
BOX001
BOX002
Pete_UK
Product | Sum
CHI046
RB-SNK141
SNK018
RB-CHE002
RB-SNK007
BOX001
BOX002
Spreadsheet: 152377d1335367092-need-help-with-multiple-lookup-formulas-and-worksheets-fsfc-04-25-12
Sheet: InvAmtByAge

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
1430 | 1430 | 1430 | 1430 | 1430 | 1483 | 1483 | 1483 | 1483 | 1527 | 1527 | 1527 | 1608 | 1608 | 1608 | 1679 | 1679 | 1679 | 1679
Spreadsheet: 167864d1342123086-excel-2007-changing-denominator-every-nth-cell-changing-denominator
Sheet: Sheet1

2007-12-30 00:00:00 | 1588052
2008-01-31 00:00:00 | 158802
2008-02-29 00:00:00 | 146346
2008-03-31 00:00:00 | 155,56
2008-04-30 00:00:00 | 147403
2008-05-30 00:00:00 | 158988
2008-06-30 00:00:00 | 125726
2008-07-31 00:00:00 | 142128
2008-08-29 00:00:00 | 166699
2008-09-30 00:00:00 | 144865
2008-10-31 00:00:00 | 182443
2008-11-28 00:00:00 | 57245
2008-12-31 00:00:00 | 92926
2009-01-30 00:00:00 | 20226
2009-02-29 | 146346
2009-03-30 00:00:00 | 155,56
2009-04-30 00:00:00 | 147403
2009-05-30 00:00:00 | 158988
2009-06-30 00:00:00 | 125726
2009-07-30 00:00:00 | 142128
2009-08-30 00:00:00 | 142128
2009-09-30 00:00:00 | 166699
2009-10-30 00:00:00 | 144865
2009-11-30 00:00:00 | 182443
2009-12-30 00:00:00 | 57245
2010-01-30 00:00:00 | 92926
2010-02-29 | 447
2010-03-30 00:00:00 | 7786
2010-04-30 00:00:00 | 48567
2010-05-30 00:00:00 | 786
2010-06-30 00:00:00 | 78864
2010-07-30 00:00:00 | 4686
2010-08-30 00:00:00 | 486846
2010-09-30 00:00:00 | 4868
2010-10-30 00:00:00 | 7866
2010-11-30 00:00:00 | 486
2010-12-30 00:00:00 | 486
2011-01-30 00:00:00 | 554
2011-02-30 | 48757
2011-03-30 00:00:00 | 4537
2011-04-30 00:00:00 | 453
Spreadsheet: 693577d1599045753-combining-if-statements-test
Sheet: Sheet1

No1 | No2 | Type | No3 | No4 | Answer
90 | 5 | Blue | 5.5 | 0.02 |  | =IF(E2="","",IF(((((((B2*(C2-2))*1.02)/(E2-1))/1.02)+(-B2))+(B2))/(B2)<0.65,"NO BET",((C2-1)/(E2-F2)*B2)))
90 | 5 | Green | 5.5 | 0.02 |  | =IF(E3="","",IF(((((((B3*(C3-2))*1.02)/(E3-1))/1.02)+(-B3))+(B3))/(B3)<0.65,"NO BET",(C3/(E3-F3)*B3)))
 |  |  |  |  |  | If "Blue" = (C2-1)/(E2-F2)*B2)
 |  |  |  |  |  | If "Green" = (C3/(E3-F3)*B3)
Spreadsheet: 719310d1613613068-possible-indirect-function-needed-or-any-feasible-method-indirect-function-help
Sheet: 166465789-246549800000

Client ID | Client Name | Account | Name | Group Name | Invoice No | Description Total | Charge Type | Random | Random | Random | Random | Random | Random | Random | Random | Random | CCY | Invoice Charge
166465789 | Example | 232134164 | Example |  | 246549800000 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | NOK | 391219.98
166465789 | Example | 232134165 | Example |  | 246549800000 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | NOK | 421211.94
166465789 | Example | 232134166 | Example |  | 246549800000 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | NOK | 451203.9
166465789 | Example | 9765467 | Example |  | 246549800000 | Valuations Fee |  |  |  |  |  |  |  |  |  |  | USD | 416
166465789 | Example | 9765468 | Example |  | 246549800000 | Valuations Fee |  |  |  |  |  |  |  |  |  |  | USD | 13
166465789 | Example | 446798 | Example |  | 246549800000 | Valuations Fee |  |  |  |  |  |  |  |  |  |  | USD | 12.56
166465789 | Example | 666460 | Example |  | 246549800000 | Surcharge |  |  |  |  |  |  |  |  |  |  | USD | 4.56
Spreadsheet: 79920d1280176109-lookup-data-and-show-charted-by-month-sample-finished-
Sheet: CORE DATA

doc name | Revision | Activation date | review date
ABC123 | 1 | 2009-09-14 00:00:00 | 2011-03-03 00:00:00
DEF456 | 3 | 2010-02-06 00:00:00 | 2011-02-05 00:00:00
GHI789 | 2 | 2008-03-27 00:00:00 | 2011-04-20 00:00:00
JKL123 | 1 | 2011-03-17 00:00:00 | 2011-03-16 00:00:00
MNO456 | 2 | 2006-09-05 00:00:00 | 2011-06-09 00:00:00
Name 6 | ? | ? | 2010-12-05 00:00:00
Name 7 | ? | ? | ?
Name 8 | ? | ? | ?
Name 9 | ? | ? | ?
Name 10 | ? | ? | ?
Name 11 | ? | ? | ?
Name 12 | ? | ? | ?
Name 13 | ? | ? | ?
Name 14 | ? | ? | ?
Name 15 | ? | ? | ?
Name 16 | ? | ? | ?
Name 17 | ? | ? | ?
Name 18 | ? | ? | ?
Name 19 | ? | ? | ?
Name 20 | ? | ? | ?
Name 21 | ? | ? | ?
Name 22 | ? | ? | ?
Name 23 | ? | ? | ?
Name 24 | ? | ? | ?
Name 25 | ? | ? | ?
Name 26 | ? | ? | ?
Name 27 | ? | ? | ?
Name 28 | ? | ? | ?
Name 29 | ? | ? | ?
Name 30 | ? | ? | ?
Name 31 | ? | ? | ?
Name 32 | ? | ? | ?
Name 33 | ? | ? | ?
Name 34 | ? | ? | ?
Spreadsheet: 715024d1611512030-count-of-last-number-from-an-array-between-two-values-counttest
Sheet: Sheet1

 | Count of values between 0.5 and 2.5 among the last 3 instances of each | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00 | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-23 00:00:00 | 2021-01-24 00:00:00
Alpha | 2 | 4 |  |  | 3 |  | 4 | 2 |  | 3 |  |  | 2
Beta | 1 | 0 |  |  | 2 |  | 1 | 3 |  | 0
Gamma | 2 | 2 |  | 3 |  | 2 |  | 0 | 1 |  | 3 |  |  |  | 1
Delta | 0 | 1 |  | 1 |  | 2 |  | 3 | 3 |  | 4 |  |  |  | 3
Epsilon | 2 | 3 |  | 0 |  | 1 |  | 2 | 0 |  | 1 |  |  |  | 2
Zeta | 1 | 3 |  | 0 |  | 2 |  | 0 | 0 |  | 0 |  |  |  | 2
Eta | 3 | 0 |  | 3 |  | 7 |  |  | 2 |  | 1 |  | 1
Theta | 1 | 2 |  | 5 |  | 5 |  |  | 5 |  | 4 |  | 2
Iota | 1 | 1 |  | 1 |  | 0 |  |  | 1 |  | 0
Kappa | 2 | 3 |  | 2 |  | 2 |  |  | 3 |  | 1 |  | 2
Lamda | 2 | 1 |  | 1 |  | 1 |  |  | 3 |  |  |  | 2
Spreadsheet: 739999d1626123481-displaying-time-from-a-fraction-effractiontotime
Sheet: Sheet1

 |  |  |  |  | 06:35:00 | 14:35:00
 |  |  |  |  | 09:19:00 | 17:56:00
 |  |  |  |  | 07:10:00 | 12:00:00
 |  |  |  |  | 14:35:00 | 17:38:00
 |  |  |  |  | 07:19:00 | 09:19:00
 |  |  |  |  | 12:00:00 | 17:55:00
 |  |  |  |  | 15:51:00 | 18:14:00
 |  |  |  |  |  |  | 1 day, 10:48:00
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 372408 | 395000 | 54996 | 51737 | 77854 | 40670 | 76796 | 95022
2 | 371402 | 400000 | 51789 | 50166 | 82226 | 75758 | 63005 | 67484
3 | 374673 | 377553 | 45902 | 49510 | 79928 | 75857 | 63323 | 63651
4 | 391192 | 400000 | 74587 | 76673 | 73280 | 73080 | 120589 | 107762
5 | 383957 | 398502 | 56653 | 51016 | 75484 | 70290 | 93011 | 84699
6 | 359161 | 377237 | 37186 | 32959 | 76331 | 75340 | 67920 | 61227
7 | 356082 | 400000 | 72481 | 70868 | 80602 | 85687 | 73891 | 74915
8 | 347490 | 341205 | 80045 | 69316 | 80506 | 77451 | 95309 | 96346
9 | 227021 | 218582 | 41724 | 47018 | 69337 | 58706 | 55471 | 57915
10 | 206977 | 218582 | 57075 | 47018 | 62471 | 58706 | 60760 | 57915
11 | 247615 | 260374 | 44330 | 39034 | 72487 | 79683 | 53273 | 47378
12 | 314990 | 315860 | 55833 | 54940 | 75985 | 74409 | 97302 | 96007
13 | 324658 | 318495 | 39927 | 48780 | 69879 | 66897 | 82453 | 76080
14 | 297028 | 295559 | 46805 | 52236 | 74314 | 65706 | 82731 | 82045
15 | 314898 | 332451 | 54801 | 46979 | 66415 | 62129 | 97837 | 88364
16 | 304910 | 333503 | 64885 | 47967 | 63434 | 60662 | 79061 | 68700
17 | 302926 | 334832 | 69533 | 44264 | 66099 | 61813 | 77275 | 66857
18 | 317995 | 331948 | 54897 | 54895 | 63349 | 62127 | 77264 | 66556
19 | 332220 | 323242 | 55852 | 51857 | 59277 | 62085 | 71415 | 75600
20 | 328464 | 326015 | 60985 | 56770 | 70350 | 64335 | 68535 | 72168
21 | 328240 | 347088 | 59353 | 56837 | 64398 | 62337 | 70003 | 69622
22 | 321628 | 325658 | 63913 | 56580 | 68501 | 66758 | 77524 | 70276
23 | 311325 | 330095 | 62152 | 56415 | 63936 | 57421 | 90398 | 81717
24 | 281426 | 300369 | 53793 | 56387 | 56074 | 50201 | 92973 | 76969
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  |  |  |  |  | 278779
2001-06-24 00:00:00
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 56969d1257166916-couting-unique-entries-with-second-condition-not-using-pivot-example-unique-a-b-count-version-1-
Sheet: Sheet1

Surname | Forename | Fullname | ID | Reason | Provider | Narrative | Start Date | End Date | Nights | Hours | Worker | Blank | A or B
Biggs | [NAME] | Biggs [NAME] | 11 |  | HW | Provider | 2009-01-01 00:00:00 | 2009-01-30 00:00:00 | 29 | 348 | RG |  | A
Biggs | [NAME] | Biggs [NAME] | 11 |  | HW | Provider | 2009-02-02 00:00:00 | 2009-02-28 00:00:00 | 26 | 312 | RG |  | A
[NAME] | [NAME] | [NAME] | 12 |  | HW | Provider | 2009-01-01 00:00:00 | 2009-01-30 00:00:00 | 29 | 348 | RG |  | A
[NAME] | [NAME] | [NAME] | 12 |  | HW | Provider | 2009-01-01 00:00:00 | 2009-01-30 00:00:00 | 29 | 348 | RG |  | A
[NAME] | [NAME] | [NAME] | 12 |  | HW | Provider | 2009-01-01 00:00:00 | 2009-01-30 00:00:00 | 29 | 348 | RG |  | A
[NAME] | [NAME] | [NAME] | 13 |  | TP | Provider | 2009-06-06 00:00:00 | 2009-07-06 00:00:00 | 30 | 360 | MH |  | B
[NAME] | [NAME] | [NAME] | 13 |  | TP | Provider | 2009-08-07 00:00:00 | 2009-09-09 00:00:00 | 33 | 396 | MH |  | B
Gould | [NAME] | [NAME] | 14 |  | HW | School | 2009-01-01 00:00:00 | 2009-01-03 00:00:00 | 2 | 24 | MH |  | B
Barley | [NAME] | Barley Matthew | 15 |  | HW | School | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 31 | 372 | MH |  | B
Barley | [NAME] | Barley Matthew | 15 |  | HW | School | 2009-03-02 00:00:00 | 2009-03-10 00:00:00 | 8 | 96 | MH |  | B
Barley | [NAME] | Barley Matthew | 15 |  | HW | School | 2009-05-03 00:00:00 | 2009-05-05 00:00:00 | 2 | 24 | MH |  | B
Expected result |  |  | 0
Unique A = 2
Unique B = 3
Spreadsheet: 744319d1629148553-subtract-2-cells-if-amount-in-cell-b-is-greater-than-cell-c-i-need-the-sum-to-go-alt-cell-sample-worksheet
Sheet: May 2021

Subscriptions | [NAME] | [NAME] | Difference
Gas |  | 35
Gas |  | 35
Net Flix |  | 12.99
Cox |  | 179.34
HBO Max | 14.99
Disney Plus | 8.89
MS Office | 11.06
You Tube | 9.99
Spotify | 12.99
Billie | 10
Club Carwash | 21.75
Discovery plus | 7.78
Chewy | 56.71
Sprint | 135.83
Totals |  |  | 27.66 | luci owes
Spreadsheet: 199412d1355211811-need-help-fo-voltage-drop-calculator-in-excel-test-vd
Sheet: Sheet2

 |  |  | VOLTAGE | 33 |  |  |  | cable | k values | KV
 |  |  | CABLE | 3c,185 mm2 |  |  |  | 3c,185 mm2 | 63020 | 33 | 3c,185 mm2 | AL | 13.8 |  | k values | KV
 |  |  | LENGTH | 100 |  |  |  | 3c,300mm2 | 14712 | 13.8 | 3c,300mm2 | CU | 33 |  | 63020 | 33
 |  |  | KVA | 66 |  |  |  | 3c,185 mm2 | 11020 | 13.8 | 170mm2 ACSR |  |  |  | 14712 | 13.8
 |  |  |  |  |  |  |  | 3c,300mm2 | 11282 | 13.8 |  |  |  |  | 11020 | 13.8
 |  |  |  |  |  |  |  | 170mm2 ACSR | 26535 | 33 |  |  |  |  | 11282 | 13.8
 |  |  | VD |  |  |  |  | 170mm2 ACSR | 4730 | 13.8 |  |  |  |  | 26535 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4730 | 13.8
Spreadsheet: f5651362-fa3c-413a-98fe-2237ddba9ff5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4352 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
Spreadsheet: 86764d1286742450-sumproduct-formula-with-a-minimum-value-needed-trial-calculator
Sheet: Weapons Calc

 |  |  |  |  |  |  |  | defend |  |  |  | attack
 |  |  |  |  | group size | 3 |  | 17.2 | 1 | 17 |  | 24.12 | 1 | 24
 |  |  | items |  |  |  |  | 16.18 | 0 | 0 |  | 22.14 | 0 | 0
 | defend | attack | purchased |  | Defense | 44 |  | 15.02 | 1 | 15 |  | 20.17 | 1 | 20
stick | 0 | 1 |  |  | Attack | 44 |  | 14.22 | 0 | 0 |  | 18.16 | 0 | 0
bat | 2 | 1 |  |  |  |  |  | 12.24 | 1 | 12 |  | 15.12 | 0 | 0
knife | 1 | 2 |  |  |  |  |  | 12.15 | 0 | 0 |  | 10.08 | 0 | 0
 | 2 | 3 |  |  |  |  |  | 9.08 | 0 | 0 |  | 8.09 | 0 | 0
 | 2 | 3 |  |  |  |  |  | 8.1 | 0 | 0 |  | 7.03 | 0 | 0
 | 6 | 5 |  |  |  |  |  | 6.05 | 0 | 0 |  | 5.06 | 0 | 0
 | 3 | 7 |  |  |  |  |  | 4.01 | 0 | 0 |  | 5.03 | 0 | 0
 | 9 | 8 |  |  |  |  |  | 3.07 | 0 | 0 |  | 3.02 | 0 | 0
 | 4 | 1 |  |  |  |  |  | 3.05 | 0 | 0 |  | 3.02 | 0 | 0
 | 3 | 5 |  |  |  |  |  | 2.03 | 0 | 0 |  | 2.15 | 1 | 2
 | 8 | 10 |  |  |  |  |  | 2.03 | 0 | 0 |  | 2.01 | 0 | 0
 | 12 | 15 |  |  |  |  |  | 2.01 | 0 | 0 |  | 1.04 | 0 | 0
chain | 16 | 18 |  |  |  |  |  | 1.02 | 0 | 0 |  | 1.02 | 0 | 0
[NAME] | 14 | 22 |  |  |  |  |  | 0.01 | 0 | 0 |  | 1 | 0 | 0
chainsaw | 15 | 2 | 1
bomb | 12 | 24 | 1
shield spike | 17 | 20 | 1
 | Total Items purchased |  | 3
Spreadsheet: 846471d1697649526-sum-values-in-between-hour-intervals-total-by-interval
Sheet: Sheet1

HOUR | Instances |  |  |  |  | Expected Result
12 AM | 34 |  | AM Shift | 6AM to 2PM (1:59:59PM)
1 AM | 36 |  | PM Shift | 2PM to 10PM (9:59:59PM) |  | Shift | Total
2 AM | 22 |  | Night Shift | 10PM to 6AM (5:59:59AM) |  | AM Shift | 551
3 AM | 16 |  |  |  |  | PM Shift | 463
4 AM | 14 |  |  |  |  | Night Shift | 219
5 AM | 25
6 AM | 31
7 AM | 41
8 AM | 91
9 AM | 116
10 AM | 80
11 AM | 44
12 PM | 68
1 PM | 80
2 PM | 74
3 PM | 72
4 PM | 46
5 PM | 81
6 PM | 66
7 PM | 35
8 PM | 44
9 PM | 45
10 PM | 36
11 PM | 36
Spreadsheet: 718326d1613086016-count-for-day-of-the-week-and-time-frame-time-hour-etaf-v2
Sheet: Sheet1

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-07 00:00:00 | 09:00:00
01:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-07 00:00:00 | 13:00:00
02:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-08 00:00:00 | 11:00:00
03:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-08 00:00:00 | 15:00:00
04:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00
05:00:00 |  |  |  |  |  |  |  |  |  |  | 13:00:00
06:00:00 |  |  |  |  |  |  |  |  |  |  | 17:00:00
07:00:00 |  |  |  |  |  |  |  |  |  |  | 21:00:00
08:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00
09:00:00 |  |  |  |  |  |  |  |  |  |  | 13:00:00
10:00:00 |  |  |  |  |  |  |  |  |  |  | 17:00:00
11:00:00 |  |  |  |  |  |  |  |  |  |  | 21:00:00
12:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00
13:00:00 |  |  |  |  |  |  |  |  |  |  | 13:00:00
14:00:00 |  |  |  |  |  |  |  |  |  |  | 17:00:00
15:00:00 |  |  |  |  |  |  |  |  |  |  | 23:45:00
16:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00
17:00:00 |  |  |  |  |  |  |  |  |  |  | 13:00:00
18:00:00 |  |  |  |  |  |  |  |  |  |  | 17:00:00
19:00:00 |  |  |  |  |  |  |  |  |  |  | 21:00:00
20:00:00
21:00:00
22:00:00
23:00:00
23:59:00
Spreadsheet: louise_kitchen__24044__Natural Gas Consolidated
Sheet: Natural Gas Consolidated

 | Natural Gas
 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount
 | A&A Headcount
 | Total Headcount
Spreadsheet: 71b9a756-2146-4c76-93cb-a20b6a47b961
Sheet: Reference Contract OI & Limits

Contract | Average 2010 All Months Combined Month-End Open Interest, All Referenced Contracts (delta-adjusted) | Non-Spot Month-Position Limit Using the Proposed Formula* | Proposed Non-Spot-Month Limit
Agricultural Contracts
Cocoa | 142119 | 5500 | Same as [NAME]
Coffee | 194108 | 6800 | Same as [NAME]
Corn | 1781963 | 46500 | 22000
Cotton No. 2 | 302429 | 9500 | 5000
[NAME] | 41567 | 3000 | Same as [NAME]
[NAME] Juice | 39795 | 2900 | Same as [NAME]
[NAME] | 235011 | 7800 | Same as [NAME]
Live Cattle | 417291 | 12400 | Same as [NAME]
Milk Class III | 42183 | 3000 | Same as [NAME]
Oats | 15037 | 2500 | 2000
Rough [NAME] | 18398 | 2500 | Same as [NAME]
Soybeans | 685585 | 19100 | 10000
Soybean Meal | 221778 | 7500 | 6500
Soybean Oil | 356944 | 10800 | 6500
Sugar No. 11 | 945999 | 25600 | Same as [NAME]
Sugar No. 16 | 12447 | 2500 | Same as [NAME]
Wheat (CBOT) | 571939 | 16200 | 6500
Wheat, Hard Red Spring | 55413 | 3300 | 6500
Wheat, Hard Winter | 189326 | 6700 | 6500
Base Metal Contracts
Copper Grade #1 | 143086 | 5500 | Same as [NAME]
Precious Metal Contracts
Gold | 755167 | 20800 | Same as [NAME]
Palladium | 23301 | 2500 | Same as [NAME]
Platinum | 34911 | 2800 | Same as [NAME]
Silver | 164812 | 6000 | Same as [NAME]
Energy Contracts
Crude Oil, Light Sweet | 4243439 | 108000 | Same as [NAME]
Gasoline Blendstock | 342930 | 10500 | Same as [NAME]
Natural Gas | 4715746 | 119800 | Same as [NAME]
No. 2 Heating Oil, New York Harbor | 539809 | 15400 | Same as [NAME]
* Note: These levels were computed using 2010 open interest for the contracts and swaps listed on the sheets that follow in this workbook.
These levels would be higher if additional swap open interest data was available.
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 23550 | 23150
2 | 23965 | 23150
3 | 23996 | 23150
4 | 23484 | 23150
5 | 23000 | 23150
6 | 23146 | 23150
7 | 20037 | 23150
8 | 23762 | 23150
9 | 23829 | 23150
10 | 23318 | 23150
11 | 23655 | 23150
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | 95639.73
2000-12-11 00:00:00
Spreadsheet: 691698d1597834400-help-with-formula-show-results-based-on-date-2020-08-19-oeldere2-stefvdm-691689d1597831575-help-with-formula-show-results-based-on-date-vo
Sheet: Blad1

ID | Name | Date | Month | count
100 | Jan |  |  |  |  |  |  | Hey everyone, I've been working on a formula for several hours but can't seem to figure it out.
101 | Pieter | 2020-02-10 00:00:00
103 | Marleen | 2020-02-10 00:00:00 |  |  |  |  |  | At each end of the month I need a formule in the yellow field that shows the 'available' ID numbers of each person. A
104 | Jan
105 | Pieter | 2020-03-10 00:00:00 |  |  |  |  |  | For exemple: For January, it shows that everybody has all of there ID numbers available. But at the end of February, Marleen has used all of her ID numbers (once on 10/02, 15/02 and 20/02). But for [NAME] in February he has only used one ID number (on 10/02) and will use his other ID numbers in March and April. But for February the formula needs to detect the 2 available numbers in February.
107 | Marleen | 2020-02-15 00:00:00
108 | Jan |  |  |  |  |  |  | I really hope you guys can help me figure this out! Thanks in advance!
109 | Pieter | 2020-04-10 00:00:00
111 | Marleen | 2020-02-20 00:00:00
Yet to accomplish | Jan | Pieter | Marleen |  |  | Jan | Pieter | Marleen |  |  | Jan | Pieter | Marleen
January | 100 | 101 | 103 |  | February | 100 | 105 |  |  | March | 100 | 109
 | 104 | 105 | 107 |  |  | 104 | 109 |  |  |  | 104
 | 108 | 109 | 111 |  |  | 108 |  |  |  |  | 108
1 | Jan | Pieter | Marleen |  | 2 | Jan | Pieter | Marleen |  | 3 | Jan | Pieter | Marleen |  | 4 | Jan | Pieter | Marleen
1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1
2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2
3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3
4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4
DC HJ | 2019-12-31 00:00:00 | 2020-02-01 00:00:00 |  |  |  |  |  | Aantal [NAME] |  | Month
 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 |  |  |  |  |  | Name | ID | 1 | 2 | 3 | 4 | Eindtotaal
 | 2020-02-29 00:00:00 | 2020-04-01 00:00:00 |  |  |  |  |  | Jan | 100 | 1 |  |  |  | 1
 | 2020-03-31 00:00:00 | 2020-05-01 00:00:00 |  |  |  |  |  | Jan | 104 | 1 |  |  |  | 1
 | 2020-04-30 00:00:00 | 2020-06-01 00:00:00 |  |  |  |  |  | Jan | 108 | 1 |  |  |  | 1
 | 2020-05-31 00:00:00 | 2020-07-01 00:00:00 |  |  |  |  |  | Marleen | 103 |  | 1 |  |  | 1
 | 2020-06-30 00:00:00 | 2020-08-01 00:00:00 |  |  |  |  |  | Marleen | 107 |  | 1 |  |  | 1
 | 2020-07-31 00:00:00 | 2020-09-01 00:00:00 |  |  |  |  |  | Marleen | 111 |  | 1 |  |  | 1
 | 2020-08-31 00:00:00 | 2020-10-01 00:00:00 |  |  |  |  |  | Pieter | 101 |  | 1 |  |  | 1
 | 2020-09-30 00:00:00 | 2020-11-01 00:00:00 |  |  |  |  |  | Pieter | 105 |  |  | 1 |  | 1
 | 2020-10-31 00:00:00 | 2020-12-01 00:00:00 |  |  |  |  |  | Pieter | 109 |  |  |  | 1 | 1
 | 2020-11-30 00:00:00 | 2021-01-01 00:00:00 |  |  |  |  |  | Eindtotaal |  | 3 | 4 | 1 | 1 | 9
Spreadsheet: 169019d1342681091-excel-2007-sorting-scaterred-data-to-view-the-max-and-min-value-of-spesific-value-example-sorting
Sheet: Sheet1

 |  | subject 1 | subject 2 | subject 3 |  |  | subject 1 | subject 2 | subject 3
 | A | 10 | 9 | 9 |  |  | (Maximum value from candidate A) | (Maximum value from candidate A) | (Maximum value from candidate A)
 | B | 9 | 2 | 9 |  |  | (Maximum value from candidate B) | (Maximum value from candidate B) | (Maximum value from candidate B)
 | C | 8 | 4 | 6 |  |  | (Maximum value from candidate C) | (Maximum value from candidate C) | (Maximum value from candidate C)
 | D | 6 | 8 | 8 |  |  | (Maximum value from candidate D) | (Maximum value from candidate D) | (Maximum value from candidate D)
 | E | 4 | 3 | 1 |  |  | (Maximum value from candidate E) | (Maximum value from candidate E) | (Maximum value from candidate E)
 | A | 4 | 9 | 7
 | B | 5 | 10 | 2
 | D | 6 | 2 | 8
 | C | 7 | 3 | 1
 | B | 1 | 4 | 4
 | A | 2 | 5 | 5
 | C | 3 | 6 | 6
 | E | 4 | 8 | 7
 | F | 5 | 9 | 8
 | A | 8 | 10 | 9
 | F | 6 | 8 | 9
 | B | 7 | 8 | 10
 | A | 8 | 7 | 7
 | D | 9 | 7 | 2
 | B | 8 | 6 | 2
 | D | 10 | 8 | 3
 | E | 6 | 10 | 4
 | E | 6 | 9 | 6
 | etc..