tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 826223d1681868384-formula-needed-to-calculate-lower-and-upper-limits-in-n-number-performance-levels-onditi-performance-levels
Sheet: Sheet1

 | Total Marks | Performance Level |  |  | [NAME] | Levels |  |  | Lower | Upper | Expected |  | Interval
[NAME] | 63 |  |  |  | 100 | 4 |  | Exceeding Expectation | 0 |  | 0 | 25
[NAME] | 26 |  |  |  |  |  |  | Meeting Expectation |  |  | 26 | 50
George | 84 |  |  |  |  |  |  | Approaching Expectation |  |  | 51 | 75
Ringo | 12 |  |  |  |  |  |  | Below Expectation |  |  | 76 | 100
Spreadsheet: 74420d1274937582-form-creation-stale-financials
Sheet: LA

 |  | 1st Q | 2nd Q | 3rd Q | 4th Q
LA | Gaps b/w effective dates and filing of next quarter financials | 129 | 129 | 60 | 129
A | Gaps b/w effective dates and filing of next quarter financials | 129 | 129 | 75 | 129
Others | Gaps b/w effective dates and filing of next quarter financials | 134 | 134 | 90 | 134
IPO Issuers, Loss Corporations and Delinquent Filers | Gaps b/w effective dates and filing of next quarter financials |  |  | 45
 |  |  |  |  |  |  | FY End
 | 1st Q | Stale Date | 2nd Q | Stale Date | 3rd Q | Stale Date | 4th Q | Stale Date
LA | 2010-03-31 00:00:00 |  | 2010-06-30 00:00:00 |  | 2010-09-30 00:00:00 |  | 2010-12-31 00:00:00
A | 2010-03-31 00:00:00 |  | 2010-06-30 00:00:00 |  | 2010-09-30 00:00:00 |  | 2010-12-31 00:00:00
Others | 2010-03-31 00:00:00 |  | 2010-06-30 00:00:00 |  | 2010-09-30 00:00:00 |  | 2010-12-31 00:00:00
IPO Issuers, Loss Corporations and Delinquent Filers |  |  |  |  | 2010-09-30 00:00:00 |  | 2010-12-31 00:00:00
Spreadsheet: 786357d1657126886-data-from-multiple-date-formats-date-formats
Sheet: Sheet1

TABLE-1
 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Fuel Price | 100 | 125 | 150 | 175 | 200 | 225 | 250 | 275 | 300 | 325 | 350 | 375
TABLE-2
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Fuel Price | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 160
TABLE-3
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Fuel Price | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65
TABLE-4
 | 2022-04-01 00:00:00 | 2022-04-02 00:00:00 | 2022-04-03 00:00:00 | 2022-04-04 00:00:00 | 2022-04-05 00:00:00 | 2022-05-01 00:00:00 | 2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-06-01 00:00:00 | 2022-06-02 00:00:00 | 2022-06-03 00:00:00 | 2022-06-04 00:00:00 | 2022-06-05 00:00:00 | 2022-07-01 00:00:00 | 2022-07-02 00:00:00 | 2022-07-03 00:00:00 | 2022-07-04 00:00:00 | 2022-07-05 00:00:00
