tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: andy_zipper__174__DYNEGY-ICE VOL Apr20
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] | 4 | 90000 |  | Power | [NAME] | 2 | 48800 |  | (blank) | No Activity | 1 | 0
 | [NAME] | 2 | 90000 |  |  | [NAME] | 1 | 800 |  | (blank) Total |  | 1 | 0
US Natural Gas Total |  | 6 | 180000 |  | Power Total |  | 3 | 49600 |  | Grand Total |  | 1 | 0
Grand Total |  | 6 | 180000 |  | Grand Total |  | 3 | 49600
Spreadsheet: errol_mclaughlin_jr__10485__Gas_exceptions
Sheet: Not in prim_sec or benchmark

CURVES NOT IN PRIMARY/SECONDARY MAPPING OR IN BENCHMARK
2001-04-17 00:00:00 | AECO-CND/IM
2001-04-17 00:00:00 | CORNWALL/IM
2001-04-17 00:00:00 | DAWN-CDN/IM
2001-04-17 00:00:00 | EMERSON-ONT/C$
2001-04-17 00:00:00 | FGT-MKTAREA
2001-04-17 00:00:00 | [NAME]
2001-04-17 00:00:00 | GDC-CHI./N/BORD
2001-04-17 00:00:00 | GDC-CHIPPAWA-US
2001-04-17 00:00:00 | GDC-EMERSON/C$
2001-04-17 00:00:00 | GDC-EMERSON-ONT
2001-04-17 00:00:00 | GDC-EMPRESS/DAY
2001-04-17 00:00:00 | GDC-EMPRESUS-DA
2001-04-17 00:00:00 | GD-CIG/RKYMTN
2001-04-17 00:00:00 | GDC-PARKWAY-USI
2001-04-17 00:00:00 | GDC-SOBDR-PG&E
2001-04-17 00:00:00 | GD-DAWN (C$)
2001-04-17 00:00:00 | GDM-ANR/ML7
2001-04-17 00:00:00 | GD-NIAGARA (C$)
2001-04-17 00:00:00 | GDP-FGT/CG
2001-04-17 00:00:00 | GD-PG&E/CITIGAT
2001-04-17 00:00:00 | GDP-MOJAVE
2001-04-17 00:00:00 | GDP-ONG/OKLAHOM
2001-04-17 00:00:00 | GDP-QUESTAR
2001-04-17 00:00:00 | GDP-TRUNKL/SO
2001-04-17 00:00:00 | GDP-TRUNKL/WLA
2001-04-17 00:00:00 | GD-QUESTAR
2001-04-17 00:00:00 | GD-TRCOZ6/NONY
2001-04-17 00:00:00 | [NAME] (C$)
2001-04-17 00:00:00 | IF-PORTLAND
2001-04-17 00:00:00 | NIAGARA-CDN/IM
2001-04-17 00:00:00 | NYMEX
2001-04-17 00:00:00 | STN2-CDN/IM
2001-04-17 00:00:00 | WADD-CDN/IM
Spreadsheet: jeff_dasovich__14198__Tp_1_1
Sheet: Sheet1

"Home" Department | Required Labor Hours per Briefcase | Required Labor Hours per Laptop Case | Total Labor Hours Available in "Home" Department |  |  | Unit. [NAME].
Frame Construction | 0.65 | 0.95 | 6500 |  |  | Haas briefcase | 10
Interior Construction | 0.45 | 0.85 | 6000 |  |  | Haas laptop carrying case | 9
Exterior Construction | 1 | 0.7 | 7000 |  |  | Additional wage/hr | 2
Quality Assurance | 0.15 | 0.3 | 1400 |  |  |  | Briefcase <=70% of TMC production
 | TO
FROM |  |  |  |  | Max Hours Reassignable
 |  | Yes | Yes | No | 400 | hours
 | No |  | Yes | Yes | 800 | hours
 | No | No |  | Yes | 100 | hours
 | Yes | Yes | No |  | 200 | hours
# of briefcases (B) |  | 5956.639566397158 | >= | 0 | <= | 70% of production
# of laptop cases (LC) |  | 2552.845528451415 | >= | 0 |  |  |  |  | Constraint #1 - Non-negativity of changing
 | Total |  |  | [NAME]. briefcase | 0.7 |  |  |  | Constraint #2 - Briefcases only 70% of total production
