tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 178852d1346939867-how-to-transpose-columns-into-rows-table
Sheet: Sheet4

Borrower ID | Loan ID | Recovery 1006-1106 | Payment 3Q 2011 | Payment 4Q 2011 | Payment 1Q 2012 | Payment 2Q 2012
6440 | 6440015 | 0 | 0 | 4570.944666666668 | 5645.580753333328 | 2936.252980000001
6440 | 6440090 | 1910.7579 | 0 | 0 | 0 | 0
6492 | 6492018 | 2348.048183333333 | 0 | 0 | 0 | 0
Borrower ID | Loan ID | Payment | Period
6440 | 6440015 | 0 | 1006-1106
6440 | 6440015 | 0 | 3Q 2011
6440 | 6440015 | 4570.944666666668 | 4Q 2011
6440 | 6440015 | 5645.580753333328 | 1Q 2012
6440 | 6440015 | 2936.252980000001 | 2Q 2012
6440 | 6440090 | 1910.7579 | 1006-1106
6440 | 6440090 | 0 | 3Q 2011
6440 | 6440090 | 0 | 4Q 2011
6440 | 6440090 | 0 | 1Q 2012
6440 | 6440090 | 0 | 2Q 2012
6492 | 6492018 | 2348.048183333333 | 1006-1106
6492 | 6492018 | 0 | 3Q 2011
6492 | 6492018 | 0 | 4Q 2011
6492 | 6492018 | 0 | 1Q 2012
6492 | 6492018 | 0 | 2Q 2012
Spreadsheet: 46bd5970-87a0-45ad-9aeb-cd46aa08b053
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Apr. 5 - Apr. 11, 2009
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2009-04-06 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2009-04-06 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00 | - | - | -
 | Top (A) | 10387 | 17226 | 72507 | 10341 | 17180 | 30204 | - | - | -
 | Center (A) | 10352 | 17234 | 72417 | 10286 | 17162 | 30213 | - | - | -
 | Flat (A) | 10363 | 17232 | 72465 | 10332 | 17155 | 30298 | - | - | -
 | Left  (A) | 10370 | 17313 | 72475 | 10339 | 17153 | 30236 | - | - | -
 | Right (A) | 10361 | 17243 | 72509 | 10339 | 17185 | 30196 | - | - | -
 | Average (A) | 10367 | 17250 | 72475 | 10327 | 17167 | 30308 | - | - | -
 | [NAME]  (A) | 13 | 36 | 38 | 23 | 15 | 18 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2009-04-06 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.1s | 1.5s | 3.0s x2 | 1.1s | 1.4s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2009-04-06 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2009-04-06 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00 | 2009-04-08 00:00:00 | 2009-04-06 00:00:00
 | Top (H/V) (um) | 1/1 | 1/1 | 2.5/3 | 1/1 | 1/1 | 2/2
 | Center (H/V) (um) | 1/1 | 1/1.5 | 2.5/2.5 | 1/1 | 1/1.5 | 2/2
 | Flat (H/V) (um) | 1/1 | 1/1.5 | 2/2 | 1/1 | 1/1.5 | 2/2.5
 | Left (H/V) (um) | 1/1.5 | 1/1.5 | 2.5/2.5 | [NAME] | 1/1.5 | 2/2.5
 | Right (H/V) (um) | 1/1.5 | 1/1.5 | 2.5/2.5 | 1/1.5 | 1/1.5 | 2.2/5
 | Comments
Spreadsheet: 729732d1619294376-automate-sum-of-different-months-and-products-revenue-summary-example-copy
Sheet: Product B

 |  |  |  |  |  |  |  |  | Forecast |  |  | Prior
 |  | 2021-01-31 00:00:00 |  |  |  |  |  |  | QTD | Var |  | QTD | Var
 | Revenue | 300 | 430 | 650 |  |  |  |  | 600 |  |  | 400
 | Expense | 40 |  |  |  |  |  |  | 600 |  |  | 400
Spreadsheet: mary_fischer__25637__31T
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031T
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-2000 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
 |  | 0
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
 |  | 0
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 121823d1316440285-excel-2007-conditional-formating-using-dates-tigeravatar-example-for-kuntz92
Sheet: Sheet1

