tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 733556d1621620321-formula-to-combine-numbers-number-combi-from-red-and-green
Sheet: number combinations

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROW | Assinged numbers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 15 |  | 31 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  | 13 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 8 | 9 |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number combinations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 13 | 15 | 17 | 25 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROW | Assinged numbers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9 | 24 | 25 | 31 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 10 | 13 |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Spreadsheet: 737007d1624017913-if-or-formula-not-producing-correct-value-when-logical-test-is-true-sample-sheet-1-etaf
Sheet: Sheet1

Name | ID Number | Date Requested | Date Sourced | Date Starting | Outstanding?
A | 1 | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-04-05 00:00:00
A | 1 | 2021-04-06 00:00:00
A | 1 | 2021-04-04 00:00:00 | Cancelled | Cancelled
A | 1 | 2021-04-27 00:00:00
A | 1 | 2021-04-28 00:00:00 | Cancelled | Cancelled
A | 1 | 2021-04-28 00:00:00 | Cancelled | Cancelled
A | 1 | 2021-05-04 00:00:00 | 2021-06-08 00:00:00
A | 1 | 2021-05-04 00:00:00 | Cancelled | Cancelled
A | 1 | 2021-05-04 00:00:00 | Cancelled | Cancelled
A | 1 | 2021-05-07 00:00:00
A | 1 | 2021-05-12 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00
A | 1 | 2021-05-14 00:00:00
A | 1 | 2021-05-14 00:00:00 | CANCELLED | CANCELLED
A | 1 | 2021-05-14 00:00:00 | CANCELLED | CANCELLED
A | 1 | 2021-05-17 00:00:00 | CANCELLED | CANCELLED
A | 1 | 2021-05-26 00:00:00 | Cancelled | Cancelled
A | 1 | 2021-05-27 00:00:00 | Cancelled | Cancelled
A | 1 | 2021-05-27 00:00:00 | 2021-06-16 00:00:00 | 2021-06-21 00:00:00
A | 1 | 2021-06-08 00:00:00 | CANCELLED | CANCELLED
Spreadsheet: 65b38ff2-c3f5-4024-9511-56d68b4b5cc0
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
BECH | Test | BECH | Beech, IgE | Beech, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BECH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BECH | Result | BECH | Beech, IgE | Beech, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6038-4
Spreadsheet: tracy_geaccone__40213__EGA fcst
Sheet: Aug 15 - Azurix

Enron Global Assets - Azurix Only
(Millions of Dollars)
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Revised |  | Prior |  | From Prior
 |  |  |  |  |  | Forecast |  | Forecast(2CE) |  | Forecast |  | Plan
Income Before Int. Expense & Income Taxes * |  |  |  |  |  |  |  | 4.8
Interest Expense
 | 3rd Party interest expense |  |  |  |  | 6 |  | 6
 | Intercompany capital charge expense (income) |  |  |  |  | 0 |  | 0
 | Other intercompany interest expense (income) |  |  |  |  | 0 |  | 0
 | Other - including capitalized interest |  |  |  |  | -0.1 |  | -0.1
Minority Interest |  |  |  |  |  | 0.5 |  | 0.5
Pre-tax income
Income Tax |  |  |  |  |  | -53 |  | 2.5
Net Income before Financing Costs
[NAME] (items greater than $1.0) |  |  |  |  |  |  |  |  |  | Interest |  |  |  | Net
 |  |  |  |  |  |  |  | IBIT |  | Expense |  | Taxes |  | Income
Prior Forecast
 | Loss on sale of assets |  |  |  |  |  |  |  |  | 0 |  | -55.5
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Other |  |  |  |  |  |  | 0 |  | 0 |  | 0
Current Forecast
*    INCOME BEFORE INTEREST EXPENSE AND INCOME TAXES INCLUDES OUTSIDE (NOT INTERCOMPANY)
INTEREST INCOME.
Spreadsheet: 4f0e57d8-c8ce-4ed7-af8f-48709c6e39de
Sheet: TIG Cohort 4 Yr 1

