tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 695887d1600442365-getting-last-row-value-with-index-match-match-offset_value
Sheet: Sheet1

 | Identifier1 |  | Identifier2 |  | Identifier3 |  | Identifier4 |  | Identifier5
 |  | Attribute1 |  | Attribute2 |  | Attribute3 |  | Attribute4 |  | Attribute5
Source1 |  | 1 |  | 4 |  | 7 |  | 10 |  | 13
Source2 |  | 2 |  | 5 |  | 8 |  | 11 |  | 14
Source3 |  | 3 |  | 6 |  | 9 |  | 12 |  | 15
This is a little tricky to explain but.. [NAME] columns are not always the same, and the identifiers are not always on the same row. Need to scan for example Identifier3's position (currently row 1, column F), add +1 column and get value on lowest row (9). This format is stupid but I cannot change it and have to work with it.
Solution: |  |  |  |  |  |  |  |  |  |  |  | Search term:
Spreadsheet: 682577d1592210715-google-sheets-countifs-multiple-criteria-from-multiple-sheets-sample
Sheet: mar

Date | Staff name | Month | Customer | Feedback
2020-06-01 00:00:00 | sanju |  | raj | wants to renew
2020-06-01 00:00:00 | sanju |  | hari | out of city
2020-06-01 00:00:00 | sanju |  | [NAME] | wrong number
2020-06-02 00:00:00 | sanju |  | sking | wrong number
2020-06-03 00:00:00 | siru |  | yking | wrong number
2020-06-04 00:00:00 | sannu |  | zking | wants to renew
2020-06-05 00:00:00 | sanju |  | rraj | wrong number
2020-06-06 00:00:00 | sanju |  | yraj | wants to renew
2020-06-01 00:00:00
Spreadsheet: 215927d1361544186-how-to-open-the-hyperlink-formulas-sheet-and-hide-all-sheets-except-clicking-hyperlink-bom-sheets
Sheet: FNDADRSCC

 | Run Date:-01.02.2013
 | 2013-02-01 00:00:00
 | Part Code | Part name | Unit | Qty | Rate | Amount
 | HFNDADRSCCRBRD | HF DELUX CAST DRS CANDY  BLAZING RED | PC | 1 | 25151.88 | 25151.88
 | 0005Z-AAH-H300 | ENGINE ASSY. HF DLX 10 SELF | PC | 1 | 6981.56 | 6981.56
 | 11191-GW8-6810 | GASKET CRANK CASE | PC | 1 | 19.16 | 19.16
 | 11394-GW8-6810 | GASKET R CRANK CASE COVER | PC | 1 | 16.59 | 16.59
 | 1132A-KWA-9400 | PLATE OIL SEPARATE SUB ASSY | PC | 1 | 55.22 | 55.22
 | [PHONE] | CLAMPER OVER FLOW PIPE | PC | 1 | 0.44 | 0.44
 | 90031-GF6-0000 | BOLT A CYL STUD 6x198x7 | PC | 2 | 12.95 | 25.9
 | 90032-GF6-0000 | BOLT B CYL STUD 6X205.5X7 | PC | 2 | 12.95 | 25.9
 | [PHONE] | DRAIN COCK PACKING | PC | 1 | 0.54 | 0.54
 | 90701-GF6-0000 | PIN DOWEL SPECIAL 8X14 | PC | 2 | 0.86 | 1.72
 | 90702-GB6-9100 | PIN DOWEL 8X12 | PC | 4 | 0.8 | 3.2
 | 90703-HC4-0000 | DOWEL PIN 10X14 | PC | 2 | 1.1 | 2.2
 | [PHONE] | PLUG RUBBER 19 MM | PC | 1 | 1.24 | 1.24
 | [PHONE] | OIL SEAL 13.8X24X5 | PC | 1 | 3.01 | 3.01
 | [PHONE] | O RING 13.8X2.5 | PC | 1 | 1.13 | 1.13
 | 91303-GF6-0000 | PACKING RUBBER 16 MM | PC | 1 | 4.72 | 4.72
 | [PHONE] | O-RING 6X1.7 | PC | 2 | 0.33 | 0.66
 | 91356-KGH-9010 | O-RING 30 MM | PC | 1 | 0.67 | 0.67
 | 92800-12000-00 | DRAIN PLUG BOLT | PC | 1 | 4.24 | 4.24
 | 96001-06028-00 | BOLT FLANGE SH.6X28 | PC | 2 | 0.95 | 1.9
 | 96001-06032-00 | BOLT FLANGE SH 6X32 | PC | 1 | 1.04 | 1.04
 | 96001-06040-00 | BOLT FLANGE SH.6X40 | PC | 5 | 1.13 | 5.65
 | 96001-06050-00 | BOLT FLANGE SH.6X50 | PC | 2 | 1.53 | 3.06
 | 96001-06060-00 | BOLT FLANGE SH.6X60 | PC | 2 | 1.67 | 3.34
 | 96001-06065-00 | BOLT FLANGE SH.6X65 | PC | 6 | 1.7 | 10.2
 | 96001-06070-00 | BOLT FLANGE SH 6X70 | PC | 1 | 1.76 | 1.76
 | 96001-06080-00 | BOLT FLANGE SH.6X80 | PC | 1 | 2.59 | 2.59
 | 11330-AAH-H000 | COVER COMP R CRANK CASE | PC | 1 | 276.54 | 276.54
