tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 213155d1360356988-darts-scoreboard-cricket-game-copy-of-cricketsol1
Sheet: Sheet1

 |  | Player 1
 |  | rd 1 | rd 2 | rd 3 | rd 4 | rd 5 | rd 6 | rd 7 | rd 8 | rd 9 | rd 10 | rd 11 | rd 12 | rd 13 | rd 14 | rd 15 | rd 16 | rd 17 | rd 18 | rd 19 | rd 20 | rd 21 | rd 22 | rd 23 | rd 24 | rd 25 | rd 26 | rd 27 | rd 28 | rd 29 | rd 30 | rd 31 | rd 32 | rd 33 | rd 34 | rd 35 | rd 36 | rd 37 | rd 38 | rd 39 | rd 40
 | Dart 1 | t20 | t19
 | Dart 2 | t20 | t18
 | Dart 3 | 20 | t18
 |  |  |  |  | 0
 | Times
 |  |  |  |  | 0
 | Value
 | points
 |  |  |  |  | 0
 |  | 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 |  | 32 |  | 33 |  | 34 |  | 35 |  | 36 |  | 37 |  | 38 |  | 39 |  | 40
25
20
19
18
17
16
15
 |  | Player 2
 |  | rd 1 | rd 2 | rd 3 | rd 4 | rd 5 | rd 6 | rd 7 | rd 8 | rd 9 | rd 10 | rd 11 | rd 12 | rd 13 | rd 14 | rd 15 | rd 16 | rd 17 | rd 18 | rd 19 | rd 20 | rd 21 | rd 22 | rd 23 | rd 24 | rd 25 | rd 26 | rd 27 | rd 28 | rd 29 | rd 30 | rd 31 | rd 32 | rd 33 | rd 34 | rd 35 | rd 36 | rd 37 | rd 38 | rd 39 | rd 40
 | Dart 1 | t19 | t17
 | Dart 2 | t19 | t17
 | Dart 3 | 19 | 17
 | Times
 |  |  |  |  | 0
 | Value
 | points
 |  | 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 |  | 32 |  | 33 |  | 34 |  | 35 |  | 36 |  | 37 |  | 38 |  | 39 |  | 40
25
20
19
18
17
16
15
501 |  |  | 301 |  |  | Cricket |  |  |  |  |  |  |  | High Dart |  |  | High Throw
Player 1 | Player2 |  | Player 1 | Player 2 |  | board | Player 1 | count | points | Player 2 | count | points |  | Player 1 | Player 2 |  | Player 1 | Player 2
 |  |  |  |  |  | 25 | 25 |  |  | 25
 |  |  |  |  |  | 20 | 20 |  |  | 20
 |  |  |  |  |  | 19 | 19 |  |  | 19
 |  |  |  |  |  | 18 | 18 |  |  | 18
 |  |  |  |  |  | 17 | 17 |  |  | 17
 |  |  |  |  |  | 16 | 16 |  |  | 16
 |  |  |  |  |  | 15 | 15 |  |  | 15
 |  |  |  |  |  | Closed
 |  |  |  |  |  | Scoring
 |  |  |  |  |  | Open
Spreadsheet: 108823d1305793207-to-find-the-latest-date-example002
Sheet: List