Fuel Price | 100 | 102 | 103 | 105 | 110 | 115 | 116 | 118 | 119 | 120 | 122 | 124 | 125 | 127 | 130 | 140 | 142 | 144 | 145 | 150
Month (with date) | Fuel Price | Source
6 | 225 | From Table-1
May | 200 | From Table-1
6 | 100 | From Table-2
2022-06-15 00:00:00 | 100 | From Table-2
2022-06-20 00:00:00 | 35 | From Table-3
May | 30 | From Table-3
6 | 130 | From Table-4 (Maximum date of month rate to be taken)
[NAME] required in the yellow highlighted cells.  Answers are shown for reference.
Spreadsheet: kate_symes__18951__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-28 00:00:00 |  | 118.22 | 28528 | 63.49 | 8720
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
Spreadsheet: mary_fischer__25628__1473-2001
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1473
COMPANY NAME  Bentley Engineering & Architecture
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION:  [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Balance transfer from 015A to 1473 to be handled in the third quarter |  | 0 |  | 96519 |  |  |  | 102206.02
Third Party AR trade - Incorrect mapping will be reclassed in third quarter |  |  |  |  |  |  |  | 2656992.09
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 53538d1253486265-how-to-extract-duplicate-rows-base-on-multiple-column-values-duplicates
Sheet: Sheet1

column name | schema | table name | data type | qualifiers | hide all duplicates | keep first duplicate | filter first on false
martin 1 | any 1 | some 3 | stuff 1 | qual 1 | 1 | 1 | filter second on true
[NAME] | any 2 | some 4 | stuff 1100 | qual 2 | 0 | 1
[NAME] | any 3 | some 5 | stuff 3 | qual 3 | 0 | 1
[NAME] | any 4 | some 6 | stuff 4 | qual 4 | 1 | 1
martin 5 | any 5 | some 7 | stuff 5 | qual 5 | 0 | 1
[NAME] | any 6 | some 8 | stuff 6 | qual 6 | 0 | 1
martin 1 | any 7 | some 9 | stuff 1 | qual 1 | 1 | 0
[NAME] | any 8 | some 10 | stuff 2 | qual 2 | 0 | 1
[NAME] | any 6 | some 8 | stuff 4 | qual 4 | 1 | 0
[NAME] | any 7 | some 9 | stuff 4 | qual 4 | 1 | 0
Spreadsheet: 539651d1506322607-extracting-values-to-new-tab-book2
Sheet: Sheet2

Parameter 1 | Parameter 2 | Parameter 3 | Parameter 4
Spreadsheet: 214989d1361218342-how-to-create-a-packing-list-from-a-distribution-list-blist
Sheet: 102

Books List
College ID:
College:
Address:
Books | Quantity
A guide to walking
Running in the Park
Night and Day
[NAME]
School Days
Final Warning
Culture and Society
Spreadsheet: e3e18c6b-eb71-408c-b96b-ac83e14afec9
Sheet: Sheet1

Snap-on Tools - Tool Storage | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Location | Name | Title | Phone | Fax | [NAME]
Kenosha, WI | [NAME] | President, Tool Storage | [PHONE] | [PHONE] | [EMAIL]
[NAME], IA | [NAME] | Manager, Purchasing Operations | [PHONE] | [PHONE] | [EMAIL]
Newmarket, ONT, Canada | [NAME] | Materials Manager | [PHONE] Ext 206 | [PHONE] | [EMAIL]
Newmarket, ONT, Canada | [NAME] | MRO Buyer | [PHONE]  ext 225 | [PHONE] | [EMAIL]
Spreadsheet: 51292d1250819812-slow-array-formulas-test
Sheet: Sheet4

 |  | 2009-04-06 00:00:00 | 2009-04-07 00:00:00 | 2009-04-08 00:00:00 | 2009-04-09 00:00:00 | 2009-04-10 00:00:00 | 2009-04-11 00:00:00 | 2009-04-12 00:00:00 | 2009-04-13 00:00:00 | 2009-04-14 00:00:00 | 2009-04-15 00:00:00 | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-04-18 00:00:00 | 2009-04-19 00:00:00 | 2009-04-20 00:00:00 | 2009-04-21 00:00:00 | 2009-04-22 00:00:00 | 2009-04-23 00:00:00 | 2009-04-24 00:00:00 | 2009-04-25 00:00:00 | 2009-04-26 00:00:00 | 2009-04-27 00:00:00 | 2009-04-28 00:00:00 | 2009-04-29 00:00:00 | 2009-04-30 00:00:00 | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | 2009-05-03 00:00:00
 | EMPLOYEE 1 |  | D | D | D |  |  |  | A | A | A |  | D | D | D | D |  |  | A | A | A | A |  | D | D | D |  |  |  | #N/A
 | EMPLOYEE 2 | A | A | A |  | D | D | D | D |  |  | A | A | A | A |  | D | D | D |  |  |  | A | A | A |  | D | D | D | #N/A
 | EMPLOYEE 3 |  |  | A | A | A | A | A |  |  | D | D | D | D |  | A | A | A | A | A |  |  | N | N | N |  |  | D | D | #N/A
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 5

 | Dec 21 | Dec 28 | Jan 4 | Jan 11 | Jan 18
Total Interest Rate* | 84500 | 84500 | 84500 | 84500 | 84500
Cleared** | N/A*** | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 323000 | 323000 | 323000 | 323000 | 323000
Weekly total, estimated swap event volumes by asset class and cleared status (in number of events), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 72d781f0-9ed0-4260-8d6d-09a65e0514c5
Sheet: Sheet1

Selected financial ratios - EHEP | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Ratios are based on data submitted by the company
 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
Equity ratio | 0 | 0 | 0 | 0.0005390250239458959 | 0 | 0.0009445795955602858 | 0
Return on assets (ROA) | -0.00369206645719623 | 0.01 | 0.01 | 0 | 0 | 0.01 | 0.01
Return on equity (ROE) | -0.003681823440011807 | 0.01 | 0.01 | 0 | 0 | 0.01 | 0.01
The information provided herein is for information purposes only and contains data submitted or uploaded by issuers. Data presented herein may be modified based on base period data in subsequent financial reports. The Budapest Stock Exchange Ltd. makes no representation or warranty as to the accuracy, completeness or authenticity of the data. For detailed terms of use, principles of data protection and liability provisions please refer to the relevant legal disclaimer. For further information please consult the relevant financial statements disclosed by the issuer.
Spreadsheet: sally_beck__35164__MgmtSum-Q3-0921_Global
Sheet: GM-WklyChnge

ENRON GLOBAL MARKETS
3RD QUARTER 2000 DETAIL OF GROSS MARGIN - WEEKLY CHANGE
Results based on activity through September 21, 2000
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Liquids |  | -10228 | 0 | 0 | -374 | 0 | -10602 | 0 | 0 | -10602
Coal |  | 1480 | 5.001999999999498 | -9.583 | 0 | 0 | 1475.418999999999 | 0 | 0 | 1475.418999999999
Emissions |  | 78 | 0 | 0 | 0 | 0 | 78 | 0 | 0 | 78
Weather |  | -483.495 | 0 | 0 | 0 | 0 | -483.495 | 0 | 0 | -483.495
Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Equity Trading |  | 969.7000000000007 | 0 | 0 | 0 | 0 | 969.7000000000007 | 0 | 0 | 969.7000000000007
FX / Int Rate Trading |  | 337 | 0 | 0 | 0 | 0 | 337 | 0 | 0 | 337
Soft Commodities Trading |  | -17.92 | 0 | 0 | 0 | 0 | -17.92 | 0 | 0 | -17.92
Grain Trading |  | 6.11 | 0 | 0 | 0 | 0 | 6.11 | 0 | 0 | 6.11
Meat Trading |  | 2.626 | 0 | 0 | 0 | 0 | 2.626 | 0 | 0 | 2.626
Financial Trading |  | 1297.516000000001 | 0 | 0 | 0 | 0 | 1297.516000000001 | 0 | 0 | 1297.516000000001
Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Overview |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Commercial |  | -7855.979 | 5.001999999999498 | -9.583 | -374 | 0 | -8234.56 | 0 | 0 | -8234.56
Other Interest Related Charges |  | 0 | 0 | 0 | 21.58699999999999 | 0 | 21.58699999999999 | 0 | 0 | 21.58699999999999
Global Markets Pre-tax Income |  | -7855.979 | 5.001999999999498 | -9.583 | -352.413 | 0 | -8212.973 | 0 | 0 | -8212.973
(1) Excludes Cap. Charge & Operating Costs
Spreadsheet: benjamin_rogers__1219__UAE's Cost Model with debt structure 04-13-00
Sheet: Cash Flows

[NAME]
 | 0
('000 $) | Close
EBITDA | 0
Less Interest Payments | 0
Pre-Tax Cashflow
Less Cash Taxes | 0
Less Principal Payments | 0
Less Capex | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cashflow to Equity
 | 1
Distribution to Equity
ENRON'S RETURNS ANALYSIS
[NAME] | 0.2
Lease Option
With 20% of Initial Project Costs |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Equity Return
Actual Cash Flow
[NAME] | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
7-Yr. Debt Option
With 20% of Initial Project Costs
Equity Return
Actual Cash Flow
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
10-Yr. Debt Option
With 20% of Initial Project Costs
Equity Return
Actual Cash Flow
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Spreadsheet: 163747d1340440371-formula-on-the-same-column-test
Sheet: Sheet1

 |  |  | 2016-03-24 00:00:00 | 2016-04-27 00:00:00 | 2016-05-30 00:00:00
1Ｆ | いつらく | Electricity | 88374 | 89339 | 90283
 |  | Gas | 8986 | 9213 | 9356
 |  | Water | 9181 | 9273 | 9360
Spreadsheet: 763419d1642166335-how-to-combine-multiple-columns-into-one-list-based-on-conditions-into-one-list-
Sheet: Sheet1

3/1 ET MPI | 3/1 CT MPI | 3/2 ET MPI | 3/1 MT MPI
1 | 18 | ET-25 | MT 40
2 | 19 | 26 | MT 50
3 | 20 | 27
4 | 21
5
6
My requirement is as follow:
Combine same Multiple Department Into One List as follow:
(Optional column header name)
3/ ET MPI | 3/ CT MPI | 3/ MT MPI
1 | 18 | MT 40 | ET= Electrical Technology
2 | 19 | MT 50 | CT = Civil Technology
3 | 20 |  | MT= Mechanical Technology
4 | 21
5
6
ET-25
26
27
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R7

Ime artikla
Spreadsheet: 849663d1700075806-conditional-formatting-an-entire-row-test
Sheet: Sheet4

Name | Date | Status | On going days
[NAME] | 2023-11-14 00:00:00 | Pending
[NAME] | 2023-01-20 00:00:00 | Pending |  |  |  |  |  | 3
[NAME] | 2023-10-05 00:00:00 | Done
[NAME] | 2023-11-14 00:00:00 | Pending
[NAME] | 2023-05-15 00:00:00 | Done
[NAME] | 2023-11-10 00:00:00 | Pending
Spreadsheet: 120000d1314907187-sales-sorting-question-sales-spreadsheet-example
Sheet: Sheet1

 | July Sales |  |  |  | July Report
1 | ABC | 11674 |  | 1
2 | DEF | 4794 |  | 2
10 | GHI | 26115 |  | 3
12 | JKL | 10543 |  | 5
 |  |  |  | 10
 |  |  |  | 20
 |  |  |  | 40
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 13d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 100227 | 909798 | 860026 | 28061 | 86164 | 121083
Europe | - | - | 852351 | - | - | 116824
North America/Asia | 100227 | 909798 | 7675 | 28061 | 86164 | 4259
Other | - | - | - | - | - | -
Index | 924103 | 3888197 | 6334937 | 476121 | 1828882 | 1699266
Asia | - | - | 187848 | - | - | 42256
Europe | - | - | 5493114 | - | - | 1515290
North America | 924103 | 3888197 | 183739 | 476121 | 1828882 | 62601
Other | - | - | 470236 | - | - | 79119
OTHER* | - | - | 923372 | - | - | 415036
TOTAL | 1024330 | 4797995 | 8118335 | 504182 | 1915046 | 2235385
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 721640d1614797110-aggregate-narrowed-down-gives-different-result-sample
Sheet: Sheet1

A | 2
B | 5
C | 4
Spreadsheet: 137889d1327422503-data-validation-gone-wrong-kol-wb-distributor-billing-frequency-aso11
Sheet: Sheet1

KOL |  |  |  |  |  |  |  |  |  | KOL
 | No of Orders | No of Distributors - Aug'11 | No of Distributors - Sep'11 | No of Distributors - Oct'11 | Cumm %of Distributors - Aug'11 | Cumm %of Distributors - Sep'11 | Cumm %of Distributors - Oct'11 |  |  | WB
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: 796303d1663210300-extracting-specific-multiple-text-in-cell-and-sorting-into-individual-cell-test-sheet-synergy80-
Sheet: Sorted

Order No. |  |  |  |  |  |  | Total PO | Received | Delivered
PL1022 | PL1001 | PL1348 | PL0083 | PL0059 |  |  | 5 | 2019-06-20 00:00:00 | 2019-06-25 00:00:00
 |  | Order No. |  |  |  |  | Total PO | Received | Delivered
Spreadsheet: 3a0c23fe-74b9-4b13-8245-bd2271c846a7
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
HEADCOUNT ENROLLMENT OF CREDIT STUDENTS
UNIVERSITY OF HAWAI‘I-WEST O‘AHU
FALL 1996 TO FALL 2006
FALL SEMESTER |  |  | TOTAL |  |  |  | Classified  Undergraduates |  |  |  |  |  |  |  | Unclassified |  |  |  |  |  | HOME-BASED |  | No
 |  |  | No. |  | % Chng |  | Subtotal |  | Soph |  | Junior |  | Senior |  | Subtotal |  | Undergrad |  | Grad |  | AT OTHER UH  3/ |  | Data
 | 1996 .............................................. |  | 648 |  | -9.5 |  | 553 |  |  |  | 305 |  | 248 |  | 95 |  | 85 |  | 10
 | 1997 .............................................. |  | 648 |  | 0.0 |  | 577 |  |  |  | 354 |  | 223 |  | 71 |  | 69 |  | 2
 | 1998 .............................................. |  | 685 |  | 5.7 |  | 626 |  |  |  | 381 |  | 245 |  | 59 |  | 54 |  | 5
 | 1999 .............................................. |  | 687 |  | 0.3 |  | 613 |  |  |  | 376 |  | 237 |  | 74 |  | 72 |  | 2
 | 2000 .............................................. |  | 665 |  | -3.2 |  | 621 |  |  |  | 328 |  | 293 |  | 44 |  | 43 |  | 1
 | 2001 ............................................. |  | 740 |  | 11.3 |  | 625 |  |  |  | 379 |  | 246 |  | 106 |  | 103 |  | 3 |  |  |  | 9
 | 2002 ............................................. |  | 834 |  | 12.7 |  | 724 |  |  |  | 446 |  | 278 |  | 109 |  | 96 |  | 13 |  |  |  | 1
 | 2003  1/ ............................................. |  | 810 |  | -2.9 |  | 636 |  |  |  | 274 |  | 362 |  | 43 |  | 43 |  | 0 |  | 42 |  | 89
 | 2004 ............................................. |  | 834 |  | 3 |  | 700 |  |  |  | 339 |  | 361 |  | 34 |  | 34 |  | 0 |  | 37 |  | 63
 | 2005............................................. |  | 858 |  | 2.9 |  | 800 |  |  |  | 384 |  | 416 |  | 29 |  | 29 |  | 0 |  | 29
 | 2006  2/ ............................................. |  | 866 |  | 0.9 |  | 795 |  | 5 |  | 280 |  | 510 |  | 40 |  | 40 |  | 0 |  | 31
 | 1/  Migration to a new student registration system took place in Fall 2003.  Unclassified graduate level no longer available.
 | 2/  Prior to Fall 2006, headcount for juniors includes records which were coded in IRO Base as freshmen and sophomore ed level.
 | Coding of lower division may have resulted from late input of transfer credits.
 | 3/ Students whose primary campus, as identified in Banner / ODS, is not UH-West O‘ahu.
 | Data for Fall 2003 and 2004 are from SIMS Base files, with information on primary campus added from Banner / Datamart.
Spreadsheet: 264808d1378988687-compare-data-in-2-columns-extract-unique-values-and-paste-into-3rd-column-0a199
Sheet: Sheet1

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

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259410 | 29832 | Avner | [NAME] | ISR | 456 | 00:23:25 | 00:01:46 | [NAME] | 00:00:00 | 00:33:04 | 1 | 01:42:25
259410 | 14124 | [NAME] | D'Erbee | BEL | 455 | 00:26:04 | 00:03:10 | 00:52:28 | 00:00:00 | 00:38:16 | 2 | 01:59:57
259410 | 22385 | [NAME] | Dobrov | RUS | 457 | 00:32:41 | [NAME] | 01:11:47 | 00:00:00 | 00:48:40 | 3 | 02:36:45