Spreadsheet: sara_shackleton__37283__Mountain View
Sheet: Sheet1

ISDA Master Swap Agreement Worksheet
 |  | ATTORNEY: | [NAME], x35620
DATE: |  | DEAL MAKER: | [NAME], (503) 464-3822
COUNTERPARTY: | Mountain View Power Company, LLC | CONTACT:
ADDRESS: | 25770 San Bernardino Ave. | TITLE:
 | San Bernardino, CA 92408 | PHONE: | (909) 478-7944
 |  | FAX:
Incorporation State |  | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) | Thermo Ecotek Corporation (BBB) | Enron Corp. (BBB+)
LIMIT $ MILLIONS | 4000000 | 15000000
Incorporation State | DE | OR
COLLATERAL  THRESHOLD | 2000000 | 10000000
Specify Type of Debt: | Subordinated Debentures | Senior, Unsecured
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | Subordinated Debentures | Senior, Unsecured
-Below = S&P/Moody's | BB+ | BBB- | Or is not rated by S&P to apply to both
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($[NAME])
-Guarantor ($[NAME]) | 5 | 100
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO: x
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0554
Spreadsheet: 277739d1384421048-combining-lists-with-a-twist-combining-lists-with-a-twist
Sheet: Sheet2

1 |  | AAA001
2 |  | [NAME]
3 |  | [NAME]
4 |  | AAA004
5 |  | AAA005
 |  | Combined list
 |  |  | 1 | AAA001
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | AAA004
 |  |  |  | AAA005
Spreadsheet: dana_davis__4475__Company Code Cost Center Defaults
Sheet: Accounts & descriptions