Magazine ID | DateTime | Registered by: | Clean | Cleaning Date | Balance day(s) before next cleaning | Cleaned by: |  |  |  |  | the latest date/time
AAA | 2011-05-19 08:49:38 | 15894 | a | 2011-05-11 08:50:12 | -1 | 12345 | -1 | 8 |  |  | 2011-05-18 08:51:09 | 1 | 1
BBB | 2011-05-19 08:49:39 | 15894 |  |  |  |  |  |  |  |  |  | #N/A
CCC | 2011-05-19 08:49:40 | 15894 |  |  |  |  |  |  |  |  |  | #N/A
GGG | 2011-05-19 08:49:57 | 15888 |  |  |  |  |  |  |  |  |  | #N/A
AAA | 2011-05-19 08:50:22 | 14777 | a | 2011-05-18 08:51:09 | 6 | 15985 | 6 | 1 |  |  | 2011-05-18 08:51:09 | 1 | 1
AAA | 2011-05-19 08:50:42 | 12548 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 850377d1700735230-expected-result-base-on-few-conditions-sample-218-aligw
Sheet: Sheet1

 |  |  | Item Code | Item 1 | Item 2 | Posted Code |  |  | Match Item Code | Expected Result
 |  |  | PT-001-223 | 0 | 0 | 45 |  |  | PT-001-223
 |  |  | PT-001-224 | 0 | 50 | 60 |  |  | PT-001-226
 |  |  | PT-001-225 | 50 | 100 | 75 |  |  | PT-001-228
 |  |  | PT-001-226 | 0 | 150 | 90
 |  |  | PT-001-227 | 0 | 200 | 105
 |  |  | PT-001-228 | 45 | 250 | 120
 |  |  | PT-001-229 | 0 | 300 | 135
 |  |  | PT-001-230 | 0 | 350 | 150
Spreadsheet: 77398d1277887580-choosing-rows-based-on-cell-comparisons-test
Sheet: Results

NAME | Status | Value1 | Value2 | Value3
[NAME] | True | 5 | 10 | -32
DATA2 | True | -10 | 25 | 96
DATA3 | True | 65 | 95 | 65
Spreadsheet: 123840d1317898127-excel-2007-sort-data-whilst-ignoring-blank-cells-rand_solution
Sheet: Sheet1

Title | Fiscal year | Period | JL reference | JL amount | 1e-17 | Period check | Random nr. sort | Sorted period check |  | Desired result |  |  | Select period | FY | Period |  |  |  |  |  |  |  |  |  | 1004
XY100102/940.47 EUR | FY10 | P01 |  |  |  |  |  |  |  | 1008S_2 |  |  | 1008 |  |  |  |  |  |  |  |  |  |  |  | 1005
[NAME] | FY10 | P05 |  |  |  |  |  |  |  | 1008S_3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1008
XY100504/118557.03 EUR | FY10 | P05 |  |  |  |  |  |  |  | XY100801
[NAME] | FY10 | P04 |  |  |  |  |  |  |  | XY100808
XY100406/976.73 EUR | FY10 | P05 |  |  |  |  |  |  |  | XY100809
XY100407/719.28 EUR | FY10 | P04 |  |  |  |  |  |  |  | blank cell
XY100808/24086.06 EUR | FY10 | P08 |  |  |  |  |  |  |  | blank cell
XY100809/47156.10 EUR | FY10 | P08 |  |  |  |  |  |  |  | blank cell
XY100801/295.55 EUR | FY10 | P08 |  |  |  |  |  |  |  | blank cell
1008S_2/9,932.87 EUR / Reversible (weekly) | FY10 | P08 |  |  |  |  |  |  |  | blank cell
1008S_3/23,173.33 EUR / Non-reversible | FY10 | P08 |  |  |  |  |  |  |  | blank cell
1004S_4/20,820.74 EUR / Reversible (weekly) | FY10 | P04 |  |  |  |  |  |  |  | blank cell
1004S_19/2,247.10 EUR / Non-reversible | FY10 | P04 |  |  |  |  |  |  |  | blank cell
1004S_6/31,480.32 EUR / Reversible (weekly) | FY10 | P04 |  |  |  |  |  |  |  | blank cell
Spreadsheet: 813820d1674005985-generating-a-unique-combo-list-ef1600_combinations
Sheet: Sheet1

 |  |  | Constraints | begin | either | end | Total no. of options
 |  |  | No. of options |  |  |  |  |  | <== See below
 |  |  | Values | Apples | Oranges | Pears
 |  |  |  | Grapes | Strawberries | Pineapples
 |  |  |  | Peaches | Melons
 |  |  |  |  | Kiwi
 |  |  |  |  | Cranberries
 |  |  | Table of choices
 |  |  |  | First | Second | Third | combination
 |  |  |  |  |  |  |  |  | <== Copy formulae in E26:H26 down sufficiently far, according to the number in cell H2
