tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cooper_richey__4349__0207 Global Data Setup
Sheet: Global Data

 | Global data for mock test on 2/7/02
 | Testing/ data needs based on data setup in downstream systems.
 | Counterparties - Active w/ addresses |  |  | Contracts
 | 1305 - UBS Warburg Energy LLC acting as agent for UBS AG, London Branch |  |  | Financials            Phys Firm                [NAME]
 | 11266 - UBS Warburg Energy (Canada) LTD |  |  | Duke             20000545            20000549                   20000552
 | 54979 - Duke Energy Trading and Marketing, L.L.C. |  |  | Reliant          20000547             20000550                   20000553
 | 64245 - Williams Energy Marketing & Trading Company |  |  | [NAME]        20000548            20000551                    20000554
 | 65268 - Reliant Energy Services, Inc. |  |  | Conoco - MPSF 20000560
 | 3497 - Conoco Inc. |  |  | Carolina - OLGTC(Short Term) 20000561, OLGTC(Long Term) 20000562
 | 27457 - Carolina Power & Light Company |  |  | Florida - MPSF 20000563, OLGTC(Short Term + Coll)
 | 1424 - Florida Power Corporation
 |  |  |  | The power contracts set up are as follows
 | Pipelines |  |  | [NAME] -20000543
 | 3015 Tennessee Gas Pipeline Co. |  |  | Reliant Energy Services - PMS - 20000544
 | Storage Service Contract 20000059  (Agency Contract 20000062) |  |  | Reliant Energy Services - PMP - 20000559
 | Transportation Contract 20000057 |  |  | Carolina P&L - PMB - 20000565
 |  |  |  | Conoco, Inc. - PMS 20000566
 |  |  |  | Conoco, Inc. - PMP 20000567
 | East | 3015 | Tennessee Gas Pipeline Co.
 | East | 3035 | Texas Gas Transmission Corporation | Contracts SETUP TO FAIL
 | West | 63064 | El Paso Gas Transmission Company | Counterparty Legal Name |  | K # | Contract Type | Error, if any
 | West | 3545 | Colorado Interstate Gas Company | Duke Energy Trading and Marketing, L.L.C. |  | 20000552 | Master Purchase Sale Spot | Status=Trade Suspended-Default
 | Central | 586 | ANR Pipeline Company | Reliant Energy Services, Inc. |  | 20000547 | 92 ISDA - Multicurrency/Cross Border | Activity Type=Physical, Service Type=N/A
 | Central | 2383 | Northern Natural Gas Company | Williams Energy Marketing & Trading Company |  | 20000551 | Master Purchase Spot | Purchase only
 | Texas | 2421 | Oasis Pipeline Company | Williams Energy Marketing & Trading Company |  | 20000004 | GISB Base Contract 6.3.1 | Status=Deleted
 | Texas | 57826 | El Paso Offshore Gathering  & Transmission Company | No contract for Florida Power Corp was set up in order to test failure.  If a contract needs to be set up, let me know
 | CANADA
 | Counterparties
 | Aquila Capital & Trade Ltd. (CP ID 102342)
 | Reliant Energy Services Canada Ltd. (CP ID 68285)
 | Coral Energy Canada Inc. (CP ID 53876)
 | Duke Energy Marketing L.P. (CP ID 54980)
 | Reliant Energy Services Inc. (CP ID 65268)
 | Pipelines
 | Westcoast Energy Inc.
 | Nova Gas Transmission
 | TCPL (TransCanada Pipelines Ltd.)
