tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 852018d1702116303-need-formula-to-automatically-sum-all-values-within-a-year-excel-workbook
Sheet: Ark

0.2 | 2018-10-19 00:00:00
0.2 | 2018-12-27 00:00:00
0.2 | 2019-03-28 00:00:00
0.2 | 2019-06-19 00:00:00
0.21 | 2019-09-20 00:00:00
0.21 | 2020-01-01 00:00:00
0.22 | 2020-03-23 00:00:00
0.22 | 2020-06-17 00:00:00
0.22 | 2020-09-22 00:00:00
0.07 | 2020-10-22 00:00:00
0.07 | 2020-11-20 00:00:00
0.08 | 2020-12-18 00:00:00
0.07 | 2021-01-21 00:00:00
0.08 | 2021-02-18 00:00:00
0.08 | 2021-03-23 00:00:00
0.07 | 2021-04-22 00:00:00
0.08 | 2021-05-24 00:00:00
0.08 | 2021-06-22 00:00:00
0.07 | 2021-07-22 00:00:00
0.08 | 2021-08-23 00:00:00
0.08 | 2021-09-22 00:00:00
0.08 | 2021-10-21 00:00:00
0.08 | 2021-11-22 00:00:00
0.08 | 2021-12-21 00:00:00
0.08 | 2022-01-21 00:00:00
0.08 | 2022-02-18 00:00:00
0.08 | 2022-03-23 00:00:00
0.06 | 2022-04-21 00:00:00
0.04 | 2022-04-21 00:00:00
0.04 | 2022-05-12 00:00:00
0.06 | 2022-05-12 00:00:00
0.06 | 2022-06-21 00:00:00
0.02 | 2022-06-21 00:00:00
0.02 | 2022-07-21 00:00:00
0.06 | 2022-07-21 00:00:00
0.06 | 2022-08-23 00:00:00
0.02 | 2022-08-23 00:00:00
0.02 | 2022-09-22 00:00:00
0.07 | 2022-09-22 00:00:00
0.06 | 2022-10-21 00:00:00
0.02 | 2022-10-21 00:00:00
0.02 | 2022-11-22 00:00:00
0.06 | 2022-11-22 00:00:00
0.07 | 2022-12-21 00:00:00
0.02 | 2022-12-21 00:00:00
0.02 | 2023-01-23 00:00:00
0.06 | 2023-01-23 00:00:00
0.06 | 2023-02-20 00:00:00
0.02 | 2023-02-20 00:00:00
0.02 | 2023-03-23 00:00:00
0.07 | 2023-03-23 00:00:00
0.07 | 2023-04-21 00:00:00
0.07 | 2023-05-23 00:00:00
0.08 | 2023-06-21 00:00:00
0.07 | 2023-07-21 00:00:00
0.07 | 2023-08-23 00:00:00
0.08 | 2023-09-29 00:00:00
0.07 | 2023-10-23 00:00:00
0.08 | 2023-11-22 00:00:00
0.08 | 2023-12-29 00:00:00
0.07 | 2024-01-23 00:00:00
0.08 | 2024-02-21 00:00:00
0.08 | 2024-03-20 00:00:00
 | 2018
0.61 | 2019
1.09 | 2020
0.9299999999999998 | 2021
1.02 | 2022
0.9199999999999999 | 2023
0.23 | 2024
Spreadsheet: 678753d1590050260-sum-range-across-worksheet-with-transposition-test-sum-range-across-worksheet
Sheet: Sheet5

 | 227 | 872 | 460 | 978 | 414 | 129 | 821 | 678 | 381 | 32 | 943
 | 65 | 179 | 925 | 285 | 919 | 969 | 424 | 564 | 647 | 556 | 845
 | 640 | 67 | 526 | 290 | 252 | 97 | 976 | 525 | 771 | 179 | 180
 | 110 | 290 | 226 | 992 | 34 | 27 | 492 | 115 | 275 | 75 | 185
 | 364 | 681 | 526 | 217 | 298 | 767 | 217 | 96 | 105 | 962 | 648
 | 991 | 319 | 388 | 844 | 102 | 172 | 574 | 759 | 844 | 999 | 599
 | 522 | 589 | 667 | 257 | 581 | 558 | 147 | 267 | 689 | 387 | 697
 | 159 | 542 | 60 | 23 | 467 | 6 | 574 | 358 | 333 | 364 | 220
 | 468 | 546 | 435 | 535 | 252 | 174 | 830 | 113 | 653 | 898 | 100
 | 526 | 725 | 220 | 997 | 309 | 18 | 747 | 995 | 755 | 276 | 551
 | 443 | 322 | 232 | 986 | 473 | 723 | 471 | 138 | 726 | 921 | 186
 | 726 | 703 | 470 | 180 | 912 | 139 | 777 | 253 | 472 | 707 | 820
 | 280 | 115 | 618 | 884 | 333 | 230 | 998 | 204 | 631 | 82 | 962
