tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 264808d1378988687-compare-data-in-2-columns-extract-unique-values-and-paste-into-3rd-column-0a199
Sheet: Results

External | Internal | Difference
123456 | 123456 | 123556
123457 | 123457 | 123557
123458 | 123458 | 123558
123460 | 123460 | 123559
123461 | 123461 | 123560
123462 | 123462 | 123561
123463 | 123463 | 123562
123464 | 123464 | 123563
123465 | 123465 | 123564
123467 | 123467 | 123565
123468 | 123468
123469 | 123469
123470 | 123470
123472 | 123472
123473 | 123473
123474 | 123474
123475 | 123475
123476 | 123476
123478 | 123478
123479 | 123479
123480 | 123480
123481 | 123481
123482 | 123482
123483 | 123483
123485 | 123485
123486 | 123486
123487 | 123487
123488 | 123488
123489 | 123489
123491 | 123491
123492 | 123492
123493 | 123493
123494 | 123494
123495 | 123495
123496 | 123496
123497 | 123497
123498 | 123498
123499 | 123499
123501 | 123501
123502 | 123502
123503 | 123503
123504 | 123504
123505 | 123505
123506 | 123506
123507 | 123507
123508 | 123508
123509 | 123509
123510 | 123510
123511 | 123511
123512 | 123512
123513 | 123513
123514 | 123514
123515 | 123515
123516 | 123516
123518 | 123518
123519 | 123519
123520 | 123520
123521 | 123521
123522 | 123522
123523 | 123523
123524 | 123524
123525 | 123525
123526 | 123526
123527 | 123527
123528 | 123528
123529 | 123529
123530 | 123530
123531 | 123531
123532 | 123532
123533 | 123533
123535 | 123535
123536 | 123536
123537 | 123537
123538 | 123538
123539 | 123539
123540 | 123540
123541 | 123541
123542 | 123542
123543 | 123543
123544 | 123544
123545 | 123545
123546 | 123546
123547 | 123547
123548 | 123548
123550 | 123550
123551 | 123551
123552 | 123552
123553 | 123553
123554 | 123554
123555 | 123555
Spreadsheet: 729180d1618945409-lookup-a-value-from-another-sheet-copy-and-paste-the-results-in-another-sheet-sales-region
Sheet: Data sheet

Date | Product inventory | A | B | C
2021-04-17 00:00:00 | QTY 1 | 200 | 2500 | 55
2021-04-17 00:00:00 | QTY 2 | 100 | 150 | 10
2021-04-18 00:00:00 | QTY 1 | 230 | 900 | 42
2021-04-18 00:00:00 | QTY 2 | 340 | 356 | 24
2021-04-19 00:00:00
Spreadsheet: 186288d1349974592-trying-to-split-a-price-across-a-date-to-work-out-weekly-income-examplebook
Sheet: Sheet1

 |  |  |  |  |  |  | Sept |  |  |  | Oct |  |  |  | Nov |  |  |  | Dec |  |  |  | Jan |  |  |  | Feb
Start Date | Price | Duration (weeks) | Price/w |  |  |  | 2012-09-30 00:00:00 |  |  |  | 2012-10-01 00:00:00
2012-11-11 00:00:00 | 50000 | 50
2012-11-12 00:00:00 | 25000 | 9
2012-11-13 00:00:00 | 19456 | 6
2012-11-14 00:00:00 | 273895 | 34
Spreadsheet: 131971d1323423384-dashboard-budget-vs-actuals-green-yellow-or-red-test_sheet
Sheet: Sheet1

 |  | Interval |  |  | Color | Budget | Actuals
 | Income X | 0.1 | Higher than budget is better |  | Green | 100 | 120
 | Income Y | 0.2 | Higher than budget is better |  | Yellow | 100 | 90
 | Income Z | 0.1 | Higher than budget is better |  | Red | 100 | -30
 | Income A | 0.05 | Higher than budget is better |  | Green | -50 | 100
 | Expense X | 0.1 | Lower than budget is better |  | Green | 100 | 80
 | Expense Y | 0.1 | Lower than budget is better |  | Red | 100 | 120
 | Expense Z | 0.1 | Lower than budget is better |  | Red | 0 | 10
