tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 759395d1639509548-excel-formula-to-check-match-data-between-two-sheet-in-different-orientation-upload1
Sheet: Stata

YEAR | COMPANY | Net
1994 | TH:2S | NA
1995 | TH:2S | NA
1996 | TH:2S | NA
1997 | TH:2S | NA
1998 | TH:2S | NA
1999 | TH:2S | NA
2000 | TH:2S | NA
2001 | TH:2S | NA
2002 | TH:2S | NA
2003 | TH:2S | NA
2004 | TH:2S | NA
2005 | TH:2S | NA
2006 | TH:2S | 34020
2007 | TH:2S | 55390
2008 | TH:2S | 112840
2009 | TH:2S | 91864
2010 | TH:2S | 71431
2011 | TH:2S | 64980
2012 | TH:2S | 52643
2013 | TH:2S | 68031
2014 | TH:2S | 41898
1994 | TH:AJ | 21495
1995 | TH:AJ | 27384
1996 | TH:AJ | 52941
1997 | TH:AJ | -616760
1998 | TH:AJ | 121234
1999 | TH:AJ | -81609
2000 | TH:AJ | -51199
2001 | TH:AJ | 152305
2002 | TH:AJ | 352870
2003 | TH:AJ | 255651
2004 | TH:AJ | 240919
2005 | TH:AJ | 172836
2006 | TH:AJ | 102073
2007 | TH:AJ | 129639
2008 | TH:AJ | 160309
2009 | TH:AJ | 288052
2010 | TH:AJ | 984924
2011 | TH:AJ | 878600
2012 | TH:AJ | 190007
2013 | TH:AJ | -97977
2014 | TH:AJ | -247856 |  |  | Created Pivot table from your data;  then copied it to other tab
 |  |  |  |  | Sum of Net | Column Labels
 |  |  |  |  | Row Labels | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | Grand Total
 |  |  |  |  | TH:2S | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34020 | 55390 | 112840 | 91864 | 71431 | 64980 | 52643 | 68031 | 41898 | 593097
 |  |  |  |  | TH:AJ | 21495 | 27384 | 52941 | -616760 | 121234 | -81609 | -51199 | 152305 | 352870 | 255651 | 240919 | 172836 | 102073 | 129639 | 160309 | 288052 | 984924 | 878600 | 190007 | -97977 | -247856 | 3035838
 |  |  |  |  | Grand Total | 21495 | 27384 | 52941 | -616760 | 121234 | -81609 | -51199 | 152305 | 352870 | 255651 | 240919 | 172836 | 136093 | 185029 | 273149 | 379916 | 1056355 | 943580 | 242650 | -29946 | -205958 | 3628935
Spreadsheet: 106122d1303331083-formula-for-date-change-based-on-text-in-adjacent-cell-ai-check-list
Sheet: AI

Name | Title | Owner | Location | Status | Review Due Date | Status | Modified Y/N | Comments/Describe Modification (date change only, cancel, significant re-write, etc.) | YES
DUE DATE GREATER THAN 3 MONTHS |  | DUE DATE LESS THAN 3 MONTHS |  |  |  |  | OVERDUE |  | NO
1 | A | NAME |  |  | 2011-04-01 00:00:00
2 | B | NAME |  |  | 4/1/2011 |  |  |  | [NAME]
3 | C | NAME |  |  | 4/1/2011
4 | D | NAME |  |  | 4/1/2011
5 | E | NAME |  |  | 4/1/2011
6 | F | NAME |  |  | 4/1/2011
7 | G | NAME |  |  | 4/1/2011
8 | H | NAME |  |  | 4/1/2011
9 | I | NAME |  |  | 4/1/2011
1 | J | NAME |  |  | 2011-09-01 00:00:00
2 | F | NAME |  |  | 9/1/2011
1 | L | NAME |  |  | 9/1/2011
2 | M | NAME |  |  | 9/1/2011
3 | N | NAME |  |  | 9/1/2011
4 | O | NAME |  |  | 9/1/2011
1 | P | NAME |  |  | 1/1/2012
2 | Q | NAME |  |  | 1/1/2012
3 | R | NAME |  |  | 1/1/2012
 | S