Transferred from: | To:
FC | IC | 0 | >= | 0
FC | EC | 202.9810298125826 | >= | 0 |  |  | Changing - blue
IC | EC | 540.6504065042964 | >= | 0 |  |  | Target - red
IC | QA | 259.3495934957569 | >= | 0
EC | QA | 0 | >= | 0
QA | FC | 0 | >= | 0
QA | IC | 0 | >= | 0
 | Total Transferred
 |  |  | /hour |  |  | <=====Target cell ([NAME]. Profit)
 | Transfer costs |  | 2005.96
FC-IC+FC-EC |  | <= | 400 | Transferred from fc |  |  |  |  | Constraint #3 - Reassignable used<=Reassignable available
IC-EC+IC-QA |  | <= | 800 | Transferred from ic
EC-QA |  | <= | 100 | Transferred from ec
QA-FC+QA-IC |  | <= | 200 | Transferred from qa
Total hours: |  |  |  |  |  |  |  |  | Calc.
 | fc |  | 6500 + transferred in - transferred out
 | ic |  | 6000 + transferred in - transferred out
 | ec |  | 7000 + transferred in - transferred out
 | qa |  | 1400 + transferred in - transferred out
Total hours constraint:
 |  | <= |  | .65B+.95LC<=total hours fc |  |  |  |  | Constraint #4 - Total hours used <=Total hours available
 |  | <= |  | .45B+.85LC<=total hours ic
 |  | <= |  | 1.0B+.7LC<=total hours ec
 |  | <= |  | .15B+.3LC<=total hours qa
Spreadsheet: 168900d1342625952-index-and-match-book5-index-and-match
Sheet: MI 

Function | First Name | Last Name | FTE | Current Grade | Current Job Title | Work City | Work Building | Current Line Manager Name |  | No Action | Preference Met - 1, 2, 3 | Placed in Group Operations | Placed in Other Division | Role Selected Not Preference | At Risk |  | Briefing Manager | Date of Brief | Comments / Feedback
 | [NAME] | Bond |  |  |  |  |  |  |  |  | 1
 | [NAME] | Moore |  |  |  |  |  |  |  |  | 3
 | Sean Connery | Selby |  |  |  |  |  |  |  |  | 1
 | Timothy | [NAME] |  |  |  |  |  |  |  |  | 2
 |  | Unsuccessful
Spreadsheet: 72689d1273409719-how-to-shift-down-31-rows-everytime-i-copy-a-cell-testing2
Sheet: Comment

Test 1
Before | Not present |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
After | Red colour found |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
Test 2
Before | Not present 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64
After | Blue colour found |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
Test 3
Before | Not present 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97
After | Yellow colour found |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98
Spreadsheet: tracy_geaccone__40535__TWOrgPLFormatCORP02
Sheet: OtherFundsFlow

DETAIL of OTHER FUNDS FLOW
(Millions of Dollars)
 |  | 2002 Activities
 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Other Funds Flow Items
[NAME]. Assets / Liabilities Changes |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.3 |  | 0.2 |  | 0.2 |  | 0.3 |  | 0.3 |  | 0.4 |  | 0.3 |  | 0.3
Change in Deferred Charges |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.1 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.2 |  | -0.1
Change in Deferred Credits |  | 0 |  | 0 |  | 0 |  | -0.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -0.1
Plant / Depreciation Retirement Issues |  | -0.1 |  | -0.1 |  | -0.1 |  | 0 |  | 0 |  | -0.1 |  | -0.1 |  | 0 |  | -0.1 |  | -0.1 |  | 0 |  | -0.1
Gain / (Loss) Offset |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Proceeds Offset |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
FASB 133 - Comprehensive Income / (Loss) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Current Liability Reserve Activity |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x
Miscellaneous
Other Funds Flow (line 101)
Spreadsheet: 1175247e-e005-4267-887c-ab23daeaa8b5
Sheet: Sheet1

MATTEL, INC. AND SUBSIDIARIES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | EXHIBIT I | Unnamed: 25
CONSOLIDATED STATEMENTS OF OPERATIONS (Unaudited)
 |  |  |  |  |  | For the Three Months Ended September 30, |  |  |  |  |  |  |  |  |  |  | For the Nine Months Ended September 30,