Grant: |  | Tiered Intervention Grant Cohort 4
CFDA # |  | 84.377
GRANT NUMBER: |  | 737
FISCAL YEAR: |  | 2013-14
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]-866-6724 or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - Septebmer 15, 2014
Code | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY  2013 | AUGUST  2013 | SEPTEMBER  2013 | OCTOBER  2013 | NOVEMBER  2013 | DECEMBER  2013 | JANUARY  2014 | FEBRUARY  2014 | [NAME]  2014 | APRIL  2014 | MAY  2014 | JUNE  2014 | JULY  2014 | AUGUST  2014 | SEPTEMBER  2014
0022-S | [NAME] | 498181 |  |  |  |  |  |  | 60090 | 44762 | 40692 | 42377 | 40119
1458-S | [NAME] | 1070778 |  |  |  |  |  |  | 130588 | 66436 |  | 170887 | 76234
5388-S | [NAME] | 836022 |  |  |  |  |  | 18935 | 71641 | 154800 | 68211 | 33887 | 58002
6350-S | [NAME] | 508200 |  |  |  |  |  |  |  |  |  | 109523
9085-S | [NAME] | 20995 |  |  |  |  |  |  |  |  |  |  | 20995
Spreadsheet: 4b156277-ed5b-4333-908c-f13faa85351d
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Warner Home Video | 883929103409 | Various | Book Of Eli | 2010-06-15 | DVD | Insp | 19.96 | Y | Available
Warner Home Video | 883929103423 | Various | Book Of Eli Blu Ray | 2010-06-15 | DVD | Insp | 19.98 | Y | Available
Warner Home Video | 883929026623 | Various | [NAME] | 2010-08-31 | DVD | Insp | 22.98 | Y | Available
Warner Home Video | 883929131716 | Warner Home Video | Temple Grandin | 2010-08-24 | DVD | Insp | 19.96 | Y | Available
Image Entertainment | 14381665024 | Various | Blood Done Sign My Name | 2010-08-03 | DVD | Insp | 27.98 | Y | Available
Image Entertainment | 14381667653 | Various | Blood Done Sign My Name (Bluray) | 2010-08-03 | DVD | Insp | 29.98 | Y | Available
Paramount | 97368931749 | Various | Noelle | 2008-11-11 | DVD | Insp | 19.99 | Y | Available
Warner Home Video | 883929168835 | Various | Charlton Heston Presents The Bible: Genesis | 2011-03-29 | DVD | Insp | 12.97 | Y | Available
Warner Home Video | 883929169153 | Various | Charlton Heston Presents The Bible: [NAME] [NAME] | 2011-03-29 | DVD | Insp | 12.97 | Y | Available
Warner Home Video | 883929168859 | Various | Charlton Heston Presents The Bible: Moses | 2011-03-29 | DVD | Insp | 12.97 | Y | Available
Warner Home Video | 883929168873 | Various | Charlton Heston Presents The Bible: The Passion | 2011-03-29 | DVD | Insp | 12.97 | Y | Available
Warner Home Video | 883929060948 | Various | Invictus | 2010-09-14 | DVD | Insp | 14.96 | Y | Available
Universal | 25192197024 | Various | [NAME] | 2010-08-31 | DVD | Insp | 14.98 | Y | Available
Image Entertainment | 14381794120 | Various | Trinity Goodheart | 2012-03-20 | DVD | Insp | 14.98 | Y | Available
Image Entertainment | 14381788426 | Various | Decision | 2012-03-06 | DVD | Insp | 22.98 | Y | Available
Warner Home Video | 883929181667 | Various | [NAME] | 2011-05-24 | DVD | Insp | 27.98 | Y | Available
Warner Home Video | 883929173280 | Various | Gods And [NAME] | 2011-05-24 | DVD | Insp | 27.98 | Y | Available
Warner Home Video | 883929033065 | Various | Taking Chance | 2011-05-10 | DVD | Insp | 9.98 | Y | Available
Spreadsheet: 536857d1504717168-sum-cells-that-carry-a-formula-book1
Sheet: Sheet1

 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
