tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 685450d1594022018-look-for-the-longest-date-from-4-columns-and-certain-conditions-sample-data
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | note : This column is not used if there is a decrease in Outstanding
Check Duplikat | Download_Date | Facility_Number | Account_Number | Customer_Name | Day_Past_Due | Day_Past_Due | Day_Past_Due_Start_Date | formula should be | Result Should be | date nonacr | date od | date due | date branch | Outstanding Current | Outstanding Previous | Growth OS
UNIK | 2020-06-12 00:00:00 | 5716786 | 5716786_290114 | Cang ie | 0 |  |  | ? | 2021-04-29 00:00:00 |  | 2020-06-02 00:00:00 | 2021-04-29 00:00:00 |  | 2003362990.71 | 2005362990.71 | -2000000
UNIK | 2020-06-12 00:00:00 | 15000472 | 15000472_300819 | ichen | 0 |  |  | ? | 2020-06-29 00:00:00 |  | 2020-04-01 00:00:00 | 2020-06-29 00:00:00 |  | 923693800.55 | 924793800.55 | -1100000
UNIK | 2020-06-12 00:00:00 | 1235 | 1235 | anie | 0 |  |  | ? | 2019-04-01 00:00:00 | 2019-04-01 00:00:00 | 2020-04-01 00:00:00 | 2020-06-29 00:00:00 |  | 25000000 | 25000000
UNIK | 2020-06-12 00:00:00 | 125456 | 125452 | [NAME] | 0 |  |  | ? | 2019-08-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 |  | 2019-08-01 00:00:00 | 50000000 | 50000000
Spreadsheet: 56463d1256655065-excel-2007-excluding-0-as-data-in-average-formula-monthly-report
Sheet: Week 4

 |  |  |  | WEEK 4
 | Technician |  |  |  | Work Comp % | QC Pass % | CDV/HSI Jobs | Activation Attemtps | [NAME] | VOD Attempts
 | 1 |  |  |  | 0.9524 | 1
 | 2 | [NAME] |  |  | 0 | 0
 | 3 | [NAME] |  |  | 0.8947 | 1
 | 4 | [NAME] |  |  | 0.8947 | 0
 | 5 | [NAME] |  |  | 1 | 0.9625
 | 6 | [NAME] |  |  | 1 | 0
 | 7 | [NAME] |  |  | 1 | 1
 | 8 | [NAME] |  |  | 1 | 0.922
 | 9 | [NAME] |  |  | 0.9231 | 0
 | 10 | [NAME] |  |  | 0.7241 | 1
 | 11 | [NAME] |  |  | 1 | 0.892
 | 12 | [NAME] |  |  | 0.9 | 0
 | 13 | [NAME] |  |  | 0.8571 | 1
 | 14 | [NAME] |  |  | 0.9444 | 0
 | 15 | [NAME] |  |  | 0 | 0
 | 16 | [NAME] |  |  | 1 | 0.98
 | 17 | [NAME] |  |  | 0.9412 | 1
 | 18 | 0
 | 19 | 0
 | 20 | 0
 | 21 | 0
 | 22 | 0
 | 23 | 0
 | 24 | 0
 | 25 | 0
Spreadsheet: 834587d1687934059-find-first-and-last-sales-dates-first-and-last-sales-date
Sheet: Sheet1

 | Product | 2018-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1st Sale Date | Last Sale Date | 1st Sale Date | Last Sale Date
 | A1000 | 0 | 0 | 915 | 466 | 164 | 431 | 603 | 414 | 700 | 584 | 144 | 763
 | A1100 | 354 | 193 | 161 | 160 | 436 | 718 | 432 | 332 | 427 | 0 | 0 | 0
 | A1200 | 159 | 312 | 0 | 0 | 226 | 463 | 123 | 731 | 654 | 772 | 262 | 0
 | A1300 | 0 | 0 | 554 | 394 | 391 | 661 | 370 | 929 | 524 | 0 | 0 | 0
 | A1400 | 466 | 615 | 456 | 0 | 0 | 0 | 349 | 430 | 332 | 245 | 758 | 133
 | A1500 | 606 | 312 | 0 | 0 | 0 | 552 | 623 | 0 | 0 | 0 | 0 | 0
 | A1600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 162
 | A1700 | 570 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A1800 | 734 | 310 | 919 | 930 | 753 | 280 | 903 | 745 | 874 | 998 | 998 | 447
 | A1900 | 0 | 0 | 0 | 0 | 0 | 0 | 487 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 683 | 105 | 985 | 0 | 0 | 0 | 0 | 780 | 0