1 | T | NAME |  |  | 9/1/2011
2 | U | NAME |  |  | 9/1/2011
3 | V | NAME |  |  | 9/1/2011
1 | W | NAME |  |  | 7/1/2011
2 | X | NAME |  |  | 7/1/2011
3 | Y | NAME |  |  | 7/1/2011
4 | Z | NAME |  |  | 7/1/2011
Spreadsheet: 839852d1692269519-to-sort-a-list-abc123
Sheet: Sheet1 (2)

[NAME] | العمر | الفئة | الفئة2
ID | Age | Category | Category |  | Category | Count |  | Category-1 | Category-2 | Category-3 | Category-4 | Category-5
1 | 16 |  |  |  | 1-5 | 6
2 | 15 |  |  |  | 11-15 | 3
3 | 15 |  |  |  | 16-20 | 5
4 | 3 |  |  |  | 21-25 | 7
5 | 4 |  |  |  | 26-30 | 5
6 | 5 |  |  |  | 31-35 | 7
7 | 1 |  |  |  | 36-40 | 5
8 | 2 |  |  |  | 41-45 | 5
9 | 4 |  |  |  | 46-50 | 4
10 | 16 |  |  |  | 51-55 | 4
11 | 20 |  |  |  | 56-60 | 5
12 | 18 |  |  |  | 6-10 | 7
13 | 20 |  |  |  | 61-65 | 2
14 | 23 |  |  |  | 66-70 | 4
15 | 23
16 | 23
17 | 24 |  |  |  |  |  |  |  | Dear All,
18 | 21
19 | 24 |  |  |  |  |  |  |  | May I kindly request to assist me in this formula
20 | 22 |  |  |  |  |  |  |  | my formula in column E (Cell E3) if possible to amened the formula to include sort
21 | 26 |  |  |  |  |  |  |  | from 1-5 to 66-70
22 | 29 |  |  |  |  |  |  |  | Taking inconsideration that I am using excel 365 but at work most employee use Excel 2010 or 2016
23 | 27
24 | 28
25 | 26 |  |  |  |  |  |  |  | Many thanks for any help
26 | 35
27 | 31
28 | 33
29 | 35
30 | 64
31 | 31
32 | 66
33 | 33
34 | 34
35 | 40
36 | 38
37 | 38
38 | 37
39 | 38
40 | 42
41 | 45
42 | 44
43 | 41
44 | 44
45 | 47
46 | 50
47 | 48
48 | 49
49 | 54
50 | 53
51 | 53
52 | 55
53 | 70
54 | 64
55 | 57
56 | 59
57 | 69
58 | 68
59 | 7
60 | 10
61 | 6
62 | 6
63 | 10
64 | 57
65 | 8
66 | 59
67 | 9
68 | 13
69 | 58
Spreadsheet: 886876d1736971613-gather-totals-based-on-column-brandonmcg-examples
Sheet: Sheet1

Account # | Total 1 | Total 2 | Total 3 |  | Need this |  |  |  |  | Row Labels | Sum of Total 1 | Sum of Total 2 | Sum of Total 3
123456 | 110 | 0 | 4411.66 |  | 123456 |  |  |  |  | 123456 | 185 | 195.11 | 4466.78
123456 | 75 | 95.11 | 0 |  | 345678 |  |  |  |  | 345678 | 95.33 | 88.66 | 0
123456 | 0 | 100 | 55.12 |  | 789456 |  |  |  |  | 789456 | 55.96 | 2.55 | 88.99
345678 | 95.33 | 88.66 | 0 |  |  |  |  |  |  | Grand Total | 336.29 | 286.32 | 4555.77
789456 | 55.96 | 2.55 | 88.99
Spreadsheet: 868712d1715360246-work-time-difference-between-two-dates-with-conditions-work-time-ans-1-
Sheet: Folha1

