tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_dorland__1586__opspackage
Sheet: OPS_SHEET NEW

Westcoast Supply / Demand
 |  |  | Estimates | Actuals |  |  |  |  | Historics |  | . |  | Hunt Export | [NAME] | [NAME] | Lower Mainland | Interior | PNG | Power | Fuel | T-South | Other | Alliance | Gordondale | Total Demand | Field Receipts | Available for Storage | Storage Balance (EOM) | % Full
 |  |  |  |  |  |  |  |  | Month | Prior Year
 |  | +/- |  |  |  |  |  |  | To Date
McMahon
Ft. [NAME]
Pine River
Cypress
Sikanni
West Stoddart
North Jedney
Kingsvale
26" Alberta
16" Boundary
[NAME]
Highway
[NAME]
BC Field Receipts
Huntington-Export
BC GLM
BC Gas Interior
Kingsvale
PNG
Westcoast Power
Fuel
Other (Estimate)
Deliveries
[NAME]
Arco @ Hunt
[NAME]
[NAME] Total
Alliance Boundary
Alliance Gordondale
Alliance McMahon
Alliance Highway
Alliance West Stoddart
Alliance Storage
Alliance Total
Field Receipts
Deliveries
Net Gordondale
Available to inject
Imbalance
WEI LINE PACK (target 2.875)
[NAME]
Aitken Creek Injections
Aitken Creek Withdrawls
Net Storage
Beginning Inventory
% of Storage Full
Unutilized Capacity (MMcf/d)
Aitken Lateral
Aitken Unit
[NAME] to N4
[NAME]
[NAME]
[NAME]
Interior
Stn 1 West
Stn 4B South
Stn N4
 | [NAME] | Sumas/   [NAME] | Sumas/ Chehalis Demand | Chehalis | Washougal | [NAME] | Other Chehalis/ Roosevelt | JP Inj(-) W/D(+) | Net JP - Balance | JP % Full | Roosevelt | Starr Road | Other Roosevelt/ [NAME] | Stanfield Net | Meacham | [NAME] | Mystery Demand | Other Meecham/ Kemmerer | Kemmerer | [NAME] | Rathdrum | Spokane NWP | Spokane WWP | Other | PGT Stanfield | South Hermiston | Coyote Springs | [NAME] | Medford / Klammath | Malin
Capacity |  | 1180 |  | 700 | 416 | 158 |  | (477), 1000 | 19032 |  | 498N, 400 S | 165 |  | 638R, 200D | 198 | 220 |  |  | 494 | 2720 | 129 | 165 | 65 |  | 638R, 200R | 100 | 106 | 130 | 100 Kl,40 Med | 2000
2000-04-01 00:00:00 | -0.3146666526794433
2000-05-01 00:00:00 | -0.5143547981016101
2000-06-01 00:00:00 | -0.6099999348322549
2000-07-01 00:00:00 | -0.6166128724621189
2000-08-01 00:00:00 | -1.229999949855189
2000-09-01 00:00:00 | -0.4853332277933751
2000-10-01 00:00:00 | -0.3101562708616257
2000-11-01 00:00:00 | 3.907666651407878
2000-12-01 00:00:00 | 8.853064475520965
2001-01-01 00:00:00 | -0.3817741486334025
2001-02-01 00:00:00 | 0.3946428448813295
2001-03-01 00:00:00 | 0.01661287923012988
2001-04-01 00:00:00 | 0.07116661898295007
2001-05-01 00:00:00 | -0.1606451612903248
2001-06-01 00:00:00 | -0.597666666666667
2001-07-01 00:00:00 | -0.7856451612903239
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00
2002-08-01 00:00:00
2002-09-01 00:00:00
2002-10-01 00:00:00
Spreadsheet: 80040d1280267644-use-countif-or-sumproduct-countifs_sumproduct
Sheet: Sheet1