Spreadsheet: 810982d1672219982-sorting-data-at-the-bottom-sorting2-2-
Sheet: Sheet2

Custodian | ISIN | Rating |  |  | Custodian | ISIN | Rating |  |  | Custodian | ISIN | Rating |  |  | ISIN | Rating
BOV | [NAME] | A |  |  | BOV | [NAME] | A |  |  | BOV | [NAME] | A |  | BOV | [NAME] | A
BOV | Cash | A+ |  |  | APS | FA123 | A |  |  | APS | FA123 | A |  | APS | FA123 | A
BOV | Cash | B- |  |  | APS | [NAME] | A |  |  | APS | [NAME] | A |  | APS | [NAME] | A
APS | FA123 | A |  |  | APS | QA888 | AA+ |  |  | APS | QA888 | AA+ |  | APS | QA888 | AA+
APS | [NAME] | A |  |  | APS | [NAME] | BB+ |  |  | APS | [NAME] | BB+ |  | APS | [NAME] | BB+
APS | QA888 | AA+ |  |  | Lombard | PA123 | A+ |  |  | Lombard | PA123 | A+ |  | Lombard | PA123 | A+
APS | [NAME] | BB+ |  |  | Lombard | QW741 | BB |  |  | Lombard | QW741 | BB |  | Lombard | QW741 | BB
Lombard | PA123 | A+ |  |  | BOV | Cash | A+
Lombard | QW741 | BB |  |  | BOV | Cash | B-
 |  |  |  |  |  |  |  |  |  | BOV | Cash | A+ |  | BOV | Cash | A+
 |  |  |  |  |  |  |  |  |  | BOV | Cash | B- |  | BOV | Cash | B-
Spreadsheet: 064aacfc-0274-48c3-810f-b43a0c5a376a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 13. LENDING FINANCE SEASONAL FACTORS, BY PURPOSE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial finance for fixed loan facilities ; |  |  | Original | A2433160J | 1985-01-01 00:00:00 | 2013-07-01 00:00:00 | 343 | Number | FACTOR | Month | 1
Commercial finance for revolving credit facilities ; |  |  | Original | A2433161K | 1985-01-01 00:00:00 | 2013-07-01 00:00:00 | 343 | Number | FACTOR | Month | 1
Total lease finance commitments ; |  |  | Original | A2433163R | 1985-01-01 00:00:00 | 2013-07-01 00:00:00 | 343 | Number | FACTOR | Month | 1
Personal finance for fixed loan facilities ; |  |  | Original | A2433157V | 1985-01-01 00:00:00 | 2013-07-01 00:00:00 | 343 | Number | FACTOR | Month | 1
Personal finance for revolving credit facilities ; |  |  | Original | A2433158W | 1985-01-01 00:00:00 | 2013-07-01 00:00:00 | 343 | Number | FACTOR | Month | 1
Investment housing, Construction of dwellings for rent and resale ; |  |  | Original | A2434908R | 1985-01-01 00:00:00 | 2013-07-01 00:00:00 | 343 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by individuals ; |  |  | Original | A2434909T | 1985-01-01 00:00:00 | 2013-07-01 00:00:00 | 343 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by others ; |  |  | Original | A2434910A | 1985-01-01 00:00:00 | 2013-07-01 00:00:00 | 343 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 797656d1664026232-generate-list-from-a-list-to-smallest-number-to-largest-number-formula-test
Sheet: Sheet1

Product Name | % | Size | Litres | Qty | Base |  |  |  |  |  |  | Base Available | 1000 |  | Product Name | % | Size | Litres | Qty | Base
1 | 0.22 | 0.5 |  | 200
2 | 0.25 | 0.2 |  | 400
3 | 0.25 | 0.35 |  | 700
4 | 0.4 | 0.5 |  | 800
5 | 0.4 | 0.7 |  | 125
6 | 0.42 | 0.5 |  | 250
7 | 0.57 | 0.7 |  | 450
8 | 0.22 | 0.2 |  | 109
9 | 0.25 | 0.35 |  | 987
10 | 0.42 | 0.5 |  | 320
Spreadsheet: 873661d1720174542-if-function-with-sumifs-if-statement-and-sumif
Sheet: source data