Process | Cliente | Ref | Start date | Origin | End Date | Destination | Vehicle | Pax | Driver | Contract | Price | Corrected Start Hour | Corrected End Hour | Time work | Column1
 |  |  | 09/05/2024 03:30:00 |  | 09/05/2024 04:30:00 |  |  | 2 | [NAME] |  |  | 03:30:00 | 04:30:00
 |  |  | 09/05/2024 05:00:00 |  | 09/05/2024 06:00:00 |  |  | 2 | Sonia Amaral |  |  |  |  |  |  |  |  | Should be
 |  |  | 09/05/2024 06:15:00 |  | 09/05/2024 07:30:00 |  |  | 4 | [NAME] |  |  | 06:15:00 | 13:00:00 |  |  |  |  | 09:30:00
 |  |  | 09/05/2024 [NAME] |  | 09/05/2024 07:30:00 |  |  | 2 | Sonia Amaral
 |  |  | 09/05/2024 08:50:00 |  | 09/05/2024 10:30:00 |  |  | 6 | [NAME] |  |  | 08:50:00 | 11:00:00
 |  |  | 09/05/2024 09:45:00 |  | 09/05/2024 16:30:00 |  |  | 4 | Sonia Amaral
 |  |  | 10/05/2024 10:45:00 |  | 10/05/2024 11:45:00 |  |  | 6 | [NAME] |  |  | 10:45:00 | 13:00:00
Total
Spreadsheet: 0c1f02ed-f0af-4150-8aa0-c343b51dabb8
Sheet: Sheet1

Unnamed: 0 | BELKNAP COUNTY OFFICES - Republican | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
2006-09-12 00:00:00 | Sheriff |  | Attorney |  |  |  | Treasurer
 | Collis, r | [NAME] | [NAME], r | Coull, r | Carroll, d | [NAME] | Muzzey, r | [NAME]
Alton | 299 |  | 157 | 143 |  |  | 291
Barnstead | 155 | 2 | 102 | 52 |  |  | 144
Belmont | 182 |  | 65 | 107 |  | 10 | 172
Center Harbor | 76 |  | 48 | 25 |  |  | 70
Gilford | 424 | 1 | 128 | 268 | 3 |  | 371 | 1
Gilmanton | 128 |  | 69 | 69 | 2 |  | 120
[NAME] | 228 |  | 56 | 138 | 20 |  | 205
[NAME] | 108 |  | 22 | 71 | 5 |  | 105
[NAME] 3 | 176 |  | 36 | 110 | 14 |  | 162
[NAME] | 132 |  | 51 | 64 |  |  | 118
[NAME] | 72 |  | 32 | 36 | 4 |  | 61
[NAME] 6 | 163 |  | 58 | 93 |  |  | 145
Meredith | 252 | 4 | 80 | 146 | 7 | 1 | 230 | 1
New Hampton | 147 | 1 | 87 | 54 | 2 |  | 140
Sanbornton | 187 | 1 | 103 | 78 | 3 |  | 174
[NAME] | 148 | 11 | 72 | 84 | 2 |  | 160
TOTALS | 2877 | 20 | 1166 | 1538 | 62 | 11 | 2668 | 2
 | BELKNAP COUNTY OFFICES - Republican
2006-09-12 00:00:00 | Reg. of Deeds |  |  | Reg. Of Probate
 | Normandin, r | [NAME] |  | Brickner, r | [NAME]