Name | Date | Entry |  | Name | Date From | Date To
[NAME] | 2010-01-01 00:00:00 | Entry1 |  | [NAME] | 2010-01-01 00:00:00 | 2010-03-31 00:00:00
[NAME] | 2010-01-01 00:00:00 | Entry2
[NAME] | 2010-01-01 00:00:00 | Entry3 |  | COUNTIFS | 2 | Excel 2007
[NAME] | 2010-02-01 00:00:00 | Entry4 |  | SUMPRODUCT | 2
[NAME] | 2010-03-01 00:00:00 | Entry5
[NAME] | 2010-03-22 00:00:00
[NAME] | 2010-06-01 00:00:00 | Entry6
[NAME] | 2010-06-02 00:00:00 | Entry7
[NAME] | 2010-06-03 00:00:00 | Entry8
[NAME] | 2010-06-05 00:00:00 | Entry9
[NAME] | 2010-06-06 00:00:00 | Entry10
[NAME] | 2010-06-08 00:00:00
[NAME] | 2010-06-09 00:00:00
[NAME] | 2010-06-10 00:00:00
[NAME] | 2010-07-01 00:00:00
[NAME] | 2010-07-02 00:00:00
[NAME] | 2010-07-03 00:00:00 | Entry11
[NAME] | 2010-07-04 00:00:00 | Entry12
[NAME] | 2010-07-05 00:00:00 | Entry13
Spreadsheet: 553551d1514401382-conditional-formatting-with-multiple-conditions-cond-formatting-test
Sheet: Sheet1

Product | Criterion | Period1 | Period2
AAA | Absolute | 1 | -1
BBB | Absolute | -1 | 1
CCC | Percentile | 24 | 76
DDD | Percentile | 48 | 50
EEE | Percentile | 53 | 26
FFF | Percentile | 75 | 3
GGG | Relative | 0.01 | -0.01
HHH | Relative | -0.01 | 0.01
III | Absolute | n/a | n/a
JJJ | Percentile | n/a | n/a
KKK | Relative | n/a | n/a
Spreadsheet: 880177d1727795944-rolling-count-of-all-the-overlapping-days-for-multiple-date-ranges-example-1-4
Sheet: Sheet2

Range# (A) | Start Date (B) | End Date (C) | Rolling sum:
1 | 2024-06-01 00:00:00 | 2024-06-03 00:00:00
2 | 2024-06-04 00:00:00 | 2024-06-10 00:00:00
3 | 2024-06-22 00:00:00 | 2024-06-29 00:00:00
4 | 2024-07-05 00:00:00 | 2024-07-15 00:00:00
5 | 2024-07-16 00:00:00 | 2024-07-25 00:00:00
6 | 2024-07-28 00:00:00 | 2024-08-05 00:00:00
7 | 2024-08-20 00:00:00 | 2024-08-23 00:00:00
8 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00
9 | 2024-08-23 00:00:00 | 2024-08-28 00:00:00
10 | 2024-09-20 00:00:00 | 2024-09-23 00:00:00
11 | 2024-09-22 00:00:00 | 2024-09-24 00:00:00
12 | 2024-07-01 00:00:00 | 2024-07-03 00:00:00
Spreadsheet: 159041d1338481319-how-to-find-cell-value-sample-1
Sheet: Sheet2

 |  |  | 21.71
 |  |  | 21.93
 |  |  | 22.12
 |  |  | 22.18 | 43.76 | x | 67.67 | x | x
 |  |  | 22.21 | 43.86 | x | 67.87 | x | x
 |  |  | 22.24 | 43.96 | x | 68.07 | x | x
 |  |  | 22.27 | 44.06 | x | 68.27 | x | x
 |  |  | 22.3 | 44.16 | x | 68.47 | x | x
 |  |  | 22.33 | 44.26 | x | 68.67 | x | x
 |  |  | 22.36 | 44.36 | x | 68.87 | x | x
 |  |  | 22.39 | 44.46 | x | 69.07 | x | x
 |  |  | 22.41 | 44.54 | x | 69.22 | x | x
 |  |  | 22.42 | 44.58 | x | 69.3 | x | x
 |  |  | 22.42 | 44.69 | x | 69.37 | x | x
 |  |  | 22.42 | 44.85 | x | 69.54 | x | x
 |  |  | 22.42 | 44.99 | x | 69.77 | x | x
 |  |  | 22.44 | 45.11 | x | 69.96 | x | x
 |  |  | 22.47 | 45.18 | x | 70.12 | x | x
 |  |  | 22.51 | 45.26 | x | 70.29 | x | x
 |  |  | 22.57 | 45.38 | x | 70.46 | x | x
 |  |  | 22.61 | 45.47 | x | 70.58 | x | x
 |  |  | 22.63 | 45.51 | x | 70.62 | x | x
 |  |  | 22.65 | 45.56 | x | 70.74 | x | x
 |  |  | 22.68 | 45.64 | x | 70.89 | x | x
 |  |  | 22.74 | 45.82 | x | 71.06 | x | x |  | 71.1
 |  |  | 22.81 | 46.04 | x | 71.29 | x | x
 |  |  | 22.86 | 46.18 | x | 71.5 | x | x
 |  |  | 22.89 | 46.29 | x | 71.71 | x | x
 |  |  | 22.92 | 46.4 | x | 71.91 | x | x
 |  |  | 22.95 | 46.5 | x | 72.11 | x | x
 |  |  | 22.98 | 46.6 | x | 72.31 | x | x
 |  |  | 23.01 | 46.7 | x | 72.51 | x | x
 |  |  | 23.04 | 46.8 | x | 72.71 | x | x
 |  |  | 23.07 | 46.9 | x | 72.91 | x | x