17
18
19
20
Spreadsheet: 328001d1403762224-find-number-in-array-that-is-less-than-index-match-index_match_result
Sheet: Xcommission

 |  |  |  |  |  |  | Actual | Actual | Actual | Actual
 |  |  |  |  |  |  | 2014-01-31 00:00:00 | 2014-02-28 00:00:00 | 2014-03-31 00:00:00 | 2014-04-30 00:00:00
vs Target | CommScale | Accel/Decel | Over/Under $ | Payout |  | EBITDA Target
0.06 |  | 0.035 |  |  |  | Target Cumulative
0.05 |  | 0.03
0.04 |  | 0.025 |  |  |  | EBITDA Actual
0.03 |  | 0.02 |  |  |  | Actual Cumulative
0.02 |  | 0.015
0.01 |  | 0.005 |  |  |  | Cumulative Total (over/under)
0 |  | 0 |  |  |  | % Diff
-0.01 |  | -0.25
-0.02 |  | -0.35
-0.03 |  | -0.45 |  |  |  | Commission Target | 8000
-0.04 |  | -0.5 |  |  |  | Commission Payout
-0.05 |  | -0.55 |  |  |  |  | should return highlighted green in cell H18
-0.06 |  | -0.6
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 9b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Fixed-Float | 681832 | 385035 | 159811 | 49021 | 14167 | 40284 | 67564 | 1397714
OTHER* | 501992 | 648401 | 79788 | 11071 | 143417 | 16070 | 102366 | 1503105
TOTAL | 1183824 | 1033436 | 239599 | 60092 | 157584 | 56354 | 169930 | 2900819
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: e449fc66-58e8-4a35-b9db-10b82b6c29cd
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
CAS | Test | CAS | Calcium, Total, Serum | Calcium, Total, S | Photometric, 5-nitro-5'-methyl-BAPTA | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Collection Instructions: If drawing for more than calcium, total, send first tube drawn. Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Males 1-14 years: 9.6-10.6 mg/dL 15-16 years: 9.5-10.5 mg/dL 17-18 years: 9.5-10.4 mg/dL 19-21 years: 9.3-10.3 mg/dL > or =22 years: 8.9-10.1 mg/dL Reference values have not been established for patients who are <12 months of age. Females 1-11 years: 9.6-10.6 mg/dL 12-14 years: 9.5-10.4 mg/dL 15-18 years: 9.1-10.3 mg/dL > or =19 years: 8.9-10.1 mg/dL Reference values have not been established for patients who are <12 months of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82310 |  |  |  |  | Rochester
CAS | [NAME] | SERUM | Serum |  |  |  | Frozen | 21 days
CAS | Result | CA | Calcium, Total, S | Calcium, Total, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 17861-6 | Calcium:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 669823d1585608106-multiple-columns-into-one-column-for-charity-multiple-columns-into-one-column-for-charity
Sheet: after (proposed)

Orders | Product name | counts | Indx
Spreadsheet: 492385d1481060212-multiple-data-validation-country-list
Sheet: Sheet2

 | Countries | Country List
Client A | Australia | Germany
Client B | Brazil
 | Canada
 | France
 | Germany
 | India
 | Indonesia
 | Italy
 | Japan
 | Malaysia
 | Mexico
 | New Zealand
 | Philippines
 | Singapore
 | Taiwan
 | Thailand
 | U.K.
 | U.S.
Spreadsheet: 873930d1720531917-get-the-date-of-each-row-in-one-shot-lso
Sheet: AT