Spreadsheet: 149425d1333959172-i-want-help-about-calculate-summary-in-excel-86685242-sk
Sheet: Summary

 |  | Summary of 0
Count of Call Type | Call Type
B-Party | InComing | Incoming SMS | Outgoing | Grand Total
3057789362 | 2 |  | 26 | 28
3083779611 | 15 |  | 8 | 23
3065824583 | 8 |  | 10 | 18
3368271567 | 6 |  | 8 | 14
3014910226 |  |  | 13 | 13
3023784130 |  |  | 12 | 12
3059187671 | 4 |  | 7 | 11
3062075688 | 3 |  | 7 | 10
3418738292 | 3 |  | 7 | 10
964757E65637 |  | 10 |  | 10
3037342547 | 4 |  | 5 | 9
3058683181 |  | 7 | 2 | 9
3046684538 | 7 |  | 1 | 8
3006123975 | 7 |  |  | 7
3052343745 | 4 |  | 3 | 7
3007890005 | 1 |  | 5 | 6
3013162783 |  |  | 6 | 6
3017939979 | 6 |  |  | 6
3017943409 | 3 |  | 3 | 6
3076844771 | 5 |  | 1 | 6
3417126975 | 3 |  | 3 | 6
3336285322 | 5 |  |  | 5
3434334012 |  | 4 | 1 | 5
3007576103 | 2 | 2 |  | 4
3045202120 | 4 |  |  | 4
3057840131 | 4 |  |  | 4
3062420772 |  |  | 4 | 4
3015619204 | 3 |  |  | 3
3035988980 |  |  | 3 | 3
3048251204 |  |  | 3 | 3
3085540592 |  |  | 3 | 3
3337621491 | 3 |  |  | 3
3417018188 | 2 |  | 1 | 3
34162321 | 2 |  |  | 2
3014516391 | 1 |  | 1 | 2
3015842469 | 2 |  |  | 2
3047445547 | 2 |  |  | 2
3054619929 |  |  | 2 | 2
3072165292 |  |  | 2 | 2
3076415410 |  | 1 | 1 | 2
3078639075 | 2 |  |  | 2
3078648624 | 2 |  |  | 2
3414766622 |  |  | 2 | 2
3002781651 | 1 |  |  | 1
3003919651 |  |  | 1 | 1
3004483388 | 1 |  |  | 1
3006896085 | 1 |  |  | 1
3012035414 |  |  | 1 | 1
3014174753 |  |  | 1 | 1
3017933150 |  |  | 1 | 1
3024162871 | 1 |  |  | 1
3026506032 | 1 |  |  | 1
3037193899 |  |  | 1 | 1
3044734112 | 1 |  |  | 1
3047118522 |  |  | 1 | 1
3056684538 |  |  | 1 | 1
3056860478 |  |  | 1 | 1
3057021544 |  |  | 1 | 1
3058401655 | 1 |  |  | 1
3066850138 | 1 |  |  | 1
3067600506 |  |  | 1 | 1
3074992569 |  |  | 1 | 1
3075498531 |  |  | 1 | 1
3076365641 | 1 |  |  | 1
3084818102 |  |  | 1 | 1
3125616511 | 1 |  |  | 1
3316983372 |  | 1 |  | 1
3316993736 |  |  | 1 | 1
3349896276 |  |  | 1 | 1
3417309819 |  |  | 1 | 1
3426981053 |  |  | 1 | 1
3437046425 |  |  | 1 | 1
3465866691 | 1 |  |  | 1
3477183260 |  |  | 1 | 1
3477256366 | 1 |  |  | 1
3478325692 |  |  | 1 | 1
Grand Total | 127 | 25 | 170 | 322
Spreadsheet: 79549d1279792743-sumproduct-sumproduct_help_2
Sheet: Source