Spreadsheet: 680374d1590996357-consolidate-information-and-return-a-value-with-max-results-in-the-row-2020-06-01-oeldere-purlo-680372d1590995406-consolidate-information-and-return-a-value-with-ma
Sheet: Sheet1

 | name1 |  | 2019-01-01 00:00:00 | name1
 | [NAME] |  | 2019-01-02 00:00:00 | [NAME] |  | Should be empty because most recent result is empty in C16
 | name3 | 1 | 2019-01-03 00:00:00 | name3
 | name4 | 1 | 2019-01-04 00:00:00 | name4 |  | Should be 1 bacause  C9 is empty.
 | name5 | 1 | 2019-01-05 00:00:00 | name5
 | [NAME] | 1 | 2019-01-06 00:00:00
 | name3 |  | 2019-01-07 00:00:00
 | name4 |  | 2019-01-08 00:00:00
 | name5 |  | 2019-01-09 00:00:00
 | name1 | 1 | 2019-01-10 00:00:00
 | [NAME] | 1 | 2019-01-11 00:00:00
 | name3 |  | 2019-01-12 00:00:00
 | name4 | 1 | 2019-01-13 00:00:00
 | name5 |  | 2019-01-14 00:00:00
 | [NAME] |  | 2019-01-15 00:00:00
Spreadsheet: 121631d1316206004-count-function-sample
Sheet: Sheet1

Items | Item#1 | Item#2 | Item#3 | [NAME] | Item#5 | Item#6 | Item#7 | Item#8 | Item#9 | Item#10 | Item#11 | [NAME] | Item#13 | Item#14 | Item#15
Date finished | 2011-01-15 00:00:00 | 2011-03-08 00:00:00 | 2011-03-29 00:00:00 | 2011-04-20 00:00:00 | 2011-05-20 00:00:00 | 2011-05-22 00:00:00 | 2011-07-08 00:00:00 | 2011-07-22 00:00:00 | 2011-08-08 00:00:00 | 2011-08-12 00:00:00 | 2011-08-23 00:00:00 | 2011-08-25 00:00:00 | 2011-09-01 00:00:00 | 2011-09-03 00:00:00 | 2011-09-14 00:00:00
Today | 2011-09-16 00:00:00
# of Items finished over 90 days
Spreadsheet: 847135d1698213669-help-extracting-strings-from-a-cloud-dataset-test-data
Sheet: Sheet1

Tags | costCentre | costcentre | CostCentre | application | Application | applicationName | projectName | environment | Environment
"applicationName": "Biz","managedBy": "[EMAIL]","ownedBy": "[EMAIL]","projectName": "ztalk","businessUnit": "ENT","requestID": "M-PRJ0048360","environment": "DEV","dataClassification": "Confidential","costCentre": "Z3064N","telstraBackup": "POL01","telstraManaged": "true","telstraPatching": "Thu9PM_Win","costcentre": "Z3001N" | Z3064N | Z3001N |  |  |  | Biz | ztalk | DEV
"CitrixProvisioningSchemeId": "c5c6ad","CitrixResource": "Internal","applicationName": "asd","businessUnit": "BUS","costCentre": "Z3006N","dataClassification": "Confidential","environment": "DR","managedBy": "[EMAIL]","ownedBy": "[EMAIL]","projectName": "BCP","requestId": "REQ0687032","application": "asd123" | Z3006N |  |  | asd123 |  |  | BCP | DR
Spreadsheet: 862978d1710525367-calendar-formulas-and-conditional-formatting-annual-calendar-dj
Sheet: May

 |  |  |  |  |  |  |  |  | MAY
 | NOTES