Spreadsheet: fc1f16c4-ba78-4e5d-9cb4-e7f104805f4c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BHCG | Test | BHCG | Beta-Human Chorionic Gonadotropin, Quantitative, Serum | Beta-HCG, Quantitative, S | Electrochemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Children(1,2) Males Birth-3 months: < or =50 IU/L* >3 months-<18 years: <1.4 IU/L Females Birth-3 months: < or =50 IU/L* >3 months-<18 years: <1.0 IU/L *hCG, produced in the placenta, partially passes the placental barrier. Newborn serum beta-hCG concentrations are approximately 1/400th of the corresponding maternal serum concentrations, resulting in neonate beta-hCG levels of 10-50 IU/L at birth. Clearance half-life is approximately 2-3 days. Therefore, by 3 months of age, levels comparable to adults should be reached.   Adults (97.5th percentile) Males: <1.4 IU/L Females Premenopausal, nonpregnant: <1.0 IU/L Postmenopausal: <7.0 IU/L   Pediatric reference values based on: 1. [NAME], [NAME], [NAME], [NAME] Human chorionic gonadotropin pattern in maternal circulation. Amniotic fluid and fetal circulation in late pregnancy. J Reprod Med 1993;38:151-154 2. [NAME], Calaminus G, Gobel U: Diagnostic value of alpha 1-fetoprotein and beta-human chorionic gonadotropin in infancy and childhood. Pediatr [NAME] 2001;18:11-26 | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | 1 day | 3 days | 1 | 84702 |  |  |  |  | Rochester
BHCG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
BHCG | Result | BHCG | Beta-HCG, Quantitative, S | Beta-HCG, Quantitative, S | Numeric |  |  |  |  | IU/L
Spreadsheet: 712857d1610454910-consolidate-data-from-2-sheets-comparison-sample-data
Sheet: Result

Code | Price (From Sheet 1) | Price (From Sheet 2)
A | 1 | 10
A1 | 5 | 5
A2 | 4 | 4
A3 | 3 | 0
B | 2 | 3
B1 | 5 | 5
B3 | 2 | 0
C | 25 | 7
C4 | 1 | 25
C5 | 11 | 0
C6 | 0 | 30
D | 0 | 1
D1 | 0 | 5
Spreadsheet: 798392d1664460083-table-size-based-on-cell-value-example
Sheet: Lookup Tables

 |  |  | Report Review & Repair Plan Report
 |  | Terminals - Lookup | EPS/EETS | Terminal Code | Project Manager - Lookup
 |  | Aldermaston - Gully | EPS | AG | [NAME] |  |  |  | Repair Status
 |  | Aldermaston - Top Site | EPS | AT | [NAME] |  |  |  | Pending
 |  | Amsterdam | ETS | AM | [NAME] |  |  |  | Ongoing
 |  | [NAME] | EPS | BN | [NAME] |  |  |  | Complete
 |  | Belfast | ETS | BE | [NAME]
 |  | [NAME] | EPS | BW | [NAME]
 |  | Bramhall | EPS | BR | [NAME]
 |  | Clydebank | ETS | CL | [NAME]
 |  | Eastham | ETS | EH | [NAME]
 |  | [NAME] | ETS | GM | [NAME]
 |  | Grays | ETS | GR | [NAME]
 |  | Hallen | EPS | HA | [NAME]
 |  | Immingham - East | ETS | IE | [NAME]
 |  | Immingham - West | ETS | IW | [NAME]
 |  | Inverness | EPS | IN | [NAME]
 |  | Killingholme | EPS | KI | [NAME]
 |  | Mannheim - North | ETS | MN | [NAME]
 |  | Mannheim - South | ETS | MS | [NAME]
 |  | Misterton | EPS | MI | Byran Chopping
 |  | [NAME] | EPS | RA | Byran Chopping
 |  | Redcliff Bay | EPS | RE | [NAME]
 |  | Riverside | ETS | RI | [NAME]
 |  | Runcorn | ETS | RU | [NAME]
 |  | [NAME] | EPS | SW | [NAME]
 |  | [NAME] | ETS | SS | [NAME]
 |  | [NAME] | ETS | SS | [NAME]
 |  | Shannon | ETS | SI | [NAME]
 |  | Shannon - AFSC | ETS | SI | [NAME]
 |  | Thetford | EPS | TH | Byran Chopping
 |  | Tyneside | ETS | TY | [NAME]
 |  | [NAME] | EPS | WA | [NAME]
 |  | Priorities | Code |  | Action Number
 |  | Pre-Commission – Safety Critical | P1 |  | A1
 |  | Pre-Commission – Non-Safety Critical | P2 |  | A2
 |  | Post-Commission – Non-Safety Critical | P3 |  | A3
 |  |  |  |  | A4
 |  |  |  |  | A5
 |  |  |  |  | A6
 |  |  |  |  | A7
 |  |  |  |  | A8
 |  |  |  |  | A9
 |  |  |  |  | A10
 |  |  |  |  | A11
 |  |  |  |  | A12
 |  |  |  |  | A13
 |  |  |  |  | A14
 |  |  |  |  | A15
 |  |  |  |  | A16
 |  |  |  |  | A17
 |  |  |  |  | A18
 |  |  |  |  | A19
 |  |  |  |  | A20
 |  |  |  |  | A21
 |  |  |  |  | A22
 |  |  |  |  | A23
 |  |  |  |  | A24
 |  |  |  |  | A25
 |  |  |  |  | A26
 |  |  |  |  | A27
 |  |  |  |  | A28
 |  |  |  |  | A29
 |  |  |  |  | A30
 |  |  |  |  | A31
 |  |  |  |  | A32
 |  |  |  |  | A33
 |  |  |  |  | A34
 |  |  |  |  | [NAME]