Grpa | c113 | a554 | c123 | Report Start | Report End
Grpb | c123 | a554 |  | 2010-01-01 00:00:00 | 2010-06-30 00:00:00
Grpc | b567 | other
 |  |  | Volume of Jobs Received in Month
 |  |  | id | Input Date | Job Type | Job Code
 |  |  | 300002 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300004 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300005 | 2010-01-11 00:00:00 | Medium | bbc
 |  |  | 300006 | 2010-01-18 00:00:00 | Medium | B567
 |  |  | 300007 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300013 | 2010-01-11 00:00:00 | Small | Other
 |  |  | 300014 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300015 | 2010-01-11 00:00:00 | Small | C113 |  | These should be the same answer
 |  |  | 300016 | 2010-01-11 00:00:00 | Small | A554
 |  |  | 300017 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300018 | 2010-01-16 00:00:00 | Small | F123
 |  |  | 300019 | 2010-01-11 00:00:00 | Small | Other
 |  |  | 300021 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300022 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300023 | 2010-01-11 00:00:00 | Small | A554
 |  |  | 300024 | 2010-01-11 00:00:00 | Small | B138
 |  |  | 300025 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300027 | 2010-01-11 00:00:00 | Medium | C113
 |  |  | 300028 | 2010-01-11 00:00:00 | Small | B138
Spreadsheet: 173117d1344439728-table-differences-table-1
Sheet: Table 1

 | BA | BB | BC | BD | BE |  | BF | BG | BH | %
AA | 234 | 235 | 466 | 235 | 234 |  | 466 | 235 | 234
AB | 345 | 36 | 457 | 345 | 535 |  | 457 | 344 | 534
AC | 235 | 534 | 45 | 29 | 235 |  | 44 | 26 | 235
AD | 2 | 454 | 7 | 235 | 25 |  | 7 | 236 | 26
AE | 637 | 56 | 462 | 235 | 23 |  | 462 | 235 | 23
AF | 34 | 869 | 45 | 346 | 632 |  | 346 | 345 | 632
AG | 23 | 96 | 365 | 236 | 626 |  | 365 | 236 | 626
 |  |  |  |  |  | Table 1
AH | 235 | 534 | 45 | 26 | 235 |  | 44 | 26 | 235
AI | 2 | 454 | 7 | 235 | 25 |  | 7 | 225 | 40
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Tri Sodium Phospate

Raw Material |  | Tri Sodium Phospate
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 94
2023-12-05 00:00:00 |  |  |  |  | 20
Total
Spreadsheet: david_delainey__8075__Master Turbine Listing
Sheet: Peoples Pmt Schedule

Payment Date | Payments from WestLB to GE
1999-12-31 00:00:00 | 0
2000-01-05 00:00:00 | 2529455.29
2000-02-22 00:00:00 | 0
2000-03-20 00:00:00 | 2529455.29
2000-04-20 00:00:00 | 2529455.29
2000-05-22 00:00:00 | 2529455.29
2000-06-20 00:00:00 | 2529455.29
2000-07-20 00:00:00 | 2529455.29
2000-08-21 00:00:00 | 6485782.8
2000-09-20 00:00:00 | 10766399.45
Total
Spreadsheet: daren_farmer__5081__Tenaska IV 2001
Sheet: March 2001

Enron North America Corp
Summary of Gas Activity for Tenaska IV Partners, Ltd.
December 2000
December Sales
 | Counterparty | Volume | Dollars
 | Tenaska IV Partners | 1405329 | 3211176.77
 | Total Sales per Unify |  |  | Actual
December Purchases
 | Apache Marketing | -620000 | -1416700
 | [NAME] | -775000 | -2125282.5
 | TXU [NAME] |  | -128677.78
 | Total Purchases per Unify |  |  | Actual
 |  |  | UA4