Spreadsheet: 266542d1379653812-count-range-of-cells-if-not-next-to-each-other-aaron85w
Sheet: Sheet1

Range |  | Numbers | Count
137 |  | 1
167 |  | 2
175 |  | 3
26
195
82
11
171
41
128
78
84
151
98
194
42
111
102
86
11
43
73
97
20
82
Spreadsheet: 836530d1689449534-merging-formulas-that-reference-sheets-indirect-formulas-test-file-3-copy
Sheet: Sheet2

 |  | Cells | Cells
 | Solution: | H222 | I222
 | ZONE | TOTAL1 | TOTAL2
Total overall |  |  |  |  | Last part would be adding the sum function to add at the end of the totals (1-2). This way when the list gets long, the sum would move with the formula in B1 and not have to be manually inputed like in cells C15 and D15
 |  |  |  |  | im thinking that the sum function would go in front of the unique function in the formula
 |  |  |  |  | IFERROR(LET(t,SORT(UNIQUE(FILTER(data!A10:A1000,ISNUMBER(SEARCH("alpha",data!A10:A1000)),"not found"))),HSTACK(t,MAP(t,[NAME],INDIRECT("'"&c&"'!H222"))),MAP(t,[NAME],INDIRECT("'"&c&"'!i222"))))),"")
 |  |  |  |  |  | ^
 |  |  |  |  |  | Sum here?
Spreadsheet: 90871d1290584419-excel-2007-finding-and-returning-the-numeric-cells-in-a-column-754252_bored
Sheet: Sheet1

raw | Key | Numbers | Text | Others | wanted - numeric | wanted - text
12 |  |  |  |  | 12 | te |  | 12 | te
3 |  |  |  |  | 3 | asd |  | 3 | asd
412 |  |  |  |  | 412 | dfg |  | 412 | dfg
34 |  |  |  |  | 34 | cbg |  | 34 | cbg
235 |  |  |  |  | 235 | er |  | 235 | er
567 |  |  |  |  | 567 | sra |  | 567 | sra
123 |  |  |  |  | 123 | [NAME] |  | 123 | [NAME]
 |  |  |  |  | 40506 | sdfgh |  | 40506 | sdfgh
 |  |  |  |  | 123 | fb |  | 123 | fb