Spreadsheet: a0ae4e57-a963-41c5-ace2-171b893b9466
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 | Unnamed: 12
American Youth Soccer Organization
REIMBURSEMENT REQUEST FORM
 | Payable to: |  |  |  |  | Date: | 4 | / | 27 | / | 2012
 | Address:
 | AYSO Position: |  |  | Section: | 10 | Area: | E | Region: |  | 363 | 363
TRAVEL
Date | Description |  | Travel | Miles @ $0.55 | Lodging | Meals |  |  | Other |  |  | Subtotal
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
Travel Costs to be Reimbursed: |  |  | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0
OPERATIONS
Date | Description |  | Telephone | Postage | Supplies | Printing |  |  | Other |  |  | Subtotal
Operational Costs to be Reimbursed: |  |  | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | Grand Total to be Reimbursed: | 0
Please indicate the purpose of the expenditures so that the appropriate budget cost center may be charged:
I hereby certify that the above is a true and correct statement of expenses incurred by me in the serivce of AYSO.
Signature
NOTE: All requests for reimbursement must be within 60 days from the date incurred and must be accompanied with
supporting documents. Failure to follow this procedure may result in disallowance of the request.
 | Approved by: |  |  |  |  | Date: |  | / |  | /
Spreadsheet: 707161d1607077223-count-cells-with-a-condition-sample
Sheet: Sheet1

Data |  |  | 2020-10-10 00:00:00 |  | 2020-10-15 00:00:00 |  |  | 2020-10-10 00:00:00 | 2020-10-10 00:00:00 | 2020-10-15 00:00:00 | 2020-10-10 00:00:00
2020-10-10 00:00:00 | Yes |  | Yes | No | Yes | No |  | Yes | No | Yes | No
2020-10-10 00:00:00 | Yes
2020-10-10 00:00:00 | Yes
2020-10-10 00:00:00 | No
2020-10-10 00:00:00 | No
2020-10-15 00:00:00 | Yes
2020-10-15 00:00:00 | No
2020-10-15 00:00:00 | No
2020-10-15 00:00:00 | Yes
2020-10-15 00:00:00 | No
Spreadsheet: kate_symes__18597__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-07 00:00:00 |  | 170.73 | 11184 | 140.82 | 10680
 | 2001-02-06 00:00:00 |  | 167.38 | 11280 | 146.9 | 6640
 | 2001-02-05 00:00:00 |  | 165.77 | 7120 | 151.67 | 6392
 | 2001-02-04 00:00:00 |  |  |  |  |  | 152.31 | 20376
 | 2001-02-03 00:00:00 |  | 181.02 | 12256 | 156.16 | 8432
 | 2001-02-02 00:00:00 |  | 179.62 | 13336 | 156.19 | 7512
 | 2001-02-01 00:00:00 |  | 219.11 | 13984 | 176.57 | 4368
 | 2001-01-31 00:00:00 |  | 238.8 | 20288 | 184.92 | 4640
 | 2001-01-30 00:00:00 |  | 222.41 | 19968 | 176.45 | 6240
 | 2001-01-29 00:00:00 |  | 227.4 | 21840 | 181.89 | 4440
 | 2001-01-28 00:00:00 |  |  |  |  |  | 181.89 | 13320
 | 2001-01-27 00:00:00 |  | 211.11 | 21472 | 172.47 | 4456
 | 2001-01-26 00:00:00 |  | 211.11 | 21392 | 172.47 | 4456
 | 2001-01-25 00:00:00 |  | 208.12 | 14880 | 179.01 | 6280
 | 2001-01-24 00:00:00 |  | 222.73 | 18880 | 169.8 | 6240
 | 2001-01-23 00:00:00 |  | 251.47 | 12800 | 171.59 | 5800
 | 2001-01-22 00:00:00 |  | 267.54 | 15440 | 185.36 | 2800
 | 2001-01-21 00:00:00 |  |  |  |  |  | 185 | 2400
 | 2001-01-20 00:00:00 |  | 435.91 | 4400 | 260.09 | 3584
 | 2001-01-19 00:00:00 |  | 435.91 | 4400 | 260.09 | 3584
 | 2001-01-18 00:00:00 |  | 326.07 | 5600 | 216.1 | 3080
 | 2001-01-17 00:00:00 |  | 232.5 | 8000 | 179.95 | 3680
 | 2001-01-16 00:00:00 |  | 181.85 | 13600 | 133.91 | 1880
 | 2001-01-15 00:00:00 |  | 181.85 | 13600 | 133.91 | 1880
 | 2001-01-14 00:00:00 |  |  |  |  |  | 128.51 | 4440
 | 2001-01-13 00:00:00 |  | 169.31 | 26800 | 128.51 | 1480
 | 2001-01-12 00:00:00 |  | 170.09 | 18800 | 123.67 | 2400
 | 2001-01-11 00:00:00 |  | 170.09 | 18800 | 123.67 | 2400
 | 2001-01-10 00:00:00 |  | 164.78 | 14800 | 129.9 | 2000
 | 2001-01-09 00:00:00 |  | 155.6 | 14000 | 129.75 | 3200
 | 2001-01-08 00:00:00 |  | 135.72 | 11600 | 102.7 | 2000