December Netout
 | Total Purchases
 | Amount paid by Plant | 1363319 | 3115183.92 | paid
 | Agency Fee (1,405,329x $0.04) |  | 55800
 | Agency Fee Adjustment |  | -56213.16
 | Payable to Tenaska IV Partners/(ENA):
 | Calculation for Purchase Demand Fee: |  | 3115183.92 | Tenaska IV payment
 |  |  |  | purchase
 |  |  |  | sale demand fee
 |  |  |  | deal 384258
Spreadsheet: 774474d1648494110-need-alternative-formula-to-fetch-price-value-based-on-effective-date-sample-file-fetch-price-based-on-effective-date-1-
Sheet: Price List

Model | Price | Price Effective Date
A | 9000 | 2022-03-01 00:00:00
B | 8000 | 2022-03-01 00:00:00
C | 10000 | 2022-03-01 00:00:00
D | 12000 | 2022-03-01 00:00:00
A | 8500 | 2022-03-20 00:00:00
B | 7500 | 2022-03-20 00:00:00
Spreadsheet: 795062d1662482470-how-to-convert-cell-contents-to-a-number-using-if-convert
Sheet: Sheet1

 | Column1 |  | Column1.1 | Column1.2 | Subtraction
 | 8:30 AM - 4:30 PM |  | 08:30:00 | 16:30:00 | 8
 | 2:00 AM - 4:00 PM |  | 02:00:00 | 16:00:00 | 14
 | 8:00 AM - 11:00 AM |  | 08:00:00 | 11:00:00 | 3
 | 11:00 AM - 4:00 PM |  | 11:00:00 | 16:00:00 | 5
 | 6:30 AM - 10:30 AM |  | 06:30:00 | 10:30:00 | 4
 | 8:45 AM - 2:45 PM |  | 08:45:00 | 14:45:00 | 6
 | 8:30 AM - 4:30 PM |  | 08:30:00 | 16:30:00 | 8
 | 8:00 AM - 3:00 PM |  | 08:00:00 | 15:00:00 | 7
Spreadsheet: 775192d1648898989-help-with-bring-the-value-of-whichever-cell-has-value-example
Sheet: Sheet1

B.USD | B.EUR | B.STR | B.
15
 | 4521
 |  | 252
 |  | 300
 |  | 210
 | 7000
23
50
12
 | 3200
 |  | 152
 |  | 721
 | 2300
 | 2500
 | 1500
50
30
45
Spreadsheet: 802894d1667132893-i-want-this-data-should-be-shown-incase-it-is-mentioned-in-pm-status-column-resource
Sheet: Resource Effort

Currently the Data is like this
PMs | Resources | 2022-11-01 00:00:00 | 2022-11-02 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00
Sahoo, [NAME] | Guru, [NAME]
[NAME] | Prabhakaran, Suresh Kumar
Expecting the data should be like this
PMs | Resources | 2022-11-01 00:00:00 | 2022-11-02 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00
Sahoo, [NAME] | Guru, [NAME] | 8 | Booked | 9 | Leave
[NAME] | Prabhakaran, Suresh Kumar | 10 | Booked | Leave | 3
Spreadsheet: 555107d1515439415-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: League Tables

 |  |  | Club Name: | [NAME]
 |  |  |  | Tournament League Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Totals
 |  | Player | Score Round 1 | Points Round 1 | Score Round 2 | Points Round 2 | Score Round 3 | Points Round 3 | Score Round 4 | Points Round 4 | Score Round 5 | Points Round 5 | Score Round 6 | Points Round 6 | Score Round 7 | Points Round 7 | Score Round 8 | Points Round 8 |  | Total Score | Total Points | Players | Rank
Spreadsheet: 839633d1692120885-index-match-formula-sample2
Sheet: Sheet1

 | Account |  | Check
 | 502
 | 601
 | 101
 | 501
 | 601
 | 501
 | 602
 | 603
 | 604
 | 502
 | 503
 | 504