te |  |  |  |  | 2345 | b |  | 2345 | b
asd |  |  |  |  | 123 |  |  | 123
dfg |  |  |  |  | 65456 |  |  | 65456
cbg
er
123
sra
2345
True
[NAME]
123
65456
sdfgh
fb
b
Spreadsheet: 770919d1646335883-pulling-data-based-on-criteria-from-one-list-to-another-book3-1-
Sheet: Sheet2

D4866064DE10 |  |  | 52 | 56 | 54 | 54 | 48 | 54 | 52 | 68 | 69
D4866064DE10 |  |  | 52 | 56 | 54 | 54 | 48 | 54 | 52 | 68 | 69
Spreadsheet: 225579d1365057306-extracting-specific-data-from-multiple-cells-and-multiple-columns-in-excel-2007-survey
Sheet: Sheet1

Data
Participant | # | Response |  |  |  |  |  | Participant | # | Response
A1 | 1 | 5 |  |  |  |  | Select | A3 | 3 | 7
A2 | 2 | 9
A3 | 3 | 7 |  |  |  |  | Select | A10 | 10 | 3
A4 | 4 | 6
A5 | 5 | 7
A6 | 6 | 10
A7 | 7 | 2
A8 | 8 | 9
A9 | 9 | 5
A10 | 10 | 3
A11 | 11 | 7
A12 | 12 | 10
A13 | 13 | 7
A14 | 14 | 7
A15 | 15 | 8
A16 | 16 | 10
A17 | 17 | 4
A18 | 18 | 4
A19 | 19 | 3
A20 | 20 | 10
Spreadsheet: c8d30a6a-1968-4fa8-9881-e8d8632b7229
Sheet: Sheet1

Table 1--Wheat: Planted acreage, harvested acreage, production, yield, and farm price | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Class and mkt year 1/ |  | Planted acreage | Harvested acreage | Production | Yield | Weighted-average farm price 2/
 |  | (million acres) | (million acres) | (million bushels) | (bushels per acre) | (dollars per bushel)
All wheat | 2009/10 | 59.168 | 49.893 | 2218.061 | 44.5 | 4.87
 | 2010/11 | 53.593 | 47.619 | 2206.916 | 46.3 | 5.7
 | 2011/12 | 54.409 | 45.705 | 1999.347 | 43.7 | 7.24
 | 2012/13 | 55.736 | 48.991 | 2269.117 | 46.3 | 7.70-7.90
Hard red winter | 2009/10 | 31.668 | 24.148 | 919.939 | 38.09586715255922 | 4.84
 | 2010/11 | 28.553 | 24.042 | 1018.337 | 42.35654271691207 | 6.49
 | 2011/12 | 28.48 | 21.441 | 780.089 | 36.38305116365841 | 6.92
 | 2012/13 | 29.863 | 24.67 | 1003.856 | 40.69136603161735 | --
Hard red spring | 2009/10 | 12.614 | 12.318 | 547.933 | 44.48230232180549 | 5.26
 | 2010/11 | 12.969 | 12.645 | 569.975 | 45.07512850929221 | 6.54
 | 2011/12 | 11.589 | 11.295 | 397.689 | 35.20929614873838 | 8.38
 | 2012/13 | 11.694 | 11.479 | 504.52 | 43.95156372506316 | --
Soft red winter | 2009/10 | 8.315 | 7.199 | 403.984 | 56.1166828726212 | 4.35
 | 2010/11 | 5.274 | 4.369 | 237.429 | 54.34401464866102 | 5.16
 | 2011/12 | 8.561 | 7.42 | 457.535 | 61.66239892183289 | 6.78
 | 2012/13 | 8.12 | 6.965 | 419.801 | 60.27293610911701 | --
