tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 105251d1302680058-rebuild-a-table-from-1-column-of-copied-data-exampleupload
Sheet: DocsAsWouldLookInOriginal

PAGE 1
[NAME]
page1headerline2
page1headerline3
page1headerline4
page1headerline5
p1data11 | p1data21 | p1data31
p1data12 | p1data22 | p1data32
p1data13 | p1data23 | p1data33
p1data14 | p1data24 | p1data34
p1data15 | p1data25 | p1data35
p1data16 | p1data26 | p1data36
p1data17 | p1data27 | p1data37
p1data18 | p1data28 | p1data38
PAGE2
[NAME]
page2headerline2
page2headerline3
[NAME]
page2headerline5
p2data11 | p2data21 | p2data31
p2data12 | p2data22 | p2data32
p2data13 | p2data23 | p2data33
p2data14 | p2data24 | p2data34
p2data15 | p2data25 | p2data35
p2data16 | p2data26 | p2data36
p2data17 | p2data27 | p2data37
p2data18 | p2data28 | p2data38
PAGE 3
[NAME]
page3headerline2
page3headerline3
page3headerline4
page3headerline5
p3data11 | p3data21 | p3data31
p3data12 | p3data22 | p3data32
p3data13 | p3data23 | [NAME]
p3data14 | p3data24 | p3data34
p3data15 | p3data25 | p3data35
p3data16 | p3data26 | p3data36
p3data17 | p3data27 | p3data37
p3data18 | p3data28 | [NAME]
Spreadsheet: 112577d1308674906-how-to-count-for-each-category-count-20formula-1-
Sheet: Sheet1

 |  |  |  |  | Results
Keyword | Category | Number |  |  |  | Numb 1-5 | Numb 6-10 |  |  | Count of Number | Number
KW1 | People | 1 |  |  | People |  |  |  |  | Category | 1-5 | 6-10 | Grand Total
KW2 | People | 7 |  |  | Places |  |  |  |  | People | 1 | 2 | 3
KW3 | places | 4 |  |  | Things |  |  |  |  | places | 2 | 1 | 3
KW4 | things | 4 |  |  |  |  |  |  |  | things | 2 |  | 2
KW5 | places | 9 |  |  |  |  |  |  |  | Grand Total | 5 | 3 | 8
KW6 | People | 8
KW7 | places | 2
KW8 | things | 1
Spreadsheet: 674944d1588085699-count-unique-values-from-one-column-based-on-value-in-other-column-example
Sheet: Tab 2

ID | Colour |  |  |  | ID | Distinct Count of Colour
28 | Red |  |  |  | 15 | 2
28 | Red |  |  |  | 28 | 5
28 | Red |  |  |  | Grand Total | 5
28 | Blue
28 | Yellow
28 | Grey
28 | Grey
28 | Green
28 | Green
28 | Green
28 | Green
15 | Blue
15 | Yellow
15 | Yellow
15 | Yellow
Spreadsheet: 3730d036-c386-4a11-a030-4584a665b706
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
French
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 100661d1298966404-conditional-formatting-with-multiple-rows-copy-of-dummy_breathtest-1
Sheet: Sheet1

Breath Test Register
DATE | NAME | GUARD | READING | COMMENT
2010-08-06 00:00:00 | A Person | Guard 12 | PASS
2010-08-06 00:00:00 | Someone Else | Guard 14 | FAIL
2010-08-06 00:00:00 | [NAME] | Guard 2 | PASS
2010-08-06 00:00:00 | Mr Man | Guard 7 | PASS
2010-08-06 00:00:00 | Someone Else | Guard 9 | FAIL
2010-08-06 00:00:00 | [NAME] | Guard 18 | PASS
2010-08-06 00:00:00 | T Ruckdriver | Guard 10 | PASS
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 14875827 | 38681757.20599999
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 953548 | 2424892.914
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 120000
 | Total Sales: |  | 15829375 | 41226650.11999999
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -10699052 | -27529445
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -12800 | -32759
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 11 | 27.77
 | Total Purchases: |  | -10711841 | -27562176.23
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 14391092 | 37280042.11
12 |  | Purchases | -10560362 | -27360712.23
 | Total Intra CTS Sales / Purchases |  | 3830730 | 9919329.879999999
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | -409770 | -1032055.33
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -409770 | -1032055.33
 | Total Storage: |  | -409770 | -1032055.33
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -8538494 | -21479830.46981242
 |  |  | 0 | 0