Spreadsheet: 355740d1414771339-populate-column-based-on-selection-from-a-dropdown-book1-ndm
Sheet: Sheet1

695 |  |  |  |  | High
466
508
358
287
597
549
481
96
912
Spreadsheet: 44a5d5fc-1a59-4a54-9af2-03da3f9fee6b
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
09/04/2005 | Football | at Syracuse | W, 15-7
09/10/2005 | Football | WOFFORD | W, 35-7
09/17/2005 | Football | at Maryland | W, 31-19
[NAME] | Football | EAST CAROLINA | W, 20-15
10/01/2005 | Football | VIRGINIA TECH | L, 17-34
10/08/2005 | Football | at Rutgers | W, 27-14
10/15/2005 | Football | LOUISVILLE | W, 46-44 (3OT)
11/02/2005 | Football | CONNECTICUT | W, 45-13
11/09/2005 | Football | at Cincinnati | W, 38-0
11/24/2005 | Football | PITT | W, 45-13
12/03/2005 | Football | at USF | W, 28-13
01/02/2006 | Football | Georgia (Sugar Bowl) | W, 38-35
Spreadsheet: 745089d1629734798-multiple-invoices-and-multiple-payments-formula-excel-question-testinglife-
Sheet: Sheet1

 |  | Customer |  | Cust 1 | Cust 1 | Cust 1 | Cust 1 | <<== Copy/Pasted transpose from L4:N8
 |  | Payment Name |  | Payment A | Payment B | Payment C | Payment D
 |  | Payment |  | 50 | 25 | 50 | 200
Customer | Invoice Name | Invoice Amount |  |  |  |  |  |  |  |  | Customer | Payment Name | Payment
Cust 1 | Invoice A | 100 |  |  |  |  |  |  |  |  | Cust 1 | Payment A | 50
Cust 1 | Invoice B | 100 |  |  |  |  |  |  |  |  | Cust 1 | Payment B | 25
Cust 1 | Invoice C | 100 |  |  |  |  |  |  |  |  | Cust 1 | Payment C | 50
Cust 1 | Invoice D | 100 |  |  |  |  |  |  |  |  | Cust 1 | Payment D | 200
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 370SF

370SF
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-02-08 00:00:00 |  |  | RJS | 2009-06-17 00:00:00 |  |  | JAD |  | 2010-07-16 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
Inventory packag is being created.28 December 2010
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 839707d1692176015-sumproduct-sum-from-multiple-sheets-depending-on-specific-month-file
Sheet: Master

Total |  | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY |  | CY
 |  | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals |  | Actuals
 |  | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312 |  | 202307
Opening |  | 1217369 | 1224307 | 1231614 | 1239945 | 1249531 | 1257416 | 1263572 | 1271058 | 1271058 | 1271058 | 1271058 | 1271058 |  | ????
Spreadsheet: 747952d1631801140-multiple-actions-depending-on-content-of-cell-example
Sheet: Sheet1

 | Currency assumptions
 | GBP | 1
 | DKK | 0.23
 | USD | 1.12
 | EUR | 1.16
 | Project | Cost | Currency | Cost in GBP
 | [NAME] | 1000 | GBP
 | Paris | 2000 | EURO
 | New York | 3000 | USD