White | 2009/10 | 4.016 | 3.801 | 237.163 | 62.39489607997896 | 4.52
 | 2010/11 | 4.237 | 4.044 | 275.095 | 68.02546983184965 | 5.88
 | 2011/12 | 4.41 | 4.237 | 313.552 | 74.00330422468728 | 6.42
 | 2012/13 | 3.936 | 3.775 | 258.984 | 68.60503311258277 | --
Durum | 2009/10 | 2.554 | 2.428 | 109.042 | 44.9 | 5.47
 | 2010/11 | 2.56 | 2.519 | 106.08 | 42.1 | 5.98
 | 2011/12 | 1.369 | 1.312 | 50.482 | 38.5 | 9.68
 | 2012/13 | 2.123 | 2.102 | 81.956 | 39 | 8.35
 | 2013/14 | 1.751 | -- | -- | -- | --
1/ June-May. Latest data may be preliminary or projected. 2/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. For hard red winter, hard red spring, soft red winter, and white, simple average of monthly prices for selected States prior to 2002/03. Latest data are from World Agricultural Supply and Demand Estimates. Source: USDA, National Agricultural Statistics Service, Crop Production, Agricultural Prices, and unpublished data; and USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Date run: 4/18/2013
Spreadsheet: 274156d1383036099-how-to-configure-vlookup-to-filter-first-one-or-two-key-words-flag-scenario-rambo2-
Sheet: BEFORE

 | File [1] |  |  |  | File [2]
flag # | business name | flag rank |  |  | business name | flag rank
1 | amadeus corp. |  |  |  | [NAME] | 1
2 | eion inc. |  |  |  | eion incorporation | 2
3 | ryo ltd. |  |  |  | mega company | 3
4 | cat tech. |  |  |  | cat technologies | 4
5 | drew usa |  |  |  | carlton patent | 5
6 | drew ph. |  |  |  | drew u.s.a | 6
7 | [NAME]. |  |  |  | defiant mall | 7
8 | regulis co. |  |  |  | knolls corp, | 8
9 | red orange violet |  |  |  | red orange violet | 9
10 | iso pte. Inc. |  |  |  | crawford patent | 10
 |  |  |  |  | regulis corp | 11
 |  |  |  |  | drew ph. | 12
 | **I have to put ranks on this side |  |  |  | amadeus corporation | 13 |  | **the problem is the naming convention is not standard
 | **this two are separate files not on same sheets |  |  |  | orange velocity | 14 |  | as you can see the corp. inc. co etc. are completed thus if i
 |  |  |  |  | iso patent incorporation | 15 |  | use =vlookup it would not detect those.
 |  |  |  |  | arceus corp. | 16 |  | **actual file consist of 2000-10000 business names with ranks
 |  |  |  |  | bucket shoal inc. | 17
 |  |  |  |  | red orange violet | 18
 |  |  |  |  | sand filter corp. | 19
 |  |  |  |  | bayo incorporation | 20
 |  |  |  |  | ryo limited | 21
Spreadsheet: 267667d1380133990-finding-matches-with-multiple-return-values-sample1
Sheet: Sheet1

Username | UserID | First Name | Last Name | Serial Number
[NAME] | jjones | [NAME] | Jones | 1111111
jdoe | jjones | [NAME] | Jones | 1111111
jjones | jdoe | [NAME] | Doe | 2222222
 | jdoe | [NAME] | Doe | 2222222
 | [NAME] | [NAME] | Smith | 3333333
 | [NAME] | [NAME] | Smith | 3333333
Spreadsheet: 65831d1266488739-find-what-names-are-missing-in-sheets-missing2
Sheet: MAIN