SN |  | Party Name |  |  | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Name | Units | Gross Qty
1 |  | [NAME] |  |  | 2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple | KG | 1000
5 |  | [NAME] |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guava | KG | 10000
8 |  | [NAME] |  |  | 2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange | KG | 1000
10 |  | [NAME] |  |  | 2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange | KG | 1000
11 |  | [NAME] |  |  | 2024-07-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple | KG | 150
14 |  | [NAME] |  |  | 2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Papaya | KG | 775
3 |  | [NAME] |  |  | 2024-07-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Papaya | KG | 2000
2 |  | KGF |  |  | 2023-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange | KG | 1650
14 |  | Ukraine |  |  | 2024-05-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Papaya | KG | 300
63 |  | Ukraine |  |  | 2023-09-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Papaya | KG | 250
21 |  | Chevoz |  |  | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple | KG | 1350
Spreadsheet: 65325d1265998829-setting-ranges-journal
Sheet: 2-10|__

Date | Salinity | Ammonia | Nitrate | Nitrite | Alkalinity | PH High | Iron | Calcium | Phosphate | Water | Fish | Other
 |  |  |  |  |  |  |  |  |  | Change | Added | Added
2010-02-09 00:00:00 | 1.023 | 0.3 | 20 | 0.3 | NT | 8.3 | 0 | 0 | 0 | NO | NO | NO
2010-02-12 00:00:00 | 1.023 | 0.25 | 25 | 0.5 | 2 | NT | NT | NT | NT | 25G | NO | NO
Spreadsheet: 204303d1357438149-circular-reference-time-calculation6
Sheet: Sheet2

A & B | Pattern 1 |  |  | Pattern 2 |  | Pattern 3 |  | Pattern 4 |  | Pattern 5
Process | Molder start |  | Molder stop | Molder start | Molder stop | Molder start | Molder stop | Molder start | Molder stop | Molder start | Molder stop
 | 07:15:00 |  | 14:30:00 | 14:30:00 | 14:30:00 | 14:30:00 | 14:30:00 | 14:30:00 | 14:30:00 | 14:30:00 | 14:30:00
Spreadsheet: 0871c64d-f858-468e-b395-919e1f08390b
Sheet: Sheet1

Unnamed: 0 | Income & Expenditure Report | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]:
Company / Artist's name:
Year
 | Income | €
 | Arts Council*
 | Box Office Income
 | Local Authority
 | Guarantees
 | Programme Sales
 | Sponsorship
 | Donations
 | Other
 | Total Income
 | Expenditure | €
 | Salaries & Fees
 | Technical & Production Costs
 | Promotion & Publicity
 | Administration
 | Travel
 | Accommodation
 | Other
 | Total Expenditure
 | Surplus / (Deficit)
Signature of Applicant:1 _______________________________________________________________________________________
Signature of Auditor / Qualified Acountant:2 _____________________________________________________________
1 Applicant is the individual who makes the application or in the case of a company or an organisation with a constitution other than that of a company an authorised signatory.
2 Please refer to our terms and conditions to see when the additional signature of an auditor / qualified accountant is required.
* Income from the Arts Council should be shown separately above. The full amount of the grant awarded must be shown. This can be split between amounts already received and amounts still outstanding.
Spreadsheet: 762510d1641584777-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Phoenix_P9

Phoenix Centralized Training ASC office
Zone | Attendees | Global ID | Position | [NAME] | Needs Room | RoomNight
[NAME] | [NAME] |  | RSR | XL | Yes/ Lake Havasu | 2
 | [NAME] |  | DSL | M | Yes/Kingmen | 2
Phoenix | [NAME] | TBD | RSA | W/M
 | [NAME] | TBD | RSA | XL
 | [NAME]
 | [NAME] | 71054113 | RSA | S/M
 | [NAME]
Tucson | [NAME] | 80071798 | CSS | Large (mens) | yes* if held in PHX
 | [NAME] | 71077641 | Promotion 'Detailer to FTM | TBD | TBD
 | [NAME] | 80073688 | CSS | Large (mens) | yes* if held in PHX
 | [NAME] | 80073939 | CSS | Med (womens) | yes* if held in PHX
 | Brianna Abeyta | TBD | CSS | Small (womens) | yes* if held in PHX