23 | Fuel: |  | -11 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -502030
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -502030
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | -7489614.62
31 |  | Prior Month Book Balance | 0 | 2639306
 |  | Total MTM Income | 0 | -4850308.62
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 5499578.5
34 |  | Originations | 0 | 15012
35 |  | Broker Fees | 0 | -4049
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 222403
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 795034d1662473369-how-to-count-a-cell-based-on-a-year-written-on-another-cell-2022-09-06-oeldere-lucas-bsample-4-
Sheet: Tabel1

Approval | Name | Value | year
2021-12-28 00:00:00 | Carmen | N/A
2021-12-28 00:00:00 | [NAME] | SIM
2021-12-28 00:00:00 | [NAME] | N/A |  |  |  | Aantal van Value | Kolomlabels
2021-12-28 00:00:00 | [NAME] | N/A |  |  |  | Rijlabels | 2021 | 2022 | Eindtotaal
 | Carmen | SIM |  |  |  | Carmen | 9 | 2 | 11
 | [NAME] | SIM |  |  |  | N/A | 8 | 1 | 9
 | [NAME] | N/A |  |  |  | SIM | 1 | 1 | 2
 | [NAME] | N/A |  |  |  | [NAME] | 9 | 2 | 11
2021-08-30 00:00:00 | Carmen | N/A |  |  |  | N/A | 6 | 1 | 7
2021-08-30 00:00:00 | [NAME] | N/A |  |  |  | SIM | 3 | 1 | 4
2021-08-30 00:00:00 | [NAME] | N/A |  |  |  | [NAME] | 9 | 2 | 11
2021-08-30 00:00:00 | [NAME] | SIM |  |  |  | N/A | 8 | 1 | 9
2021-08-30 00:00:00 | Carmen | N/A |  |  |  | SIM | 1 | 1 | 2
2021-08-30 00:00:00 | [NAME] | N/A |  |  |  | [NAME] | 9 | 2 | 11
2021-08-30 00:00:00 | [NAME] | N/A |  |  |  | N/A | 5 | 2 | 7
2021-08-30 00:00:00 | [NAME] | SIM |  |  |  | SIM | 4 |  | 4
2021-08-30 00:00:00 | Carmen | N/A |  |  |  | Eindtotaal | 36 | 8 | 44
2021-08-30 00:00:00 | [NAME] | N/A
2021-08-30 00:00:00 | [NAME] | N/A
2021-08-30 00:00:00 | [NAME] | SIM
2022-06-01 00:00:00 | Carmen | N/A
2022-06-01 00:00:00 | [NAME] | SIM
2022-06-01 00:00:00 | [NAME] | N/A
2022-06-01 00:00:00 | [NAME] | N/A
2021-09-09 00:00:00 | Carmen | N/A
2021-09-09 00:00:00 | [NAME] | N/A
2021-09-09 00:00:00 | [NAME] | N/A
2021-09-09 00:00:00 | [NAME] | N/A
2021-09-09 00:00:00 | Carmen | N/A
2021-09-09 00:00:00 | [NAME] | N/A
2021-09-09 00:00:00 | [NAME] | N/A
2021-09-09 00:00:00 | [NAME] | N/A
2021-09-13 00:00:00 | Carmen | N/A
2021-09-13 00:00:00 | [NAME] | N/A
2021-09-13 00:00:00 | [NAME] | SIM
2021-09-13 00:00:00 | [NAME] | N/A
2022-06-01 00:00:00 | Carmen | SIM
2022-06-01 00:00:00 | [NAME] | N/A
2022-06-01 00:00:00 | [NAME] | SIM
2022-06-01 00:00:00 | [NAME] | N/A
2021-12-29 00:00:00 | Carmen | N/A
2021-12-29 00:00:00 | [NAME] | N/A
2021-12-29 00:00:00 | [NAME] | SIM
2021-12-29 00:00:00 | [NAME] | SIM
2021-09-09 00:00:00 | Carmen | SIM
2021-09-09 00:00:00 | [NAME] | N/A
2021-09-09 00:00:00 | [NAME] | SIM
2021-09-09 00:00:00 | [NAME] | N/A
Spreadsheet: 835701d1688735858-text-split-then-create-spilling-table-textsplit
Sheet: Feuil1