(In millions, except per share and |  |  |  |  |  | 2010 |  |  |  | 2009 |  |  |  | Yr / Yr |  |  | 2010 |  |  |  | 2009 |  |  |  | Yr / Yr
percentage information) |  |  |  |  |  | $ Amt |  | % Net Sales |  | $ Amt |  | % Net Sales |  | % Change |  |  | $ Amt |  | % Net Sales |  | $ Amt |  | % Net Sales |  | % Change
Net Sales |  |  |  |  | $ | 1833.1 |  |  | $ | 1791.9 |  |  |  | 0.02 |  | $ | 3731.6 |  |  | $ | 3475.7 |  |  |  | 0.07
Cost of sales |  |  |  |  |  | 895.6 |  | 0.489 |  | 873.3 |  | 0.487 |  | 0.03 |  |  | 1872.6 |  | 0.502 |  | 1805.2 |  | 0.519 |  | 0.04
Gross Profit |  |  |  |  |  | 937.5 |  | 0.511 |  | 918.6 |  | 0.513 |  | 0.02 |  |  | 1859 |  | 0.498 |  | 1670.5 |  | 0.481 |  | 0.11
Advertising and promotion expenses |  |  |  |  |  | 201.6 |  | 0.11 |  | 197.1 |  | 0.11 |  | 0.02 |  |  | 397.7 |  | 0.107 |  | 371 |  | 0.107 |  | 0.07
Other selling and administrative expenses |  |  |  |  |  | 377.3 |  | 0.206 |  | 385 |  | 0.215 |  | -0.02 |  |  | 988 |  | 0.265 |  | 985.7 |  | 0.284 |  | 0
Operating Income |  |  |  |  |  | 358.6 |  | 0.196 |  | 336.5 |  | 0.188 |  | 0.07 |  |  | 473.3 |  | 0.127 |  | 313.8 |  | 0.09 |  | 0.51
Interest expense |  |  |  |  |  | 13.8 |  | 0.008 |  | 19.3 |  | 0.011 |  | -0.28 |  |  | 40.9 |  | 0.011 |  | 52.7 |  | 0.015 |  | -0.22
Interest (income) |  |  |  |  |  | -1.8 |  | -0.001 |  | -1.5 |  | -0.001 |  | 0.22 |  |  | -7.1 |  | -0.002 |  | -7.5 |  | -0.002 |  | -0.06
Other non-operating expense (income), net |  |  |  |  |  | - |  |  |  | 14.1 |  |  |  |  |  |  | -2.5 |  |  |  | 5.6
Income Before Income Taxes |  |  |  |  |  | 346.6 |  | 0.189 |  | 304.6 |  | 0.17 |  | 0.14 |  |  | 442 |  | 0.118 |  | 263 |  | 0.076 |  | 0.68
Provision for income taxes |  |  |  |  |  | 63.3 |  |  |  | 74.8 |  |  |  |  |  |  | 82.3 |  |  |  | 62.7
Net Income |  |  |  |  | $ | 283.3 |  | 0.155 | $ | 229.8 |  | 0.128 |  | 0.23 |  | $ | 359.7 |  | 0.096 | $ | 200.3 |  | 0.058 |  | 0.8
EPS - Basic |  |  |  |  | $ | 0.78 |  |  | $ | 0.63 |  |  |  |  |  | $ | 0.98 |  |  | $ | 0.55
Average Number of Common Shares |  |  |  |  |  | 360.6 |  |  |  | 360.8 |  |  |  |  |  |  | 362.2 |  |  |  | 359.5
EPS - Diluted |  |  |  |  | $ | 0.77 |  |  | $ | 0.63 |  |  |  |  |  | $ | 0.97 |  |  | $ | 0.55
Average Number of Common and
Potential Common Shares |  |  |  |  |  | 363.5 |  |  |  | 361.9 |  |  |  |  |  |  | 365.4 |  |  |  | 360.3
Spreadsheet: 842100d1694170054-sumifs-v-sumproduct-example
Sheet: Sheet1

 |  |  |  |  | correct |  |  |  | Data
 |  |  |  |  |  |  | Criteria |  | A | B | A | C | D
 |  |  |  |  |  |  | A |  | 7 | 4 | 3 | 8 | 1
 |  |  | SumProduct |  |  |  | B
 |  |  | [NAME]
 |  |  |  |  | Not working
Spreadsheet: 14f93eff-6033-457e-bdda-537ff33efdc8
Sheet: EPR Rev Stats