Mt. Vista
El Paso
Spreadsheet: 678068d1589700881-vlookup-display-only-oldest-date-example
Sheet: Sheet1

IJZERTOLTRAZURIL |  |  |  |  | VOLGNUMMERS G1117 |  |  |  | VERVALDATUM |  | VOLGNR G1117 | PROD. DATUM | PROD. DATUM + 3 JR
 | MAALFASE (R1215) | VERDUNFASE (R1252) | EINDPRODUCT (R1253) |  | MAALFASE |  | VERDUNFASE |  |  |  | 57856 | 2017-02-01 00:00:00
SET 1 | 20A035 | 20A156 | 20A122 |  | 87965 | 12345 | 12345 | 45612 |  |  | 12345 | 2018-01-01 00:00:00
 |  | 20A182 | 20A122 |  |  |  | 45612 | x |  |  | 87965 | 2013-04-01 00:00:00
 |  | x | x |  |  |  | x | x |  |  | 45612 | 2019-05-01 00:00:00
SET 2 | 20A035 | 20A156 | 20A898 |  | 57856 |  | 87965 | 12345
 |  |  |  |  | 57856 |  | 87965 | 12345
 |  | 20A182 |  |  | 57856
SET 3 | 20A035 | 20A156
 |  | 20A182 |  |  | x | x | x | x
SET 4 | 20A035 | 20A156
 |  | 20A182
SET 5 | 20A035 | 20A156
 |  | 20A182
SET 6 | 20A035 | 20A156
 |  | 20A182
Spreadsheet: 734422d1622146292-matching-2-criteria-and-subtracting-the-answers-by-each-other-book1
Sheet: Sheet1

Thailand - 09/24/2020 |  |  |  |  |  |  | I'd like a formula to return results from column D. First,I'd like to MATCH A1 to [NAME] and MATCH F6 to B6.
 |  |  |  |  |  |  | Then I'd like to subtract the Thailand CoW from Las Vegas CoW.
 | CoW |  |  |  |  |  | The issue is the data is in different tabs throughout the workbook.
 |  |  |  |  |  |  | The end goal is to subtract the Thailand CoW% from the Las Vegas CoW%.
 | Las Vegas - 09/11/2020 |  | -0.05 |  | Las Vegas - 09/11/2020
 | Bestbet Orange Park - 04/06/2021 |  | 0.135 |  | Las Vegas - 09/11/2020
 | Coconut Creek P1 - 11/20/2020 |  | 0.195 |  | Las Vegas - 09/11/2020
 | Coconut Creek P2 - 11/20/2020 |  | 0.195 |  | Las Vegas - 09/11/2020
 | Dallas - 02/09/2020 |  | 0.25 |  | Las Vegas - 09/11/2020
 | Daytona Beach - 04/06/2021 |  | 0.135 |  | Las Vegas - 09/11/2020
 | Ebro - 10/08/2020 |  | 0.155 |  | Las Vegas - 09/11/2020
 | Fort Pierce - 11/20/2020 |  | 0.195 |  | Las Vegas - 09/11/2020
 | Fort Pierce Casino - 10/08/2020 |  | 0.155 |  | Las Vegas - 09/11/2020
 | Hollywood - 11/4/2020 |  | 0.185 |  | Las Vegas - 09/11/2020
 | Immokalee - 11/20/2020 |  | 0.195 |  | Las Vegas - 09/11/2020
 | Jacksonville - 04/06/2021 |  | 0.135 |  | Las Vegas - 09/11/2020
 | [NAME] |  |  |  | Las Vegas - 09/11/2020
 | Melbourne - 04/06/2021 |  | 0.135 |  | Las Vegas - 09/11/2020
 | Naples - 04/06/2021 |  | 0.135 |  | Las Vegas - 09/11/2020
 | Oxford - 10/08/2020 |  | 0.155 |  | Las Vegas - 09/11/2020
 | Palm Beach - 04/06/2021 |  | 0.135 |  | Las Vegas - 09/11/2020
 | Pensacola - 04/06/2021 |  | 0.135 |  | Las Vegas - 09/11/2020
 | Sarasota - 10/08/2020 |  | 0.155 |  | Las Vegas - 09/11/2020
 | Tampa - 11/4/2020 |  | 0.195 |  | Las Vegas - 09/11/2020
 | Tampa Derby Lane - 04/06/2021 |  | 0.135 |  | Las Vegas - 09/11/2020
 | Thailand - 09/24/2020 |  | 0.43 |  | Las Vegas - 09/11/2020