WHAT USER NAME FROM JOB1 IS NOT IN SHEETS 1, 2 ,3: |  | WHAT USER NAME FROM JOB1 IS NOT IN SHEETS 1, 2 ,3 AND HAS STATS (VALUE) <>0: |  | JOB1 | [NAME] | JOB3 |  | JOB1 | STATS | [NAME] | STATS | JOB3 | STATS
WHAT USER NAME FROM JOB2 IS NOT IN SHEETS 1, 2 ,3: |  | WHAT USER NAME FROM JOB2 IS NOT IN SHEETS 1, 2 ,3 AND HAS STATS (VALUE) <>0:
WHAT USER NAME FROM [NAME] IS NOT IN SHEETS 1, 2 ,3: |  | WHAT USER NAME FROM [NAME] IS NOT IN SHEETS 1, 2 ,3 AND HAS STATS (VALUE) <>0:
Spreadsheet: 480622d1474000043-pivot-table-calculated-field-book1
Sheet: Sheet1

Name | Hours Worked | Average Hours
[NAME] | 8 | 36
[NAME] | 14 | 36
[NAME] | 2 | 36
[NAME] | 5 | 36
[NAME] | 12 | 50
[NAME] | 15 | 50
[NAME] | 15 | 50
[NAME] | 13 | 50
[NAME] | 15 | 40
[NAME] | 12 | 40
[NAME] | 0 | 40
Spreadsheet: 41339d1239811751-identify-list-and-sum-2-columns-test-time-sheet
Sheet: Jan 5-10

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME]
2009-01-05 00:00:00 | 06:30:00 | 07:30:00 | 1 | 28111 |  | CNC P  LAGUP CORE
 | 07:30:00 | 03:00:00 | 7 | SHOP | 8
2009-01-06 00:00:00 | 06:30:00 | 08:30:00 | 2 | 28111 |  | CNC P  LAGUP CORE
 | 08:30:00 | 03:00:00 | 6 | SHOP | 8
2009-01-07 00:00:00 | 06:00:00 | 06:30:00 | 0.5 | 28112 |  | GAUGE DESIGN
 | 06:30:00 | 08:30:00 | 2 | 28113 |  | GAUGE DESIGN
 | 08:30:00 | 09:30:00 | 1 | 28111 |  | CNC P LAGUP CORE
 | 09:30:00 | 03:00:00 | 5 | SHOP | 8.5
2009-01-08 00:00:00 | 06:00:00 | 07:00:00 | 1 | 28113 |  | CNC P
 | 07:00:00 | 12:00:00 | 5 | SHOP
 | 12:30:00 | 02:15:00 | 1.75 | 28113 | 7.75 | CNC P
2009-01-09 00:00:00 | 06:30:00 | 12:00:00 | 5.5 | SHOP
 | 12:30:00 | 02:00:00 | 1.5 | 29001
 | 02:00:00 | 02:45:00 | 0.75 | SHOP | 7.75
 |  |  |  |  |  |  |  |  | VACATION 54.5 HRS
 |  | SHOP | 29.25
 |  | 28111 | 4
 |  | 28112 | 0.5
 |  | 28113 | 4.75
 |  | 29001 | 1.5
 |  |  | 40 | TOTAL | 40
Spreadsheet: 117851d1313162216-radio-button-assistance-simple-questionnaire-macro
Sheet: Sheet1

Question | Qtext | Yes Text | No Text | Go Yes | Go No
1 | Do you like dogs? | I like dogs | I do not like dogs. | 2 | 3
2 | Do you own a dog? | and I own a dog. | but I do not own a dog. | 5 | 5
3 | Do you like cats? | I like cats | I do not like cats | 4 | 5
4 | Do you own a cat? | and I own a cat | but I do not own a cat. | 6 | 6
5 | Do you like cats? | I also like cats | But I don't like cats. | 4 | 6
6 | Hope you enjoyed this survey
Spreadsheet: 836134d1689114519-excel-formula-for-health-status-report-zoho
Sheet: Sheet1

Overall |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overall score | Individual Green Count
Issues |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Green | 8
Scope |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amber
Risks |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red | 2
Progress
In Progress
 | [NAME]