Financial Year |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Period | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
Month | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 | ACTUAL | ACTUAL | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST |  | Row 4 will  be updated from Forecast to Actual as the actuals come through
Cost 1 | 10000 |  | 0 |  | 18000 |  | 25000 |  | 25000
Cost 2
Cost 3
Cost 4
Cost 5 |  | 28000 |  |  | 12000 |  |  | 63000
Cost 6
Cost 7
Cost 8
Cost 9
Spreadsheet: 857990d1706806173-distribute-data-to-columns-named-month-table-dj
Sheet: Found

[NAME] | January | February | March | April | May | June | July | August | September | October | November | December
[NAME]
[NAME]
[NAME]
 |  | How can we bring the data in the column we want from the section with month names on the data page to the columns of the months?
 |  | It is to count and find the days of the customers with the letter s in the months in the other page of the columns named month.
Spreadsheet: 32589d1228776428-vlookup-or-if-statements-widgets-gidgets-lidgets
Sheet: Sheet1

Widgets | 3 | 7
Gidgets | 6 | 5
Lidgets | 5 | 5
Field1 | excellent | bad
widgets | Gidgets | Lidgets | Result
1 | 3 | 5 | good
7 | 5 | 5 | bad
4 | 3 | 7 | ok
3 | 6 | 5 | excellent
6 | 1 | 2 | terrible
Spreadsheet: 266469d1379620825-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-county-fips-codes
Sheet: WISCONSIN-48

 | COUNTY | CODE
 | Adams | 1
 | Ashland | 3
 | Barron | 5
 | Bayfield | 7
 | [NAME] | 9
 | Buffalo | 11
 | [NAME] | 13
 | Calumet | 15
 | [NAME] | 17
 | [NAME] | 19
 | Columbia | 21
 | Crawford | 23
 | Dane | 25
 | Dodge | 27
 | Door | 29
 | [NAME] | 31
 | Dunn | 33
 | [NAME] | 35
 | Florence | 37
 | Fond du Lac | 39
 | Forest | 41
 | Grant | 43
 | Green | 45
 | Green Lake | 47
 | Iowa | 49
 | Iron | 51
 | [NAME] | 53
 | [NAME] | 55
 | Juneau | 57
 | Kenosha | 59
 | [NAME] | 61
 | La Crosse | 63
 | Lafayette | 65
 | [NAME] | 67
 | Lincoln | 69
 | Manitowoc | 71
 | Marathon | 73
 | Marinette | 75
 | Marquette | 77
 | Menominee | 78
 | Milwaukee | 79
 | Monroe | 81
 | Oconto | 83
 | Oneida | 85
 | [NAME] | 87
 | Ozaukee | 89
 | Pepin | 91
 | Pierce | 93
 | Polk | 95
 | Portage | 97
 | Price | 99
 | Racine | 101
 | Richland | 103
 | Rock | 105
 | Rusk | 107
 | St. Croix | 109
 | Sauk | 111
 | Sawyer | 113
 | Shawano | 115
 | [NAME] | 117
 | [NAME] | 119
 | Trempealeau | 121
 | Vernon | 123
 | [NAME] | 125
 | Walworth | 127
 | Washburn | 129
 | Washington | 131
 | [NAME] | 133
 | Waupaca | 135
 | [NAME] | 137
 | Winnebago | 139
 | Wood | 141
Spreadsheet: 73728d1274321974-value-from-a-field-in-another-sheet-with-multiple-criteria-example
Sheet: Sheet2

Type | Fruit | Colour | Size | Percentage
Tree | Apple | Green | Small | 15
Tree | Apple | Green | Large | 26
Tree | Apple | Red | Small | 94
Tree | Apple | Red | Large | 12
Tree | Pear | Green | Small | 15
Tree | Pear | Green | Large | 22
Tree | Pear | Red | Small | 82
Tree | Pear | Red | Large | 14
Spreadsheet: 137621d1327261112-if-a-name-from-dropdown-then-e-list-item-and-g-list-item-as
Sheet: Sheet1