Alton | 306 |  |  | 301
Barnstead | 159 |  |  | 159
Belmont | 186 |  |  | 172
Center Harbor | 75 |  |  | 71
Gilford | 411 |  |  | 364 | 1
Gilmanton | 136 |  |  | 123 | 1
[NAME] | 228 |  |  | 202
[NAME] | 109 |  |  | 100
[NAME] 3 | 177 |  |  | 155
[NAME] | 127 |  |  | 118
[NAME] | 70 |  |  | 62
[NAME] 6 | 155 |  |  | 149
Meredith | 246 | 1 |  | 229 | 1
New Hampton | 147 |  |  | 142
Sanbornton | 189 |  |  | 169
[NAME] | 166 | 1 |  | 161
TOTALS | 2887 | 2 |  | 2677 | 3
 | COUNTY COMMISSIONERS
 | District 1 |  | Dist. 2 | District No. 3
 | Daigneault, r | [NAME] |  | Boothby, r | [NAME]
Alton |  |  | NO ELECTION | 294
Barnstead
Belmont
Center Harbor |  |  |  | 73
Gilford |  |  |  | 370 | 1
Gilmanton
[NAME] | 212 | 1
[NAME] | 109
[NAME] 3 | 173 | 2
[NAME] | 126 | 1
[NAME] | 68
[NAME] 6 | 143
Meredith |  |  |  | 239 | 3
New Hampton |  |  |  | 140
Sanbornton
[NAME]
TOTALS | 831 | 4 |  | 1116 | 4
Spreadsheet: darrell_schoolcraft__7774__imbalsumm0106
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -1880 | -3499
2 | -2029 | -3500
3 | -2037 | -3500
4 | -2033
5 | -2050 | -2818
6 | -2079 | -2139
7 | -1523 | -2139
8 | -2085 | -2139
9 | -1910 | -3500
10 | -2018 | -3500
11 | -2065 | -3500
12 | -2122 | -2139
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -304459
2001-06-12 00:00:00
Spreadsheet: 7355c0f8-3579-40f0-aabd-8d35b6b2a453
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Colorado Department of Education | Unnamed: 4 | Unnamed: 5 | Page: 1 | Unnamed: 7
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Student Profile | File Type: | EOY IPST Overwrite
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
BILINGUAL | OV010 | Error | Bilingual Code must be a valid code | Active | 1
BIRTH_DATE_STUDENT | OV004 | Error | Birth Date must be a valid date | Active | 1
DISTRICT_CODE | [NAME] | Error | District Code must be a valid code | Active | 1
ESL_STATUS | OV011 | Error | ESL Status Code must be a valid code | Active | 1
FREE_REDUCED_LUNCH | OV005 | Error | Free/Reduced Lunch Code must be a valid code | Active | 1
GENDER_STUDENT | OV003 | Error | Gender must be a valid code | Active | 1
GIFTED_AND_TALENTED | OV012 | Error | Gifted and Talented Code must be a valid code | Active | 1
GIFTED_AND_TALENTED | OV015 | Error | Gifted and Talented cannot vary between schools for a student. | Active | 1
HOMELESS | OV009 | Error | Homeless Code must be a valid code | Active | 1
MIGRANT | OV008 | Error | Migrant Code must be a valid code | Active | 1
MIGRANT | OV014 | Error | Migrant cannot vary between schools for a student. | Active | 1
SASID | 99999 | Error | The SASID is invalid or name, birth date, or gender doesnt match whats in the RITS system for the entered SASID | Active | 1
SASID | [NAME] | Error | The combination of DISTRICT_CODE, SCHOOL_CODE, and SASID must be unique. | Active | 1
SCHOOL_CODE | OV006 | Error | School Code must be a valid code | Active | 1
SCHOOL_CODE | OV007 | Error | School Code must be a valid school for the reported district | Active | 1
Spreadsheet: 218389d1362440525-multiple-dependent-lists-with-unique-results-mortgagebackup4
Sheet: Sheet1

 | Search Criterea |  |  |  |  |  | Key | Lead ID # | 1123 | Red
 | Lead ID # | First Name | Last Name | Phone | Address | County | Loan Type | Purchase/Refi | Status | Lead Source | Date | Agent Name
 | 1123 | [NAME] | Pepper |  |  | King
 | 1132 | Fred | Salt |  |  | King
 | 1142 | [NAME] | Red |  |  | Snohomish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year