Spreadsheet: 105829d1303126759-array-problem-with-empty-cells-book1_skwiskwis
Sheet: Sheet1

Your formula > |  | Helper Column
[NAME] .
zbor (no helper column)
zbor (no helper column)
romperstomper
[NAME] suggestion as rompers'
 | a
 | b
 | a
 | a
 | b
 | c
 | d
 | b
 | c
 | d
 | b
 | c
 | d
Spreadsheet: 175792d1345647040-sum-multiple-criteria-within-two-differnt-sets-of-date-ranges-date-range-test
Sheet: Sheet2

Store Number | Product Type | Vendor | Store Count Actual | Start | End
7 | A | 1 | 29 | 2012-10-23 00:00:00 | 2012-12-31 00:00:00
7 | A | 1 | 456 | 2012-10-23 00:00:00 | 2012-11-29 00:00:00
7 | B | 1 | 52 | 2012-10-23 00:00:00 | 2012-12-31 00:00:00
Spreadsheet: 72450d1273134317-the-option-to-choose-data-in-excel-stock-draft-spreadsheet-v2
Sheet: Sheet1

Order date | Status | Account | OrderNo | SuppID(T) | Description | Cost
2010-05-04 00:00:00 | O | 4121 | 11111111 | Apple Sales International | iMac 27-inch Quad-Core | 1224
2010-05-04 00:00:00 | O | 4121 | 22222222 | Apple Sales International | [NAME] (new 2.66GHz Intel Core 2 Duo) | 4570
2010-05-04 00:00:00 | O | 5570 | 33333333 | Maplin Electronics Ltd | CCTV to VGA Adaptor  part no   N78CQ | 34.04
2010-05-04 00:00:00 | O | 5570 | 33333333 | Maplin Electronics Ltd | Nighthawk153 [NAME] CCTV 2-Camera Part no N77CJ | 110.64
2010-05-05 00:00:00 | O | 4121 | 44444444 | Dell Corporation Ltd | Research - Precision M4400 | 4026.25
2010-05-05 00:00:00 | O | 4121 | 44444444 | Dell Corporation Ltd | Targus bag Manufacturer Part : TSS059EU | Dell Part : A2542169 | 8.93
2010-05-05 00:00:00 | O | 4121 | 44444444 | Dell Corporation Ltd | Ultra Portable - Latitude E4200 | 10171.6
Spreadsheet: 024496e0-7f30-4bc1-8ec9-f5faece02fdd
Sheet: Payments

Monthly OATT Schedule 1 Through or Out Service (TOUT) Settlement
TR_OATTSCH1TOUT_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Customer Details |  |  |  | Pool Details |  | Payment
[NAME] Number | [NAME] Name | Customer OATT Schedule 1 Revenue Requirements Dollars | Customer OATT Schedule 1 Revenue Requirements Percent | Pool OATT Schedule 1 TOUT Charge | Pool OATT Schedule 1 Revenue Requirements Dollars | OATT Schedule 1 TOUT Payment
String | String | $ | % | $ | $ | $
Spreadsheet: 73674d1274289813-sum-formula-in-multiple-worksheets-example
Sheet: February 2010

Broker ID | Broker Name | ePCG Submitted Lines | Total Submitted Lines
4117 | The Rule Company Inc | 4 | 55
4750 | Gunn Steers & Company, LLC | 2 | 15
9243 | Sullivan Insurance Group Inc. | 8 | 23
10714 | Fred Rhodes & Company | 3 | 4
Spreadsheet: 684415d1593354281-combining-data-from-multiple-sheets-consolidated-sample
Sheet: Email