Project Name | Status | Phase | PM | Schedule | Oissues | Scope | Risks | Change Mgmt | Progress | Follow Through | Overall Health
Project 1 |  | Green | Amber | Red | Green | Red | Red | Amber |  | Green
Project 2 |  | Green | Amber | Red | Green | Red | Red | Amber | Amber
 |  | Green | Green | Green | Green | Green | Green | Green | Green | Green
Spreadsheet: 267678d1380136085-pulling-data-from-a-master-list-company-wide-employee-list
Sheet: Dallas

EMP ID | Dallas Org Chart |  |  |  |  |  | I want a formula that will have the employee name autopopulated.
 | Seabolt, [NAME] |  |  |  |  |  | The Emp Id And Position will pull once the name is populated
 | Shakhmeyster, [NAME] |  | this is a helper cell |  |  |  | I think the names should be pulled from "Location & Job Title".
 |  |  | count of
Sales
 | [NAME], [NAME] |  | location | DALLAS |  | Just change the info in these two cells and it will populate in the green columns that I made
 |  |  | job title | DRIVER
 |  |  |  | EMP ID | NAME | JOB | [NAME]
Administrative
Operation
 | [NAME], [NAME]
Drivers
 | [NAME], Erasto
Yard Employees
 | [NAME], [NAME]
[NAME]
 | [NAME], [NAME]
Spreadsheet: mark_taylor__24803__Enron Entity Master
Sheet: Sheet1

Enron Etity | CP ID #
Enron North America Corp. | 1305
Houston Pipe Line Company | 1321
Enron Gas Liquids, Inc. | 5375
Enron Canada Corp | 11266
Enron Reserve Acquisition Corp. | 11356
Enron Power Marketing, Inc. | 26048
Enron Liquid Fuels, Inc. | 27625
Enron Capital & Trade Resources International Corp. | 46503
Enron Gas & Petrochemicals Trading Limited | 56926
Enron Capital & Trade Resources Limited | 58294
Enron Coal Services Limited | 70914
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -623008 | -616826 | -25138 | -25000
2 | -610523 | -585078 | -25001 | -25000
3 | -663655 | -658037 | -25919 | -25000
4 | -684927 | -709416 | -23707 | -25000
5 | -709597 | -718815 | -25000 | -25000
6 | -713428 | -714110 | -25002 | -25000
7 | -720273 | -719066 | -25488 | -25000
8 | -709442 | -697388 | -24057 | -25000
9 | -702534 | -702433 | -24999 | -25000
10 | -673048 | -701948 | -43196 | -25000
11 | -717759 | -710462 | -25501 | -25000
12 | -695728 | -695888 | -62
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  |  |  | 151133
2001-09-12 00:00:00
CBS Dollars
 |  |  | 465120
Spreadsheet: 68848d1269382323-fishing-weights-weights2-template
Sheet: Sheet1

 |  |  |  |  | FISHING. WEIGHTS 2010
NAME | VENUE1 | VENUE 2 | VENUE 3 | VENUE 4 | VENUE 5 | VENUE 6 | VENUE 6 | VENUE 7 | VENUE 8 | VENUE 9 | TOTAL
A. OTHER | 2.06 | 8.04 | 15.03 | 4.09 |  |  |  |  |  |  |  | 1
[NAME]
[NAME]
[NAME]
E. OTHER |  |  |  |  |  |  |  |  |  |  |  | 1
E. OTHER
[NAME]
G.OTHER
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME]
J.OTHER
K. OTHER |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 770025d1645784126-dealing-with-alternative-codes-book1-1-
Sheet: Sheet1