Spreadsheet: kate_symes__19063__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-10 00:00:00 |  | 175.51 | 21664 | 89.05 | 7360
 | 2001-04-09 00:00:00 |  | 140.37 | 29824 | 99.04 | 10024 | 160.69 | 4429 | 82.6 | 1221
 | 2001-04-08 00:00:00 |  | 135 | 0 | 99 | 0 | 94.68 | 4331 | 89.95 | 950 |  | 98.94 | 30072
 | 2001-04-07 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 124.58 | 4097 | 104.49 | 973
 | 2001-04-06 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 144.64 | 4383 | 107.57 | 1185
 | 2001-04-05 00:00:00 |  | 210.51 | 39072 | 95.69 | 12336 | 113.42 | 2159 | 94.37 | 1318
 | 2001-04-04 00:00:00 |  | 235.75 | 35568 | 96.01 | 11864 | 134.48 | 2153 | 65.34 | 1391
 | 2001-04-03 00:00:00 |  | 232.48 | 34768 | 101.7 | 8424 | 124.35 | 2275 | 80.72 | 166
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456 | 151.72 | 5836 | 152.21 | 1055
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
Spreadsheet: 104800d1302259831-matching-data-from-one-sheet-to-another-based-on-cusips-kopie-von-merged_dataset
Sheet: Gindex,risk,size,lev, profitab.

CUSIP6 | Year | Company | Delaware_Inc | State_of_Inc | Gindex | Blank_Check | Classified_Board | Beta | TotalAssets | TotLTDebt
000361 | 1998 | A A R CORP | 1 | DE | 15 | 1 | 1 | 1.5 | 1.5
 | 1999
000361 | 2000 | A A R CORP | 1 | DE | 15 | 1 | 1 | 1.5 | 1.5
 | 2001
000361 | 2002 | AAR CORP | 1 | DE | 15 | 1 | 1 | 1.5 | 1.5
 | 2003
000361 | 2004 | AAR CORP | 1 | DE | 15 | 1 | 1 | 1.5 | 1.5
 | 2005
000361 | 2006 | AAR CORP | 1 | DE | 15 | 1 | 1 | 1.5 | 1.5
000957 | 1998 | A B M INDUSTRIES INC | 1 | DE | 11 | 1 | 1 | 1.09 | 1.09
000957 | 2000 | A B M INDUSTRIES INC | 1 | DE | 11 | 1 | 1 | 1.09 | 1.09
 | 2001
000957 | 2002 | ABM INDUSTRIES INC | 1 | DE | 11 | 1 | 1 | 1.09 | 1.09
 | 2003
000957 | 2004 | ABM INDUSTRIES INC | 1 | DE | 10 | 1 | 1 | 1.09 | 1.09
 | 2005
000957 | 2006 | ABM INDUSTRIES INCORPORATED | 1 | DE | 9 | 1 | 1 | 1.09 | 1.09
001055 | 1998 | A F L A C INC | 0 | GA | 6 | 0 | 0 | 1.66 | 1.66
 | 1999
001055 | 2000 | A F L A C INC | 0 | GA | 6 | 0 | 0 | 1.66 | 1.66
 | 2001
001055 | 2002 | AFLAC INC | 0 | GA | 6 | 0 | 0 | 1.66 | 1.66
 | 2003
001055 | 2004 | AFLAC INC | 0 | GA | 6 | 0 | 0 | 1.66 | 1.66
 | 2005