Date | Date Identifier | EMP ID | Name | Support Cat | Survey LOB | Survey Skill | CCR Loyalty | CSAT Survey Count | CSAT Count | NPS Survey Count | Promoter Count
2020-06-02 00:00:00 | 4496335-060220 | 4496335 | Gabby Pineda Calderon | [NAME] | PCBO | 1835 | 2 | 1 | 0 | 1 | 0
2020-06-03 00:00:00 | 4496335-060320 | 4496335 | Gabby Pineda Calderon | [NAME] | PCHV | 1836 | 1 | 1 | 0 | 1 | 0
2020-06-11 00:00:00 | 4496335-061120 | 4496335 | Gabby Pineda Calderon | [NAME] | PCBO | 1835 | 3 | 1 | 0 | 1 | 1
2020-06-12 00:00:00 | 4496335-061220 | 4496335 | Gabby Pineda Calderon | [NAME] | PCBO | 1835 | 5 | 1 | 1 | 1 | 0
2020-06-17 00:00:00 | 4496335-061720 | 4496335 | Gabby Pineda Calderon | [NAME] | PCBO | 1835 | 1 | 1 | 0 | 1 | 0
2020-06-18 00:00:00 | 4245221-061820 | 4245221 | Xandy Eredia Golimlim | [NAME] | PCBO | 1835 | 5 | 1 | 1 | 1 | 1
2020-06-19 00:00:00 | 4496335-061920 | 4496335 | Gabby Pineda Calderon | [NAME] | PCHV | 1836 | 3 | 1 | 0 | 1 | 1
2020-06-19 00:00:00 | 4245221-061920 | 4245221 | Xandy Eredia Golimlim | [NAME] | PCBO | 1835 | 5 | 1 | 1 | 1 | 1
Spreadsheet: 4a641f0b-6922-47b1-b380-b75b0cff0f12
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FIAIA | Test | FIAIA | [NAME] and Anti-Infliximab Antibody | [NAME] and Anti-Infliximab Ab | Electrochemiluminescence Immunoassay (ECLIA) |  |  |  | 2 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 2 mL of serum frozen in a plastic vial. | 1 mL | Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icterus	NA Other	NA | Infliximab Drug Level < 0.4 ug/mL  Results of 0.4 or higher indicates detection of Infliximab. In the presence of anti- Infliximab antibodies, the Infliximab drug level reflects the antibody-unbound fraction of Infliximab concentration in serum.   Anti-Infliximab Antibody < 22 ng/mL  Results of 22 or higher indicates detection of Anti-Infliximab Antibodies.   Test Performed by: Esoterix Endocrinology                              4301 Lost Hills Road                              Calabasas Hills, CA 91301 | Varies: 1 time per week | 5 - 7 days | 7 - 11 days |  | Profile |  |  |  |  | Esoterix Endocrinology
FIAIA | [NAME] | SERUM | Serum |  |  |  | Frozen | 7 days
FIAIA | Result | Z3191 | Infliximab Drug Level | Infliximab Drug Level | Numeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
FIAIA | Result | Z3192 | Anti-Infliximab Antibody | Anti-Infliximab Antibody | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FIAIA | Billing Component | FIAIA |  | CHEMILUMINESCENT ASSAY |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82397
FIAIA | Billing Component | FIAIA |  | QUANTITATIVE ASSAY DRUG |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80299
Spreadsheet: 269847d1381308796-problems-with-index-and-match-book12
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME]
2013-01-01 00:00:00 | 1 | 2 | 3
2013-01-02 00:00:00 | 1 | 2 | 3
2013-01-03 00:00:00 | 1 | 2 | 3
 |  |  |  | [NAME]
 |  |  | 2013-01-01 00:00:00
 |  |  | 2013-01-02 00:00:00
 |  |  | 2013-01-03 00:00:00