Spreadsheet: 852559d1702556532-index-match-array-returning-duplicate-values-test
Sheet: Sheet1

 |  |  | Service Average Scores | Self Determination | Emotional Well-being | Physical Well-being | Material Well-being | Rights | Personal Development | Social Inclusion | Interpersonal Relationships
 |  |  |  | 3 | 4 | 5 | 4 | 4 | 3 | 2 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SMALL | LARGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Self Determination
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Self Determination
Spreadsheet: eric_saibi__9709__010402
Sheet: O W Sommers 01

Owner Name |  | San Antonio City Public Service Board
Station Name |  | OW Sommers Power Station
Unit Name |  | Sommers 01
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Natural Gas
Capacity |  | 446 MW
Start Date |  | 2002-01-03 00:00:00
End Date |  | 2002-02-10 00:00:00
Comments |  | Boiler Problems
SIC |  | 4911
Plant ID |  | 1002208
Unit ID |  | 1005824
Outage ID |  | 19380
Spreadsheet: 00f3a408-1e09-4161-a974-22a6c61c6782
Sheet: +50 MS 

BWF World Senior Championships 2013
MS 50 |  |  |  |  | Redrawn on 02nd September 2013
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | Member ID | St. | Cnty | Flag | Round 1 | Round 2 | Round 3 | Quarterfinals | Semifinals | Final | Winner
1 | 69 |  | TPE |  | [NAME] [1]
2 |  |  |  |  | Bye 1
3 | 55053 |  | SWE |  | [NAME]
4 | 61946 |  | GER |  | [NAME]
5 | 4968 |  | NOR |  | Geir Olve Storvik
6 |  |  |  |  | Bye 9
7 | 57907 |  | IND |  | [NAME]
8 | 64969 |  | POL |  | [NAME]
9 | 70467 |  | INA |  | [NAME] [5/8]
10 |  |  |  |  | Bye 5
11 | 64250 |  | AUT |  | [NAME]
12 | 73830 |  | TUR |  | [NAME]
13 | 4045 |  | FRA |  | [NAME]
14 | 50346 |  | RUS |  | Ildar Suleymanov
15 | 75722 |  | DEN |  | Jan Behrens
16 | 67439 |  | ENG |  | [NAME]
17 | 14863 |  | AUS |  | Loke [NAME] [3/4]
18 |  |  |  |  | Bye 3
19 | 92165 |  | TUR |  | [NAME]
20 | 78265 |  | IND |  | Rudra Narayan Sarkar
21 | 66848 |  | RUS |  | [NAME]
22 | 84299 |  | ENG |  | [NAME]
23 | 83629 |  | NED |  | Eng Gie Tan
24 | 6249 |  | FRA |  | [NAME]
25 | 88509 |  | DEN |  | [NAME] [5/8]
26 |  |  |  |  | Bye 7
27 | 64564 |  | SUI |  | [NAME]
28 | 50550 |  | AZE |  | [NAME]
29 | 60602 |  | JPN |  | [NAME]
30 | 85051 |  | RSA |  | Stephanus [NAME]
31 | 67808 |  | SWE |  | [NAME]
32 | 52427 |  | GER |  | [NAME]
33 | 68599 |  | POL |  | [NAME]
34 | 73914 |  | SWE |  | [NAME]
35 | 55898 |  | FRA |  | [NAME] Boulc'H
36 | 77103 |  | HUN |  | Geza Kotan
37 | 52431 |  | GER |  | [NAME]
38 | 57449 |  | RSA |  | [NAME]
39 |  |  |  |  | Bye 8
40 | 93369 |  | NOR |  | Geir Arnevik [5/8]
41 | 73664 |  | NED |  | [NAME]
42 | 70909 |  | TUR |  | Melih N Salman
43 | 60363 |  | CAN |  | [NAME]
44 | 98360 |  | UKR |  | [NAME] Gebdovskyi
45 | 66256 |  | AUT |  | [NAME]
46 | 57289 |  | RUS |  | [NAME]
47 |  |  |  |  | Bye 4
48 | 52402 |  | ENG |  | [NAME] [3/4]
49 | 96908 |  | BUL |  | [NAME]
50 | 99130 |  | RUS |  | [NAME]
51 | 76265 |  | SWE |  | Per Areskar
52 | 70655 |  | FRA |  | [NAME]
53 | 60257 |  | TUR |  | [NAME]
54 | 91769 |  | JPN |  | [NAME]
55 |  |  |  |  | Bye 6
56 | 78048 |  | MAS |  | [NAME] [5/8]
57 | 69154 |  | SUI |  | [NAME]
58 | 75179 |  | AZE |  | [NAME]
59 |  |  |  |  | Bye 10
60 | 71923 |  | GER |  | [NAME]
61 | 62535 |  | ENG |  | [NAME]
62 | 93351 |  | IND |  | [NAME]
63 |  |  |  |  | Bye 2
64 | 75772 |  | DEN |  | [NAME] [2]
Spreadsheet: 677505d1589377845-isolating-outlier-data-sets-sample-data
Sheet: Sheet1