name |  |  |  | fruit |  | color
billy bob |  |  |  | banana |  | yellow
list of names |  |  |  | fruit data |  |  |  |  |  |  |  |  |  |  | fruit | color
billy bob |  |  |  | apple |  | red |  |  | apple | banana |  |  |  |  | apple | red
[NAME] |  |  |  | banana |  | yellow |  |  | red | yellow |  |  |  |  | banana | yellow
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | black
Spreadsheet: 877167d1723838392-index-small-formula-relationship-book-2
Sheet: Sheet1

Employee ID | Name | Relationship | Date of Birth |  | Relationship List |  | Employee ID | Name | Employee Date of birth | Spouse Date of Birth | Child 1 Date of birth | Child 2 Date of birth | Child 3 Date of birth | Child 4 Date of birth | Child 5 Date of birth | Child 6 Date of birth
1 | [NAME] | Employee | 1980-01-06 00:00:00 |  | Spouse
2 | [NAME] | Employee | 1984-05-18 00:00:00 |  | Ex-Spouse
2 | [NAME] | Spouse | 1986-02-10 00:00:00 |  | Domestic Partner
2 | [NAME] | Child | 2016-04-05 00:00:00
2 | [NAME] | Child | 2018-07-06 00:00:00
3 | [NAME] | Employee | 1960-05-24 00:00:00
3 | [NAME] | Ex-Spouse | 1962-08-17 00:00:00
3 | [NAME] | Child | 1985-05-06 00:00:00
4 | [NAME] | Employee | 1990-01-04 00:00:00
4 | Stevie Jones | Domestic Partner | 1991-05-01 00:00:00
Spreadsheet: 109012d1305917702-sumproduct-or-countif-sptest
Sheet: Sheet1

 |  |  | Expected Col C result
[NAME] | [NAME] |  | 1
[NAME] | [NAME] |  | 1
[NAME] | [NAME] |  | 1
[NAME] | [NAME] |  | 2
[NAME] | [NAME] |  | 1
[NAME] | [NAME] |  | 1
[NAME] | [NAME] |  | 1
[NAME] | [NAME] |  | 2
[NAME] | [NAME] |  | 2
[NAME] | [NAME] |  | 3
[NAME] | [NAME] |  | 4
[NAME] | [NAME] |  | 5
[NAME] | [NAME] |  | 1
[NAME] | [NAME] |  | 2
[NAME] | [NAME] |  | 1
jane | [NAME] |  | 2
Spreadsheet: 677856d1589554995-how-do-i-get-the-current-number-of-consecutive-wins-win-streak
Sheet: Sheet1

 | Current win streak | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16
1 | 2 | Win | Lose | Win | Win | Win | Lose | Lose | Win | Win
2 | 1 | Lose | Win | Win | Lose | Lose | Win | Lose | Lose | Win
3 | 4 | Lose | Lose | Win | Lose | Lose | Win | Win | Win | Win
4 | 0 | Win | Win | Lose | Lose | Win | Lose | Lose | Lose | Lose
5 | 0 | Win | Lose | Win | Lose | Lose | Win | Win | Win | Lose
Spreadsheet: 688649d1595888916-using-data-validation-to-link-data-to-different-locations-excel-help-2
Sheet: Financing Structure & Fees Ass.

Financing Structure
 | Structure
Sources of Funds | Structure 1 | Structure 2 | Structure 3 | Structure 4 | Status Quo
Revolving Credit Facility Size | 250 | 250 | 250 | 250
Revolving Credit Facility Draw
Term Loan A |  | 500
Term Loan B | 2150 | 1650 | 2100 | 1750
Term Loan C
2nd [NAME]
Senior Notes | 1500 | 1500 | 700 | 1000
Senior Suboridinate Notes |  |  | 700 | 1000
Senior Bridge Facility
Senior Subordinate Bridge Facility
Equity Contribution | 2100 | 2100 | 2250 | 2250
Rollover Equity
Cash and Cash Equivalents | 250 | 250 | 250
Total Sources of Funds
Uses of Funds
Equity Purchase Price | 4350 | 4350 | 4350 | 4350 | 4350
Existing Bank Debt | 1000 | 1000 | 1000 | 1000 | 1000
Existing Bond Debt | 500 | 500 | 500 | 500 | 500
Existing Mezzanine Debt | 0 | 0 | 0 | 0 | 0
Tender / Call Premiums | 20 | 20 | 20 | 20 | 20
Deferred Financing Fees | 90 | 90 | 90 | 90 | 90
Other Fees and Expenses | 40 | 40 | 40 | 40 | 40
Total Use of Funds
Financing Fees
 |  | Fees
 | Structure 1 | Size | (%) | ($)