Spreadsheet: 266737d1379706620-formula-for-value-by-date-and-find-number-count-with-word-on-multiple-sheets-setup-exception-tracking-by-ae-example
Sheet: Alice

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception % | prelim | paystub | assets >45 | asset stmt missing | [NAME] | 4506 | credit | missing bank
2013-03-31 00:00:00 |  |  |  |  |  |  | 0 | 27
2013-04-30 00:00:00 |  |  |  |  |  |  | 0 | 52
2013-05-13 00:00:00 | Synergy | [NAME] | [NAME] | Cuny | 37653 | asset >45
2013-05-13 00:00:00 | Seacliff Mortgage | [NAME] | [NAME] | Gates | 37484 | paystub >30
2013-05-23 00:00:00 | Meridian | [NAME] | [NAME] | [NAME] | 39114 | paystub >30 & asset >45
2013-05-31 00:00:00 | Elite One | [NAME] | [NAME] | Swisher | 39282 | paystubs >30 | 4 | 39
2013-06-17 00:00:00 | Back Bay Funding | [NAME] | Lily Doerr | McCann | 39461 | paystub >30
2013-06-17 00:00:00 | Back Bay Funding | [NAME] | Lily Doerr | [NAME] | 39504 | asset >45
2013-06-24 00:00:00 | Meridian | [NAME] | [NAME] | Pyle | 39557 | asset >45 | 3 | 29
2013-07-15 00:00:00 | Meridian Real Estate Group | [NAME] | [NAME] | LaVenture | 40180 | missing prelim
2013-07-15 00:00:00 | Stratis Financial Corporation | [NAME] | [NAME] | Stichka | 39888 | missing prelim & assets >45
2013-07-17 00:00:00 | Stratis Financial Corporation | [NAME] | [NAME] | Najm | 40204 | missing 2011 W2(s), assets >45
2013-07-19 00:00:00 | Elite One Mortgage | [NAME] | Rosana Rincon | Fomusoh | 40151 | assets missing pages
2013-07-24 00:00:00 | Back Bay Funding | [NAME] | Lily Doerr | Calata | 40208 | paystub >30 & asset >45 | 5 | 28
2013-08-06 00:00:00 | Stratis Financial Corporation | [NAME], Jr. | [NAME] | Ballout | 40640 | prelim >45; CB pay stub>30
2013-08-13 00:00:00 | Trans United Real Estate & Loans | [NAME] | [NAME] | Yassa | 40805 | missing prelim
2013-08-15 00:00:00 | Service One Mortgage | [NAME] | [NAME] | Nguyen | 40817 | asset >45
2013-08-27 00:00:00 | Trans United Real Estate & Loans | [NAME] | [NAME] | [NAME] | 40995 | Credit >45 | 4 | 29
Spreadsheet: 842094d1694166666-count-the-gaps-between-two-consecutive-data-tectonic-gaps
Sheet: पत्रक1

True | 3 | Gaps
False | 2 | 2 |  | 2
False | -2 | 0 |  | 0
True | -3 | 5 |  | 5
True | -4 | 1 |  | 1
False | 3 | 9 |  | 9
False | 4 |  |  | 0
False | 5
False
False
True
False
True
False
False
False
False
False
False
False
False
False
True