Spreadsheet: 7e01bd7d-628f-4103-ab60-12a586525ceb
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SARD | Test | SARD | Sardine (Pilchard), IgE | Sardine (Pilchard), IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
SARD | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SARD | Result | SARD | Sardine (Pilchard), IgE | Sardine (Pilchard), IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 30989-8 | Sardinops [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 807858d1670112236-if-todays-date-december-it-will-automatically-subtract-december-november-sample
Sheet: Sheet1

 | Today's Date | 2022-12-03 00:00:00 |  | =if(today(date(2022,12)),=C18,"")
 | Current Price | 400000
 | JAN | 250000
 | FEB | 270000
 | MAR | 260000
 | APR | 280000
 | MAY | 300000
 | [NAME] | 320000
 | JULY | 330000
 | AUG | 360000
 | SEPT | 380000
 | OCT | 390000
 | NOV | 380000
 | DEC | 400000
Spreadsheet: 244fbea2-30ee-41e1-a943-b2401f5ed418
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3377 | 18686 | [NAME] | Hufschmid | SUI | 0 |  |  |  |  |  | 1
3377 | 10169 | [NAME] | [NAME] | USA | 0 |  |  |  |  |  | 2
3377 | 10331 | [NAME] | Manzan | BRA | 0 |  |  |  |  |  | 3
3377 | 5814 | [NAME] | Mccormack | AUS | 0 |  |  |  |  |  | 4
3377 | 15235 | Normann | [NAME] | GER | 0 |  |  |  |  |  | 5
3377 | 15394 | Mark | [NAME] | USA | 0 |  |  |  |  |  | 6
3377 | 15200 | Joachim | Franzmann | GER | 0 |  |  |  |  |  | 7
3377 | 6512 | [NAME] | Rogers | USA | 0 |  |  |  |  |  | 8
3377 | 5324 | Olivier | Marceau | SUI | 0 |  |  |  |  |  | 9
3377 | 18690 | Andres | Johns | AUS | 0 |  |  |  |  |  | 10
Spreadsheet: phillip_m_love__30655__9901_OA
Sheet: TX-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 464945d1465383482-importing-csv-file-with-dates-in-necessary-format-example1
Sheet: Sheet1

From | From E-mail Address | To | Subject | Received
[NAME] | [NAME] | [NAME] | atlikums ir 0 Eur. ? | 2016-01-06 09:56:00
[NAME] | [NAME] | [NAME] | Par atlikumu (38057) | 2016-01-06 09:11:00
dimaspell | dimaspell | [NAME] | 37995 | 2016.30.05 11:35
kurmjakungs41 | kurmjakungs41 | [NAME] | internets (37992) | 2016.30.05 10:40
Spreadsheet: 879246d1726688830-true-false-condition-help-test-file-2-
Sheet: Sheet2

 | 2024 | 230ix | Thunder | 8E18669 |  | 2024-01-31 00:00:00 | 2024-02-13 00:00:00 | 2024-09-12 00:00:00 | False | False | 45065 | 42655 | 500 |  |  |  | False |  | would like to add a set to this as well so that when "I11" has  date, then this returns "RETIRED"
 | 2024 | 230ix | Thunder | 8E18669 |  | 2024-01-31 00:00:00 | 2024-02-13 00:00:00 |  | False | False | 45065 | 42655 | 500 |  |  |  | False |  | code works perfect when "FALSE"
 | 2024 | 230ix | Thunder | 8E18669 |  | 2024-01-31 00:00:00 | 2024-02-13 00:00:00 |  | False | False | 45065 | 42655 | 500 |  |  |  | True |  | This should equal $35,830 as the top box does   (when I11 has a date the formula is accurate)
Spreadsheet: 857077d1706155873-calculating-data-from-multiple-sheets-manually-calculated-example
Sheet: Returns 4

 | Pro Forma Summary
 |  |  |  |  | Pro Forma
 |  |  |  |  |  | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  | TTM | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma
 | Revenue |  |  |  | 1420000 | 1462600 | 1564982 | 1674530.74 | 1791747.8918 | 1917170.244226 | 2013028.7564373 | 2113680.194259166 | 2177090.600086941 | 2242403.318089549 | 2309675.417632236
 | [NAME] |  |  |  | 880400 | 917817 | 945351.51 | 973712.0553 | 1002923.416959 | 1033011.11946777 | 1064001.453051803 | 1095921.496643357 | 1128799.141542658 | 1162663.115788938 | 1197543.009262606
 | Gross Profit |  |  |  | 539600 | 544783 | 619630.49 | 700818.6847 | 788824.474841 | 884159.1247582302 | 949027.3033854973 | 1017758.697615809 | 1048291.458544283 | 1079740.202300612 | 1112132.40836963
 | Operating Expenses |  |  |  | 139600 | 145533 | 149898.99 | 154395.9597 | 159027.838491 | 163798.67364573 | 168712.6338551019 | 173774.012870755 | 178987.2332568776 | 184356.850254584 | 189887.5557622215
 | NOI |  |  |  | 400000 | 399250 | 469731.5 | 546422.725 | 629796.63635 | 720360.4511125002 | 780314.6695303954 | 843984.6847450535 | 869304.2252874053 | 895383.3520460277 | 922244.8526074087
 | Management Fee Allocation |  | 0.05 |  | 26980 | 27239.15 | 30981.5245 | 35040.934235 | 39441.22374205 | 44207.95623791151 | 47451.36516927487 | 50887.93488079043 | 52414.57292721415 | 53987.01011503059 | 55606.62041848151
 | EBITDA |  |  |  | 373020 | 372010.85 | 438749.9755 | 511381.790765 | 590355.41260795 | 676152.4948745887 | 732863.3043611206 | 793096.7498642631 | 816889.6523601911 | 841396.3419309971 | 866638.2321889271
 | [NAME] |  | 0.015 |  | 0 | 21939 | 23474.73 | 25117.9611 | 26876.218377 | 28757.55366339 | 30195.4313465595 | 31705.20291388749 | 32656.35900130411 | 33636.04977134324 | 34645.13126448354
 | DCF (Unlevered) |  |  |  | 373020 | 350071.85 | 415275.2455 | 486263.829665 | 563479.1942309501 | 647394.9412111987 | 702667.873014561 | 761391.5469503757 | 784233.293358887 | 807760.2921596539 | 831993.1009244436
Spreadsheet: 77422d1277904994-duplicates-based-on-multiple-columns-dummy-file
Sheet: Sheet1

Customer Name | Product Line | Address | Province | Postal
Apple | Appliance | 123 Apple Rd | ON | L1L 1L1
Orange | Furniture | 123 Orange Rd | BC | [NAME]
[NAME] | Appliance | 123 Banana Rd | MB | H1H 1H1
[NAME] | Furniture | 123 Banana Rd | MB | H1H 1H1
Orange | Furniture | 123 Orange Rd | BC | [NAME]
Orange | Mattress Pads | 123 Orange Rd | Bc | [NAME]
Avacado | Furniture | 123 Avacado Rd | SK | S1S 1S1
Spinach | Mattress Pads | 123 Spinach Ave | PEI | M1M 1M1
Tomato | Appliance | 123 Tomato Lane | NF | F1F 1F1
Spreadsheet: kevin_hyatt__19594__TW01DEAL
Sheet: #6Feb@11.55

 |  | TW - OPERATION SUN DEVIL Package #6
 |  |  |  |  |  |  |  | TENASKA |  | NNG/TW
 |  |  |  |  | VOLUME | PRICE | TOTAL GAINS | CASH FLOW |  | CASHFLOW
 |  | FEBRUARY  2001 NYMEX PRICE: |  |  |  | 7.275
 |  | FEBRUARY 2001 PERMIAN BASIS PRICE: |  |  |  | 0
 |  | PHYSICAL PREMIUM / DISCOUNT: |  |  |  | 0.02
 |  | PERMIAN FIXED PRICE: |  |  | 10664
 |  | FUEL RATE PERMIAN TO TW/HALEY: |  |  | 0.0129
 |  | DEMAND:
 |  | COMMODITY: |  |  |  | 0.01
 |  | TW/NNG HALEY PRICE
 |  | TW FUEL
 |  | TW DEMAND |  |  |  | 0.3519
 |  | TW COMMODITY: |  |  |  | 0.0318
 |  | CALIFORNIA PRICE |  |  | 10000 | 11.55
 |  | CASH FLOW BEFORE SHARING:
 |  | TENASKA SHARE @ 8%
 |  | NNG/TW SHARE @ 92%
 |  | PAYMENT TRANSFER THRU SWAP
 |  | NET CASH
 |  | PERMIAN POOL VOLUME
 |  | TW / HALEY
 |  | VOLUME AT THE BORDER |  |  |  | 10000
Spreadsheet: 707481d1607316324-vlookup-issue-test
Sheet: Sheet2

Date & Time | Place | [NAME] | Toll $ | [NAME] to Finish
2019-12-31 09:36:13 | ED-AB | ABCD123 | 7.76
2019-12-31 10:47:55 | WCX-233 | ABCD123 | 4.27
2019-12-31 13:09:52 | WCX-206 | ABCD123 | 4.93
2019-12-31 13:24:03 | M7-131 | ABCD123 | 5.93
2019-12-31 16:23:02 | M7-147 | ABCD123 | 2.23
2019-12-31 16:30:49 | M5-HV | ABCD123 | 4.79
2020-01-02 15:51:26 | WCX-134 | ABCD123 | 4.44
Spreadsheet: 748704d1632305980-combine-workday-and-sequence-auto-fill-date-and-time-ans2
Sheet: Sheet1

 |  |  |  |  | Start | 08:00:00 |  | start Date | 2021-09-01 00:00:00
 |  |  |  |  | End | 10:30:00
 |  |  |  |  | Time interval | 00:30:00
Spreadsheet: 190844d1351804252-find-2-types-of-value-based-on-3-match-conditions-example
Sheet: Sheet1

 | left table
 | Speed | Pd | Ps | Load | Flow
 | 300 | 400 | 20 | 206.0374 | 1.309381
 | 300 | 450 | 30 | 211.4116 | 1.285792
 | 300 | 500 | 40 | 215.5321 | 1.26167
 | 300 | 550 | 50 | 218.6033 | 1.237189
 | 325 | 400 | 20 | 220.8462 | 1.212812
 | 325 | 450 | 30 | 222.3543 | 1.188193
 | 325 | 500 | 40 | 223.2607 | 1.164033 |  |  |  |  | right table
 | 325 | 550 | 50 | 223.6217 | 1.139963 |  |  |  |  | Pd/Ps | 20 | 30 | 40 | 50
 | 350 | 400 | 20 | 223.4996 | 1.115983 |  |  |  |  |  |  | 300 | speed
 | 350 | 450 | 30 | 222.9466 | 1.09209 |  |  |  |  | 400
 | 350 | 500 | 40 | 222.0069 | 1.068283 |  |  |  |  | 450
 | 350 | 550 | 50 | 210.7603 | 1.833591 |  |  |  |  | 500
 | 400 | 400 | 20 | 225.3199 | 1.809208 |  |  |  |  | 550
 | 400 | 450 | 30 | 237.344 | 1.784887
 | 400 | 500 | 40 | 247.3641 | 1.760535 |  |  |  |  | Pd/Ps | 20 | 30 | 40 | 50
 | 400 | 550 | 50 | 255.7467 | 1.736374 |  |  |  |  | 325 | speed
 |  |  |  |  |  |  |  |  |  | 400 | Load / Flow
 |  |  |  |  |  |  |  |  |  | 450
 |  |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  |  | 550
Spreadsheet: 786195d1657033414-vlookup-with-dependent-drop-down-list-book1
Sheet: Summary

 | Time period & Country | Offer
 | Jan22 - Mar22 & US | TC Basic
HPE Server Platform | HW Units | Discount %
Proliant 1
Proliant 2
Proliant 3
Proliant 4
Proliant 5
Proliant 6
Proliant 7
Proliant 8
Proliant 9
Proliant 10
Proliant 11
Proliant 12
Proliant 13
Proliant 14
Proliant 15
Proliant 16
Proliant 17
Proliant 18
Proliant 19
Proliant 20
Proliant 21
Proliant 22
Proliant 23
Proliant 24
Proliant 25
Proliant 26
Jan22 - Mar22 & US | TC Basic
Jan22 - Mar22 & France | TC Essential
Jan22 - Mar22 & UK | TC Critical
Jan22 - Mar22 & Germany | FC NBD
Oct 21 - Dec 21 & US | PC NBD
Oct 21 - Dec 21 & France | PC 24x7
Oct 21 - Dec 21 & UK | PC Advanced NBD
Oct 21 - Dec 21 & Germany | PC Advanced 24x7