Spreadsheet: 3a3b75d1-df81-4edc-a299-611791ac106f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
9815 | Test | 9815 | Grocott's Methenamine Silver Stain for Fungi | [NAME]'s [NAME] for [NAME] | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube: Formalin-fixed, paraffin-embedded tissue block Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88312 |  |  |  |  | Rochester
9815 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
9815 | Result | 9815 | [NAME]'s [NAME] for [NAME] | [NAME]'s [NAME] for [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10755-7
Spreadsheet: andy_zipper__171__DYNEGY-ICE VOL Apr18
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-18-01 thru Apr-18-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-18-01 | 905451455 |  | Sold | NG Fin BS, LD1 for IF | Perm | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | -0.0675 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-18-01 | 171677426 |  | Sold | NG Fin BS, LD1 for IF | Perm | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | BP Amoco Corporation | -0.0675 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Spreadsheet: 29f2c5fa-8051-4fb7-8456-f65af100c720
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | FY2010 HOPWA Allocation Summary
 | Appropriation |  |  | Total Allocated Amount
 | Total | 298485000 |  | Total | 298485000
 | 0.75 | 223863750 |  | Total MSA | 259140831
 | 0.25 | 74621250 |  | Total State | 39344169
 | Formula Factors |  |  | Statistics
 | Eligible States Cases | 188394 |  | $ Per AIDS Case | 208.84
 | Eligible MSAs Cases | 883546 |  | $ Per Excess Case | 9834.65
 | Total Cases | 1071940 |  | % of Total U.S. Cases Covered | 0.9942834775527014
 |  |  |  | % Allocated to States | 0.1318
 | Excess Per Capita Incidence Calculations |  |  | % Allocated to MSA's | 0.8682
 | Total 3 Year Cases | 92267
 | Total 3 Year Population | 599328070
 | 3-Year Avg Per Capita Incidence | 15.3951
 | Sum of Excess Cases | 7587.5848
 | Notes:
 | The following spreadsheets (see tabs below) include State and Metropolitan Statistical Area (MSA) data on HOPWA FY2010 allocations and cumulative cases of AIDS, as reported to CDC through March 2009.  Only MSAs with population greater than or equal to 500,000 were included, and MSA boundaries were based on the most current OMB bulletin. The MSA worksheets also include annual AIDS case data: This data reflects annual AIDS case counts from April through March of the years indicated (e.g., April 2008 through March 2009). Columns titled "3-Year PCI" reflect per capita AIDS cases for the previous 3 years. Total population counts are based on July 1, 2009 population estimates from the U.S. Census Bureau.
Spreadsheet: 709804d1608564719-enter-two-conditions-to-query-the-size-forum1221
Sheet: Sheet1

Model | Size | inlet * Outlet |  |  |  | Model | Size | in
 |  | in | [NAME] |  |  | T5 | 4
T5 | 1~2 | 1/2" * 5/8"
 | 3 | 1/2" * 7/8"
 | 4 | 5/8" * 7/8"
 | 5 | 7/8" * 1-1/8"
T12 | 1~2 | 5/8" * 7/8"
 | 3~4 | 7/8" * 1"
 | 5~6 | 7/8" * 1-1/8"
T20 | 1 | 7/8" * 1-1/8"
T55 | 1~2 | 1-1/8" * 1-3/8"
Spreadsheet: 130ab46e-f95c-41da-ba15-19c5d6c45392
Sheet: Sheet1

2002-09-10 00:00:00 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Sorlucco, d | Doolan, r | Gallus, r | Ward, r | [NAME]
Albany | 26 |  |  |  | 2
Atkinson and [NAME]. Gt. | - | - | - | - | -
[NAME] | 113 |  | 1 |  | 2
Bean's Grant | - | - | - | - | -
Bean's Purchase | - | - | - | - | -
[NAME] | 174 |  | 30 | 2 | 13
[NAME] | 150
[NAME] 3 | 183
[NAME] 4 | 166 |  | 14 |  | 15
Bethlehem | 84 |  |  | 7
Cambridge | - | - | - | - | -
Carroll | 30
[NAME]'s Purchase | - | - | - | - | -
[NAME] | 4 |  | 2
Colebrook | 36 | 1 | 4 |  | 4
Columbia | 7 |  |  |  | 1
Crawford's Purchase | - | - | - | - | -
Cutt's Grant | - | - | - | - | -
[NAME] | 25 | 2 |  |  | 1
Dix's Grant | - | - | - | - | -
Dixville | 1
Dummer | 10
Errol | 5 |  | 2 |  | 3
Erving's Location | - | - | - | - | -
Franconia | 72
[NAME] | 162 | 1 | 14 | 1 | 9
Green's Grant | - | - | - | - | -
Hadley's Purchase | - | - | - | - | -
Hale's Location | 2
Hart's Location | 2
[NAME] | 73 |  |  |  | 1
[NAME] | 27 |  | 2 |  | 1
Kilkenny | - | - | - | - | -
Lancaster | 99 | 1 | 2 | 4 | 4
Lincoln | 64
Lisbon | 32 |  |  | 2
Littleton | 183 | 4 | 4 | 39 | 8
Livermore | - | - | - | - | -
Low and Burbank's Grant | - | - | - | - | -
[NAME] | 22 | 1 |  |  | 1
Martin's Location | - | - | - | - | -
Milan | 44 |  | 8 | 1
[NAME] | 1
Northumberland | 91
[NAME] | - | - | - | - | -
[NAME]'s Grant | - | - | - | - | -
Pittsburg | 18 |  | 2 | 1 | 1
Randolph | 50 |  |  |  | 2
Sargent's Purchase | - | - | - | - | -
Second College Grant | - | - | - | - | -
Shelburne | 22
[NAME] | 14
Stewartstown | 17
[NAME] | 12
Success | - | - | - | - | -
[NAME] | 31 | 1 |  | 2
Thompson & Meserve's Purchase | - | - | - | - | -
Waterville Valley | 24
Wentworth's Location | - | - | - | - | -
[NAME] | 65 | 2 | 2 | 2 | 1
Totals | 2141 | 13 | 87 | 61 | 69
Spreadsheet: 210812d1359567469-really-need-help-please-automation-across-sheets-sample-excel
Sheet: PROBLEM

Location OF CONFIRMED ATTENDEES | f
MAO
TF
CF
LF
PF
CDO
NDC
SDC
PDC
NL SO
CL SO
SL SO
EV SO
WV SO
NM SO
SM SO
 |  |  |  | Location-Based
 |  |  |  | MAO | f
 |  |  |  | The divisions under each (from the confirmed attendees sheet) and the numbers should appear here
 |  |  |  | e.g.
 |  |  |  | N Infant Nutrition | 13
 |  |  |  | TF
 |  |  |  | Technical | 2
Spreadsheet: 55623d1255714286-telling-excel-a-cell-equals-another-cell-on-a-worksheet-hprp-assessment-final-sample
Sheet: HPRP A-Financial Info

Homelessness Prevention and Rapid Re-Housing Program
APPLICANT INFORMATION
Intake Date: | 2009-10-25 00:00:00 |  |  |  | # in Household: | 0
Household Information
Last Name: | Doe |  | M. Initial: | M | First Name: | 0
Last Name: | 0 |  | M. Initial: | 0 | First Name: | 0
Home Phone: | [PHONE] |  |  | Cell [NAME]): | 0
Work [NAME]): | [PHONE] |  |  | [NAME]): | 0
HPRP ASSESSMENT
Financial Information
[NAME] |  |  |  | ANSWER |  | AMOUNT
Do you have a checking account?
Do you have a savings account?
Do you have a IDA/Escrow account?
Any other cash assets? _________________________
 |  |  |  | Total Assets: |  | 0
