tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30657__9911_OA
Sheet: TX-HPLR-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  HPLR
 |  |  | 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 | -1089399 | -567411.3600000143
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | -15000 | -44650
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 120000
 | Total Sales: |  | -1104399 | -492061.3600000143
 | Purchases:
6 |  | 3rd Party / Inter Enron | 120147 | 3111548
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 11290 | 27847.60000000009
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | -74 | -186.2900000000009
 | Total Purchases: |  | 131363 | 3139209.31
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | -5967750 | -17708650.78
12 |  | Purchases | 5967750 | 17708652.7
 | Total Intra CTS Sales / Purchases |  | 0 | 1.919999998062849
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 45000 | 136350
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 45000 | 136350
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 928036 | 2697352.888982255
23 | Fuel: |  | 80 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
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: 268502d1380657232-trying-to-create-a-template-for-scoring-a-test-sample-test
Sheet: Sheet1

 | Answer Key | Student 1 | Score | Student 2 | Score | Student 3 | Score
Does Christmas takes place in December? | Yes | Yes |  | Yes |  | No
Does a square have 4 sides? | Yes | Yes |  | No |  | Yes
Is it illegal to steal someone else's property? | Yes | Yes |  | Yes |  | No
 |  | Total |  | Total |  | Total
Spreadsheet: 792226d1660790716-find-detail-value-according-to-customer-code-find-detail-value-according-to-customer-code-1-
Sheet: Sheet1