Revolving Credit Facility Size |  |  | 0.015
Term Loan A |  |  | 0.015
Term Loan B |  |  | 0.015
Term Loan C |  |  | 0.015
2nd [NAME] |  |  | 0.0225
Senior Notes |  |  | 0.0225
Senior Suboridinate Notes |  |  | 0.0225
Senior Bridge Facility |  | 1500 | 0.01
Senior Subordinate Bridge Facility |  | 0 | 0.01
Other Financing Fees & Expense |  |  |  | 5.3
Total Financing Fees
Amortization of Financing Fees
 | Term | Year 1 2013 | Year 2 2014 | Year 3 2015 | Year 4  2016 | Year 5 2017 | Year 6  2018 | Year 7  2019 | Year 8 2020 | Year 9  2021 | Year 10 2022
Revolving Credit Facility Size | 6
Term Loan A
Term Loan B | 7
Term Loan C
2nd [NAME]
Senior Notes | 8
Senior Suboridinate Notes
Senior Bridge Facility | 8
Senior Subordinate Bridge Facility
Other Financing Fees & Expense | 8
Annual Amortization
Spreadsheet: 221010d1363348136-creating-tables-from-a-main-table-that-is-updating-from-an-external-source-table-to-table
Sheet: Sheet1

TEAM | SCORE | PRICE | CONDITION
ARSENAL | 28 | 1.019587934030636 | True
MANUTD | 65 | 1.420883152770701 | True
CHELSEA | 81 | 1.752278904739712 | True
LIVERPOOL | 0 | 1.465495430472571 | True
ARSENAL | 27 | 1.955683609781523 | False |  | <<False therfore does not make it to the table below
ARSENAL | 24 | 1.732711639002429 | True
CHELSEA | 99 | 1.277467080792022 | True
MANUTD | 78 | 1.991946518035425 | False
CHELSEA | 8 | 1.489320361685431 | True
CHELSEA | 8 | 1.43 | False
ARSENAL | 8 | 1.87 | True
 |  |  |  |  |  | TEAM | STAKE | PRICE
 |  |  |  |  |  | ARSENAL | 28 | 1.02
 |  |  |  |  |  | ARSENAL | 24 | 1.73
 |  |  |  |  |  | ARSENAL | 8 | 1.82
Spreadsheet: 546295d1509981357-cascading-drop-down-data-validation-lists-with-only-unique-items-dynamic-drop-down
Sheet: List

list | manager | cashier | janitor
 |  |  |  |  |  | enter your jobs along the top and alter the ranges to suit your tables in the Table Sheet then drag to suit.
 |  |  |  |  |  | the lists update automaticly as will the drop downs to suit the information
Spreadsheet: 870553d1717056516-transpose-with-filter-to-create-new-data-row-transpose-testing-aligw
Sheet: Sheet3

508584 | Skill 1 |  | Skill 2 | Skill 3 | Skill 4 | Skill 5 | Skill 6 | Skill 7 | Skill 8 | Skill 9 | Skill 10
 | Skill 2
 | Skill 3
 | Skill 4
 | Skill 5
 | Skill 6
 | Skill 7
 | Skill 8
 | Skill 9
 | Skill 10