Date
2009-10-02 00:00:00
2009-10-22 00:00:00
2009-11-26 00:00:00
2009-12-13 00:00:00
2009-12-19 00:00:00
2009-12-21 00:00:00
2010-01-11 00:00:00
2010-01-21 00:00:00
2010-01-23 00:00:00
2010-01-27 00:00:00
2010-02-14 00:00:00
2010-02-28 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-04-23 00:00:00
2010-04-28 00:00:00
2010-05-21 00:00:00
2010-07-03 00:00:00
2010-09-18 00:00:00
2010-10-22 00:00:00
2010-10-23 00:00:00
2010-12-16 00:00:00
2011-01-06 00:00:00
2011-01-24 00:00:00
2011-01-29 00:00:00
2011-02-16 00:00:00
2011-04-05 00:00:00
2011-07-08 00:00:00
2011-08-14 00:00:00
2011-08-18 00:00:00
2011-10-01 00:00:00
2012-01-01 00:00:00
Spreadsheet: kevin_hyatt__19597__ROFR
Sheet: Shipper Options

SHIPPER CONTRACTUAL OPTIONS:
Ctrc # | Shipper | Notice Date | Description
24194 | PNM | 2000-09-30 00:00:00 | PNM may extend term for 1-15 years.  Notice to TW by 9/30/2000.  Expired.
24198 | Sid | various | Sid may suspend service for 3 calendar months during any contract year.  Five days notice prior to month.  Month added on to end of term.
24670 | SMUD | 2006-03-01 00:00:00 | SMUD may extend term for 1-10 years beyond primary term.  Notice to TW by 3/1/2006.
25071 | BP Energy | 2003-06-03 00:00:00 | BP may terminate contract 7 years after in-service.  Notice to TW by 6/3/2003.  Termination would then be 11/30/2003.
25071 | BP Energy | anytime | With 60 days notice, BP may reduce MAXDTQ by 10,000/d (6,500/d from Ignacio, 3,500/d from Blanco).
25071 | BP Energy | 2001-06-03 00:00:00 | BP may reduce MAXDTQ 10,000/d (6,500/d from Ignacio, 3,500/d from Blanco).  Notice to TW by 6/3/2001.  Reduction would be effective 11/30/2001.
26490 | Agave | 2001-04-30 00:00:00 | Agave may extend term until 10/31/2002 or 10/31/2003.  Notice to TW by 4/30/2001.  Extended to 10/31/2003.
26490 | Agave | anytime | Agave may reduce MAXDTQ by 15,000/d with 180 days notice (Option #1).
26490 | Agave | anytime | Agave may reduce MAXDTQ by 15,000/d with 180 days notice, not earlier than 1 year following exercising Option #1 (Option #2).  Expired
27047 | Red Cedar | 2003-11-30 00:00:00 | Red Cedar may reduce MAXDTQ by up to 50,000/d.  Notice to TW by 11/20/2003.  Reduction would be effective 1/1/2004.
Spreadsheet: 102054d1300118737-adding-an-updated-revised-date-time-on-the-end-of-row-project-communication-grid-sample-
Sheet: Sheet1

Name of Project | Date Assigned | Deadline [Internal or External] | Expected Time Frame To Reach Goal | Individua/Team Assigned to Oversee Project | Business Owner Contact Info: | Author of Documentation | Any Approvals Required for Items Communicated | Any Other Necessary Approvals Required | Approvals Required From | Purpose of Communication | Objective | Goal | Frequency of Communication | Modes of Communication | Item Being Communicated | Recipients/ [NAME] | Process Necessary to Facilitate Project | Resources Necessary Not Otherwise Available | What Processes Have Been Competed To Date & By Whom | Any Impediments to Prevent Us From Completing Project | Any Existing Issues | Remedy for Issue | Comments/Notes
Spreadsheet: 111865d1308135675-average-help-av
Sheet: Sheet1

 | TN
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 33.7
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 33
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 38.6
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 35.2
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 42.2
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 47.3
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 38.5
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 32.4
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 41.4
 | #N/A
 | #N/A
 | #N/A
 | 25.8
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 35.8
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | 28.6
 | #N/A
 | #N/A
AVERAGE
Spreadsheet: john_forney__15554__Frontera REV-VOM CALC
Sheet: Sheet1

PARAMETERS
 | Options Exercised 0700 - 2200
 | HSC = $2.48
 | Sales = 300 MW's, 0700 - 2200 @ $25
 | Production HR = 7.7
 | Start-up HR = 18
 | VOM = 2.75/MW
 | Start-up sequence = 30, 30, 30, 135, 200
 | FRONTERA REVENUE - VARIABLE O&M CALC
REVENUE |  | Price | MW's | HR |  | Total
 | Options | 21.89 | 2400
 | Other | 25 | 4800
VOM |  | 2.75 | 7440
GAS | HSC + .01 | 2.58 | 7200 | 7.7
 |  |  |  | Subtotal
START-UP COSTS |  | Price | MW's | HR
 | Sales | 7 | 425
 | Gas | 2.58 | 425 | 18
 |  |  |  | Subtotal
 |  |  | Grand Total
Spreadsheet: 835233d1688432897-ongoing-sheet-when-data-changes-test-database-v1
Sheet: Ongoing

Pump No. | Signed Out | Returned On | Patient Name | UR No. | Page | Location | Comments
 | 2023-06-25 00:00:00 | 2023-06-28 00:00:00 | sdfgsdfgsdfsd |  | 152
 | 2023-04-21 00:00:00 | 2023-06-28 00:00:00 | ytsrtysdfg |  | 154
 | 2023-06-28 00:00:00 | 2023-06-19 00:00:00 | sdhsdfhsdfh |  | 128
 | 2023-04-30 00:00:00 | 2023-04-20 00:00:00 | ghdgdgfh |  | 153
 | 2021-01-14 00:00:00 |  | cgjggkfgh
 |  | 2023-06-28 00:00:00 | ffghfhj
 | 2020-03-03 00:00:00 |  | dfhhfh
 |  | 2023-05-09 00:00:00 | dfhdfgh |  | 154
 |  |  | fghjfhjfh |  | 153
 | 2023-02-01 00:00:00 |  | fghfgh
 | 2018-06-18 00:00:00 |  | fghfgh |  | 152
 | 2023-06-21 00:00:00 | 2023-06-28 00:00:00 | cbcvnb
 | 2023-06-11 00:00:00 | 2023-06-28 00:00:00 | [NAME]
 | 2023-06-25 00:00:00 | 2023-06-22 00:00:00 | cvbncvbncvbn
 | 2019-10-23 00:00:00 |  |  |  | 153
 |  | 2023-06-28 00:00:00
 | 2023-06-23 00:00:00 | 2023-01-24 00:00:00 |  |  | 209
Spreadsheet: 196746d1354096475-lookup-in-multiple-sheets-222
Sheet: Sheet1

Dept | Project No | Request Date | Request No | Latest Date Of Delivery | Low | Medium | High | Potential Suppliers | Currency | item # | Description | Unit Price
1 | 12-EG-LB-000 | 2012-10-10 00:00:00 | 12-HO-QUR-001-A | 2012-10-20 00:00:00 |  |  | X | zzzzz | USD | 1 | [NAME] or 800 and [NAME] | 60
1 | 12-EG-LB-000 | 2012-10-11 00:00:00 | 12-HO-QUR-001-B | 2012-10-21 00:00:00 |  |  | X | xxxxx | USD | 2 | Logitech Wireless Desktop MK220 920-003160 | 10
1 | 12-EG-LB-000 | 2012-10-12 00:00:00 | 12-HO-QUR-001-C | 2012-10-22 00:00:00 |  |  | X | sssss | USD | 3 | [NAME] Keybord 8000x & [NAME] | 20
Spreadsheet: 228155d1366026789-column-filter-datafile
Sheet: Sheet1

 |  |  |  |  |  |  | Name | [NAME]
 | Date | Name | Chq. No. | A/c | Amount
 |  | [NAME] | 1002044 | Promax | 50000 |  | Row Labels | Sum of Amount
 |  | [NAME] | 6429967 | Promax | 100000 |  | 2012-01-05 00:00:00 | 50000
 |  | Perveen Akbar | 6429972 | Promax | 100000 |  | 2012-03-08 00:00:00 | 100000
 |  | [NAME] | 6429994 | Promax | 100000 |  | 2012-08-15 00:00:00 | 30000
 |  | [NAME] | 3923431 | Promax | 100000 |  | 2013-03-05 00:00:00 | 60000
 |  | Perveen Akbar | 2923434 | Promax | 100000 |  | 2013-03-28 00:00:00 | 60000
 |  | [NAME] | 3923433 | Promax | 100000 |  | Grand Total | 300000
 |  | [NAME] | 1002083 | [NAME] | 30000
 |  | [NAME] | 1002089 | [NAME] | 150000
 |  | [NAME] | 6051108 | Promax | 200000
 |  | Perveen Akbar | 6051115 | Promax | 100000
 |  | [NAME] | 6051189 | Promax | 70000
 |  | [NAME] | 6051178 | Promax | 30000
 |  | [NAME] | Cash |  | 60000
 |  | [NAME] | 9883035 | Promax | 150000
 |  | [NAME] | 8433307 | [NAME] | 20000
 |  | [NAME] | 8433303 | [NAME] | 60000
 |  | [NAME] | 9883060 | Promax | 10000
Spreadsheet: 186424d1350037461-how-to-transpose-the-datas-of-part-code-and-supplier-into-row-and-column-book1
Sheet: Sheet1

 | Part Code | Supplier |  | Required Result
 | 30500-AAG-H210 | 100001 |  | 30500-AAG-H210 | 100001 | 100056 | 100262 | 100367 | 100373 | 100619
 | 30500-AAG-H210 | 100056 |  | 31500-KC5-0000 | 100001 | 100056 | 100262 | 100373 | 100619
 | 30500-AAG-H210 | 100262 |  | [PHONE] | 100036 | 100040 | 100057 | 100151
 | 30500-AAG-H210 | 100367
 | 30500-AAG-H210 | 100373
 | 30500-AAG-H210 | 100619
 | 31500-KC5-0000 | 100001
 | 31500-KC5-0000 | 100056
 | 31500-KC5-0000 | 100262
 | 31500-KC5-0000 | 100373
 | 31500-KC5-0000 | 100619
 | [PHONE] | 100036
 | [PHONE] | 100040
 | [PHONE] | 100057
 | [PHONE] | 100151
Spreadsheet: kate_symes__18293__Deal Correction 4-12
Sheet: 4-2

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-04-02 00:00:00 | 2001-04-02 00:00:00 | 2001-03-14 00:00:00 | STCA | KS | EES | N/A | Price: from 133.23 to 133.53 |  | 550208 | ZP-26 | 2001-03-15 00:00:00 | [NAME] | 1s and 2s | 133.53 | EES
 | 2001-04-02 00:00:00 | 2001-04-02 00:00:00 | 2001-03-30 00:00:00 | LTSW | Global Risk | N/A | N/A | Added leg to swap deal for Sunday round-the-clock hours | No Sunday index in system for PV - added today | 566316.3 | Palo Verde | 7/1/01-6/30/06 | RTC | 25 | 96 | EES
 |  |  |  | Grand Count
Spreadsheet: 829127d1683939587-help-with-daily-schedule-with-auto-days-off-example-tennfox-
Sheet: Sunday

 | Primary | Trainee |  | 2023-05-14 00:00:00 |  |  | Off
211
212
213
214
314
315
316
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 11a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 414 |  | 414
 | FRA | 9930 |  | 9930
 | Exotic
 | Inflation
 | IRS- [NAME] | 27569 |  | 27569
 | OIS | 1254 |  | 1254
 | VNS | <100 |  | <100
 | Zero Coupon | <100 |  | <100
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | 39167 | N/A*** | 39167
Estimated swap transaction volumes, week ending December 14, by product type and tenor (millions of USD), all participant types and currencies.
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 cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 13c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 1870051 | - | 235307
Europe | - | 852351 | - | 116824
North America/Asia | - | 1017700 | - | 118483
Index | 2746778 | 8400459 | 1331094 | 2673174
Asia | - | 187848 | - | 42256
Europe | 1329411 | 4163704 | 407728 | 1107562
North America | 1394250 | 3601788 | 911421 | 1456182
Other | 23117 | 447119 | 11945 | 67174
Other | - | 923372 | - | 415036
Exotic/Total Return Swap | - | 57332 | - | 41371
Swaptions | - | 866040 | - | 373665
TOTAL | 2746778 | 11193882 | 1331094 | 3323517
Spreadsheet: 793767d1661698065-generate-a-list-of-a-filtered-dataset-generatelists_52779
Sheet: GenerateLists

Name | Put/Call | Strike | Amount |  |  |  |  |  |  |  |  |  |  |  | DV - List
A29 | P | 700 | 4 |  |  | P |  |  | P | 718 |  | 717
AEX | P | 725 | -10 |  |  |  |  | A29 | P | 718 |  | 717 |  |  | A29
A29 | P | 713 | -1 |  |  | All_Items |  | A29 | P | 718 |  | 717 |  |  | AEX
A29 | P | 718 | 3 |  |  |  |  | A29 | P | 712 |  | 716
A29 | C | 722 | -3 |  |  |  |  | A29 | P | 700 |  | 716
A29 | C | 718 | 8 |  |  |  |  | A29 | P | 700 |  | 716
A29 | C | 720 | 3 |  |  |  |  | A29 | P | 700 |  | 716
A29 | C | 716 | -5 |  |  |  |  | A29 | P | 700 |  | 716
A29 | P | 712 | 1 |  |  |  |  | A29 | P |  |  | 713
A29 | P | 717 | -3 |  |  |  |  | AEX | P | 720 |  | 725
A29 | P | 716 | -5 |  |  |  |  | AEX | P | 705 |  | 725
AEX | P | 710 | -4 |  |  |  |  | AEX | P | 705 |  | 725
AEX | C | 700 | -2 |  |  |  |  | AEX | P | 705 |  | 725
AEX | P | 700 | 3 |  |  |  |  | AEX | P | 705 |  | 725
AEX | C | 715 | 4 |  |  |  |  | AEX | P | 700 |  | 725
AEX | C | 710 | -4 |  |  |  |  | AEX | P | 700 |  | 725
AEX | P | 705 | 4 |  |  |  |  | AEX | P | 700 |  | 725
AEX | P | 700 | 4 |  |  |  |  | AEX | P | 700 |  | 725
AEX | C | 730 | 5 |  |  |  |  | AEX | P | 700 |  | 725
AEX | P | 720 | 1 |  |  |  |  | AEX | P | 700 |  | 710
AEX | C | 755 | 2 |  |  |  |  | AEX | P | 700 |  | 710
 |  |  |  |  |  |  |  | AEX | P |  |  | 710
Unique names (extrcted by UNIQUE; there could be more) |  |  |  |  |  |  |  | AEX | P |  |  | 710
AEX
Sorted array on Strike with Amount > 0 for P of each unique name (how can I loop through all and create the following?)
 | P | 718 | 3
A29 | P | 712 | 1
A29 | P | 700 | 4
 | P | 717 | -3
A29 | P | 716 | -5
A29 | P | 713 | -1
Sorted array on Strike with Amount < 0 for P of each unique name
 | P | 720 | 1
AEX | P | 705 | 4
AEX | P | 700 | 3 |  | Remark: October
AEX | P | 700 | 4 |  | Remark: November
 | #REF! | #REF! | #REF!
#REF! | #REF! | #REF! | #REF!
Hoe can I do this?
list to generate for each unique name
A29 | P | 718 |  | 717
A29 | P | 718 |  | 717
A29 | P | 718 |  | 717
A29 | P | 712 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P |  |  | 713
AEX | P | 720 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 710
AEX | P |  |  | 710
AEX | P |  |  | 710
Spreadsheet: 161860d1339663004-auto-sort-when-measure-changes-copy-of-book1
Sheet: Sheet4

 |  |  | I2 |  |  | <-----Select from Dropdown
 |  | Benchmark:
 |  | Best Value
 |  | Benchmark
 |  | Superior:
 |  | Improved:
 |  | Conformance:
 |  | Non Conformance:
 |  | data type:
 |  | In Year: 2012
 |  |  | All Companies | Non Conformance |  | 3 | Down | ▼
 |  | Rank | Centre | Assessment |  | Value | Trend
 |  | 14 | Company 1 | Improved |  | 51 | Down | ▼
 |  | 7 | Company 2 | Superior |  | 80 | Down | ▼
 |  | 29 | Company 3 | Non Conformance |  | 17 | Down | ▼
 |  | 1 | Company 4 | Superior |  | 94 | Up | ▲
 |  | 20 | Company 5 | Conformance |  | 41 | Down | ▼
 |  | 27 | Company 6 | Conformance |  | 29 | Down | ▼
 |  | 26 | Company 7 | Conformance |  | 31 | Down | ▼
 |  | 9 | Company 8 | Superior |  | 78 | Up | ▲
 |  | 21 | Company 9 | Conformance |  | 38 | Down | ▼
 |  | 11 | Company 10 | Improved |  | 64 | Up | ▲
 |  | 3 | Company 11 | Superior |  | 91 | Up | ▲
 |  | 31 | Company 12 | Non Conformance |  | 15 | Down | ▼
 |  | 10 | Company 13 | Improved |  | 71 | Down | ▼
 |  | 1 | Company 14 | Superior |  | 94 | Up | ▲
 |  | 4 | Company 15 | Superior |  | 89 | Up | ▲
 |  | 6 | Company 16 | Superior |  | 81 | Up | ▲
 |  | 29 | Company 17 | Non Conformance |  | 17 | Down | ▼
 |  | 14 | Company 18 | Improved |  | 51 | Up | ▲
 |  | 24 | Company 19 | Conformance |  | 33 | Down | ▼
 |  | 32 | Company 20 | Non Conformance |  | 7 | Down | ▼
 |  | 19 | Company 21 | Conformance |  | 43 | Down | ▼
 |  | 25 | Company 22 | Conformance |  | 32 | Down | ▼
 |  | 12 | Company 23 | Improved |  | 62 | No Change | ►
 |  | 23 | Company 24 | Conformance |  | 36 | Down | ▼
 |  | 8 | Company 25 | Superior |  | 79 | Up | ▲
 |  | 17 | Company 26 | Conformance |  | 46 | Down | ▼
 |  | 16 | Company 27 | Improved |  | 50 | Up | ▲
 |  | 18 | Company 28 | Conformance |  | 45 | Up | ▲
 |  | 21 | Company 29 | Conformance |  | 38 | Up | ▲
 |  | 5 | Company 30 | Superior |  | 85 | Up | ▲
 |  | 28 | Company 31 | Conformance |  | 25 | Down | ▼
 |  | 13 | Company 32 | Improved |  | 59 | Up | ▲
Spreadsheet: 849009d1699572925-show-projects-that-an-employee-is-assigned-elliot-current-project-schedule-2023-test
Sheet: Detailer View

 | Detailer Name: | [NAME]
Client Name | Show/Project | Size | Detailer | AE | Launch Date | Designer | Graphic Elevations Due Date | New Build Items | Prestage Drawings | Shop Setup Start Date | Ship Date | Electrical Drawing Due | Rigging | Internet | Final Setup Drawing Package Due | Show Date | AM
Spreadsheet: 162065d1339704897-pivot-table-sort-by-month-not-6-14-12-problem-report-log_jpr73
Sheet: Summary Pivot Table

Date | (Tous) |  | Date | (Tous)
Person: | (Tous) |  | Department: | (Tous)
Department | Count of Issue |  | Person | Count of Issue
Accounting | 31 |  | [NAME] | 1
Building 5 | 3 |  | Amber | 32
Building 6 | 2 |  | [NAME] | 2
Executive | 10 |  | [NAME] | 33
Materials | 48 |  | Anne | 1
Outside Sales | 9 |  | Annette | 9
Sales | 179 |  | [NAME] | 4
Shop | 45 |  | [NAME] | 6
Total général | 327 |  | [NAME] | 1
 |  |  | [NAME] | 13
 |  |  | [NAME] | 1
 |  |  | [NAME] | 10
 |  |  | [NAME] | 4
 |  |  | [NAME] | 7
 |  |  | Joy | 21
 |  |  | [NAME] | 2
 |  |  | [NAME] | 4
 |  |  | [NAME] | 8
 |  |  | [NAME] | 3
 |  |  | Lauren | 20
 |  |  | [NAME] | 9
 |  |  | [NAME] | 9
 |  |  | [NAME] | 12
 |  |  | Marge | 2
 |  |  | [NAME] | 5
 |  |  | [NAME] | 2
 |  |  | [NAME] | 19
 |  |  | [NAME] | 1
 |  |  | [NAME] | 2
 |  |  | [NAME] | 7
 |  |  | Nicole | 6
 |  |  | Nina | 3
 |  |  | [NAME] | 3
 |  |  | [NAME] | 10
 |  |  | [NAME] | 2
 |  |  | [NAME] | 19
 |  |  | Scot | 10
 |  |  | Stacy E | 2
 |  |  | [NAME] | 3
 |  |  | Total général | 308
Spreadsheet: 681035d1591308862-table-generator-example-maxwelln1-
Sheet: Sheet1

 | Start | 0
 | End | 4 |  | X | Y
 | Interval | 0.1
Spreadsheet: 860371d1708498821-does-a-derivative-of-sumif-exist-avgironistance
Sheet: Sheet1

 | Average Distance
5i | For each "5i" in column B, add the value in Column A to the value in column C.  Then, divide by the count of "5i" in column B.
5i
6i
7i
8i
9i
PW
50*
Yardage | Iron | -Lft / +Rgt
195 | 5i | -2
135 | 58* | 11
200 | 5i | 8
120 | 58* | -7
205 | 5i | 4
175 | 58* | -16