001055 | 2006 | AFLAC INCORPORATED | 0 | GA | 6 | 0 | 0 | 1.66 | 1.66
001084 | 1998 | A G C O CORP | 1 | DE | 7 | 1 | 1 | 1.38 | 1.38
001084 | 2000 | A G C O CORP | 1 | DE | 7 | 1 | 1 | 1.38 | 1.38
001084 | 2002 | AGCO CORP | 1 | DE | 7 | 1 | 1 | 1.38 | 1.38
001084 | 2004 | AGCO CORP | 1 | DE | 9 | 1 | 1 | 1.38 | 1.38
001084 | 2006 | AGCO CORP | 1 | DE | 9 | 1 | 1 | 1.38 | 1.38
001204 | 1998 | A G L RESOURCES INC | 0 | GA | 13 | 1 | 1 | 0.67 | 0.67
001204 | 2000 | A G L RESOURCES INC | 0 | GA | 13 | 1 | 1 | 0.67 | 0.67
001204 | 2002 | AGL RESOURCES INC | 0 | GA | 13 | 1 | 1 | 0.67 | 0.67
001204 | 2004 | AGL RESOURCES INC | 0 | GA | 13 | 1 | 1 | 0.67 | 0.67
001204 | 2006 | AGL RESOURCES INC | 0 | GA | 13 | 1 | 1 | 0.67 | 0.67
Spreadsheet: 27002d1219770459-display-number-of-occurances-from-unique-list-against-bulk-list-occurances
Sheet: Sheet1

 | Top OF List ---> |  | [NAME] |  | Name Of Complete List: rngUserInput
 | End OF List ---> |  | D$100 |  | You can change this range by going to [NAME]
 |  |  | Complete List |  | Unique List |  | No. Of Occurances
 |  |  | a |  | a |  | 3
 |  |  | b |  | b |  | 3
 |  |  | c |  | c |  | 2
 |  |  | d |  | d |  | 3
 |  |  | e |  | e |  | 3
 |  |  | f |  | f |  | 5
 |  |  | g |  | g |  | 5
 |  |  | h |  | h |  | 5
 |  |  | I |  | I |  | 5
 |  |  | a
 |  |  | b
 |  |  | c
 |  |  | d
 |  |  | e
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | I
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | I
 |  |  | a
 |  |  | b
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | I
 |  |  | d
 |  |  | e
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | I
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 14c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared
Index Tranche | 12 | 100 | - | 94
Index | 5101 | 2702 | 3383 | 3236
OTHER* | 61 | 141 | 43 | 115
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -42 | -3276
500046 | -9305 | -4879 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -28601 | -39795
500528
500529
500619
INDEX
2001-11-30 00:00:00 |  |  | -510924.54
2001-12-26 00:00:00
CBS Volume
 |  |  | -24926
Spreadsheet: 822836d1679560244-count-distinct-unique-values-based-on-multiple-criteria-sample-storage-counts
Sheet: Sheet2