506008 | Skill1 |  | Skill2 | Skill3 | Skill4 | Skill5 | Skill6 | Skill7 | Skill8 | Skill9 | Skill10
 | Skill2
 | Skill3
 | Skill4
 | Skill5
 | Skill6
 | Skill7
 | Skill8
 | Skill9
 | Skill10
 | Skill11
 | Skill12
 | Skill13
 | Skill14
 | Skill15
 | Skill16
 | Skill17
 | Skill18
 | Skill19
 | Skill20
 | Skill21
521813 | Skill 1 |  | Skill 2 | Skill 3 | Skill 4 | Skill 5 | Skill 6 | Skill 7 | Skill 8 | Skill 9 | Skill 10
 | Skill 2
 | Skill 3
 | Skill 4
 | Skill 5
 | Skill 6
 | Skill 7
 | Skill 8
 | Skill 9
 | Skill 10
 | Skill 11
 | Skill 12
 | Skill 13
 | Skill 14
 | Skill 15
 | Skill 16
 | Skill 17
 | Skill 18
 | Skill 19
 | Skill 20
Spreadsheet: 214242d1360852043-how-to-select-records-meeting-specific-criteria-example
Sheet: Sheet1

AJ |  |  | AL |  |  | AM
Company | Country |  | Company | Country |  | Company | Country
ABC | DE |  | OPQ | UK |  | AAA | UK
DEF | FR |  | RST | FR |  | BBB | GR
HIJ | UK |  | UVW | UK
KLM | UK |  | XYZ | CN
Select: | AL
 | OPQ
 | UVW
AJ
AL
AM
Spreadsheet: 0558ac89-b8a4-4fb6-9bfb-48fb285af4fc
Sheet: Compatibility Report

 | Compatibility Report for PTA Advising Master, LOCKED.xls
 | Run on 5/11/2010 13:06
 | The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
 | Significant loss of functionality |  |  | # of occurrences
 | Some cells have more conditional formats than are supported by the selected file format. Only the first three conditions will be displayed in earlier versions of Excel. |  |  | 17
 |  |  |  | 'PTA Checksheet'!I9
 |  |  |  | 'PTA Checksheet'!I11
 |  |  |  | 'PTA Checksheet'!I13
 |  |  |  | 'PTA Checksheet'!I15
 |  |  |  | 'PTA Checksheet'!I17
 |  |  |  | 'PTA Checksheet'!I19
 |  |  |  | 'PTA Checksheet'!I21
 |  |  |  | 'PTA Checksheet'!I23
 |  |  |  | 'PTA Checksheet'!I25
 |  |  |  | 'PTA Checksheet'!I27
 |  |  |  | 'PTA Checksheet'!T9
 |  |  |  | 'PTA Checksheet'!T11
 |  |  |  | 'PTA Checksheet'!T13
 |  |  |  | 'PTA Checksheet'!T25
 |  |  |  | 'PTA Checksheet'!T23
 |  |  |  | 'PTA Checksheet'!T19
 |  |  |  | 'PTA Checksheet'!T17
 | One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, such as data bars, color scales, or icon sets. |  |  | 4
 |  |  |  | 'PTA Checksheet'!AJ21
 |  |  |  | 'PTA Checksheet'!F32
 |  |  |  | 'PTA Checksheet'!Z57
 |  |  |  | 'PTA Checksheet'!F34
 | Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition. |  |  | 13
 |  |  |  | 'PTA Checksheet'!E31:E34
 |  |  |  | 'PTA Checksheet'!I9:T27
 | Minor loss of fidelity
 | A table style is applied to a table in this workbook. Table style formatting cannot be displayed in earlier versions of Excel. |  |  | 4
 |  |  |  | 'PTA Checksheet'!Y32:AA42
 |  |  |  | 'PTA Checksheet'!AC32:AE207
 |  |  |  | 'PTA Checksheet'!AG32:AH37
 |  |  |  | 'PTA Checksheet'!AG39:AG41
 | Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. |  |  | 51
Spreadsheet: 18b54cc7-d39e-4048-b90f-95d21ecf946c
Sheet: Check Register

 | [Enter RSO Name Here]
 | Number | Date | Description of Transaction | C | Debit   (-) | Credit (+) | Balance
 |  |  | Previous balance