values |  |  | values |  |  |  |  | value2 | value3 | value4
value1:554,value2:36,value3:987 |  |  |  |  |  |  | 554 | 36 | 987
value1:54,value2:396,value4:52 |  |  | value1:54,value2:396,value4:52 |  |  |  | 54 | 396 |  | 52
value3:594,value2:6 |  |  | value3:594,value2:6 |  |  |  |  | 6 | 594
Spreadsheet: b035385b-4418-4c56-9662-341c56c7d11a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6939 | 21851 | Rebecca | Kingsford | NZL | 91 | 00:20:09 | 00:00:00 | 01:09:46 | 00:00:00 | 00:38:12 | 1 | 02:08:06
6939 | 21841 | Simone | Ackermann | NZL | 92 | 00:20:06 | 00:00:00 | 01:12:19 | 00:00:00 | 00:39:15 | 2 | 02:11:41
6939 | 39136 | Penny | [NAME] | NZL | 94 | 00:19:23 | 00:00:00 | 01:10:33 | 00:00:00 | 00:42:47 | 3 | 02:12:42
6939 | 15708 | Rebecca | Grant | NZL | 93 | 00:21:15 | 00:00:00 | 01:15:19 | 00:00:00 | [NAME] | 4 | 02:18:47
6939 | 21847 | Sophie | Corbidge | NZL | 95 | 00:21:17 | 00:00:00 | 01:21:15 | 00:00:00 | 00:43:21 | 5 | 02:25:53
Spreadsheet: 774323d1648392498-how-can-i-make-sumifs-calculate-correctly-exclel-forum-help327
Sheet: Sheet1

Date |  | Qty
2022/3/1 | 2022-03-01 00:00:00 | 1
2022/3/2 | 2022-03-02 00:00:00 | 2
2022/3/3 | 2022-03-03 00:00:00 | 3
2022/3/4 | 2022-03-04 00:00:00 | 4
2022/3/5 | 2022-03-05 00:00:00 | 5
2022/3/6 | 2022-03-06 00:00:00 | 6
2022/3/7 | 2022-03-07 00:00:00 | 7
2022/3/8 | 2022-03-08 00:00:00 | 8
2022/3/9 | 2022-03-09 00:00:00 | 9
2022/3/10 | 2022-03-10 00:00:00 | 10
2022/3/11 | 2022-03-11 00:00:00 | 11
2022/3/12 | 2022-03-12 00:00:00 | 12
2022/3/13 | 2022-03-13 00:00:00 | 13
2022/3/14 | 2022-03-14 00:00:00 | 14
2022/3/15 | 2022-03-15 00:00:00 | 15
2022/3/16 | 2022-03-16 00:00:00 | 16
2022/3/17 | 2022-03-17 00:00:00 | 17
2022/3/18 | 2022-03-18 00:00:00 | 18
2022/3/19 | 2022-03-19 00:00:00 | 19
2022/3/20 | 2022-03-20 00:00:00 | 20
2022/3/21 | 2022-03-21 00:00:00 | 21
2022/3/22 | 2022-03-22 00:00:00 | 22
2022/3/23 | 2022-03-23 00:00:00 | 23
2022/3/24 | 2022-03-24 00:00:00 | 24
2022/3/25 | 2022-03-25 00:00:00 | 25
2022/3/26 | 2022-03-26 00:00:00 | 26
2022/3/27 | 2022-03-27 00:00:00 | 27
2022/3/28 | 2022-03-28 00:00:00 | 28
2022/3/29 | 2022-03-29 00:00:00 | 29
2022/3/30 | 2022-03-30 00:00:00 | 30
2022/3/31 | 2022-03-31 00:00:00 | 31
Spreadsheet: 857360d1706376815-search-value-in-table-with-2-values-known-index-match-match-aligw-nick-vdr-
Sheet: Sheet1

 | 1 | 2 | 3 |  | x | 1
10 | 5 | 10 | 15 |  | y | 15
20 | 30 | 40 | 50 |  | z
30 | 60 | 70 | 80
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.29.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-29 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 4 | 1 | 1 | 0 | 0 | 1 | 0
 | 5TH FL | 34 | 20 | 22 | 0 | 4 | 1 | 1 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 18 | 0 | 4 | 1 | 1 | 0 | 0 | 2.5 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 0.5 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 4 | 0 | 0 | 1 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-29 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 4 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 19 | 0 | 4 | 1 | 2 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 17 | 0 | 5 | 0 | 0 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 877091d1723766105-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-jdnethaji-
Sheet: Sheet1