Driver | Paysheet | Stop | Customer Name | Address
12345 | 2020-01-01 00:00:00 | 1 | ABC Company | 123 Main Street
12345 | 2020-01-01 00:00:00 | 2 | DEF Company | 456 Main Street
12345 | 2020-01-01 00:00:00 | 3 | GHI Company | 789 Main Street
12345 | 2020-01-01 00:00:00 | 4 | JKL Company | 321 Main Street
12345 | 2020-01-01 00:00:00 | 5 | MNO Company | 654 Main Street
12345 | 2020-01-02 00:00:00 | 1 | ABC Company | 123 Main Street
12345 | 2020-01-02 00:00:00 | 2 | DEF Company | 456 Main Street
12345 | 2020-01-02 00:00:00 | 3 | GHI Company | 789 Main Street
12345 | 2020-01-02 00:00:00 | 4 | JKL Company | 321 Main Street
12345 | 2020-01-02 00:00:00 | 5 | MNO Company | 654 Main Street
12345 | 2020-01-03 00:00:00 | 1 | ABC Company | 123 Main Street
12345 | 2020-01-03 00:00:00 | 2 | DEF Company | 456 Main Street
12345 | 2020-01-03 00:00:00 | 3 | GHI Company | 789 Main Street
12345 | 2020-01-03 00:00:00 | 4 | JKL Company | 321 Main Street
12345 | 2020-01-03 00:00:00 | 5 | ABC Company | 123 Main Street
12345 | 2020-01-04 00:00:00 | 1 | ABC Company | 123 Main Street
12345 | 2020-01-04 00:00:00 | 2 | DEF Company | 456 Main Street
12345 | 2020-01-04 00:00:00 | 3 | GHI Company | 789 Main Street
12345 | 2020-01-04 00:00:00 | 4 | JKL Company | 321 Main Street
12345 | 2020-01-04 00:00:00 | 5 | MNO Company | 654 Main Street
12345 | 2020-01-05 00:00:00 | 1 | ABC Company | 123 Main Street
12345 | 2020-01-05 00:00:00 | 2 | DEF Company | 456 Main Street
12345 | 2020-01-05 00:00:00 | 3 | GHI Company | 789 Main Street
12345 | 2020-01-05 00:00:00 | 4 | DEF Company | 456 Main Street
12345 | 2020-01-05 00:00:00 | 5 | MNO Company | 654 Main Street
12345 | 2020-01-06 00:00:00 | 1 | ABC Company | 123 Main Street
12345 | 2020-01-06 00:00:00 | 2 | DEF Company | 456 Main Street
12345 | 2020-01-06 00:00:00 | 3 | GHI Company | 789 Main Street
12345 | 2020-01-06 00:00:00 | 4 | JKL Company | 321 Main Street
12345 | 2020-01-06 00:00:00 | 5 | MNO Company | 654 Main Street
Spreadsheet: 547563d1510620443-how-to-merge-tabs-and-make-the-columns-inside-each-tab-alternate-with-each-other-3tabs
Sheet: Sheet3