Alternative | Product number | Desired output | Explanation
1 | 900921822 | 1 | No alternative for 900921822 so only 1
1 | 900921822 | 1
1 | 900921822 | 1
1 | 900921822 | 1
1 | 900921822 | 1
2 | 900927222 | 1 | No alternative for 90092722 so only 1
2 | 900927222 | 1
2 | 900927222 | 1
2 | 900927222 | 1
2 | 900927222 | 1
2 | 900927222 | 1
2 | 900927222 | 1
2 | 900927222 | 1
1 | 900927223 | 0 | There is alternative for 900927223 so 0 when alt. number is 1
1 | 900927223 | 0
1 | 900927223 | 0
1 | 900927223 | 0
1 | 900927223 | 0
1 | 900927223 | 0
1 | 900927223 | 0
2 | 900927223 | 1 | There is alternative for 900927223 so 1 when alt. number is 2
2 | 900927223 | 1
2 | 900927223 | 1
2 | 900927223 | 1
2 | 900927223 | 1
2 | 900927223 | 1
2 | 900927223 | 1
2 | 900927223 | 1
1 | 900927224 | 0 | There is alternative for 900927224 so 0 when alt. number is 1
1 | 900927224 | 0
1 | 900927224 | 0
1 | 900927224 | 0
1 | 900927224 | 0
1 | 900927224 | 0
1 | 900927224 | 0
2 | 900927224 | 1 | There is alternative for 900927224 so 1 when alt. number is 2
2 | 900927224 | 1
2 | 900927224 | 1
2 | 900927224 | 1
2 | 900927224 | 1
2 | 900927224 | 1
2 | 900927224 | 1
2 | 900927224 | 1
1 | 900928848 | 1 | There is no alternative for 900928848 so 1
1 | 900928848 | 1
1 | 900928848 | 1
1 | 900928848 | 1
1 | 900928848 | 1
1 | 900928848 | 1
Spreadsheet: 7632a183-45f8-4696-b878-3ce20df0f8fc
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0000088 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Governors Club | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Chatham | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 50060 | 31616 | 00610 | 00620 | 00400 | 70300 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | pH | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | mg/L | mg/L | NTU
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Composite | Grab | Grab | Composite | Composite | Grab | Composite | Composite | Recorder
Monthly Limit: |  |  | 223153 | 10 |  |  | 14 | 4 |  |  |  | 5
Daily Limit: |  |  |  | 15 |  |  | 25 | 6 |  | 6-9 |  | 10 | 10
Sample Frequency: |  |  | [NAME] | 2 x Month | 3 x Year | 5 x Week | 2 x Month | 2 x Month | 2 x Month | 5 x Week | 3 x Year | 2 x Month | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 108523d1305579189-look-for-corresponding-values-in-multiple-workbooks-campaign-work-bs1534a-day92
Sheet: Sample 2

Asset # | Business Unit | Location | Work Order # | RET | Analysis Reports | Task Status | Date Completed | [NAME] | Additional Comments
9333 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details | Open | TBD
9334 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details | Closed | 2010-12-01 00:00:00
9335 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details | Closed | 2011-01-03 00:00:00
Spreadsheet: 76805d1277296736-matrix-array-if-formula-risks-for-forum
Sheet: Guidance Notes

 |  |  | Assessment
 | Assessment | Probability (%) | Cost Impact (£K) | Time Impact (Days)
 | VHI | >90% | > £500k | >30
 | HI | 60% - 90% | £250k - £500k | 21 - 30
 | MED | 40% - 59% | £100k - £249k | 2020-11-01 00:00:00
 | LO | 20% - 39% | £50k - £99k | 2009-10-06 00:00:00
 | VLO | >0% - 19% | < £50k | >0 - 5
 | NIL | - | No effect on cost | No effect on schedule
 |  |  | Priority
Spreadsheet: 275964d1383698399-populate-cells-if-there-is-a-min-and-max-value-leave-01
Sheet: Sheet1

Leave details
Staff member | Vacation Type | Start Date | End Date
Fred | Sick | 2013-01-01 00:00:00 | 2013-01-04 00:00:00
[NAME] | Unpaid | 2013-01-24 00:00:00 | 2013-01-26 00:00:00
[NAME] | Annual | 2013-02-23 00:00:00 | 2013-03-03 00:00:00
[NAME] | Annual | 2013-04-15 00:00:00 | 2013-04-26 00:00:00