ASSEMBLY MARK NUMBER | SL.NO | BUILDING REF. | PRIORITY | LEVEL | ASSEMBLY NAME | QTY | GROSS WEIGHT | DELIVERY | ERECTION | REMARKS | Delivery Weight | Erection Weight |  |  |  |  |  | Count of Delivery  Weight | Count of Install Weight
QLGF-C2001 | 1 | A | PRIORITY-1A | GF | COLUMN | 1 | 200.1 |  |  |  |  |  |  |  | Row Labels | Sum of QTY | Sum of GROSS WEIGHT | Count of Delivery Weight | Count of Erection Weight | Sum of Install Weight
QLGF-C2002 | 2 | A | PRIORITY-1A | GF | COLUMN | 2 | 512.6 |  |  | Part assembly 1/2 |  |  |  |  | A
QLGF-C2002 | 3 | A | PRIORITY-1B | GF | COLUMN |  |  |  |  | Part assembly 2/2 |  |  |  |  | PRIORITY-1A
QLGF-C2003 | 4 | A | PRIORITY-1B | GF | COLUMN | 1 | 205.6 |  |  |  |  |  |  |  | GF
QLGF-BM2003 | 5 | A | PRIORITY-1B | GF | FLOOR_BEAM | 1 | 181 |  |  |  |  |  |  |  | COLUMN | 3 | 712.7 | 2 | 2
QLGF-BM2004 | 6 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  |  |  | Part assembly 1/3 |  |  |  |  | PRIORITY-1B
QLGF-BM2004 | 7 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  |  |  | Part assembly 2/3 |  |  |  |  | GF
QLGF-BM2004 | 8 | A | PRIORITY-2A | GF | FLOOR_BEAM | 1 | 205.7 |  |  | Part assembly 3/3 |  |  |  |  | COLUMN | 3 | 205.6 | 2 | 2
QLGF-HB2005 | 9 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 203.6 |  |  |  |  |  |  |  | FLOOR_BEAM | 1 | 181 | 1 | 1
QLGF-HB2009 | 10 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 200.1 |  |  |  |  |  |  |  | PRIORITY-2A
QL-1-VB2001 | 11 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 906.1 |  |  |  |  |  |  |  | GF
QL-1-VB2002 | 12 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 1137.6 |  |  |  |  |  |  |  | FLOOR_BEAM | 3 | 205.7 | 3 | 3
QL-1-BM2002 | 13 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 |  |  |  | Part assembly 2/2 |  |  |  |  | HORIZONTAL BRACING | 2 | 403.7 | 2 | 2
QL-1-BM2002 | 14 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 673.6 |  |  | Part assembly 1/2 |  |  |  |  | PRIORITY-2B
QL-1-BM2003 | 15 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 525 |  |  |  |  |  |  |  | LEVEL-1
QL-1-BM2004 | 16 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 483.6 |  |  |  |  |  |  |  | VERTICAL BRACING | 2 | 2043.7 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIORITY-2C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVEL-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOOR_BEAM | 4 | 1682.2 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 18 | 5434.6 | 16 | 16
Spreadsheet: 115816d1311308577-small-cross-worksheet-calculation-error-transaction-record-updated-
Sheet: Loans to Jay

Month | Date | Amount ($) | Description |  | Total: | 430.63 |  | Monthly Carryover
2 | 2011-02-07 00:00:00 | 300 | repay of loan for loss of bank card |  |  |  |  | Month | Amount
3 | 2011-03-20 00:00:00 | 30 | curling for kids |  |  |  |  | 2011-01-01 00:00:00
4 | 2011-04-19 00:00:00 | 15 | Money that came home from the found library book |  |  |  |  | 2011-02-01 00:00:00
5 | 2011-05-17 00:00:00 | 20 | Sara paid for piano lessons |  |  |  |  | 2011-03-01 00:00:00
3 | 2011-03-31 00:00:00 | 65.63 | EDP payment adjusted for the 5 days / month |  |  |  |  | 2011-04-01 00:00:00
 |  |  |  |  |  |  |  | 2011-05-01 00:00:00
 |  |  |  |  |  |  |  | 2011-06-01 00:00:00
 |  |  |  |  |  |  |  | 2011-07-01 00:00:00
 |  |  |  |  |  |  |  | 2011-08-01 00:00:00
 |  |  |  |  |  |  |  | 2011-09-01 00:00:00
 |  |  |  |  |  |  |  | 2011-10-01 00:00:00
 |  |  |  |  |  |  |  | 2011-11-01 00:00:00
 |  |  |  |  |  |  |  | 2011-12-01 00:00:00