Account | Descriptions | Comments
*52501500 | Bank Charges | Previous cost element
*52506000 | Fines & Penalties | Previous cost element
*59002000 | Franchise/Annual Report Tax Expense | Previous cost element
*59004000 | Ad Valorem Tax Expense | Previous cost element
62000000 | Interest Income - Third party
64010000 | Gain/Loss on Foreign Currency - Realized
64010100 | Gain/Loss on Foreign Currency - Realized - JVA
64010200 | FX Realized Intercompany
64011000 | Gain/Loss on Foreign Currency - Unrealized
64011100 | Gain/Loss on Foreign Currency - Unrealized - JVA
64011200 | FX Unrealized Intercompany
64020000 | Gain on Disposition of Assets - Non Merchant
64022000 | Other Gains / Losses
64030000 | Gain/Loss on Physical Inv Diff
*69010000 | AFUDC-Equity | Previous cost element
69005000 | Other Deductions
70010000 | Interest Expense - Third Party
70090500 | Int Exp – Other
*70095000 | AFUDC-Debt | Previous cost element
Spreadsheet: c8766cea-2242-4914-9f9e-cff95b9fd5d0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | ZOOM B2.1u EFFECT CONFIGURATION SHEET | 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 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  | EFFECTS & AMP SIMULATION PARAMETERS
No. | Description | COMP |  |  |  |  | WAH/EFX |  |  |  |  | [NAME] |  |  |  |  | ZNR/MIX |  |  |  | LO / EQ |  |  |  |  | HI / EQ |  |  |  |  | MOD/SFX |  |  |  |  | DELAY |  |  |  |  | REVERB |  |  |  |  | CONTROL
A0
A1
A2
A3
A4
A5
A6
A7
A8
A9
B0
B1
B2
B3
B4
B5
B6
B7
B8
B9
C0
C1
C2
[NAME]
C4
C5
C6
C7
C8
C9
D0
D1
D2
D3
D4
D5
D6
D7
D8
D9
Spreadsheet: 885836d1735702021-generating-a-sequential-enquiry-number-using-a-formula-leasehold-enquiry-tracker-test-copy4
Sheet: Enquiries

 | LEASEHOLD ENQUIRY TRACKER
 | ENQUIRY NUMBER | ACTION REQUIRED | CUSTOMER NUMBER | LEASED ADDRESS | NAME | PHONE NUMBER | EMAIL ADDRESS | ENQUIRY DATE | FOLLOW-UP | FOLLOW_HIDDEN | ENQUIRY TYPE | ENQUIRY DETAILS | ACTION | CODED ACTION | FOLLOW-UP REQUIRED | REMINDER DATE | FOLLOW-UP DATE | COMPLETION DATE | NOTES
 |  |  | 33357 | 1 High Street |  |  |  | 2024-10-25 00:00:00 | Not required |  | [NAME] | Roof leaking unable to let out the property. | Passed on to repairs - NW replied 12.11.24 to advise scaffolding going up soon but not got an exact date. Followed up 3.12.24 - RB, 4.12.24 - NW, 6.12.24,  11.12.24 - NA | Referred to Repairs |  |  | 2024-11-28 00:00:00 |  | Leaseholder also reported rubbish and abandoned furniture  - referred to environmental services.
 |  |  | 35238 | 5 High Street |  |  |  | 2024-11-04 00:00:00 | 1 day |  | Upgrade | Enquiry re replacement windows | Referred to [NAME] - works planned for Feb/Mar next year | Referred to [NAME] | Arrange visit |  | 2024-02-01 00:00:00 | FEB/MAR | Attend consultation event.
 |  |  | 33357 | 1 High Street |  |  |  | 2024-11-18 00:00:00 | 1 week |  | General | L/H enquiry regarding when block was built. |  | Advised leaseholder | Visit leaseholder |  |  | 2024-11-18 00:00:00
 |  |  | 33921 | 9 High Street |  |  |  | 2024-11-05 00:00:00 | 3 day |  | Fire door | Fire door query - does it meet requirements? | Asked L/H for door certificate but unable to provide - located 2 actions on riskhub - confirmed new door to be fitted - referred to ventro - fitting date 4.12.24 | Referred to contractor |  |  | 2024-12-05 00:00:00 | 2024-12-05 00:00:00 | L/H confirmed new door fitted
 |  |  | 35969 | 2 High Street |  |  |  | 2024-11-13 00:00:00 | 2 weeks |  | Flat sale | Final invoice amount request. | Invoice raised. | Invoice raised | Raise invoice |  |  | 2024-11-13 00:00:00 | Sale completed 13.11.24 - new owner details required
 |  |  | 35969 | 2 High Street |  |  |  | 2024-11-18 00:00:00 | 12 months |  | Flat sale | Copy invoices for last 3 years requested - insurance, rent, maintenance | E-mailed Chloe Yates in finance 19.11.24 & 10.12.24 | Information provided | [NAME] |  | 2024-12-11 00:00:00 | 2024-12-11 00:00:00 | All invoices received and e-mailed across.
 |  |  | 33759 | 11 High Street |  |  |  | 2025-01-02 00:00:00 | 2 years |  | Repair | Repair to outhouse/storage room - damage caused by leaking roof. | Contacted repairs - RB advised this job with the plastering section | Referred to Repairs |  |  | 2025-01-02 00:00:00
 |  |  | 33974 | 8 High Street |  |  |  | 2025-01-19 00:00:00 |  |  | Access | Property going through probate as owner died - access issue for viewings | Advised Estate Agent to contact me if access needed in pm |  |  |  | Ongoing
 |  |  | 84972
 |  |  | 92529
 |  |  | 76194
 |  |  | 47294
 |  |  | 44859
 |  |  | 32438
 |  |  | 76736
 |  |  | 46763
 |  |  | 24388
 |  |  | 90480
 |  |  | 84346
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 7102

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OME 7102 |  | Start Date | 24/07/2011 |  |  |  | [NAME]
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | f
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: 55501d1255615157-rank-problem-game-and-ranking-sheets-09-10-season
Sheet: DIV 1 Ranking  