Tab3 Col1 | [NAME] | Tab3 Col3
6 | 56 | 14
7 | 57 | 15
8 | 58 | 16
9 | 59 | 17
10 | 60 | 18
11 | 61 | 19
12 | 62 | 20
13 | 63 | 21
Spreadsheet: 718191d1613040697-trying-to-workout-post-cost-from-zone-and-weight-post-example
Sheet: Sheet1

 | Weight | Road Zones |  |  |  |  |  |  |  | ROAD ZONES
 | [NAME] | 1 | 2 | 3 | 4 | 5 |  | Note |  | Country | Zone | Country | Zone
 | 31000 | 30.18 | 34.74 | 52.84 | 83.82 | 99.8 |  | A brexit fee of £6.50 is applied to all shipments |  | Austria | 1 | Italy | 2
 |  |  |  |  |  |  |  |  |  | Balearics | 4 | Latvia | 5
 |  |  |  |  |  |  |  |  |  | Belgium | 1 | [NAME] | 3
 |  |  |  |  |  |  |  |  |  | Bulgaria | 4 | Lithuania | 5
 |  |  |  |  |  |  |  |  |  | Croatia | 3 | Luxembourg | 1
 |  |  |  |  |  |  |  |  |  | Cyprus | 5 | Monaco | 2
 |  |  |  |  |  |  |  |  |  | Czech | 2 | Netherlands | 1
 |  |  |  |  |  |  |  |  |  | Denmark | 3 | Norway | 4
 |  |  |  |  |  |  |  |  |  | Estonia | 5 | Poland | 3
 |  |  |  |  |  |  |  |  |  | Finland | 3 | Portugal | 3
 |  |  |  |  |  |  |  |  |  | FR - Corsica | 3 | Rep of Ireland | 3
 |  |  |  |  |  |  |  |  |  | France | 2 | Romania | 4
 |  |  |  |  |  |  |  |  |  | Germany | 1 | Slovakia | 2
 |  |  |  |  |  |  |  |  |  | Gibraltar | 5 | Slovenia | 2
 |  |  |  |  |  |  |  |  |  | Greece | 4 | Spain | 2
 |  |  |  |  |  |  |  |  |  | Hungary | 2 | Sweden | 3
 |  |  |  |  |  |  |  |  |  | IT - San Marino | 3 | Switzerland | 3
 |  |  |  |  |  |  |  |  |  | IT - Sardinia/Sicily | 4
 |  |  |  |  |  |  |  |  |  | Italy | 2
 |  |  |  |  |  |  |  |  |  | Latvia | 5
 |  |  |  |  |  |  |  |  |  | [NAME] | 3
 |  |  |  |  |  |  |  |  |  | Lithuania | 5
 | Country | Zone | Weight | Cost |  |  |  |  |  | Luxembourg | 1
 | Greece |  | 34000 |  |  |  |  |  |  | Monaco | 2
 |  |  |  |  |  |  |  |  |  | Netherlands | 1
 |  |  |  |  |  |  |  |  |  | Norway | 4
 |  |  |  |  |  |  |  |  |  | Poland | 3
 |  |  |  |  |  |  |  |  |  | Portugal | 3
 |  |  |  |  |  |  |  |  |  | Rep of Ireland | 3
 |  |  |  |  |  |  |  |  |  | Romania | 4
 |  |  |  |  |  |  |  |  |  | Slovakia | 2
 |  |  |  |  |  |  |  |  |  | Slovenia | 2
 |  |  |  |  |  |  |  |  |  | Spain | 2
 |  |  |  |  |  |  |  |  |  | Sweden | 3
 |  |  |  |  |  |  |  |  |  | Switzerland | 3