Time | Invoice | Customer code | Name | Product | Quantity | Invoice helper |  | Result
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | Bánh quy | 1
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | 3 |  |  | Customer code | Name | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity | Invoice | Product | Quantity
2022-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] socola | 4 |  |  | [NAME]
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa | [NAME] ngọt | 1 |  |  | KH009
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa | Bánh sữa | 2
2022-01-02 00:00:00 | A09100 | KH009 | Anh Hòa | [NAME] | 4
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | [NAME] ngọt | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | [NAME] socola | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh láng | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-03 00:00:00 | A03100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | [NAME] ngọt | 9
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | [NAME] | 4
2022-01-04 00:00:00 | A04100 | [NAME] | [NAME] | Bánh nhân | 3
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa | Bánh nhân | 2
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa | Bánh sữa | 5
2022-01-04 00:00:00 | A05100 | KH009 | Anh Hòa | Bánh sữa | 6
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh quy | 1
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh quy | 2
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | [NAME] ngọt | 3
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | [NAME] ngọt | 4
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh dứa | 5
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh nhân | 8
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh chíp | 9
2022-01-04 00:00:00 | A06100 | [NAME] | [NAME] | Bánh bông lan | 5
2022-02-01 00:00:00 | A01200 | [NAME] | [NAME] | Bánh gối | 10
2022-02-02 00:00:00 | A02200 | [NAME] | [NAME] | [NAME] ngọt | 1
2022-02-03 00:00:00 | A03200 | [NAME] | [NAME] | Bánh sữa | 10
2022-02-05 00:00:00 | A11200 | KH009 | Anh Hòa | Bánh côcla | 10
2022-02-12 00:00:00 | A12200 | [NAME] | [NAME] | [NAME] ngọt | 1
2022-02-15 00:00:00 | A15200 | [NAME] | [NAME] | Bánh sữa | 10
Spreadsheet: benjamin_rogers__1018__benRogers
Sheet: Sheet1

 |  | Date | Fixed [NAME]**
 |  |  | ** in thousand $
 |  | 2000-04-01 00:00:00 | 0
 |  | 2000-10-01 00:00:00 | 986.9738361779238
 |  | 2001-04-01 00:00:00 | 1395.697067513363
 |  | 2001-10-01 00:00:00 | 1395.697067513363
 |  | 2002-04-01 00:00:00 | 1421.232076954503
 |  | 2002-10-01 00:00:00 | 1421.232076954503
 |  | 2003-04-01 00:00:00 | 1329.059960522437
 |  | 2003-10-01 00:00:00 | 1329.059960522437
 |  | 2004-04-01 00:00:00 | 1357.462889049445
 |  | 2004-10-01 00:00:00 | 1357.462889049445
 |  | 2005-04-01 00:00:00 | 1359.731497071438
 |  | 2005-10-01 00:00:00 | 1359.731497071438
 |  | 2006-04-01 00:00:00 | 1411.470695762109
 |  | 2006-10-01 00:00:00 | 1411.470695762109
 |  | 2007-04-01 00:00:00 | 1466.389310128405
 |  | 2007-10-01 00:00:00 | 1466.389310128405
 |  | 2008-04-01 00:00:00 | 1499.18607839798
 |  | 2008-10-01 00:00:00 | 1499.18607839798
 |  | 2009-04-01 00:00:00 | 1524.560847373237
 |  | 2009-10-01 00:00:00 | 1524.560847373237
 |  | 2010-04-01 00:00:00 | 1559.622681010637
 |  | 2010-10-01 00:00:00 | 1559.622681010637
 |  | 2011-04-01 00:00:00 | 1587.914968525329
 |  | 2011-10-01 00:00:00 | 1587.914968525329
 |  | 2012-04-01 00:00:00 | 1587.914968525329
 |  | 2012-10-01 00:00:00 | 1587.914968525329
 |  | 2013-04-01 00:00:00 | 1649.590750471445
 |  | 2013-10-01 00:00:00 | 1649.590750471445
 |  | 2014-04-01 00:00:00 | 1703.355699274464
 |  | 2014-10-01 00:00:00 | 1703.355699274464
 |  | 2015-04-01 00:00:00 | 1758.22910371611
 |  | 2015-10-01 00:00:00 | 1758.22910371611
 |  | 2016-04-01 00:00:00 | 1814.324897347092
 |  | 2016-10-01 00:00:00 | 1814.324897347092
 |  | 2017-04-01 00:00:00 | 1855.946043120275
 |  | 2017-10-01 00:00:00 | 1855.946043120275
 |  | 2018-04-01 00:00:00 | 1903.257293234389
 |  | 2018-10-01 00:00:00 | 1903.257293234389
 |  | 2019-04-01 00:00:00 | 1919.47906836522
 |  | 2019-10-01 00:00:00 | 1919.47906836522
 |  | 2020-04-01 00:00:00 | 0
 |  | 2020-10-01 00:00:00 | 0