Spreadsheet: 647943d1572784120-clean-up-of-a-raw-data-set-moving-data-to-column-based-on-type-and-text-example
Sheet: Sheet1

RAW DATA |  | Helper
--
[NAME] |  | 3
Are you back yet?
2018-05-20 17:44:00
[NAME]
[NAME]. [NAME], off to have a turtle sandwich
2018-05-15 10:38:00
[NAME]
What was the joke? 😐
2018-05-15 10:37:00
[NAME]
jk lol
2018-05-15 10:34:00
[NAME]
Yes, they taste great!
2018-05-15 10:33:00
[NAME]
I like turtles.
Spreadsheet: andy_zipper__166__DYNEGY-ICE VOL Apr10
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
US Natural Gas | [NAME] | 2 | 10000 |  | Power | [NAME] | 6 | 168800 |  | Natural Gas Liquids | Wade Hicks | 1 | 10000
 | [NAME] | 4 | 18000 |  |  | [NAME] | 3 | 5600 |  | Natural Gas Liquids Total |  | 1 | 10000
 | [NAME] | 2 | 10000 |  |  | [NAME] | 1 | 450 |  | Grand Total |  | 1 | 10000
 | [NAME] | 3 | 3835000 |  | Power Total |  | 10 | 174850
US Natural Gas Total |  | 11 | 3873000 |  | Grand Total |  | 10 | 174850
Grand Total |  | 11 | 3873000
Spreadsheet: 2969ce76-c264-479e-ad93-bcd9dd60e6be
Sheet: Sheet1

Travel and Entertainment Expense | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Whitman College
 |  |  |  |  |  |  |  |  | Business Office
 |  |  |  |  | Date Submitted