DIVISION 1 RANKINGS 09 -10
No | Team | Win | Loss | Draw | Shots | Points
5 | [NAME] | 2 | 1 | 0 | 13 | 12
2 | Berri | 2 | 1 | 0 | 5 | 15
3 | Loxton | 2 | 1 | 0 | 14 | 15
7 | Lyrup | 1 | 1 | 1 | 2 | 6
6 | Renmark | 2 | 1 | 0 | 0 | 7
4 | Renmark RSL | 1 | 1 | 1 | 7 | 15
1 | [NAME] | 2 | 1 | 0 | 18 | 24
FINAL RANKINGS
No | Team | Win | Loss | Draw | Shots | Points
1 | [NAME] | 2 | 1 | 0 | 18 | 24
2 | Berri | 2 | 1 | 0 | 5 | 15
3 | Loxton | 2 | 1 | 0 | 14 | 15
4 | Renmark RSL | 1 | 1 | 1 | 7 | 15
5 | [NAME] | 2 | 1 | 0 | 13 | 12
6 | Renmark | 2 | 1 | 0 | 0 | 7
7 | Lyrup | 1 | 1 | 1 | 2 | 6
Spreadsheet: mary_fischer__25410__Global Operation perf summary rpt Mar 02
Sheet: Americas

1
 | Americas
 | Fleet Statistics
 |  |  | YTD |  |  |  |  | Month
 | Type |  | Turbines Installed YTD | Number of Turbines   > 90 Days | Availability [1] WTGs >90 Days [2] | GWh Actual | GWh Projected [3] | Turbines Installed in Month | Number of Turbines   > 90 Days | Availability [1] WTGs >90 Days [2] | GWh Actual | GWh Projected [3]
 | EW 1.5 |  | 0 |  |  | 265.98 |  | 0 |  |  | 101.78 |  |  |  |  |  | Fleet
 | Z 750 |  | 0 |  |  | 418.501 | 434.733 | 0 |  |  | 135.409 | 157.697
 | Z 550 |  | 0 |  |  | 3.793 | 3.649 | 0 |  |  | 1.176 | 1.3 |  |  |  |  | Type | Oct |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar
 | V 27 |  | 0 |  |  | 55.266 | 58.163 | 0 |  |  | 23.094 | 21.399 |  |  |  |  |  | # WTGs | Avail | # WTGs | Avail | # WTGs | Avail | # WTGs | Avail | # WTGs | Avail | # WTGs | Avail
 | V 17 |  | 0 |  |  | 27.458 | 37.488 | 0 |  |  | 13.454 | 16.359 |  |  |  |  | EW 1.5 | 20 | 0.946 | 67 | 0.874 | 107 | 0.931 | 128 | 0.893 | 198 | 0.885 | 279 | 0.962
 | V 15 |  | 0 |  |  | 18.196 | 27.352 | 0 |  |  | 9.533 | 12.328 |  |  |  |  | Z 750 | 664 | 0.943 | 664 | 0.958 | 664 | 0.9704 | 664 | 0.969 | 664 | 0.976 | 664 | 0.963
 | Fleet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z 550 | 11 | 0.923 | 11 | 0.892 | 11 | 0.9351 | 11 | 0.913 | 11 | 0.911 | 11 | 0.945
 |  | [1] 1.5 Availability is Enron Availability.  All others are Machine Availability. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V 27 | 440 | 0.996 | 440 | 0.99 | 440 | 0.9877 | 440 | 0.995 | 440 | 0.995 | 440 | 0.99
 |  | [2] Number of turbines and availability after completion of initial 90 day operational period. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V 17 | 1041 | 0.98 | 1041 | 0.937 | 1041 | 0.948 | 1041 | 0.964 | 1041 | 0.973 | 1041 | 0.957
 |  | [3] GWh Based on Nacelle Mounted Anemometers for 1.5 MW Fleet and Projections for all others.  Due to low data recovery projections only calculate for |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V 15 | 771 | 0.956 | 771 | 0.871 | 771 | 0.899 | 771 | 0.94 | 771 | 0.95 | 771 | 0.944
 |  | [NAME], [NAME] and Sommerset in Feb and Mar.  Actual production includes all sites.
 |  | [4] EW 1.5 Omits 15 WTGs at Trent due to foundation problems
 | Warranty - YTD Financial Measures ($ in thousands)
 | Type |  | Avg # of Turbines under warranty YTD | Warranty Cost YTD [1] | Cost Under (Over) Reserve Level [2] | Warranty Fees and Reserves Ulitized | Net Warranty Expense YTD | Warranty  Cost per WTG YTD
 | EW 1.5
 | Z 750
 | Z 550 |  |  |  | 0
 | V15/17/27 |  |  |  | 0
 | Totals
 | Operations - YTD Financial Measures ($ in thousands)
 |  |  | Avg # of Turbines Operated YTD | Gross Revenue | Maint. Expense [1] | Net Revenue | G&A &   Constr OH [2] | EBIT | Annualized Maint. Exp per kWh (cents) | Annualized [NAME] per WTG
 | EW 1.5
 | Z 750
 | Z 550
 | V15/17/27
 | Other [2] |  |  |  |  | 0
 | Totals
 | Top three fleet issues and update on efforts
 | EW 1.5 | 1.
 |  | 2.
 |  | 3.
 | Z 750 | 1.
 |  | 2.
 |  | 3.
 | Z 550 | 1.
 |  | 2.
 |  | 3.
 | V15/17/27 | 1.
 |  | 2.