Spreadsheet: 861688d1709562111-pulling-data-from-multiple-excel-sheet-payroll-test
Sheet: Summary

DONOTIMPORT | JOURNAL | DATE | REVERSEDATE | [NAME] | REFERENCE_NO | LINE_NO | ACCT_NO | LOCATION_ID | DEPT_ID | DOCUMENT | MEMO | DEBIT | CREDIT | SOURCEENTITY | ALLOCATION_ID | BILLABLE | TAXIMPLICATIONS | TAXSOLUTIONID | TAX_VENDORID | TAX_CUSTOMERID | TAX_CONTACTID | TAX_DETAILID | TAX_AMOUNT | [NAME] | SAGE50_REFERENCE | SAGE50_JOURNAL | GLENTRY_VENDORID | GLENTRY_EMPLOYEEID | GLENTRY_CLASSID | TAX_LINE_NO
 | GJ |  |  |  | 1 |  |  | [NAME] |  |  | Net Wages |  |  |  |  |  |  | United Kingdom - VAT
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
Spreadsheet: 861397d1709269504-group-by-percentages-in-power-query-groupby-allisterb-mohamedgadallah
Sheet: Sheet1

 |  |  |  |  |  |  | Dept | Employee | Value
 |  |  |  |  |  |  | 100 | [NAME] | 10
 |  |  |  |  |  |  | 200 | [NAME] | 5
 |  |  |  |  |  |  | 100 | [NAME] | 20
 |  |  |  |  |  |  | 300 | [NAME] | 80
 |  |  |  |  |  |  | 400 | [NAME] | 300
 |  |  |  |  |  |  | 100 | [NAME] | 50
 |  |  |  |  |  |  | 200 | [NAME] | 40
 |  |  |  |  |  |  | 500 | [NAME] | 60
 |  |  |  |  |  |  | 300 | [NAME] | 50
 |  |  |  |  |  |  | Employee | Dept | Sum By Employee by Dept | Total For Employee | %
 |  |  |  |  |  |  | [NAME] | 100 | 10
 |  |  |  |  |  |  | [NAME] | 200 | 5
 |  |  |  |  |  |  | [NAME] | 100 | 20
 |  |  |  |  |  |  | [NAME] | 300 | 80
 |  |  |  |  |  |  | [NAME] | 400 | 300
 |  |  |  |  |  |  | [NAME] | 100 | 50
 |  |  |  |  |  |  | [NAME] | 200 | 40
 |  |  |  |  |  |  | [NAME] | 500 | 60
 |  |  |  |  |  |  | [NAME] | 300 | 50
Spreadsheet: 848040d1698848065-return-the-top-value-from-a-filtered-array-based-on-multiple-criteria-no-helper-columns-excel-forum-help
Sheet: Sheet1

 |  |  |  | Data
Input | Customer A |  |  | Customer | Product Purchased | Revenue
 |  |  |  | Customer A | Blue | 5
Output | Product Purchased with the most NET revenue |  |  | Customer B | Red | 1
 | BLUE |  |  | Customer C | Red | 1
 |  |  |  | Customer A | Blue | 5
 |  |  |  | Customer B | Red | 1
 |  |  |  | Customer C | Green | 2
 |  |  |  | Customer A | Orange | 20
 |  |  |  | Customer B | Red | 1
 |  |  |  | Customer C | Blue | 1
 |  |  |  | Customer A | Blue | 15
 |  |  |  | Customer B | Red | 2
 |  |  |  | Customer C | Gray | 2
Spreadsheet: 839290d1691790896-xlookup-not-showing-result-sample1
Sheet: Balances