Supplemental Data (Unaudited)
 | Periods Ended September 30,
Revenue Metrics | Fourth Quarters |  |  | Years
 | 2013 | 2012 |  | 2013 | 2012
In millions, unless otherwise noted
Gaming Operations
Revenues | 247.1 | 263.8 |  | 991.4000000000001 | 1040
North America | 211.2 | 229.6 |  | 854.2 | 907.8
International | 35.90000000000001 | 34.2 |  | 137.2 | 132.2
Gross margin | 0.63 | 0.61 |  | 0.62 | 0.61
North America | 0.62 | 0.6 |  | 0.61 | 0.6
International | 0.69 | 0.71 |  | 0.69 | 0.7
Installed base (units '000) | 54.60000000000001 | 57.10000000000001 |  | 54.60000000000001 | 57.10000000000001
North America | 41.40000000000001 | 43.40000000000001 |  | 41.40000000000001 | 43.40000000000001
International | 13.2 | 13.7 |  | 13.2 | 13.7
Yield (average revenue per unit per day - $0.00) | 48.78 | 50.83 |  | 48.74 | 51.49
Product Sales
Revenues | 312.2 | 313.4 |  | 1085.2 | 966.8000000000001
North America | 215.6 | 224.2 |  | 759.8 | 648.2
International | 96.60000000000001 | 89.19999999999999 |  | 325.4 | 318.6
Machines | 217.7 | 217.5 |  | 755.5 | 653.5
North America | 145.3 | 152.9 |  | 519.4 | 421.3
International | 72.4 | 64.6 |  | 236.1 | 232.2
Non-machine | 94.5 | 95.9 |  | 329.7 | 313.3
North America | 70.3 | 71.3 |  | 240.4 | 226.9
International | 24.2 | 24.6 |  | 89.3 | 86.4
Gross margin | 0.5 | 0.56 |  | 0.52 | 0.54
North America | 0.51 | 0.58 |  | 0.54 | 0.57
International | 0.48 | 0.49 |  | 0.48 | 0.49
Machine units recognized ('000) | 18.8 | 14.5 |  | 57.2 | 43.6
North America | 13.9 | 10.4 |  | 42.2 | 29.1
International | 4.9 | 4.1 |  | 15 | 14.5
Machine units shipped ('000) [includes units where revenues deferred] | 18.4 | 14.6 |  | 55.6 | 44.2
North America | 13.4 | 10.4 |  | 41.7 | 29.3
New | 1.9 | 1.9 |  | 8.8 | 7.3
Replacement | 11.5 | 8.5 |  | 32.9 | 22
International | 5 | 4.2 |  | 13.9 | 14.9
New | 2.1 | 1.2 |  | 4.8 | 5.6
Replacement | 2.9 | 3 |  | 9.1 | 9.3
Machine ASP ('000) | 11.6 | 15 |  | 13.2 | 15
North America | 10.5 | 14.7 |  | 12.3 | 14.5
International | 15 | 15.8 |  | 15.8 | 16
Interactive
Revenues | 73 | 53.89999999999999 |  | 265 | 143.9
North America | 62.3 | 36.09999999999999 |  | 221.1 | 88.1
International | 10.7 | 17.8 |  | 43.9 | 55.8
Social Gaming | 61.4 | 35.8 |  | 218.5 | 87
North America | 61.4 | 35.8 |  | 218.5 | 87
International | 0 | 0 |  | 0 | 0
IGTi | 11.6 | 18.1 |  | 46.5 | 56.9
North America | 0.9 | 0.3 |  | 2.6 | 1.1
International | 10.7 | 17.8 |  | 43.9 | 55.8
Gross margin | 0.62 | 0.62 |  | 0.61 | 0.56
North America | 0.63 | 0.61 |  | 0.62 | 0.61
International | 0.55 | 0.64 |  | 0.57 | 0.49
DoubleDown average user statistics*
DAU (Daily active users) ('000) | 1705 | 1415 |  | 1636 | 1372
MAU (Monthly active users) ('000) | 6720 | 5072 |  | 6141 | 5097
Bookings per DAU ($0.00) | 0.4 | 0.28 |  | 0.37 | 0.26
*as a single application with multiple games, active users equal unique users
Spreadsheet: 771296d1646594435-name-check-data-validation-formula-writer-data-extraction2
Sheet: Sheet3

[NAME] (MA) Trotter (CR) | [NAME] (MA) Trotter (CR) | (Trotter (CR), [NAME]) |  | Yes
[NAME] (MA) Trotter (CR) | [NAME] (MA) Trotter (CR) | (Trotter (CR), [NAME]) |  | Yes
[NAME] (MA) Trotter (CR) | [NAME] (MA) Trotter (CR) | (Trotter (CR), [NAME]) |  | Yes
[NAME] (MA) Trotter (CR) | [NAME] (CR) | (Trotter (CR), [NAME]) |  | NO
[NAME] (MA) Trotter (CR) | [NAME] (MA) Trotter (CR) | (Trotter (CR), [NAME]) |  | Yes
[NAME] (MA) Trotter (CR) | [NAME] (CR) | (Roper (CR), [NAME]) |  | NO
[NAME] (MA) Trotter (CR) | [NAME] (MA) Trotter (CR) | (Trotter (CR), [NAME]) |  | Yes
[NAME] (MA) Trotter (CR) | [NAME] (MA) Trotter (CR) | (Trotter (CR), [NAME]) |  | Yes
[NAME] (MA) Trotter (CR) | [NAME] (MA) Trotter (CR) | (Trotter (CR), [NAME]) |  | Yes
[NAME] (CR) | [NAME] (CR) | (Rigsby (CR), [NAME]) |  | Yes
[NAME] (CR) | [NAME] (MA) Trotter (CR) | (Rigsby (CR), [NAME]) |  | NO
[NAME] (CR) | [NAME] (CR) | (Rigsby (CR), [NAME]) |  | Yes
[NAME] (CR) | [NAME] (CR) | [NAME] (MA) Trotter (CR) |  | NO
[NAME] (CR) | [NAME] (CR) | (Rigsby (CR), [NAME])
[NAME] (CR) | [NAME] (CR) | (Rigsby (CR), [NAME])
[NAME] (CR) | [NAME] (CR) | (Roper (CR), [NAME])
[NAME] (CR) | [NAME] (CR) | (Roper (CR), [NAME])
[NAME] (CR) | [NAME] (CR) | [NAME] (MA) Trotter (CR) |  | NO
[NAME] (CR) | [NAME] (CR) | (Roper (CR), [NAME])
[NAME] (CR) | [NAME] (CR) | (Roper (CR), [NAME])
[NAME] (CR) | [NAME] (CR) | (Roper (CR), [NAME])
[NAME] (CR) | [NAME] (CR) | (Roper (CR), [NAME])
[NAME] (CR) | [NAME] (CR) | (Rigsby (CR), [NAME]) |  | NO
[NAME] (CR) | [NAME] (CR) | (Roper (CR), [NAME])
Spreadsheet: 136719d1326806796-consolidate-data-into-a-single-column-formula-result
Sheet: Sheet1

Parent | Child |  |  | Parent | Child
AA | A1
AA | A2
AA | A3
AA | A4
AA | A5
BB | A1
BB | B2
BB | B3
CC | A1
DD | B1
CC | B1
DD | B2
CC | B3
A1 | Z1
A1 | [NAME]
Spreadsheet: 62647d1263556306-distribution-of-data-from-different-dates-713529_raoul_duke
Sheet: PT_Chart

Article Title | (All)
Producer | (All)
Tag | (All)
Values
Sum of Mth 1 | 1.507583393563888
Sum of Mth 2 | 1.841675943734559
Sum of Mth 3 | 2.478853879127186
Sum of Mth 4 | 2.262190678061502
Sum of Mth 5 | 2.364095240852253
Sum of Mth 6 | 2.14598769721367
Sum of Mth 7 | 2.039336950118109
Sum of Mth 9 | 2.02139544669747
Sum of Mth 8 | 2.007525783884222
Sum of Mth 10 | 1.644165983148926
Sum of Mth 11 | 1.859534827324716
Sum of Mth 12 | 1.734939018825014
Sum of Mth 13 | 1.286350662846945
Sum of Mth 14 | 0.972053748320342
Sum of Mth 15 | 0.7817256288792316
Sum of Mth 16 | 0.736260073802771
Sum of Mth 17 | 0.5135813560971747
Sum of Mth 18 | 0.6004580587178039
Sum of Mth 19 | 0.6286031563220238
Sum of Mth 20 | 0.4419912871675827
Sum of Mth 21 | 0.6079183693835873
Sum of Mth 22 | 0.5237728159110215
Spreadsheet: 50741d1250198044-how-to-switch-or-rotate-charactor-question
Sheet: Question

 | Question : please searching character below for correct group ?
 |  |  |  |  |  |  |  |  | 1
 | Group # 1 |  |  |  | Group # 2 |  |  |  | Group # 3
1 | HLR |  |  |  | ZXOSTZXOST |  |  |  | UUUUUXXXXX
 | HZU | HXU | HOU | HSU | HTU | HZX | HXX | HOX | HSX | HTX |  |  |  | 33333
 | LZU | LXU | LOU | LSU | LTU | LZX | LXX | LOX | LSX | LTX
 | RZU | RXU | [NAME] | RSU | RTU | RZX | RXX | ROX | RSX | RTX
 | Group # 1 |  |  |  | Group # 2 |  |  |  | Group # 3
2 | RSTUW |  |  |  | GHTO |  |  |  | KYU
 | RGK | RHK | RTK | ROK | RGY | RHY | RTY | ROY | RGU | RHU | RTU | [NAME]
 | SGK | SHK | STK | SOK | SGY | SHY | STY | SOY | SGU | SHU | STU | SOU
 | TGK | THK | TTK | TOK | TGY | THY | TTY | TOY | TGU | THU | TTU | TOU
 | UGK | UHK | UTK | UOK | UGY | UHY | UTY | UOY | UGU | UHU | UTU | UOU
 | WGK | WHK | WTK | WOK | WGY | WHY | WTY | WOY | WGU | WHU | WTU | WOU
 | Group # 1 |  |  |  | Group # 2 |  |  |  | Group # 3
3
 | KPV | KAV | KLV | KUV | KPZ | KAZ | KLZ | KUZ | KPT | KAT | KLT | KUT
 | GPV | GAV | GLV | GUV | GPZ | GAZ | GLZ | GUZ | GPT | GAT | GLT | GUT
 | HPV | HAV | HLV | HUV | HPZ | HAZ | HLZ | HUZ | HPT | HAT | HLT | HUT
 | MPV | MAV | MLV | MUV | MPZ | MAZ | MLZ | MUZ | MPT | MAT | MLT | MUT
 | KPK | KAK | KLK | KUK
 | GPK | GAK | GLK | GUK
 | HPK | HAK | HLK | HUK
 | MPK | MAK | MLK | MUK
 |  | Score : |  |  |  |  |  | Name :
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: TX-HPLC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  [NAME]
 |  |  | 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 | 53851393 | 231073644
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 531200 | 2195040
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 54382593 | 233268684
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -61030753 | -260483091
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -1345522 | -5615570
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 8963 | 37729
 | Total Purchases: |  | -62367312 | -266060932
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 84958346 | 364399214
12 |  | Purchases | -83346867 | -357411158
 | Total Intra CTS Sales / Purchases |  | 1611479 | 6988056
 |  |  | 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) | 3036024 | 13255287
18 |  | W/D (Purchase from Stg) | -2569968 | -11256460
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -2569968 | -11256460
 | Total Storage: |  | 466056 | 1998827
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 5907184 | 25298922.0180411
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -1907166
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -1907166
 |  |  | 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 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: joe_quenet__15083__PJM
Sheet: DJ PJM Electricity Index

 | DATE |  |  |  | Firm On Peak |  | MW |  | [NAME]
 | 2001-10-25 00:00:00 |  |  |  | 26.75 |  | 2350 |  | 37600
 | 2001-10-24 00:00:00 |  |  |  | 26.31 |  | 1950 |  | 31200
 | 2001-10-23 00:00:00 |  |  |  | 24.48 |  | 2150 |  | 34400
 | 2001-10-22 00:00:00 |  |  |  | 25.31 |  | 1350 |  | 21600
 | 2001-10-21 00:00:00
 | 2001-10-20 00:00:00
 | 2001-10-19 00:00:00 |  |  |  | 25.5 |  | 1250 |  | 20000
 | 2001-10-18 00:00:00 |  |  |  | 26.93 |  | 2600 |  | 41600
 | 2001-10-17 00:00:00 |  |  |  | 25.28 |  | 2750 |  | 44000
 | 2001-10-16 00:00:00 |  |  |  | 26.48 |  | 900 |  | 14400
 | 2001-10-15 00:00:00 |  |  |  | 26.31 |  | 1050 |  | 16800
 | 2001-10-14 00:00:00
 | 2001-10-13 00:00:00
 | 2001-10-12 00:00:00 |  |  |  | 23.51 |  | 2100 |  | 33600
 | 2001-10-11 00:00:00 |  |  |  | 23.98 |  | 1350 |  | 21600
 | 2001-10-10 00:00:00 |  |  |  | 25.31 |  | 1800 |  | 28800
 | 2001-10-09 00:00:00 |  |  |  | 28.25 |  | 1800 |  | 28800
 | 2001-10-08 00:00:00 |  |  |  | 29.17 |  | 3850 |  | 61600
 | 2001-10-07 00:00:00
 | 2001-10-06 00:00:00
 | 2001-10-05 00:00:00 |  |  |  | 28.6 |  | 1950 |  | 31200
 | 2001-10-04 00:00:00 |  |  |  | 28.93 |  | 1350 |  | 21600
 | 2001-10-03 00:00:00 |  |  |  | 27.5 |  | 900 |  | 14400
 | 2001-10-02 00:00:00 |  |  |  | 26.01 |  | 1000 |  | 16000
 | 2001-10-01 00:00:00 |  |  |  | 24.71 |  | 2050 |  | 32800
 | 2001-09-30 00:00:00
 | 2001-09-29 00:00:00
 | 2001-09-28 00:00:00 |  |  |  | 23.73 |  | 3450 |  | 55200
 | 2001-09-27 00:00:00 |  |  |  | 24.58 |  | 3200 |  | 51200
 | 2001-09-26 00:00:00 |  |  |  | 25.14 |  | 3600 |  | 57600
 | 2001-09-25 00:00:00 |  |  |  | 25.91 |  | 3650 |  | 58400
Spreadsheet: 784356d1655673296-amend-formula-to-take-other-conditions-into-account-test1
Sheet: Info

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B&b | Morning/Night | First/Last | DormBnt Periods |  | Rest | Data Check | Data Check |  | HH | MM | SS
Spreadsheet: 832073d1686104369-look-up-3-names-in-cell-and-return-another-column-when-true-sample-workbook
Sheet: Sheet1

Name (reference) | Class (desired result if true) |  |  | FamilyName | FirstName | Middle Name | 1st Class Found | 2nd Class Found | 3rd Class Found | Total Classes Found
Diamond Agnes Agnes | xxs |  |  | Diamond | Agnes | Agnes |  |  |  |  |  |  | Sample of Desired Results
Blacksmith Amanda Agnes | yty |  |  | Diamond | Christina
Pashagumskum April Masty | zzz |  |  | Pashagumskum | April
Forward [NAME] | abu |  |  |  | [NAME] | April
Loon Brant Agnes | bio |  |  | Loon | Brant | Agnes
Moses Christina Daniel | cc |  |  | Moses | Christina | [NAME]
Masty [NAME] | xxs |  |  | Masty | [NAME] | Brant
[NAME] | yty |  |  | Ortepi | [NAME] | [NAME]
[NAME] [NAME] | xxs |  |  | [NAME] | [NAME] | April
Rodrique Elma Enomey | yty |  |  | Rodrique | Elma | Enomey
[NAME] | abu |  |  | Herodier | Enomey | Brant
Gagnon Frances | zzz |  |  | Gagnon | Frances
Shecapio Frédéric [NAME] | abu |  |  | Shecapio | Frédéric | [NAME]
Lafond George | bio |  |  | Lafond | George | Frédéric
Pashagumskum April Barbara | xxs |  |  | Linklater | Ghislain | Brant
Gull Greta April Barb | dre |  |  | Gull | Greta | April
Jackson-Lambert Jamie Christina | xxs |  |  | Jackson-Lambert | [NAME]
[NAME] | abu |  |  | [NAME] | Jayme
[NAME]) [NAME] | xxs |  |  | [NAME] |  | Agnes
Diamond Agnes Agnes Moar | xxs |  |  | Matoush | [NAME] | George
[NAME] | yty |  |  | Matoush | Kenny | [NAME]
Cheezo [NAME] April Barbara | cc
[NAME] | cc
Jolly [NAME] | bio
Diamond Agnes Agnes | bio
Shecapio Frédéric Eleanor [NAME] April | bio