Spreadsheet: 53644d1253574120-excel-2007-generate-numbers-between-max-and-min-value-generate-number-based-in-max-min-given
Sheet: Sheet1

[NAME] |  | 25 | 15 | 20 | 5 | 10 | 15 | 10
Min |  | 17.5 | 10.5 | 14 | 3.5 | 7 | 10.5 | 7
Result |  |  |  |  |  |  |  |  |  | 80
1. K3 = Input Number
2. Result in C3 to I3 should not be higher than [NAME] and not lower than Min.
3. C3:I3 should equal to K3
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -23994 | -2772
500046 | -307 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -52988
500528
500529
500619
INDEX
2001-08-31 00:00:00 |  |  | -757792.37
2001-09-22 00:00:00
CBS Volume
 |  |  | -152176
Spreadsheet: 33537d1229997672-how-to-make-records-non-visible-after-a-certain-time-school-closings-test
Sheet: Sheet1

School | Status | Notes | Expire |  | DO NOT REMOVE OR EDIT BELOW LIST
School A
School B | Closed | No afterschool activities | 12:00:00 |  | Closed
School C | 1 Hour Delay | No morning  Pre-K | 10:00:00 |  | 1 Hour Delay
School D | 2 Hour Delay | No morning pre-K, no AM BOCES | 11:00:00 |  | 2 Hour Delay
School E | Closed | No afterschool activities, Senior Play postponed to Thursday | 12:00:00 |  | Early dismissal
School F | Early dismissal | High school dismissed at 11:15 am, [NAME] and Middle School at 11:45 am | 13:00:00
 |  |  |  |  | 09:00:00
 |  |  |  |  | 10:00:00
 |  |  |  |  | 11:00:00
 |  |  |  |  | 12:00:00
 |  |  |  |  | 13:00:00
 |  |  |  |  | 14:00:00
 |  |  |  |  | 15:00:00
 |  |  |  |  | 16:00:00
 |  |  |  |  | 18:00:00
 |  |  |  |  | 21:00:00
Spreadsheet: 753293d1635346747-average-value-for-a-given-time-period-applied-to-all-previous-time-periods-example-problem-1-
Sheet: Sheet1