EmplID | Rcd | Name | [NAME] | Empl Class | CSU Unit | [NAME] | Dept. Name | Job Code | Job Title | FTE | FLSA Status | Union Code | AM Pay Group | Absence Type | Termination Date | Beginning Balance | Adjustment Amount | Ending Balance | Adjustment Period | Adjustment Comments
 |  | Baidwan,[NAME] | Terminated | Temporary |  |  | Biology |  | Teaching Associate AY | 0.346667 | Exempt | R11 | R11 SAL X | Personal Holiday Balance | 2016-08-16 00:00:00 | 1 | 0 | 1
 |  | Bailey,Helen I | Retired | Regular |  |  | VP For University Advancement |  | [NAME] Analyst/Spclst 12 Mo | 1 | Nonexempt | R09 | CSUEU SALN | Personal Holiday Balance | 2021-11-01 00:00:00 | 1 | 0 | 1
 |  | Bailey,Helen I | Retired | Regular |  |  | VP For University Advancement |  | [NAME] Analyst/Spclst 12 Mo | 1 | Nonexempt | R09 | CSUEU SALN | Vac - Period End Balance | 2021-11-01 00:00:00 | 199.842 | 0 | 199.842
 |  | Bailey,[NAME] | Terminated | Student |  |  | Nursing |  | Teaching Associate AY | 0.132075 | Exempt | R11 | R11 SAL NX | Personal Holiday Balance | 2008-12-19 00:00:00 | 1 | 0 | 1
 |  | Bailey-Van Houten,[NAME] | Terminated | Temporary |  |  | Chemistry |  | [NAME] | 0.1 | Exempt | R03 | [NAME] | Personal Holiday Balance | 2012-06-30 00:00:00 | 1 | 0 | 1
Spreadsheet: mary_fischer__25609__32C-2001
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032C
COMPANY NAME   Enron Building Services Inc. Hldg Co.
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 783385d1654778717-update-of-iferror-lookup-formula-by-adding-max-formula-test_formula-etaf
Sheet: Sheet1

Name | EXM 1 | EXM CR1 | EXM 2 | EXM CR2 | EXM 3 | EXM CR3 | EXM4 | EXM CR4 | Final result
[NAME] | 57.5 | 60
Lukas | 55 | 62.5 | 60
Maria | 22.5 | 25 | 45 |  | n/a |  | 55
[NAME] | 52.5 |  | 60
[NAME] | 57.5 | 65 | 60
[NAME] | 90 | 92.5
Dwayne | 45 |  | 57.5 |  | 62.5
[NAME] | n/a |  | 45 |  | n/a |  | 60
Spreadsheet: 145730d1331725037-excel-2007-alternative-for-using-sumif-with-a-3d-reference-example-3d-sumif
Sheet: Loc_f

 |  |  | Area location: | Area2 |  |  |  |  |  |  |  | Loc_A
 |  |  |  |  |  | 2011 | 2012 | 2013 | 2014 | 2015
 |  |  |  |  | Sales | 100 | 250 | 300 | 100 | 50
 |  |  |  |  | Revenue | 50 | 125 | 150 | 50 | 25
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 13b

 |  | Dealers** |  |  | Buyside |  |  | TOTAL
Product |  | HY*** | IG | Other | HY | IG | Other | HY | IG | Other
Index Tranche* | Asia |  |  | 144 |  |  |  |  |  | 144
 | Europe |  |  | 535519 |  |  | 32313 |  |  | 567833
 | North America | 53970 | 519821 | 2086 | 7206 | 20964 | <100 | 61176 | 540785 | 2086
Index | Asia | 656 | 72285 | 134138 | <100 | 10651 | 29960 | 656 | 82936 | 164098
 | Europe |  |  | 2856062 |  |  | 961370 |  |  | 3817432
 | North America | 260055 | 1427638 | 231186 | 163711 | 785251 | 55726 | 423766 | 2212889 | 286912
TOTAL |  | 314682 | 2019744 | 3759135 | 170917 | 816866 | 1079369 | 485599 | 2836610 | 4838504
Estimated gross notional amount outstanding, October 25 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 82080d1282135303-sorting-multiple-instances-of-the-same-record-draft
Sheet: Sheet1

 | name | time |  |  |  | name | time totals
 | [NAME] | 01:00:00
 | [NAME] | 00:30:00
 | tom | 01:00:00
 | tom | 01:00:00
 | [NAME] | 00:30:00
 | [NAME] | 01:00:00
 | [NAME] | 00:30:00
 | tom | 00:30:00
 | [NAME] | 01:00:00
 | [NAME] | 00:30:00
 | tom | 01:00:00