[NAME] |  |  |  | ANSWER |  | AMOUNT
Are you currently past due on any credit/bank payments?
Have you ever filed for bankruptcy?
In the past year have you used a payday lender/check cashing service?
Do you currently owe a payday lender?
Do you currently have any credit cards or loans other than payday loans?
 |  |  |  | Sub-Total:
 |  |  |  | Total Rental Arrears
 |  |  |  | Total Utility Arrears
 |  |  |  | Total Debt: |  | 0
Staff Notes:
Spreadsheet: 762423d1641553425-find-and-mark-values-in-another-cell-cf-find-values-aligw
Sheet: Sheet1

keyword | name
gun | vvv rere gun
Satellite | vvv rere tytytyyt
Satellite Phone | ffdf scope gfgfgf
Scope | gfgfgfgf
stun gun | gfgssf satellite phone
stungun | hghghghg
Thermal | ghghgfh767676 satellite
 | ggfggfdfdf
 | [NAME]
 | erere
Spreadsheet: 300924d1393604233-merging-and-de-duping-exercise-book3
Sheet: AFTER

RowID | ID1 | ID2 | ID3 | ID4 |  |  | [NAME] |  |  |  |  | Phone | Donation |  |  |  | FirstName | SurName | [NAME] |  |  |  |  | City |  | Postcode
1 | 70959 | 1366 |  |  |  |  | [EMAIL] |  |  |  |  |  | 22 |  |  |  | Derek | AXX | 480 Main Street |  |  |  |  | [NAME] |  | GXX 9XX
4 | 82295 |  |  | 1234 |  |  | [EMAIL] |  |  |  |  | 7x07052XXX | 11 |  |  |  | SXX | Aitken | 6 Drive |  |  |  |  | YYY |  | GXX 0XX
6 | 29316 | 1535 |  |  |  |  | [EMAIL] |  |  |  |  | XX16079xxx | 153 |  |  |  | [NAME] | Alxxx | 100 Road 2 |  |  |  |  | [NAME] |  | GXX 8XX
8 | 11251 |  |  |  |  |  | [NAME] |  |  |  |  | 013XXX | 10 |  |  |  | DXX | BeXXX | 3 JXX Street |  |  |  |  |  |  | FX XXX
9 | 3093 |  |  |  |  |  | [EMAIL] |  |  |  |  |  | 10 |  |  |  | DXX | BeXXX | 24 SXXX Crescent |  |  |  |  |  |  | KWX XXX
Spreadsheet: 821094d1678444587-sumproduct-isnumber-search-has-duplicate-values-book2
Sheet: Sheet1

 |  | INPUT AREA
 |  | TYPE | Accounts |  |  | % of Total
 |  | Corporate | 4377 |  | Airline
 |  | Local Tour Operator | 1629 |  | Competitor
 |  | Travel Agency | 824 |  | Corporate
 |  | Other | 181 |  | Destination Management Company
 |  | Oversea Tour Operator | 176 |  | GSA
 |  | MICE | 122 |  | Head Office
 |  | Online Travel Agency | 117 |  | Hotel
 |  | Airline | 74 |  | Local Tour Operator
 |  | Destination Management Company | 41 |  | MICE
 |  | Wedding & Events | 38 |  | Online Travel Agency
 |  | Head Office | 21 |  | Other
 |  | Regional Office | 17 |  | Oversea Tour Operator
 |  | Hotel | 11 |  | Press
 |  | Competitor | 4 |  | Regional Office
 |  | Press | 2 |  | Travel Agency
 |  | GSA | 1 |  | Wedding & Events
 |  |  |  |  | TOTAL
 |  |  |  |  |  | Control -->