Name | Sales | year | Quarter |  | Ideal Output
Fred | 20 | 2019 | 1 |  | 33.75
Fred | 23 | 2019 | 2 |  | 33.75
Fred | 34 | 2019 | 3 |  | 33.75
Fred | 45 | 2019 | 4 |  | 33.75
Fred | 6 | 2020 | 1 |  | 33.75
Fred | 5 | 2020 | 2 |  | 33.75
Fred | 56 | 2020 | 3 |  | 33.75
Fred | 68 | 2020 | 4 |  | 33.75
[NAME] | 23 | 2019 | 1 |  | 36.75
[NAME] | 54 | 2019 | 2 |  | 36.75
[NAME] | 75 | 2019 | 3 |  | 36.75
[NAME] | 89 | 2019 | 4 |  | 36.75
[NAME] | 56 | 2020 | 1 |  | 36.75
[NAME] | 3 | 2020 | 2 |  | 36.75
[NAME] | 43 | 2020 | 3 |  | 36.75
[NAME] | 45 | 2020 | 4 |  | 36.75
Mark | 30 | 2019 | 4 |  | 17.5
Mark | 20 | 2020 | 1 |  | 17.5
Mark | 10 | 2020 | 2 |  | 17.5
Mark | 15 | 2020 | 3 |  | 17.5
Mark | 25 | 2020 | 4 |  | 17.5
Spreadsheet: 712656d1610361245-combine-data-from-multiple-sheets-on-one-sheet-cert-jobs-wip-gk2
Sheet: Data

Employee Login | 14491 | 8683 | 17211 | 69975 | 88153 | 63373 | 73429 | Shift Pattern
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 16a

Product |  | TOTAL
Single - Name* | Corporate
 | Loans
 | Municipal
 | Recovery
 | Sovereign