Spreadsheet: fb0f50d6-5e28-4a62-9798-ca6d138772c9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Lidmodeļu sacensību 2012. [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Nosaukums | Klases |  |  |  |  | Datums |  | Vieta | Dienas | Atbildiga persona
[NAME] atklātais Čempionāts |  |  |  |  | F1D, F4F | 2012-01-28 00:00:00 |  | Rubene | 1 | Gunars Puriņš
[NAME] tehniķu centra kausa izcīņa |  |  |  |  | F1D, F4F | 2012-02-18 00:00:00 |  | [NAME] | 1 | [NAME]
Latvijas jaunatnes čempionāts |  |  |  |  | F1D, F4F | 2012-03-10 00:00:00 |  | Rubene | 1 | [NAME]
[NAME] atklātā čempionātā 3. posms |  |  |  |  | H-600 | 2012-04-21 00:00:00 |  | Valmiera | 1 | Gunars Puriņš
[NAME] atklātā čempionātā 1. posms |  | [NAME] |  |  |  | 2012-04-28 00:00:00 |  | Cesis | 1 | Gunars Puriņš
[NAME] atklātā čempionātā 4. posms |  |  |  |  | H-600 | 2012-05-12 00:00:00 |  | Valmiera | 1 | Gunars Puriņš
Atklāto Rīgas pilsētas skolēnu  [NAME] |  | [NAME] |  |  | H-600 | 2012-05-19 00:00:00 |  | [NAME] | 1 | [NAME]
"Mazeiku" CUP | F3J | [NAME] |  |  |  | 2012-05-19 00:00:00 | 2012-05-20 00:00:00 | Lietuva | 2
"Edvin Cup" | F3J | [NAME] | F5J |  |  | 2012-05-26 00:00:00 | 2012-05-27 00:00:00 | Riidaja (Esti) | 2
[NAME] atklātā čempionātā 2. posms |  | [NAME] |  |  |  | 2012-06-02 00:00:00 |  | Valmiera | 1 | Gunars Puriņš
"Nakotne CUP" | F3J | [NAME] |  |  |  | 2011-06-16 00:00:00 | 2011-06-17 00:00:00 | Cesis | 2 | Nakotnes Vanagi
«Белые Ночи» | F3J | [NAME] |  |  |  | 2012-06-09 00:00:00 | 2012-06-10 00:00:00 | [NAME] (Russia) | 4
"Alytaus taurė" Eurotur, Baltic Open | F3J | [NAME] |  | F3A |  | 2012-07-14 00:00:00 | 2012-07-15 00:00:00 | Alitus (Lietuva) | 2
German Open, Eurotur |  | [NAME] |  |  |  | 2012-07-20 00:00:00 | 2012-07-22 00:00:00 | Vācija | 3
European Championship |  | [NAME] |  |  |  | 2012-08-11 00:00:00 | 2012-08-19 00:00:00 | Chamblay (Francija) | 8
[NAME] | F3J |  |  |  |  | 2012-08-25 00:00:00 |  | Ropaži | 1 | [NAME]
[NAME] posms |  |  |  |  | F1 | 2012-08-25 00:00:00 | 2012-08-26 00:00:00 | Tukums | 2
[NAME] atklātā čempionāts 3. posms |  | [NAME] |  |  |  | 2012-09-01 00:00:00 |  | Valmiera | 1 | Gunars Puriņš
[NAME] posms |  |  |  |  | F1 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | Tukums | 2
[NAME] |  | [NAME] |  |  |  | 2012-09-29 00:00:00 |  | [NAME] | 1 | [NAME]
Latvijas jaunatnes Čempionāts |  |  |  |  | F1 | 2012-09-15 00:00:00 | 2012-09-16 00:00:00 | Tukums | 2
[NAME] |  |  |  |  | F1 | 2012-09-22 00:00:00 | 2012-09-23 00:00:00 | Tukums | 2
[NAME] atklātā čempionāts 1. posms |  |  |  |  | H-600 | 2012-10-20 00:00:00 |  | Valmiera | 1 | Gunars Puriņš
Atklāto Rīgas pilsētas skolēnu  [NAME] |  | [NAME] |  |  | H-600 | 2011-10-29 00:00:00 | ? | [NAME] | 1 | Annas2
[NAME] atklātā čempionāts 2. posms |  |  |  |  | H-600 | 2012-12-08 00:00:00 |  | Valmiera | 1 | Gunars Puriņš
Baltic Open F3J (3/4 cup)
Baltic Open F3K (3/4 cup)
[NAME]
Spreadsheet: 883312d1731921940-rolling-subtraction-of-numbers-ongoing-contribution-history-carry-forward-wip-
Sheet: Non-Concessional

 | Summary |  |  |  | Complete
 | Total NCC Recorded |  |  |  | Reference
 | ATO Figure (Used) |  |  |  | Calculated
 | [NAME]
 | Status
 | Non- Concessional Contribution Contribution History
 | Start Date | End Date | NCC Made | NCC (Claimed NoI) | NCC Retained | [NAME] | Available (less Bring Forward) | Bring Forward Triggered | Bring Forward Amount | Bring Forward Year | [NAME] | Space | ATO Portal Checked | ATO Figure (Used) | [NAME] | Date Verified | Notes
 | 2018-07-01 00:00:00 | 2019-06-30 00:00:00 |  |  |  | 100000
 | 2019-07-01 00:00:00 | 2020-06-30 00:00:00 |  |  |  | 100000
 | 2020-07-01 00:00:00 | 2021-06-30 00:00:00 |  |  |  | 100000
 | 2021-07-01 00:00:00 | 2022-06-30 00:00:00 |  |  |  | 110000
 | 2022-07-01 00:00:00 | 2023-06-30 00:00:00 |  |  |  | 110000
 | 2023-07-01 00:00:00 | 2024-06-30 00:00:00 |  |  |  | 110000
 | 2024-07-01 00:00:00 | 2025-06-30 00:00:00 |  |  |  | 120000
Spreadsheet: 96386d1295804971-connect-database-dog
Sheet: Sheet2

Dog Name | DOB | Age | Reg Number | [NAME] | [NAME] | [NAME]
Diesel | 2010-06-09 00:00:00 | 155 | 1234B | Sue | 67 Acacia Ave | 12388966
Digger | 2010-06-09 00:00:00 | 510 | 1234567E | [NAME] | 70 Acacia Ave | 12388966
[NAME] | 2007-09-11 00:00:00 | 169 | 12345C | [NAME] | 68 Acacia Ave | 12388966
Toby | 1973-12-17 00:00:00 | 103 | 123A | [NAME] | 66 Acacia Ave | 12388966
Zero | 1973-12-17 00:00:00 | 200 | 123456D | [NAME] | 69 Acacia Ave | 12388966
Spreadsheet: 723666d1615826133-how-to-return-multiple-column-headers-based-on-a-difference-column-headers-based-on-differences-in-values-jayidhh-
Sheet: Week 2

 | Balance Of Remuneration | [NAME] | Family Leave | [NAME] | Irregular payment | Net Pay | q | Overtime 1.5 | Overtime 2.0 | Pay as you [NAME] | Performance bonus | Salary Cost | [NAME] | Skills Development Levy | r | Sunday Wage | Sundry Deduction | Total Company Contributions | Total Deductions | Total Earnings | Unemployment Insurance Fund | Unemployment Insurance Fund | Wage Hourly
 | Totals | Earning | Earning | Deduction | Earning | Totals | Deduction | Earning | Earning | Deduction | Earning | Totals | Earning | Company Contribution | Deduction | Earning | Deduction | Totals | Totals | Totals | Company Contribution | Deduction | Earning
Number 1 | 2445 | 0 |  | 0 |  | 2268 | 0 | 787.5 | 0 | 152.45 |  | 2493.9 | 0 | 24.45 | 0 | 517.5 | 0 | 48.9 | 176.9 | 2445 | 24.45 | 24.45 | 1140
Spreadsheet: 257bb1d3-0603-4bec-b624-70c14a9e2a71
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-05-13 09:22:56.410000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.654 | 102.529 | 102.404 | 102.029
4.5 | 102.117 | 101.992 | 101.867 | 101.492 |  | Note: | Refer To Price [NAME]
4.375 | 101.541 | 101.416 | 101.291 | 100.916 |  |  | For all Price Adjs
4.25 | 100.933 | 100.808 | 100.683 | 100.058
4.125 | 100.079 | 99.954 | 99.829 | 99.204
4 | 99.066 | 98.941 | 98.816 | 98.191
3.875 | 98.013 | 97.888 | 97.763 | 97.138
3.75 | 97.138 | 97.013 | 96.888 | 96.263
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.589 | 102.464 | 102.339 | 101.964
3.625 | 102.19 | 102.065 | 101.94 | 101.565
3.5 | 101.633 | 101.508 | 101.383 | 101.008
3.375 | 100.907 | 100.782 | 100.657 | 100.032
3.25 | 100.156 | 100.031 | 99.906 | 99.281
3.125 | 99.489 | 99.364 | 99.239 | 98.614 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-05-27 09:22:56.410000
30 DAY | 2014-06-11 09:22:56.410000
45 DAY | 2014-06-26 09:22:56.410000
60 DAY | 2014-07-11 09:22:56.410000
90 DAY | 2014-08-10 09:22:56.410000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 594b07d9-1de6-4cc2-b64f-dda6b1360abf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Directions:  Fill in the Yellow cells on other pages, the rest is done automatically.
 | Monthly | Annual
Budget Summary: | Budget | Amount | %
Total Income | 0 | 0
Less: Necessary Expenses | 0 | 0
Discretionary Income | 0 | 0
Less: Investment Spending | 0 | 0
Discretionary Income less Investments | 0 | 0
Less: Discretionary Spending | 0 | 0
Amount remaining to save or invest | 0 | 0
Spreadsheet: 858943d1707417269-calculate-of-minutes-until-4pm-book1
Sheet: Sheet1

11:17:00
12:43:00
14:09:00
15:35:00
17:01:00
18:27:00
19:53:00
21:19:00
22:45:00
00:11:00
01:37:00
03:03:00
04:29:00
05:55:00
Spreadsheet: 740091d1626183766-sheet-named-range-lookup-indirect-function-syntax-multiple-page-lookup
Sheet: Sub and Supps List

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  | Customer Code | Subcontractor | Address | Sub Contact |  |  |  |  | Production Contact |  |  |  |  | Logistics Contact |  |  |  |  | Accounts Contact |  |  |  |  | Sub Contact |  |  |  |  | Production Contact |  |  |  |  | Logistics Contact |  |  |  |  | Accounts Contact
 |  |  |  |  |  |  | Code | Name | Telephone | Mobile | [NAME] | Code | Name | Telephone | Mobile | [NAME] | Code | Name | Telephone | Mobile | [NAME] | Code | Name | Telephone | Mobile | [NAME] | Code | Name | Telephone | Mobile | [NAME] | Code | Name | Telephone | Mobile | [NAME] | Code | Name | Telephone | Mobile | [NAME] | Code | Name | Telephone | Mobile | [NAME]
 |  |  |  | BRA | BRAS R US | The Road, Thetown, The Country, AA1 2ZZ | [NAME] | [NAME] | [PHONE] | 07976 456787 | [EMAIL] | ALBRA | [NAME] | [PHONE] | 07976 123455 | [EMAIL] | GLBRA | [NAME] | [PHONE] | 07976 456123 | [EMAIL] | DBBRA | [NAME] | 011 789455 | 07976 664987 | [EMAIL] |  |  | [PHONE] | 07976 456787 | [EMAIL] |  |  | [PHONE] | 07976 123455 | [EMAIL] |  |  | [PHONE] | 07976 456123 | [EMAIL] |  |  | 011 789455 | 07976 664987 | [EMAIL]
 |  |  |  | BRO | BROTHERS | This Street, Thattown, That Country BB2 1YY | SNBRO | Sid New | [PHONE] | 07976 456788 | [EMAIL] | JDBRO | [NAME] | [PHONE] | 07976 123456 | [EMAIL] | SSBRO | [NAME] | [PHONE] | 07976 456124 | [EMAIL] | RFBRO | [NAME] | 012 789455 | 07976 664988 | [EMAIL] |  |  | [PHONE] | 07976 456788 | [EMAIL] |  |  | [PHONE] | 07976 123456 | [EMAIL] |  |  | [PHONE] | 07976 456124 | [EMAIL] |  |  | 012 789455 | 07976 664966 | [EMAIL]
 |  |  |  | BRU | BRUTE FORCE | That Avenue, Thistown, Thother County ZZ2 3CC | JBBRU | [NAME] | [PHONE] | 07976 456789 | [EMAIL] | BGBRU | [NAME] | [PHONE] | 07976 123457 | [EMAIL] | JJBRU | [NAME] | [PHONE] | 07976 456125 | [EMAIL] | [NAME] | [NAME] | 013 789455 | 07976 664989 | [EMAIL] |  |  | [PHONE] | 07976 456789 | [NAME] |  |  | [PHONE] | 07976 123457 | [EMAIL] |  |  | [PHONE] | 07976 456125 | [EMAIL] |  |  | 013 789455 | 07976 664963 | [EMAIL]
Spreadsheet: 169655d1343009484-excel-2007-list-differences-between-tables-table-difference
Sheet: Table 1

 | BA | BB | BC | BD | BE
AA | 234 | 235 | 466 | 235 | 234
AB | 345 | 3 | 457 | 345 | 535
AC | 235 | 534 | 45 | 26 | 235
AD | 2 | 454 | 7 | 235 | 25
AE | 637 | 56 | 462 | 235 | 23
AF | 34 | 869 | 345 | 346 | 632
AG | 523 | 96 | 365 | 236 | 626
Spreadsheet: 884609d1733840235-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: User19

Main | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received | Tool Type | Description | Price | Received
Order Date | 2024-11-19 00:00:00
 | Socket Set | 1/4" Wera Set | 85.56
 | Tool Storage | [NAME] | 87.92
Total
Spreadsheet: benjamin_rogers__1185__United American Energy 02-09-00
Sheet: Notes

NOTES
1 | Please double check the model/pages before sending out to clients as certain information/comment cells/notes etc. may be too detailed to be disclosed
2 | The model shows only an example of the economics for a LM6000 project. Please update Capital Cost and O&M estimates given by Engineers for
 | your specific project, and make necessary changes to modify the model for the transaction structure you are trying to model
3 | All yellow shaded cells are required input cells
4 | Please note that the following are very project specific: state taxe, property tax, gross receipt tax, income stream etc.
5 | When quoting heat rate and capacity to Asset Management, please use average numbers
6 | Turbine carrying cost are based on assumptions on the WestLB Structure, the numbers may change after 03/15/00
7 | Heat rate and capacity vary depending on gas compression, altitude, etc.. Please double check with Engineers for specific project heat rate and capacity
SOURCES
 |  |  |  |  |  |  |  | Source |  |  |  |  |  | Date
1 | Federal Tax, State Tax, Franchise Tax, Sales & Used Tax, NOL |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 2000-02-04 00:00:00
 | calculations
2 | 15 year MACRS |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 2000-02-04 00:00:00
3 | Book Depreciation |  |  |  |  |  |  | Use Genco assumption as per [NAME] |  |  |  |  |  | 2000-02-03 00:00:00
4 | [NAME] |  |  |  |  |  |  | Calculated by [NAME]
5 | No Capacity Degradation for LM [NAME] model |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 2000-02-08 00:00:00
6 | Spread Option Model |  |  |  |  |  |  | [NAME]
CONTACTS
 | Subjects |  |  | Contacts |  |  | Extension
 | Model/Process |  |  | [NAME] |  |  | x 3-9446
 |  |  |  | [NAME] |  |  | x 3-7998
 | Turbine Technical Info |  |  | [NAME] |  |  | x 3-6337
 | Engineers |  |  | [NAME] |  |  | x 6-6385
 |  |  |  | [NAME] |  |  | x 6-6063
 |  |  |  | [NAME] |  |  | x 6-7089
 | O&M |  |  | [NAME] |  |  | x 6-8371
 | Spread Option Model |  |  | im [NAME] |  |  | x 3-7202
 | Accounting |  |  | [NAME] |  |  | x 5-7405
 | Tax |  |  | [NAME] |  |  | x 3-6174
Spreadsheet: 073e0a00-086f-4749-8c1c-b117e669356e
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (5 Entries):
 | 2 Analysis 2.12 Microwave systems 2.12.3 MW extraction
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Analysco Ltd. | United Kingdom | Chipping Norton, Oxfordshire | OX7 6LS | A2.509
2 | [NAME] | Austria | Graz | 8054 | A2.110
3 | CEM GmbH | Germany | Kamp-Lintfort | 47475 | A1.210
4 | [NAME] | Italy | Sorisole | 24010 | A2.332
5 | MLS GmbH Mikrowellen-Labor-Systeme | Germany | Leutkirch | 88299 | A2.235
Spreadsheet: 702496d1604388926-extract-the-list-of-unique-values-from-a-table-sample-data-3-
Sheet: Sheet1

Concatenate | Month | Agent
 | 2020 JUL | [NAME] |  | 2020 SEP |  |  | I need the list of unique names from the "Agent" column in Table1:
 | 2020 JUL | [NAME] |  |  |  |  | * if the "Month" column starts with E2
 | 2020 JUL | [NAME] |  |  |  |  | * minus the hardcoded word "TOTAL"
 | 2020 JUL | Unique1
 | 2020 JUL | [NAME]
 | 2020 JUL | Clementine
 | 2020 JUL | Brett |  |  |  |  | The result I need (alphabetical preferred, but not required)
 | 2020 JUL | Chase |  |  |  |  | [NAME]
 | 2020 JUL | Sean |  |  |  |  | [NAME]
 | 2020 JUL | Olive |  |  |  |  | [NAME]
 | 2020 JUL | [NAME] |  |  |  |  | Reeve
 | 2020 JUL | [NAME] |  |  |  |  | [NAME]
 | 2020 JUL | TOTAL |  |  |  |  | Clementine
 | 2020 AUG | [NAME] |  |  |  |  | Brett
 | 2020 AUG | [NAME] |  |  |  |  | Unique3
 | 2020 AUG | [NAME] |  |  |  |  | Sean
 | 2020 AUG | Reeve |  |  |  |  | Olive
 | 2020 AUG | [NAME] |  |  |  |  | [NAME]
 | 2020 AUG | Clementine |  |  |  |  | [NAME]
 | 2020 AUG | Brett
 | 2020 AUG | Chase
 | 2020 AUG | Sean
 | 2020 AUG | Olive |  |  |  |  | Notes:
 | 2020 AUG | [NAME] |  |  |  |  | * In reality, Table2 is located in a different sheet/row
 | 2020 AUG | Unique2 |  |  |  |  | * non-array formula is strongly preferred
 | 2020 AUG | TOTAL |  |  |  |  | * the concatenate column exists in reality, and can be used if needed
 | 2020 SEP | [NAME]
 | 2020 SEP | [NAME]
 | 2020 SEP | [NAME]
 | 2020 SEP | Reeve
 | 2020 SEP | [NAME]
 | 2020 SEP | Clementine
 | 2020 SEP | Brett
 | 2020 SEP | Unique3
 | 2020 SEP | Sean
 | 2020 SEP | Olive
 | 2020 SEP | [NAME]
 | 2020 SEP | [NAME]
 | 2020 SEP | TOTAL
Spreadsheet: 758893d1639147987-find-duplicate-values-with-non-matching-values-in-another-column-duplicateexample-pcb-
Sheet: Sheet1

ID | Flag | green | red | Match | #[NAME] |  |  | Result |  | https://www.excelforum.com/excel-formulas-and-functions/1365849-find-duplicate-values-with-non-matching-values-in-another-column.html
12345 | green
67890 | red
23456 | red
45678 | green
56789 | red
56789 | red
12345 | red
67890 | green
78901 | green
78901 | green
89012 | green
90123 | green
54321 | red
65432 | red
76543 | green
87654 | red
87654 | green
98765 | red
98765 | red
13579 | green
13579 | green
13579 | green
24680 | red
24680 | red
24680 | red
14703 | green
25814 | green
36925 | green
47036 | green
58147 | green