Spreadsheet: 106453d1303745665-sumifs-across-sheets-copy-of-central-office-2010-2011-w-formulas
Sheet: JJA

FIRST NAME | MI | EMP # | HIRE | [NAME] | EXTENDED LEAVE | FACILITY | UNIT/COTTAGE | JJA GRAD | ORIENTATION | HR ORIENTATION | PROF/ETHIC | FUND | F/S | MANDATED REPORTER | INTRO WORKING W/JUV OFF | CPR/AED | BFA | SUICIDE | CULTURE AWARE | MED AWARE | SEARCH | SCM - PRIMARY | SCM - SECONDARY | SCM - ESI | SCM - TERTIARY | MECHANICALS | PbS | R2K | LEP | SICKLE CELL | COMMENTS | Total
 |  |  |  |  |  |  |  |  | 2.75 | 2 | 3 | 7 | 1 | 1 | 6 | 4 | 4 | 8 | 3 | 1 | 3 | 8 | 4 | 14 | 2 | 3.5 | 0.25 | 0.5 | 0.5 | 1
Jeanette |  | 424683 | 1992-03-02 00:00:00
Antania |  | 646058 | 2010-08-21 00:00:00
[NAME] |  | 495042 | 1999-01-11 00:00:00
[NAME] |  | 71949 | 1974-07-01 00:00:00
[NAME] |  | 439185 | 1993-03-30 00:00:00
[NAME] |  | 608039 | 2004-08-02 00:00:00
[NAME] |  | 462816 | 1995-06-01 00:00:00
Arleathia |  | 25374 | 1978-02-01 00:00:00
[NAME] |  | 72385 | 1977-11-02 00:00:00
Meri |  | 544272 | 2010-01-11 00:00:00
[NAME] |  | 647210 | 2007-09-04 00:00:00
[NAME] |  | 608513 | 2004-08-16 00:00:00
[NAME] |  | 438766 | 1993-03-29 00:00:00
[NAME] |  | 494815 | 1998-12-07 00:00:00
[NAME] |  | 71810 | 1979-11-07 00:00:00
[NAME] |  | 525136 | 2001-12-31 00:00:00
[NAME] |  | 45967 | 1986-06-16 00:00:00
[NAME] |  | 56717 | 1980-05-19 00:00:00
Daryl |  | 515249 | 2001-01-16 00:00:00
Michelle |  | 49776 | 2010-10-02 00:00:00
George |  | 489089 | 1998-05-18 00:00:00
Avery |  | 628970 | 2006-04-03 00:00:00
[NAME] |  | 432011 | 1992-08-22 00:00:00
[NAME] |  | 392020 | 1997-03-03 00:00:00
Becky |  | 620673 | 2005-08-15 00:00:00
[NAME] |  | 87575 | 1982-09-07 00:00:00
[NAME] |  | 194488 | 2009-04-05 00:00:00
[NAME] |  | 35716 | 2010-10-30 00:00:00 |  |  |  |  |  |  |  | 2010-12-06 00:00:00 | 2010-12-07 00:00:00 | 2010-12-07 00:00:00 | 2010-12-08 00:00:00 | 2010-12-08 00:00:00 | 2010-12-09 00:00:00 | 2010-12-09 00:00:00 | 2010-12-10 00:00:00 | 2010-12-13 00:00:00 |  | 2010-12-13 00:00:00 | 2010-12-14 00:00:00 | Excused | Excused | Excused |  |  | 2011-01-21 00:00:00 | 2011-01-21 00:00:00 | 2011-01-21 00:00:00
[NAME] |  | 679339 | 2010-10-25 00:00:00
[NAME] |  | 515575 | 2001-01-29 00:00:00
[NAME] |  | 455242 | 1994-06-27 00:00:00
Spreadsheet: mary_fischer__25637__31T
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031T
EQUITY INVESTEE'S SUMMARIZED INFORMATION
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36