Index Tranche | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A**
Estimated swap dollar volumes, week ending May 24, by product type (total value of trades in 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. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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.
***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: 12fec4dd-e919-4f80-913c-54598e071180
Sheet: EG

Table | Egypt |  | North Africa
 | Grain | Root | Commercial | Food aid |  | Aggregate
Year | production | production | imports | receipts |  | availability
 |  | (grain equiv.) | (grains) | (grain equiv.) |  | of all food
 |  |  | ---1,000 tons ---
2002 | 18161.212 | 547.4274491932068 | 10337.48474 | 12.055832 |  | 26852.44366762637
 | 18625.231 | 591.7177355744653 | 8192.000398999999 | 22.53726 |  | 26873.11506122236
 | 18707.822 | 703.48393805815 | 6820.932513000001 | 13.890191 |  | 26644.87407498295
 | 20371.745 | 872.9818392543691 | 10899.18763 | 13.892489 |  | 27887.40122131627
 | 20254.015 | 678.5612455965801 | 9709.214826 | 34.466889 |  | 28104.71988362009
 | 19275.25 | 788.4789140039453 | 10536.39375 | 2.29327 |  | 29154.47662954474
 | 21398.846 | 958.6887756375605 | 15107.1905 | 6.139408 |  | 32685.76152640979
 | 20944.145 | 1066.305455067035 | 15325.31835 | 1.79431 |  | 33199.77223731385
2010(e) | 20495 | 805.8309418353596 | 15640.40304916335 | 3.408996 |  | 33771.5683389309
Projections |  |  |  | Food gaps*
 |  |  |  | NG | DG
2011 | 21487.60462660184 | 818.6974895632372 | 12833.73720538356 | 0 | 0 | 32141.35207622132
 | 23328.19730738371 | 884.8837572517692 | 14924.20273844862 | 0 | 0 | 36182.50460179836
 | 25160.33670080756 | 954.247733759934 | 17139.99707346953 | 0 | 0 | 40438.84942216435
Source: Economic Research Service, using data from FAOSTAT (grain and root and tuber production and imports), and the World Food Program (food aid).
*NR stands for nutritional requirements and describes the amount of grain equivalent needed to support nutritional standards on
a national average level. DG stands for distributional gap and it describes that amount of grain equivalent needed to allow each
income quintile to reach the nutrional requirement.
Spreadsheet: 60261d1260827621-formula-to-combine-and-sort-two-tables-by-ascending-value-comparison-calculator-b
Sheet: Sheet1

 |  |  | Boat A |  |  |  |  | Boat B
 |  | RPM | MPH | GPH | MPG |  | RPM | MPH | GPH | MPG |  | RPM | MPH | MPH | GPH | GPH | MPG | MPG
 |  | (x100) |  |  |  |  | (x100) |  |  |  |  | (x100)
 |  | 5 |  |  |  |  | 5 | 2.8 | 0.18 | 15.8
 |  | 10 | 5.3 | 1.4 | 3.79 |  | 10 | 5.5 | 0.73 | 7.5
 |  | 15 | 6.9 | 2.1 | 3.29 |  | 15 | 7.2 | 1.74 | 4.2
 |  | 20 | 8.1 | 3.5 | 2.31 |  | 20 | 9.1 | 4.75 | 1.9
 |  | 25 | 8.7 | 4.5 | 1.93 |  | 25 | 18.8 | 6.03 | 3.1
 |  | 30 | 16.7 | 5.2 | 3.21 |  | 30 | 27.7 | 7.26 | 3.8
 |  | 35 | 27.2 | 6.1 | 4.46 |  | 35 | 34.4 | 9.09 | 3.8
 |  | 40 | 32.9 | 7.6 | 4.33 |  | 40 | 42 | 11.86 | 3.5
 |  | 45 | 39.9 | 10.2 | 3.91 |  | 45 | 47.9 | 14.98 | 3.2
 |  | 50 | 44.4 | 12.5 | 3.58 |  | 50 | 53.3 | 17.02 | 3.1
 |  | 55 | 54.5 | 15.9 | 3.43 |  | 55
 |  | WOT | 56.8 | 17.5 | 3.25 |  | WOT | 58.7 | 20.57 | 2.9
Spreadsheet: 479354d1473335351-count-number-of-unique-instances-based-on-fixed-id-numbers-excelhelp_1
Sheet: Sheet1

 | Data set: |  |  |  |  |  | Issue:
 | Lead ID | Meeting number | Lead status | Lead source | Contact name |  | number of raw leads generated |  | Current count of each status
 | 1 | 1 | Raw | Organic | [NAME] |  |  |  | Organic | Paid - Conference | Paid - Other | Account manager | TSM - led
 | 2 | 1 | Raw | Paid - Conference | [NAME]
 | 3 | 1 | Raw | TSM - led | [NAME]
 | 1 | 2 | Qualified | Organic | [NAME]
 | 1 | 3 | Qualified | Organic | [NAME]
 | 4 | 1 | Raw | TSM - led | [NAME]
 | 4 | 2 | Sold | TSM - led | [NAME]
 | 5 | 1 | Raw | TSM - led | [NAME]
 | 6 | 1 | Raw | TSM - led | [NAME]
 | 1 | 4 | Sold | Organic | [NAME]
Spreadsheet: 452030d1458545161-ifs-and-sums-and-nests-or-something-more-simple-book1example
Sheet: Sales

 | Sale orders |  |  |  |  | Opening Cost |  |  | Running SOH | Running Total
Order Number | [NAME] | Total Sold | Cost of Order
1 | 200 |  | =40 x £1.12 plus 160 x £1 |  |  |  |  |  |  |  |  | Cost | Total Qty | Running Total
2 | 320 |  | =320 x £1 |  |  |  |  |  |  |  |  | 1.12 | 40
3 | 30 |  | =30 x £1 |  |  |  |  |  |  |  |  | 1 | 1000
4 | 400 |  | =400 x £1 |  |  |  |  |  |  |  |  | 2 | 1000
5 | 250 |  | =90 x £1 plus 160 x £2 |  |  |  |  |  |  |  |  | 2.2 | 1000
6 | 100 |  | =100 x £2 |  |  |  |  |  |  |  |  | 1 | 2000
7 | 400 |  | =400 x £2
8 | 240 |  | =240 x £2
9 | 240 |  | =100 x £2 plus 140 x £2.20
10 | 300 |  | =300 x £2.20
11 | 400 |  | =400 x £2.20
12 | 50 |  | =50 x £2.20
13 | 150 |  | =110 x £2.20 plus 40 x £1
Spreadsheet: 674862d1588059783-sum-data-based-on-a-gl-code-and-month-in-year-book1-gl
Sheet: 19v20 Summary

MONTH
 |  | 2019-05-01 00:00:00
200 | Sales 1
210 | Sales 2
211 | Sales 3
212 | Sales 4
213 | Sales 5
214 | Sales 6
215 | Sales 7
220 | Sales 8
 | Direct Costs
 | Overhead
 | Expense
 | Other Income