Spreadsheet: 858000d1706808414-formula-to-place-worksheet-name-in-cell-on-another-worksheet-sample-sheet
Sheet: Sup 2

 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 |  |  |  | Team Score
 |  |  |  | Updated 12/27/23
Spreadsheet: 786363d1657128302-summarizing-ytd-values-based-on-single-criterion-operating-review-mockup
Sheet: 2022 FCST vs 2021

2022 |  |  |  | 2022 (Live FCST) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vs Month |  |  |  |  |  | 2021 | 2021 Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022 Budget |  |  |  |  |  | 2022 Budget
 |  | (In Millions) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vs 2021 |  |  | vs AOP |  |  | PY |  | Fcst |  |  | Notes |  | Act | Act | Act | Act | Act | Act | Act | Act | Act | Act | Act | Act | Act |  |  | AOP | AOP | AOP | AOP | AOP | AOP | AOP | AOP | AOP | AOP | AOP | AOP
 |  | Corporate Accounts | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Full Year |  | Δ $ | Δ % |  | Δ $ | Δ % |  | Δ $ | Δ % | Δ $ | Δ % |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Full Year |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Full Year
 |  | BDs | 21 | 20 | 23 | 21 | 21 | 22 | 20 | 23 | 21 | 21 | 20 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 20 | 23 | 22 | 20 | 22 | 21 | 22 | 21 | 21 | 20 | 20 |  |  |  | 21 | 20 | 23 | 21 | 21 | 22 | 20 | 23 | 21 | 21 | 20 | 20