Name |  |  |  |  |  |  | TR#
WID# |  |  |  |  | Payment Delivery Instructions:
Destination
Travel Dates
Need funds by
Purpose
TRAVEL ADVANCE |  |  |  |  |  |  |  |  | TOTAL
Date |  |  |  |  |  | Amount Advanced (debit project GL#:
Budget Officer Approval |  |  |  |  |  | [NAME] (credit Project #:
 |  |  |  |  |  | Net Advance (Project GL#: |  |  | 0
TRAVEL ADVANCE |  |  |  |  |  | Receipts verified by:
Dates of travel
Airfare |  |  |  |  |  |  |  |  | 0
Personal Mileage |  |  |  |  |  |  |  |  | 0
Car rental |  |  |  |  |  |  |  |  | 0
Lodging |  |  |  |  |  |  |  |  | 0
Breakfast |  |  |  |  |  |  |  |  | 0
Lunch |  |  |  |  |  |  |  |  | 0
Dinner |  |  |  |  |  |  |  |  | 0
Phone, postage, internet |  |  |  |  |  |  |  |  | 0
Parking, tolls, gas, taxi's |  |  |  |  |  |  |  |  | 0
Registration |  |  |  |  |  |  |  |  | 0
Entertainment*** |  |  |  |  |  |  |  |  | 0
 | Totals: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Reimbursement Designation |  |  |  |  |  |  |  | Less: net advance from above: | 0
Department Name |  | General [NAME] |  | Amount |  | Less: prepaid items, please reference
 |  |  | Total: | 0 |  |  |  | Total to be reimbursed to traveler: | 0
***ENTERTAINMENT - Please detail names and/or number of individuals involved and type of function. |  |  |  |  | EMPLOYEE CERTIFIATIONS By my signature below I certify to the best of my knowledge,  1. the expenses detailed above have not been nor will be reimbursed by any other entity other than Whitman College 2. the expenses detailed above were necessary to the business purposes of Whitman College and were appropriate and reasonable in nature.
 |  |  |  |  | Sign:
Department or Division Approval: |  |  |  | Budget Officer Approval: |  |  |  |  | Sign for Cash Received
Spreadsheet: 275686d1383605460-count-if-this-week-pt-count-names
Sheet: Sheet1

DOCS REMAINING DAILY TARGET |  | DOCS REMAINING WEEKLY TARGET
NAME | FILE NAME | PRACTICE GROUP | # [NAME] | DOCUMENT TYPE | COMPLETION DATE |  | Sanitiser | Docs this week |  | Row Labels | Count of COMPLETION DATE
name 1 | FILE NAME 1 | APEC | 63 | Client Presentation | 2013-11-04 00:00:00 |  | name 11 |  |  | name 1 | 10
name 1 | FILE NAME 2 | APEC | 49 | Client Presentation | 2013-11-04 00:00:00 |  | name 5 |  |  | name 2 | 2
name 1 | FILE NAME 3 | APEC | 101 | Client Presentation | 2013-11-04 00:00:00 |  | name 4 |  |  | name 3 | 7
name 2 | FILE NAME 4 | APEC | 46 | Proposal | 2013-11-04 00:00:00 |  | name 1 |  |  | name 4 | 3
name 2 | FILE NAME 5 | APEC | 67 | Proposal | 2013-11-04 00:00:00 |  | name 6 |  |  | name 5 | 1
name 3 | FILE NAME 6 | APEC | 86 | Proposal | 2013-11-04 00:00:00 |  | name 3 |  |  | name 6 | 4
name 3 | FILE NAME 7 | APEC | 39 | Proposal | 2013-11-04 00:00:00 |  | name 7 |  |  | name 7 | 1
name 3 | FILE NAME 8 | APEC | 71 | Proposal | 2013-11-04 00:00:00 |  | name 2 |  |  | Grand Total | 28
name 4 | FILE NAME 9 | APEC | 73 | Proposal | 2013-11-04 00:00:00 |  | name 8
name 5 | FILE NAME 10 | APEC | 73 | Proposal | 2013-11-04 00:00:00 |  | name 9
name 1 | FILE NAME 11 | APEC | 43 | Domain Training Material | 2013-11-04 00:00:00 |  | name 10
name 1 | FILE NAME 12 | APEC | 49 | Domain Training Material | 2013-11-04 00:00:00 |  | Total Docs this week
name 1 | FILE NAME 13 | APEC | 50 | Domain Training Material | 2013-11-04 00:00:00 |  | Total Docs today
name 3 | FILE NAME 14 | APEC | 74 | Domain Training Material | 2013-11-04 00:00:00
name 3 | FILE NAME 15 | APEC | 74 | Domain Training Material | 2013-11-04 00:00:00
name 1 | FILE NAME 16 | APEC | 41 | Client Presentation | 2013-11-04 00:00:00
name 3 | FILE NAME 17 | APEC | 36 | Market Study | 2013-11-04 00:00:00
name 3 | FILE NAME 18 | APEC | 61 | Market Study | 2013-11-04 00:00:00
name 6 | FILE NAME 19 | APEC | 79 | Market Study | 2013-11-04 00:00:00
name 1 | FILE NAME 20 | APEC | 58 | Market Study | 2013-11-04 00:00:00
name 6 | FILE NAME 21 | APEC | 31 | Market Study | 2013-11-04 00:00:00
name 4 | FILE NAME 22 | APEC | 43 | Market Study | 2013-11-04 00:00:00
name 6 | FILE NAME 23 | APEC | 82 | Market Study | 2013-11-04 00:00:00
name 4 | FILE NAME 24 | APEC | 41 | Methodology | 2013-11-04 00:00:00
name 7 | FILE NAME 25 | APEC | 106 | Methodology | 2013-11-04 00:00:00
name 6 | FILE NAME 26 | APEC | 62 | Methodology | 2013-11-04 00:00:00
name 1 | FILE NAME 27 | APEC | 57 | Methodology | 2013-11-04 00:00:00
name 1 | FILE NAME 28 | APEC | 55 | Methodology | 2013-11-04 00:00:00
Spreadsheet: sally_beck__35039__0417
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-06-01 00:00:00 | 2ND QUARTER 2000 EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
[NAME] | Gas Trading
[NAME] | Power Trading
IR_FX | Financial Drift
ECT_INV_IRFX | Financial Trading
CANADA | Canada
COAL | Coal
WEATHER | GRM -  Weather
SO2 | Emissions
INSURANCE | GRM - New Products |  | 1364
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
DWNSTRM_IND_ORIG | Industrial Downstream
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico
 | Total Origination
N_BS_DEV | Generation Investments
ASST_ORIG | Gas Assets |  | 4961
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing |  | 838
PROD_FIN | Energy Investments
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman |  | 2930
 | Total Commercial
GROUP | Group
TREASURY_INT | Other Interest Related Charges
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Genco |  | 8206 | 8789
 | Gas Assets |  | 40447 | 38743
Spreadsheet: 215213d1361307459-array-function-for-date-month-range-date-month-book8
Sheet: Sheet1

 | Start date | 2011-01-01 00:00:00
 | End Date | 2013-04-30 00:00:00