Spreadsheet: 859332d1707750622-if-and-formula-test-file
Sheet: Sheet2

Group | ID Number | Location | Level | Pay
XPP | 89698 | 5698 |  |  | Actual Pay was 14.00 but change to 15. However group is not SOO
XPP | 95865 | 8978 |  | 16
XPP | 102032 | 12258 |  | 16
OEA | 108199 | 15538 |  | 12.5
OEA | 114366 | 18818 |  | 12.5
OEA | 120533 | 22098 |  | 12.5
OEA | 126700 | 25378 |  | 12.5
SOO | 132867 | 28658 | 17.85 | 16.85
SOO | 139034 | 31938 | 17.85 | 16.85
SOO | 145201 | 35218 |  | 16.85
SOO | 151368 | 38498 | (RSD) | 16.85
SOO | 157535 | 41778 |  | 16
SOO | 163702 | 45058 | (RSD) | 16.85
SOO | 169869 | 48338 |  | 16.85
SOO | 176036 | 51618 | (RSD) | 16
SOO | 182203 | 54898 | (RSD) | 16.85
SOO | 188370 | 58178 | (RSD) | 16.85
SOO | 194537 | 61458 |  | 16.85
SOO | 200704 | 64738 | (RSD) | 16.85
SOO | 206871 | 68018 | 20.2 | 16.85
SOO | 213038 | 71298 | (RSD) | 16.85
SOO | 219205 | 74578 | 18.3 | 16.85
TAE | 225372 | 77858 |  | 8
TAE | 231539 | 81138 |  | 8
TAE | 237706 | 84418 |  | 8
TAE | 243873 | 87698 |  | 8
TAE | 250040 | 90978 |  | 8
TAE | 256207 | 94258 |  | 8
TAE | 262374 | 97538 |  | 8
TAE | 268541 | 100818 |  | 8
EXA | 274708 | 104098 |  | 10
EXA | 280875 | 107378 |  | 10
EXA | 287042 | 110658 |  | 10
EXA | 293209 | 113938 |  | 10
EXA | 299376 | 117218 |  | 10
WOA | 305543 | 120498 |  | 16
WOA | 311710 | 123778 |  | 16
WOA | 317877 | 127058 |  | 16
WOA | 324044 | 130338 |  | 16
Spreadsheet: 13c4d4eb-56d4-454f-b6c9-6e31ab7903c6
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 14. COMMERCIAL FINANCE COMMITMENTS, Summary: Australia, All Series ($000)
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
Fixed loans ; |  |  | Original | A2414272W | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Original | A2414273X | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414274A | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Seasonally Adjusted | A2414269J | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Seasonally Adjusted | A2414270T | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Seasonally Adjusted | A2414271V | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Trend | A2414266A | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Trend | A2414267C | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Trend | A2414268F | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 866981d1713887716-help-extracting-specific-text-from-inconsistent-text-strings-data-set-new
Sheet: Sheet1

Invoice | Code Item or Activity Code | Description | QTY |  | Invoice | Code Item | Description | [NAME]
33593 | SI1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | 3 |  | 33593 | SI1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | MRTU2090087
33593 | LE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | 2 |  | 33593 | SI1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | FCIU6090526
33593 | GE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | 3 |  | 33593 | SI1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | MRTU213834
 |  |  |  |  | 33593 | LE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | MRTU2126493
 |  |  |  |  | 33593 | LE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | MRTU205845
 |  |  |  |  | 33593 | GE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | MRTU2126493
 |  |  |  |  | 33593 | GE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | MRTU205845
 |  |  |  |  | 33593 | GE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | MRTU213834
 | Note : This are example of Activity Code and Activity Name (The list is more then this)
 | Activity Code | Activity Name
 | PR1 | Plugging reefer
 | SI1 | STUFFING IN
 | LE1 | LIFT ON EMPTY
 | RC1 | REPAIR CONTAINER
 | TI1 | TAMBAH ISI
 | AK1 | ALIH KAPAL
 | TRF1 | THC & RELOKASI FULL
 | MRTU