NET REVENUE |  | Sales |  |  |  |  |  |  | 10000000 | 10000000 | 10000000 | 10000000 | 10000000 | 10000000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000
Volume |  | Volume |  |  |  |  |  |  | 10000000 | 10000000 | 10000000 | 10000000 | 10000000 | 10000000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note: check with [NAME] on end of year bid activity |  | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000
Spreadsheet: 82082d1282135945-sorting-multiple-instances-of-the-same-record-draft
Sheet: Sheet1

 | name | time |  |  |  | Sum of time
 | [NAME] | 01:00:00 |  |  |  | name | Total
 | [NAME] | 00:30:00 |  |  |  | [NAME] | 02:30:00
 | tom | 01:00:00 |  |  |  | [NAME] | 02:30:00
 | tom | 01:00:00 |  |  |  | tom | 03:30:00
 | [NAME] | 00:30:00 |  |  |  | Grand Total | 08: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: andy_zipper__175__DYNEGY-ICE VOL Apr23
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-23-01 thru Apr-23-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-23-01 | 140734247 |  | Bought | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | Duke Energy Trading and Marketing LLC | 4.93 | USD / MMBtu | 2500 | Daily | 912500 | MMBtus | [NAME], J
Apr-23-01 | 791145622 |  | Bought | NG Fin BS, LD1 for IF | CNG-SP | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Aquila Risk Management Corp. | 0.3275 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | Mckay, B
Apr-23-01 | 123926774 |  | Sold | NG [NAME], ID, GDD | Tenn-5L | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | -0.0025 | USD / MMBtu | 30000 | Daily | 930000 | MMBtus | Quigley, D
Apr-23-01 | 140041111 |  | Sold | NG [NAME], ID, GDD | TET ELA | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | -0.0025 | USD / MMBtu | 30000 | Daily | 930000 | MMBtus | Quigley, D
Apr-23-01 | 146285971 |  | Sold | NG [NAME], ID, GDD | Tenn-8L | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | -0.0025 | USD / MMBtu | 30000 | Daily | 930000 | MMBtus | Quigley, D
Apr-23-01 | 942211769 |  | Sold | NG [NAME], ID, GDD | TET WLA | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 30000 | Daily | 930000 | MMBtus | Quigley, D
Apr-23-01  Deals
Spreadsheet: 811614d1672691009-how-can-i-highlight-one-cell-based-on-a-matching-cell-being-highlighted-example
Sheet: Sheet1

SPRINGFIELD ARMORY |  | Done | 2023-01-02 00:00:00 | SPRINGFIELD ARMORY
RUGER |  |  |  | RUGER
SMITH & WESSON |  |  |  | SMITH & WESSON
TAURUS |  |  |  | FEDERAL AMMO
SIG SAUER |  |  |  | SIG SAUER
CZ |  |  |  | TAURUS
HENRY |  |  |  | CZ
MOSSBERG |  |  |  | [NAME]
GLOCK |  |  |  | GLOCK
BENELLI |  | Done | 2022-12-02 00:00:00 | [NAME]
SAVAGE ARMS |  |  |  | HENRY
KIMBER |  |  |  | N/A
EMPEROR FIREARMS |  |  |  | MOSSBERG
FN AMERICA |  |  |  | BENELLI