Spreadsheet: 688588d1595860511-how-to-rank-filtered-cells-w-o-duplicates-w-o-breaking-sequence-2020-07-27-oeldere-villalobos-688578d1595857861-how-to-rank-filtered-cells-w-o-duplicates-w-
Sheet: sample

 | Problem: How to rank (in column B) filtered cells w/o duplicates w/o breaking sequence?
 | Actual formula
Rank | Designation | Material | Progress |  | rank |  | Designation | Material | Progress
 | A50T14 | 8005604 | 0
 | A100T11 | 49327165 | 0
 | A50T12 | 49413254 | 0
 | A50T11 | 49422339 | 0
 | A50T14 | 49325000 | 0.0963718820861678
 | A50T11 | 8007802 | 0.1858864027538726
 | A50T12 | 8996380 | 0.2200320880128352
 | A50T14 | 49373647 | 0.3025210084033613
Spreadsheet: daren_farmer__5070__HPLN0519
Sheet: Sheet1

HPLN0519.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - May 19-21, 2001
 |  |  |  |  |  | **Sat/Sun | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 5/19-20/2001 | 2001-05-21 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 267123d1379958415-address-list-transformation-compnameandaddress
Sheet: Address

Company Name | Address | Company: | Address: | Tel: | Fax: | [NAME]: | Website:
Company: | ABC Co Ltd
Address: | 1 Scotts Road
Tel: | +81 1111 2222
Fax: | +81 5555 6666
[NAME]: | [EMAIL]
Website: | www.mydomain.com
Company: | Another Co Ltd
Address: | Random Street 44
Tel: | +86 6666 7777
[NAME]: | [EMAIL]
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-4

Tuesday
Deal #s | 759130 |  | 759133 | 759138 | 759139 | 759256 | 759305 | 759550
2001-09-04 00:00:00 |  |  | NP | SP | SP | SP | PV | SP
Delivery Pt. | EPMI CA Pool |  | Sale | Sell | Buy | Buy | export | Sell
Counterparty | NP | SP | EES | EES | EES | STSW CA Imbal | STSW | CA Imbal
Totals | -3120 | 3120 | -4400 | -800 | 4896 | 200 | -200 | -200
1 | 101 | -101 | -250 | -100 |  | 25 | -25 | -25
2 | 101 | -101 | -250 | -100 |  | 25 | -25 | -25
3 | 101 | -101 | -250 | -100 |  | 25 | -25 | -25
4 | 101 | -101 | -250 | -100 |  | 25 | -25 | -25
5 | 101 | -101 | -250 | -100 |  | 25 | -25 | -25
6 | 101 | -101 | -250 | -100 |  | 25 | -25 | -25
7 | -233 | 233 | -150 |  | 306 |  |  | 0
8 | -233 | 233 | -150 |  | 306 |  |  | 0
9 | -233 | 233 | -150 |  | 306 |  |  | 0
10 | -233 | 233 | -150 |  | 306 |  |  | 0
11 | -233 | 233 | -150 |  | 306 |  |  | 0
12 | -233 | 233 | -150 |  | 306 |  |  | 0
13 | -233 | 233 | -150 |  | 306 |  |  | 0
14 | -233 | 233 | -150 |  | 306 |  |  | 0
15 | -233 | 233 | -150 |  | 306 |  |  | 0
16 | -233 | 233 | -150 |  | 306 |  |  | 0
17 | -233 | 233 | -150 |  | 306 |  |  | 0
18 | -233 | 233 | -150 |  | 306 |  |  | 0
19 | -233 | 233 | -150 |  | 306 |  |  | 0
20 | -233 | 233 | -150 |  | 306 |  |  | 0
21 | -233 | 233 | -150 |  | 306 |  |  | 0
22 | -233 | 233 | -150 |  | 306 |  |  | 0
23 | 101 | -101 | -250 | -100 |  | 25 | -25 | -25
24 | 101 | -101 | -250 | -100 |  | 25 | -25 | -25
TIE POINTS
Spreadsheet: 273027d1382587074-reversing-the-order-of-auto-updated-rows-into-a-new-sheet-hammertest-iv
Sheet: Sheet2

Reference | Name | Type | Value | Average | Report