Product ID | Category | QoH | Sublocation summary | [NAME] | [NAME] | Sublocation Restated | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |  | Column1 | Bins | [NAME] | Oversized | Regular
ABL-0021 | Abler | 60 | RECEIVING: 60 | Pallet Pick | 60 | RECEIVING: 60 |  |  |  |  |  |  |  | Abler
ABL-0022 | Abler | 173 | RECEIVING: 173 | Pallet Pick | 200 | RECEIVING: 173 |  |  |  |  |  |  |  | AllCure | 0 |  | 3 | 9
AC-112 | AllCure | 5361 | X-18-E-06-A-02: 1271, X-22-A-02-A-01: 157, X-24-B-01-A-01: 1140, X-25-B-10-A-01: 528, X-25-B-10-A-02: 1152, X-25-C-10-A-03: 1104, X-Quarantine: 9 | Pallet Pick |  | X-18-E-06-A-02: 1271 | X-22-A-02-A-01: 157 | X-24-B-01-A-01: 1140 | X-25-B-10-A-01: 528 | X-25-B-10-A-02: 1152 | X-25-C-10-A-03: 1104 | X-Quarantine: 9 |  | Alpine | 0
AC-112 | AllCure | 3532 | Q-10-B-01-A-02: 11, X-17-E-01-A-01: 1476, X-24-B-01-A-02: 936, X-25-D-10-A-01: 988, X-25-E-08-A-01: 24, Z-TRAILER: 97 | Pallet Pick |  | Q-10-B-01-A-02: 11 | X-17-E-01-A-01: 1476 | X-24-B-01-A-02: 936 | X-25-D-10-A-01: 988 | X-25-E-08-A-01: 24 |  |  |  | Bythe | 0 |  | 1
ALP-0778 | Alpine | 4 | B-09-A-12-B-05: 4 | B-09-A-12-B-05 | 4 | B-09-A-12-B-05: 4 |  |  |  |  |  |  |  | [NAME] | 0 | 10
ALP-0779 | Alpine | 4 | B-09-A-12-C-01: 4 | B-09-A-12-C-01 | 4 | B-09-A-12-C-01: 4 |  |  |  |  |  |  |  | Codger | 0 |  |  | 2
ALP-0806 | Alpine | 1 | B-07-A-08-A-01: 1 | B-07-A-08-A-01 | 128 | B-07-A-08-A-01: 1 |  |  |  |  |  |  |  | Dialate | 0 |  | 4
BY-002 | Bythe | 78 | X-17-E-08-A-01: 78 |  |  | X-17-E-08-A-01: 78
BY-003 | Bythe | 28 | X-17-E-08-A-01: 28 |  |  | X-17-E-08-A-01: 28
BY-004 | Bythe | 207 | X-17-E-08-A-01: 207 |  |  | X-17-E-08-A-01: 207
BY-005 | Bythe | 75 | X-17-E-08-A-01: 75 |  |  | X-17-E-08-A-01: 75 |  |  |  |  |  |  |  | BINS = RECEIVING or start w/ a B-
BY-006 | Bythe | 37 | X-17-E-08-A-01: 37 |  |  | X-17-E-08-A-01: 37 |  |  |  |  |  |  |  | [NAME] = End w/ .D
810-0001-00 | [NAME] | 2 | [NAME]: 2 | [NAME] | 3 | [NAME]: 2 |  |  |  |  |  |  |  | Oversized Pallet = Start w/ X-*-E
810-0002-04 | [NAME] | 4 | [NAME]: 1, B-01-A-06-D-03.D: 3 | [NAME] |  | [NAME]: 1 | B-01-A-06-D-03.D: 3 |  |  |  |  |  |  | Regular Pallet = Start w/ X-
810-0024-00 | [NAME] | 40 | B-01-A-01-A-01.D: 6, B-01-A-01-A-02.D: 6, B-01-A-01-A-03.D: 6, B-01-A-01-A-04.D: 6, [NAME]: 6, [NAME]-C-05.D: 6, [NAME]: 4 | B-01-A-01-A-02.D |  | B-01-A-01-A-01.D: 6 | B-01-A-01-A-02.D: 6 | B-01-A-01-A-03.D: 6 | B-01-A-01-A-04.D: 6 | [NAME]: 6 | [NAME]-C-05.D: 6 | [NAME]: 4
COD-0021 | Codger | 126 | X-04-D-11-A-01: 87, X-04-D-12-A-01: 39 | B-04-B-01-C-06 | 25 | X-04-D-11-A-01: 87 | X-04-D-12-A-01: 39
XZ-9000 | Dialate | 1522 | X-17-E-05-A-01: 432, X-17-E-05-A-02: 370, X-17-E-05-A-03: 360, X-17-E-06-A-01: 360 |  |  | X-17-E-05-A-01: 432 | X-17-E-05-A-02: 370 | X-17-E-05-A-03: 360 | X-17-E-06-A-01: 360
 |  |  |  |  |  |  | 2 | 0
 |  |  |  |  |  | AllCure | 0 | 0
 |  |  |  |  |  | Alpine | 3 | 0
 |  |  |  |  |  | Bythe | 0 | 0
 |  |  |  |  |  | [NAME] | 0 | 10
 |  |  |  |  |  | Codger | 0 | 0
 |  |  |  |  |  | Dialate | 0 | 0